SELECT DISTINCT r.uid, r.foreign_id, JSON_UNQUOTE(JSON_EXTRACT(r.json_data, '$.metadata.difficulty')) AS metadata_string, JSON_UNQUOTE(JSON_EXTRACT(r.json_data, '$.metadata.route_length')) AS metadata_string FROM `tx_webxgsmap_domain_model_resource` `r` INNER JOIN `tx_webxgsmap_resource_category_mm` `mm_category` ON `r`.`uid` = `mm_category`.`uid_local` WHERE (`mm_category`.`uid_foreign` IN (:dcValue1)) AND (`r`.`object_type` <> :dcValue2) AND (`r`.`object_type` <> :dcValue3) AND (`r`.`object_type` <> :dcValue4) AND (`r`.`object_type` <> :dcValue5) AND (`r`.`object_type` <> :dcValue6) AND (`r`.`object_type` <> :dcValue7) AND (`r`.`object_type` <> :dcValue8) AND (`r`.`object_type` <> :dcValue9) AND (`r`.`object_type` <> :dcValue10) AND (`r`.`sys_language_uid` = :dcValue11) AND (((`r`.`deleted` = 0) AND (`r`.`hidden` = 0) AND (`r`.`starttime` <= 1780773060) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780773060))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(1 item)
      0 => '114' (3 chars)
   dcValue2 => 'sportclimbing_2018_route' (24 chars)
   dcValue3 => 'sportclimbing_2018_sector' (25 chars)
   dcValue4 => 'sportclimbing_2018' (18 chars)
   dcValue5 => 'gdi_piste' (9 chars)
   dcValue6 => 'gdi_lift' (8 chars)
   dcValue7 => 'climbing_route_2018_route' (25 chars)
   dcValue8 => 'climbing_route_2018_sector' (26 chars)
   dcValue9 => 'event' (5 chars)
   dcValue10 => 'event_phoenix' (13 chars)
   dcValue11 => 1 (integer)
Dorfwirt Wiesing | Holiday Region Achensee

Dorfwirt Wiesing

Discover a fresh take on tradition at the Dorfwirt in Wiesing, where the culinary team is passionate about creating regional specialties. With a capacity of up to 80 guests, the restaurant is the ideal choice for any occasion, from festive parties to group meetings.

On weekends, from Friday to Sunday, the Dorfwirt serves a delightful afternoon selection from 14:00 to 17:30.

more
less

Infrastructure on site

Underground car park in the centre of Wiesing
Car park between Raiffeisenbank and Widum (parish house)
ENI Tankstelle Wiesing

opening hours

Closing soon
Next 7 days
Saturday
06.06.2026
11:00 - 22:00
Sunday
07.06.2026
11:00 - 22:00
Monday
08.06.2026
closed
Tuesday
09.06.2026
closed
Wednesday
10.06.2026
11:00 - 14:00
17:00 - 22:00
Thursday
11.06.2026
11:00 - 14:00
17:00 - 22:00
Friday
12.06.2026
11:00 - 22:00
more less
Saturday
13.06.2026
11:00 - 22:00
Sunday
14.06.2026
11:00 - 22:00
Monday
15.06.2026
closed
Tuesday
16.06.2026
closed
Wednesday
17.06.2026
11:00 - 14:00
17:00 - 22:00
Thursday
18.06.2026
11:00 - 14:00
17:00 - 22:00
Friday
19.06.2026
11:00 - 22:00
now open

Andreas Grill und Mario Klingler

Infrastructure on site

Underground car park in the centre of Wiesing
Car park between Raiffeisenbank and Widum (parish house)
ENI Tankstelle Wiesing
TVB Achensee KI Assist