Recent Updates
WordPress database error: [Table 'relagvms_rel.wpwr_my_calendar_category_relationships' doesn't exist]
SELECT *, UNIX_TIMESTAMP(occur_begin) AS ts_occur_begin, UNIX_TIMESTAMP(occur_end) AS ts_occur_end
FROM wpwr_my_calendar_events
JOIN wpwr_my_calendar AS e
ON (event_id=occur_event_id)
JOIN wpwr_my_calendar_categories AS c
ON (event_category=category_id)
JOIN wpwr_my_calendar_category_relationships AS r ON r.event_id = e.event_id
WHERE event_flagged <> 1 AND event_approved = 1 AND r.category_id IN (2)
AND ( DATE(occur_begin) BETWEEN '2018-08-27 00:00:00' AND '2018-09-02 23:59:59'
OR DATE(occur_end) BETWEEN '2018-08-27 00:00:00' AND '2018-09-02 23:59:59'
OR ( DATE('2018-08-27') BETWEEN DATE(occur_begin) AND DATE(occur_end) )
OR ( DATE('2018-09-02') BETWEEN DATE(occur_begin) AND DATE(occur_end) ) )
ORDER BY occur_begin, event_title ASC
MonMonday | TueTuesday | WedWednesday | ThuThursday | FriFriday | SatSaturday | SunSunday |
---|---|---|---|---|---|---|
August 27, 2018 | August 28, 2018 | August 29, 2018 | August 30, 2018 | August 31, 2018 | September 1, 2018 | September 2, 2018 |