string(4542) "SELECT a.id, UNIX_TIMESTAMP(a.timestamp) modified, a.veranst_img img, a.veranst_img_copyright img_copyright, a.veranstalter adress_id_veranstalter, a.id event_id, e.id datum_id, a.treffpunkt, a.treffpunkt_en, a.`kommentar_termin`, a.`highlight`, a.`highlight_im_ort`, ga.id adress_id, ga.ort_klasse orts_id, ga.strasse, ga.plz, IF(a.`gps_lgrad`, a.`gps_lgrad`, IF(ga.`gps_lgrad`, ga.`gps_lgrad`, 0)) `gps_lgrad`, IF(a.`gps_bgrad`, a.`gps_bgrad`, IF(ga.`gps_bgrad`, ga.`gps_bgrad`, 0)) `gps_bgrad`, ga.`ortsteil`, ga.einrichtung o_einrichtung, ga.zu_uebersetzen o_einrichtung_2t, go.ort, gg.gebiet, gg.gebiet `tvf_gebiet`, go.`tvf_gebiet` AS tvf_gebiets_id, a.titel headline, a.titel_en headline_en, a.untertitel, a.untertitel_en, a.infotel, a.nummer, a.beschreibung text, a.beschreibung_en text_en, a.printtext `text_print`, a.zeit_dauer, MIN(uz.von) `zeit_von`, MIN(uz.bis) `zeit_bis`, a.buchbarer_zeitraum, CONCAT_WS("|", a.id, IF(a.als_zeitraum=1, 0, e.id)) group_by, IF( IF( a.als_zeitraum, MAX(IF(e.bis, e.bis, e.von)), e.bis ) = "0000-00-00", IF(a.als_zeitraum, MIN(e.von), e.von), IF( IF( a.als_zeitraum, MIN(e.von), e.von) < "2024-05-04", IF(a.als_zeitraum, MAX(IF(e.bis, "2024-05-04", e.von)), "2024-05-04"), IF(a.als_zeitraum, MIN(e.von), e.von)) ) sort_datum, IF(IF(a.als_zeitraum, MAX(IF(e.bis,e.bis,e.von)), e.bis)="0000-00-00", 0, TO_DAYS(IF(a.als_zeitraum, MAX(IF(e.bis,e.bis,e.von)), e.bis)) - TO_DAYS(IF(IF(a.als_zeitraum, MIN(e.von), e.von)<"2024-05-04", "2024-05-04",IF(a.als_zeitraum, MIN(e.von), e.von)))) sort_tage, DATE_FORMAT(IF(a.als_zeitraum, MIN(e.von), e.von), "%d.%m.%y") datum_von, DATE_FORMAT(IF(a.als_zeitraum, MAX(IF(e.bis,e.bis,e.von)), e.bis), "%d.%m.%y") datum_bis, IF(a.als_zeitraum, MIN(e.von), e.von) datum_von_din, IF(a.als_zeitraum, MAX(IF(e.bis,e.bis,e.von)), e.bis) datum_bis_din, MIN(uz.von) sort_zeit, GROUP_CONCAT(DISTINCT r.`name` ORDER BY r.`lft` ASC SEPARATOR ", ") `rubrik`, GROUP_CONCAT(DISTINCT r.`dzt_id` ORDER BY r.`lft` ASC SEPARATOR "#") `dzt_category`, "veranstaltungen" data_type, "/veranstaltungen/" mod_rewrite FROM timm_veranstaltungen.veranstaltungen a LEFT JOIN timm_veranstaltungen.themen_v t ON t.id = a.id LEFT JOIN timm_veranstaltungen.datum e ON e.veranst_id = a.id LEFT JOIN timm_veranstaltungen.rubriken_v rv ON rv.id = a.id LEFT JOIN timm_veranstaltungen.rubriken r ON r.id = rv.kat LEFT JOIN timm_magenta4_de.globale_adressen ga ON ga.id = a.ort LEFT JOIN timm_magenta4_de.globale_orte go ON go.id = ga.ort_klasse LEFT JOIN timm_magenta4_de.globale_gebiete gg ON gg.id = go.tvf_gebiet LEFT JOIN timm_veranstaltungen.uhrzeit uz ON uz.id = a.id LEFT JOIN timm_magenta4_de.globale_orte_v gov ON go.id=gov.id WHERE go.id IN (809,821,513,469,311,167,458,252,429,428,518,271,502,82,143,145,152,354,376,411,467,493,211,344,399,372,222,498,383,375,400,447,457,516,254,269,189,660,264,682,91,505,154,201,137,677,416,346,499,258,683,427,174,265,302,304,320,415,634,806,445,170,247,295,679,124,180,270,397,780,169,176,203,210,296,385,420,253,280,463,387,84,403,421,107,803,378,318,472,393,812,240,300,875,163,114,916,918,966,805,244,123,171,639,409,356,823,97) AND a.im_tvf=1 AND gov.kat=26 AND (a.fwsl_event="1" OR fwsl_fest="1") AND a.`ort`= 6721 AND a.buchbarer_zeitraum=0 AND a.id != 1 AND e.von <= "2025-05-04" AND IF(e.bis="0000-00-00", e.von >= "2024-05-04", e.bis >= "2024-05-04") AND a.`inactive` = 0 GROUP BY group_by HAVING 1 ORDER BY sort_datum, sort_tage, sort_zeit, a.titel"

Header-Image © FrankenTourismus / FWL / Hub