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)
465 Rund um den Guffert | Holiday Region Achensee

465 Rund um den Guffert

From the starting point the route follows the forest road alongside the Ampelsbach stream. Underneath the Gufferthütte (serviced, route 407) – follow the signs Kaiserhaus/Pinegg to Kaiserhaus (serviced). The route continues over a gravel road back to the starting point via Steinberg am Rofan. 


Note: The distance indicated is for the complete loop.

more
less

Infrastructure on site

Köglboden
Gasthaus Waldhäusl
Dorfhaus Steinberg
Gasthaus Kaiserhaus
Gufferthütte
Difficulty
Medium
Route Length
41 km
Route Time Total
06:00 h
Elevation Gain
990 hm

Infrastructure on site

Köglboden
Gasthaus Waldhäusl
Dorfhaus Steinberg
Gasthaus Kaiserhaus
Gufferthütte
TVB Achensee KI Assist