WordPress database error: [Table 'greatwallhardnew.wp_my_calendar_category_relationships' doesn't exist]
SELECT *, UNIX_TIMESTAMP( CONVERT_TZ( `occur_begin`, '-07:00', '-07:00' ) ) AS ts_occur_begin, UNIX_TIMESTAMP( CONVERT_TZ( `occur_end`, '-07:00', '-07:00' ) ) AS ts_occur_end
FROM wp_my_calendar_events AS o
JOIN wp_my_calendar AS e
ON (event_id=occur_event_id)
JOIN wp_my_calendar_categories AS c
ON (event_category=category_id)
JOIN wp_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-09-28 00:00:00' AND '2020-11-01 23:59:59'
OR DATE(occur_end) BETWEEN '2020-09-28 00:00:00' AND '2020-11-01 23:59:59'
OR ( DATE('2020-09-28') BETWEEN DATE(occur_begin) AND DATE(occur_end) )
OR ( DATE('2020-11-01') BETWEEN DATE(occur_begin) AND DATE(occur_end) ) )
GROUP BY o.occur_id ORDER BY occur_begin, event_title ASC
MonMonday
TueTuesday
WedWednesday
ThuThursday
FriFriday
SatSaturday
SunSunday
September 28, 2020
September 29, 2020
September 30, 2020
October 1, 2020
October 2, 2020
October 3, 2020
October 4, 2020
October 5, 2020
October 6, 2020
October 7, 2020
October 8, 2020
October 9, 2020
October 10, 2020
October 11, 2020
October 12, 2020
October 13, 2020
October 14, 2020
October 15, 2020
October 16, 2020
October 17, 2020
October 18, 2020
October 19, 2020
October 20, 2020
October 21, 2020
October 22, 2020
October 23, 2020
October 24, 2020
October 25, 2020
October 26, 2020
October 27, 2020
October 28, 2020
October 29, 2020
October 30, 2020
October 31, 2020
November 1, 2020