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

Extbase Variable Dump

array(11 items)
   dcValue1 => array(3 items)
      0 => '2' (1 chars)
      1 => '60' (2 chars)
      2 => '767' (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)

Maurach - Häusererbühelkapelle - Maurach | Holiday Region Achensee

Unterkünfte

Erlebnisse

Maurach - Häusererbühelkapelle - Maurach

Panorama Häusererbühelkapelle © Achensee Tourismus

Weg ab der Rofan Seilbahn in Richtung Häusererbühelkapelle © Achensee Tourismus

Der Wanderweg führt links von der Talstation der Rofan Seilbahn über einen breiten aussichtsreichen Weg ansteigend zur Kapelle. Der Rückweg erfolgt über den gleichen Weg oder über den Waldweg.

mehr

weniger