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

Extbase Variable Dump

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

Sportschule Achensee –Stefan Wöll | Holiday Region Achensee

Unterkünfte

Erlebnisse

Sportschule Achensee –Stefan Wöll

Sportschule Achensee © Sportschule Achensee

Tennisunterricht, Langlaufunterricht und geführte Skitouren mit Stefan Wöll. Der geprüfte Bergwanderführer und staatlich geprüfte Skiführer bietet professionelle Betreuung im Sommer und Winter. Tennisschläger und Bälle stehen bei Bedarf zum Verleih zur Verfügung.

mehr

weniger

Öffnungszeiten

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

Auf Karte anzeigen

Stefan Wöll

Ländbergstraße 10

6213 Pertisau am Achensee

+43 (676) 847994100

info@sportschule-achensee.com

http://www.sportschule-achensee.com

Sportschule Achensee –Stefan Wöll

Öffnungszeiten

Kontakt

Mo - So 08:00–18:00

Folgt uns