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