Suchen Sie nach Termin oder nach Rubrik. Oder nach beidem.
Bei vielen Veranstaltungen können Sie auch direkt das Ticket buchen. Oder zumindest den Termin in Ihren Online-Kalender importieren. 

Veranstaltungskalender

  • Veranstaltung

  • Orte

  • Art

select distinct date_format(rex_production_event_date, '%Y-%m') as month_group, rp.rex_production_id, rpe.rex_production_event_id, rex_production_name, rex_production_description, rex_production_image, rex_production_event_location_name, count(rpe.rex_production_event_id) as event_count, date_format(min(rex_production_event_date), '%Y-%m-%d') as event_date_start, date_format(max(rex_production_event_date), '%Y-%m-%d') as event_date_end, date_format(min(rex_production_event_date), '%d.%m.%Y') as event_date_local, date_format(max(rex_production_event_date), '%d.%m.%Y') as event_date_local_end, date_format(rex_production_event_time_from, '%H:%i') as event_time_start, date_format(rex_production_event_time_till, '%H:%i') as event_time_end, rex_production_update_status+rex_production_event_update_status as status from rex_production rp inner join rex_production_event rpe on rp.rex_production_id=rpe.rex_production_id and rex_production_event_update_status=0 left join rex_production_event_location rpel on rpe.rex_production_event_location_id=rpel.rex_production_event_location_id left join rex_production_highlight rph on rpe.rex_production_event_id=rph.rex_production_event_id where rex_production_event_date >= date_format(now(), '%Y-%m-%d') group by month_group, rp.rex_production_id, rpe.rex_production_event_id having event_date_end >= date_format(now(), '%Y-%m-%d') and status=0 order by month_group, event_count asc, event_date_start, event_time_start, rex_production_name

November 2017

Dezember 2017

Januar 2018

Februar 2018