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` <= 1780775940) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780775940))))) ORDER BY RAND() ASC LIMIT 10

Extbase Variable Dump

array(11 items)
   dcValue1 => array(1 item)
      0 => '78' (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)

Hochplatte (1,813m) - option 2 | Holiday Region Achensee

Accommodations

Experiences

Hochplatte (1,813m) - option 2

ski tour to the Hochplatte in Achenkirch © Achensee Tourismus

The route climbs alongside the asphalt road in a northerly direction (300m), then follows the forest road to the Bründlalm. The tour continues in a north-westerly direction to the Jochalm, then back to the forest road, through sparse forest to the Seewaldhütte (1,582m). The route leads further to the west over the ridge to the summit.
The descent follows the ascent route.

less