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

462 Plumsjoch

The trail starts at the Plumssattel (1,669 metres) in the Nature Park Karwendel and can be accessed via the red route 452 (Risstal–Plumsjoch). It is a very steep downhill route with sharp bends, leading to the Alpengasthof Gern Alm (serviced).
ATTENTION: This trail is suitable only for experienced bikers and includes sections where you will need to dismount and walk your bike.

 

Note: The distances given indicate the length of the one-way route, as shown on the map and in the elevation profile.

more
less

Infrastructure on site

Alpengasthof Gern Alm
Plumsjochhütte
Difficulty
Hard
Route Length
2.8 km
Route Time Total
00:30 h

Infrastructure on site

Alpengasthof Gern Alm
Plumsjochhütte
TVB Achensee KI Assist