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