function event_join in Event 5.2

Returns SQL JOIN statement to use for event queries

Parameters

$prefix prefix of the node table, "n" is the default:

$type 'INNER' OR 'LEFT', default 'INNER':

Related topics

File

./event.module, line 1225

Code

function event_join($prefix = 'n', $type = 'INNER') {
  return "{$type} JOIN {event} e ON {$prefix}.nid = e.nid {$type} JOIN {event_timezones} tz ON e.timezone = tz.timezone";
}