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