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` <= 1791589380) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1791589380))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(2 items)
      0 => '114' (3 chars)
      1 => '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)
Skilehrerstüberl | Holiday Region Achensee
Accommodations
Experiences

Skilehrerstüberl

icon mountain hut/pasture with food & drink
icon mountain hut/pasture with food & drink © Tirol Werbung

The Skilehrerstüberl, situated right next to the Christlum valley station, has long been a favourite spot to warm up after a day of skiing. Its cozy atmosphere and diverse menu, featuring both traditional Tirolean specialties and international dishes, make it a popular choice for skiers.

more
less

Infrastructure on site

Christlum 1
to resources

opening hours

Closed until further notice
Next 7 days
Saturday
10.10.2026
closed
Sunday
11.10.2026
closed
Monday
12.10.2026
closed
Tuesday
13.10.2026
closed
Wednesday
14.10.2026
closed
Thursday
15.10.2026
closed
Friday
16.10.2026
closed
more less
Saturday
17.10.2026
closed
Sunday
18.10.2026
closed
Monday
19.10.2026
closed
Tuesday
20.10.2026
closed
Wednesday
21.10.2026
closed
Thursday
22.10.2026
closed
Friday
23.10.2026
closed
closed

Opening hours depend on snow conditions and the operation of the ski area.

Show on map

Hochalmlifte Christlum GmbH
Christlumsiedlung 115a
6215 Achenkirch am Achensee
+43 (5246) 6623
https://www.christlum.at/gastro-events#stuberl

Infrastructure on site

Christlum 1
to resources
EN

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

Open cookie settings
TVB Achensee KI Assist