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` <= 1780769640) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780769640))))) 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

Einzel- und Gruppentraining im Tennis sowie geführte Skitouren im Winter. Stefan Wöll ist ein Geprüfter Bergwanderführer sowie Staatlich geprüfter Skiführer.

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

https://www.sportschule-achensee.com

Sportschule Achensee - Stefan Wöll

Öffnungszeiten

Kontakt

Mo - So 08:00–18:00

Folgt uns