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 => '47' (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)
5-summit via ferrata - Hochiss | Holiday Region Achensee

5-summit via ferrata - Hochiss

At 2,299m, the Hochiss is the highest mountain in the Rofan mountains and offers unique rock. The most impressive section is the summit face.

more
less

Infrastructure on site

Car park Rofan Seilbahn 1
Car park Rofan Seilbahn 2
Rofan cable car
Mauritzalm
Erfurter Hütte
Berggasthof Rofan
Almstüberl
Difficulty
webx_gs_difficulty_

Infrastructure on site

Car park Rofan Seilbahn 1
Car park Rofan Seilbahn 2
Rofan cable car
Mauritzalm
Erfurter Hütte
Berggasthof Rofan
Almstüberl
TVB Achensee KI Assist