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