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

Extbase Variable Dump

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

Langlaufschule Achensee - Peter Schwandl | Holiday Region Achensee

Unterkünfte

Erlebnisse

Langlaufschule Achensee - Peter Schwandl

Langlaufschule Achensee © Langlaufschule Achensee

Geführte E-Bike und Mountainbiketouren, geführte Bergwandertouren, Bogensport und Skirollerunterricht (Leihmaterial vorhanden) werden bei der Langlaufschule Achensee geboten.

mehr

weniger

Öffnungszeiten

Bitte wendet euch bezüglich Terminabsprache direkt an den Anbieter.

Auf Karte anzeigen

Peter Schwandl

Florianiweg 3/2

6212 Maurach am Achensee

+43 (688) 8193605

info@langlaufschule-achensee.at

https://www.langlaufschule-achensee.at

Langlaufschule Achensee - Peter Schwandl

Öffnungszeiten

Kontakt

Mo - So 08:00–18:00

Folgt uns