ROK 2022/2023

SELECT id, title, shortTitle, startDate, endDate, startTime, endTime, bookings FROM events WHERE (endDate >= '2023-09-30' OR startDate >= '2022-10-01') AND startDate <= '2023-09-30' AND filters LIKE '%%' AND ( title LIKE '%%' OR longDesc LIKE '%%' ) AND isContest = 1 AND visibility = 1 ORDER BY startDate, startTime