SELECT e.EventID,
e.EventName,
e.StartDateTime,
e.EndDateTime,
e.EventShortDesc,
e.Location,
e.active,
e.signature_event,
e.EventImage, et.EventType
FROM cal_event e INNER JOIN cal_event_type et ON e.EventTypeID = et.EventTypeID
WHERE e.active = 1 AND signature_event = 1 AND EventImage <> "" AND EventImage <> "NULL"
AND e.StartDateTime >= '#url.Year#-#url.Month#-#DatePart("d", now())#01'AND (e.StartDateTime >= #now()# OR e.EndDateTime >= #now()# OR #now()# BETWEEN e.StartDateTime AND e.EndDateTime)
ORDER BY e.StartDateTime
LIMIT 3
| Upcoming Signature Events |
| #EventName#
#DateFormat(StartDateTime, "MMMM D, YYYY")# - #DateFormat(EndDateTime, "MMMM D, YYYY")#
|
|
|
|