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` <= 1791589200) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1791589200))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(3 items)
      0 => '70' (2 chars)
      1 => '114' (3 chars)
      2 => '115' (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)
Seehotel Einwaller | Holiday Region Achensee

Seehotel Einwaller

Have you ever tried the homemade ice creams? Feast on the various snacks, homemade pizzas and cake specialities and treat yourself to a cosy drink -always with a direct and unrestricted view of the crystal-clear lake, of course. In the evening, the à la carte restaurant serves a fine selection of varied dishes.

In order to continue to offer all guests the ideal moment of enjoyment away from the hustle and bustle, the hotel asks for table reservations.

Info: Breakfast 08:00–11:00 with reservation | Afternoon coffee, cakes & light dishes until 17:00 | From 18:00 à la carte with reservation

more
less

opening hours

opens at 08:00
Next 7 days
Saturday
10.10.2026
08:00 - 22:00
Sunday
11.10.2026
08:00 - 22:00
Monday
12.10.2026
08:00 - 22:00
Tuesday
13.10.2026
08:00 - 22:00
Wednesday
14.10.2026
closed
Thursday
15.10.2026
08:00 - 22:00
Friday
16.10.2026
08:00 - 22:00
more less
Saturday
17.10.2026
08:00 - 22:00
Sunday
18.10.2026
08:00 - 22:00
Monday
19.10.2026
08:00 - 22:00
Tuesday
20.10.2026
08:00 - 22:00
Wednesday
21.10.2026
closed
Thursday
22.10.2026
08:00 - 22:00
Friday
23.10.2026
08:00 - 22:00
open today

Familie Carina und Christian Angerer
Seepromenade 15
6213 Pertisau am Achensee
TVB Achensee KI Assist