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

Extbase Variable Dump

array(11 items)
   dcValue1 => array(1 item)
      0 => '26' (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 => 0 (integer)

Notburga Runde | Holiday Region Achensee

Unterkünfte

Erlebnisse

Notburga Runde

laufen bei Seespitz in Maurach in Richtung Freizeitanlage Atoll Achensee © Achensee Tourismus

laufen am Seeufer in Maurach © Achensee Tourismus

nordic walking am See bei Seepsitz © Achensee Tourismus

oberhalb vom Hotel Huber Hochland führt die Notburga Laufrunde zurück in Richtung See © Achensee Tourismus

Vom SEE-Bad Atoll Achensee führt die Strecke durch Maurach bis zum Ortsteil Neumaurach und entlang des St. Notburga Promenadenweges bis zur Pfarrkirche in Eben. Über einen flachen Feldweg geht es zurück zum Ausgangspunkt.

mehr

weniger