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` <= 1780769340) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780769340))))) 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)
484 Riederbergweg | Holiday Region Achensee

484 Riederbergweg

From the starting point, the route initially leads on an asphalt road towards the hotel “Das Kronthaler”. The route then runs along the forest road Riederberg, past the reservoir and the Christlum Alm (not serviced), to the Riederbergstüberl (not serviced). From there a forest road climbs gently to the Gföllalm (serviced, 1,381 metres). To get to the Moosenalm (not serviced, 1,530 metres), turn right about 700 metres before the Gföllalm and after another two kilometres and 200 metres in altitude you reach the Moosenalm.


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

Christlum 1
Porsche Destination Charging Hotel Das Kronthaler 4*S
Difficulty
Medium
Route Length
4.7 km
Route Time Total
01:00 h
Elevation Gain
430 hm

Infrastructure on site

Christlum 1
Porsche Destination Charging Hotel Das Kronthaler 4*S
TVB Achensee KI Assist