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