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 '2021-09-27 00:00:00' AND '2021-10-31 23:59:59'
OR DATE(occur_end) BETWEEN '2021-09-27 00:00:00' AND '2021-10-31 23:59:59'
OR ( DATE('2021-09-27') BETWEEN DATE(occur_begin) AND DATE(occur_end) )
OR ( DATE('2021-10-31') 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 27, 2021
September 28, 2021
September 29, 2021
September 30, 2021
October 1, 2021
October 2, 2021
October 3, 2021
October 4, 2021
October 5, 2021
October 6, 2021
October 7, 2021
October 8, 2021
October 9, 2021
October 10, 2021
October 11, 2021
October 12, 2021
October 13, 2021
October 14, 2021
October 15, 2021
October 16, 2021
October 17, 2021
October 18, 2021
October 19, 2021
October 20, 2021
October 21, 2021
October 22, 2021
October 23, 2021
October 24, 2021
October 25, 2021
October 26, 2021
October 27, 2021
October 28, 2021
October 29, 2021
October 30, 2021
October 31, 2021