WordPress database error: [Table 'db1304824_liamd.wp_my_calendar_category_relationships' doesn't exist]
SELECT *, UNIX_TIMESTAMP(occur_begin) AS ts_occur_begin, UNIX_TIMESTAMP(occur_end) AS ts_occur_end
FROM wp_my_calendar_events
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-04-29 00:00:00' AND '2019-06-02 23:59:59'
OR DATE(occur_end) BETWEEN '2019-04-29 00:00:00' AND '2019-06-02 23:59:59'
OR ( DATE('2019-04-29') BETWEEN DATE(occur_begin) AND DATE(occur_end) )
OR ( DATE('2019-06-02') BETWEEN DATE(occur_begin) AND DATE(occur_end) ) )
ORDER BY occur_begin, event_title ASC
| MonMonday | TueTuesday | WedWednesday | ThuThursday | FriFriday | SatSaturday | SunSunday |
|---|---|---|---|---|---|---|
| April 29, 2019 | April 30, 2019 | May 1, 2019 | May 2, 2019 | May 3, 2019 | May 4, 2019 | May 5, 2019 |
| May 6, 2019 | May 7, 2019 | May 8, 2019 | May 9, 2019 | May 10, 2019 | May 11, 2019 | May 12, 2019 |
| May 13, 2019 | May 14, 2019 | May 15, 2019 | May 16, 2019 | May 17, 2019 | May 18, 2019 | May 19, 2019 |
| May 20, 2019 | May 21, 2019 | May 22, 2019 | May 23, 2019 | May 24, 2019 | May 25, 2019 | May 26, 2019 |
| May 27, 2019 | May 28, 2019 | May 29, 2019 | May 30, 2019 | May 31, 2019 | June 1, 2019 | June 2, 2019 |
