Konkursy

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