| SQL |
SELECT sisa_events.eventtitle AS eventtitle,
sisa_events.eventdate AS eventdate,
sisa_events.eventtime AS eventtime,
sisa_events.eventvenue AS eventvenue,
sisa_events.eventleader AS eventleader,
sisa_events.eventid AS eventid,
sisa_events.eventbigimage AS eventbigimage,
sisa_events.eventiscommittee AS eventiscommittee,
sisa_events.eventismember AS eventismember,
sisa_events.eventispublic AS eventispublic,
sisa_events.eventenddate AS eventenddate,
sisa_calendarcategory.calendarcategoryname AS calendarcategoryname,
sisa_events.eventuuid AS eventuuid,
timestart.timename AS starttime,
timeend.timename AS endtime,
sisa_events.eventavailable AS eventavailable,
sisa_events.EventCanRegister AS eventcanregister,
sisa_events.event_calendarcategoryid AS event_calendarcategoryid,
sisa_events.EventIsAllDay AS EventIsAllDay,
sisa_events.eventlivestreamurl AS livestreamurl,
sisa_events.eventposteventurl AS posteventurl,
sisa_events.eventcontenttype AS contenttype
FROM sisa_events
INNER JOIN sisa_calendarcategory
ON sisa_events.event_calendarcategoryid = sisa_calendarcategory.calendarcategoryid
LEFT JOIN sisa_time AS timestart
ON sisa_events.eventstarttime = timestart.timeid
LEFT JOIN sisa_time AS timeend
ON sisa_events.eventendtime = timeend.timeid
WHERE (eventdate >= {d '2025-10-15'})
AND (eventavailable = ?)
AND (EventIsPublic = ?)
AND (Event_CalendarCategoryID = CalendarCategoryID)
ORDER BY EventDate asc |
