Restaurant Alter Esel
A house on the historical register right in the middle of the historic town of Marktbreit is the location of this exclusive and fine restaurant. The chef carefully prepares mostly international culinary treats that are sure to impress.
Outdoor seating is available.
string(4543) "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-06",
IF(a.als_zeitraum, MAX(IF(e.bis, "2024-05-06", e.von)), "2024-05-06"),
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-06", "2024-05-06",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`= 41308 AND a.buchbarer_zeitraum=0 AND a.id != 1 AND e.von <= "2025-05-06" AND IF(e.bis="0000-00-00", e.von >= "2024-05-06", e.bis >= "2024-05-06")
AND a.`inactive` = 0
GROUP BY group_by
HAVING 1
ORDER BY sort_datum, sort_tage, sort_zeit, a.titel"
