My Calendar

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',4) AND ( DATE(occur_begin) BETWEEN '2021-12-27 00:00:00' AND '2022-02-0' at line 8]
SELECT *, UNIX_TIMESTAMP( CONVERT_TZ( `occur_begin`, '-08:00', '-07:00' ) ) AS ts_occur_begin, UNIX_TIMESTAMP( CONVERT_TZ( `occur_end`, '-08: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 (,4) AND ( DATE(occur_begin) BETWEEN '2021-12-27 00:00:00' AND '2022-02-06 23:59:59' OR DATE(occur_end) BETWEEN '2021-12-27 00:00:00' AND '2022-02-06 23:59:59' OR ( DATE('2021-12-27') BETWEEN DATE(occur_begin) AND DATE(occur_end) ) OR ( DATE('2022-02-06') BETWEEN DATE(occur_begin) AND DATE(occur_end) ) ) GROUP BY o.occur_id ORDER BY occur_begin, event_title ASC