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