SELECT e.*, ed.headline, ed.ticketText FROM events e, events_description ed WHERE e.id IN (SELECT DISTINCT(tt.events_id) FROM tickettypes tt, tickettypes_sites tte WHERE tte.sites_id='1' AND tte.tickettypes_id=tt.id AND tt.deleted!=1) AND e.deleted!=1 AND e.canceled!=1 AND e.online=1 AND DATE_FORMAT(NOW(), '%Y%m%d%H%i') < DATE_FORMAT(e.eventStart, '%Y%m%d%H%i') AND ((e.bookingStartType='EVENT') OR (e.bookingStartType='TIME' AND DATE_FORMAT(NOW(), '%Y%m%d') >= DATE_FORMAT(e.bookingStart, '%Y%m%d'))) AND ((e.bookingEndType='EVENT' AND DATE_FORMAT(NOW(), '%Y%m%d%H%i') < DATE_FORMAT(e.eventStart, '%Y%m%d%H%i')) OR (e.bookingEndType='TIME' AND DATE_FORMAT(NOW(), '%Y%m%d') <= DATE_FORMAT(e.bookingEnd, '%Y%m%d'))) AND e.id=ed.events_id AND ed.languages_id='1' ORDER BY e.eventStart DESCLIMIT 0, 20