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