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 (1)
AND ( DATE(occur_begin) BETWEEN '2020-12-28 00:00:00' AND '2021-01-31 23:59:59'
OR DATE(occur_end) BETWEEN '2020-12-28 00:00:00' AND '2021-01-31 23:59:59'
OR ( DATE('2020-12-28') BETWEEN DATE(occur_begin) AND DATE(occur_end) )
OR ( DATE('2021-01-31') BETWEEN DATE(occur_begin) AND DATE(occur_end) ) )
ORDER BY occur_begin, event_title ASC
MonMonday | TueTuesday | WedWednesday | ThuThursday | FriFriday | SatSaturday | SunSunday |
---|---|---|---|---|---|---|
December 28, 2020 | December 29, 2020 | December 30, 2020 | December 31, 2020 | January 1, 2021 | January 2, 2021 | January 3, 2021 |
January 4, 2021 | January 5, 2021 | January 6, 2021 | January 7, 2021 | January 8, 2021 | January 9, 2021 | January 10, 2021 |
January 11, 2021 | January 12, 2021 | January 13, 2021 | January 14, 2021 | January 15, 2021 | January 16, 2021 | January 17, 2021 |
January 18, 2021 | January 19, 2021 | January 20, 2021 | January 21, 2021 | January 22, 2021 | January 23, 2021 | January 24, 2021 |
January 25, 2021 | January 26, 2021 | January 27, 2021 | January 28, 2021 | January 29, 2021 | January 30, 2021 | January 31, 2021 |