Bistro & Wein
The chic wine bistro of the Thomas Mend winery is located in the center of Iphofen. "Fresh, seasonal, regional" is the motto of the establishment. Taste authentic Franconian wines and an extensive selection of creative Franconian tapas.
string(4544) "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`= 188135 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"
