Konkursy

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