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