Brauner Bär und weiße Traube
Opening hours :
open
March till October
November
December till February
Spend relaxing hours at our Franconian restaurant and cozy wine arbor. Enjoy our wines that complement our traditional Franconian as well as peppy modern cuisine.
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-03",
IF(a.als_zeitraum, MAX(IF(e.bis, "2024-05-03", e.von)), "2024-05-03"),
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-03", "2024-05-03",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`= 56406 AND a.buchbarer_zeitraum=0 AND a.id != 1 AND e.von <= "2025-05-03" AND IF(e.bis="0000-00-00", e.von >= "2024-05-03", e.bis >= "2024-05-03")
AND a.`inactive` = 0
GROUP BY group_by
HAVING 1
ORDER BY sort_datum, sort_tage, sort_zeit, a.titel"
