Zurück zur Übersicht

,

Termine und Tickets

Reihung nach Event Datum Ort Genre

Das könnte Ihnen auch gefallen

Fehler bei Query SELECT COUNT(events.id) as anz_termine, termine.id as t_id, events.titel as e_titel, events.subtitel as e_subtitel, events.bild as e_bild, termine.ort as t_ort, termine.location as t_location, termine.datum as t_datum, termine.uhrzeit as t_uhrzeit, termine.markierung as t_markierung FROM termine LEFT JOIN events ON (termine.event_id = events.id) WHERE events.id != 0 AND termine.visible=1 AND events.visible=1 AND termine.archiv=0 AND events.archiv=0 AND termine.datum >= "2017-11-21" AND events.domains LIKE "%1,%" AND () GROUP BY events.id ORDER BY termine.datum ASC LIMIT 3