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

Blaubergalm

Typical mountain eatery located at an elevation of 1,540 metres above sea level. The dishes are made with produce from the alpine pasture and the hut’s own farm. Homemade cheese and bacon are available for purchase. Overnight stays are possible on Mondays, Saturdays and public holidays.

more
less

Infrastructure on site

Die Alpenüberquerung (stage 2: Wildbad Kreuth - Achenkirch)
469 Achenwald-Blaubergalm
Achenkirch - Blaubergalm - Achenkirch

opening hours

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

Daniel Sprenger
In den Blaubergen
6215 Achenkirch am Achensee

Infrastructure on site

Die Alpenüberquerung (stage 2: Wildbad Kreuth - Achenkirch)
469 Achenwald-Blaubergalm
Achenkirch - Blaubergalm - Achenkirch
TVB Achensee KI Assist