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` <= 1780765680) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780765680))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(2 items)
      0 => '2' (1 chars)
      1 => '509' (3 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 => 0 (integer)
Achenkirch - Zöhreralm - Adlerhorst - Achenkirch | Holiday Region Achensee

Achenkirch - Zöhreralm - Adlerhorst - Achenkirch

Vom Parkplatz „Sonnberg“ beim Biomasseheizkraftwerk führt ein gut ausgebauter Forstweg zur Zöhreralm (1.334 Meter, Gehzeit ca. 1 Stunde 15 Minuten). Anschließend verläuft ein Steig weiter in Richtung Adlerhorst (1.230 Meter). Von dort führt ein schöner Weg über Serpentinen zurück zum Ausgangspunkt.

mehr
weniger

Infrastruktur vor Ort

Gemeindeamt Achenkirch - WC
Bäckerei Café Adler
Schwierigkeit
Leicht
Routenlänge
7.7 km
Gesamtzeit der Route
03:00 h
Höhenmeter Bergauf
410 hm

Infrastruktur vor Ort

Gemeindeamt Achenkirch - WC
Bäckerei Café Adler
TVB Achensee KI Assist