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` <= 1780771980) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780771980))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(3 items)
      0 => '70' (2 chars)
      1 => '115' (3 chars)
      2 => '127' (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)
Café StressLess | Holiday Region Achensee
Accommodations
Experiences

Café StressLess

cozy terrace of Café StressLess
cozy terrace of Café StressLess © Café Stressless
cozy terrace of Café StressLess
exterior view of the Café StressLess © Café Stressless

There are various snacks to choose from, as well as cake and ice cream. Breakfast is available for guests in the morning.

more
less

opening hours

open until 23:00
Next 7 days
Saturday
06.06.2026
08:00 - 23:00
Sunday
07.06.2026
closed
Monday
08.06.2026
closed
Tuesday
09.06.2026
08:00 - 23:00
Wednesday
10.06.2026
08:00 - 23:00
Thursday
11.06.2026
08:00 - 23:00
Friday
12.06.2026
08:00 - 23:00
more less
Saturday
13.06.2026
08:00 - 23:00
Sunday
14.06.2026
closed
Monday
15.06.2026
closed
Tuesday
16.06.2026
08:00 - 23:00
Wednesday
17.06.2026
08:00 - 23:00
Thursday
18.06.2026
08:00 - 23:00
Friday
19.06.2026
08:00 - 23:00
now open
Show on map

Marina Aschberger
Dorf 33
6210 Wiesing
https://www.cafe-stressless.at
EN

The item cannot be displayed. To see the item, accept the marketing cookies.

Open cookie settings
TVB Achensee KI Assist