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)
407 Ampelsbach-Guffert | Holiday Region Achensee

407 Ampelsbach-Guffert

From the starting point, a forest road climbs alongside the Ampelsbach stream to a bridge, then turns left and continues at a 10% gradient. The route turns right and leads to the beautifully situated Gufferthütte (serviced). From there, a circular walk leads to the Rhaetian rock inscriptions. 


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

Köglboden
Rhaetian inscriptions
Gufferthütte
Difficulty
Medium
Route Length
7.8 km
Route Time Total
01:30 h
Elevation Gain
510 hm

Infrastructure on site

Köglboden
Rhaetian inscriptions
Gufferthütte
TVB Achensee KI Assist