Tuchhaus - Brunnenbar & Genießerei
Opening hours :
Advertisements
Summer:
Monday till Sunday: 02:00 p.m. to 10:00 p.m.
current dates: see website
Finally, it is back and celebrates a successful comeback: The legendary Volkacher Brunnenschoppen. Eagerly awaited by the citizens and guests of Volkach, it is now once again: "Come, let's go for a drink at the market fountain".
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`= 168769 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"