Winzer Sommerach Sommerbar
Opening hours :
Closed, opens at 9AM
Monday till Friday: 9:00AM till 6:00PM Saturday and Sunday, on public holidays: 10:00AM till 6:00PM
The WEINREICH vinotheque is always a popular meeting place, where you can enjoy wines from sustainable viticulture at the tasting bar all year round. In the summer months, the summer bar offers additional seating in the shady vine arbors or under the numerous parasols.
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`= 100374 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"