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` <= 1780772940) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780772940))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(1 item)
      0 => '84' (2 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)
P5 - Loipe Tristenau | Holiday Region Achensee
Accommodations
Experiences

P5 - Loipe Tristenau

Tristenautal valley in Pertisau
Tristenautal valley in Pertisau © Achensee Tourismus
Tristenautal valley in Pertisau
at the beginning on the Tristenau cross-country ski trail © Achensee Tourismus
Tristenautal valley in Pertisau
cross-country skiing centre Pertisau © Achensee Tourismus
Tristenautal valley in Pertisau
inn "Langlaufstüberl" at the cross-country skiing centre in Pertisau © Achensee Tourismus
Tristenautal valley in Pertisau
Cross-country skiing with the family - starting point cross-country skiing centre in Pertisau - start of the Tristenau trail, Falzthurn-Gramai and Pletzach-Gern trail © Achensee Tourismus

At the beginning, the difficult trail leads over the terrain of the golf club Achensee, then climbs through the forest to the end of the idyllic Tristenau valley. For advanced skiers. 

more
less

Infrastructure on site

Langlaufstüberl - WC
to resources
Romantikrestaurant & Tanzlokal Langlaufstüberl
to resources
Karwendeltäler
to resources
Sport Wöll
to resources
Closed
GPX File
Difficulty
Hard
Route Length
7 km
Route Time Total
01:00 h
Elevation Gain
180 hm

Infrastructure on site

Langlaufstüberl - WC
to resources
Romantikrestaurant & Tanzlokal Langlaufstüberl
to resources
Karwendeltäler
to resources
Sport Wöll
to resources
EN

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

Open cookie settings
TVB Achensee KI Assist