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` <= 1786472940) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1786472940))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(2 items)
      0 => '119' (3 chars)
      1 => '121' (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)
Gaisalm | Holiday Region Achensee

Gaisalm

The Gaisalm is a haven of tranquility which is hard to find these days. It lies nestled between the mountains and the lake in an idyllic, secluded location, directly on the peaceful western shore of Lake Achensee. The culinary team spoils guests with traditional dishes, Tirolean delicacies, and homemade cooked desserts. The playground is within eyeshot of the terrace. The Gaisalm is open in the summer season and a popular stopover for locals, tourists, and families alike.

more
less

Infrastructure on site

Die Alpenüberquerung (stage 3: Achenkirch - Maurach am Achensee/Fügen)
Playground Gaisalm
Achenkirch - Gaisalm (Mariensteig) - Pertisau - Achenkirch
Pertisau - Gaisalm - Achenkirch - Pertisau
Shipping pier Gaisalm

opening hours

opens on 12/08/2026 at 08:30
Next 7 days
Tuesday
11.08.2026
08:30 - 18:00
Wednesday
12.08.2026
08:30 - 18:00
Thursday
13.08.2026
08:30 - 18:00
Friday
14.08.2026
08:30 - 18:00
Saturday
15.08.2026
08:30 - 18:00
Sunday
16.08.2026
08:30 - 18:00
Monday
17.08.2026
08:30 - 18:00
more less
Tuesday
18.08.2026
08:30 - 18:00
Wednesday
19.08.2026
08:30 - 18:00
Thursday
20.08.2026
08:30 - 18:00
Friday
21.08.2026
08:30 - 18:00
Saturday
22.08.2026
08:30 - 18:00
Sunday
23.08.2026
08:30 - 18:00
Monday
24.08.2026
08:30 - 18:00
closed today

Rainer Hollaus

Infrastructure on site

Die Alpenüberquerung (stage 3: Achenkirch - Maurach am Achensee/Fügen)
Playground Gaisalm
Achenkirch - Gaisalm (Mariensteig) - Pertisau - Achenkirch
Pertisau - Gaisalm - Achenkirch - Pertisau
Shipping pier Gaisalm
TVB Achensee KI Assist