ROK 2023/2024

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