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

Extbase Variable Dump

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

Karwendel-Bergbahn Bergstation | Holiday Region Achensee

Unterkünfte

Erlebnisse

Karwendel-Bergbahn Bergstation

Name: Tourismusverband Achensee
Address: Achenseestraße 63, Österreich, Maurach am Achensee, 6212
Telephone: +43 5 95300-0
Price range: [€€]

wlan © Achensee Tourismus

Der Achensee ist ONLINE und somit auch seine Gäste. Mit dem Achensee Free WLAN Angebot surfen Sie kostenlos während Ihres Aufenthaltes in der Region Achensee.

mehr

weniger

Öffnungszeiten

0–24 Uhr, täglich

Auf Karte anzeigen

Karwendel-Bergbahn GmbH

Naturparkstraße 31

6213 Pertisau am Achensee

+43 5 95300-0

info@achensee.com

https://www.achensee.com

Karwendel-Bergbahn Bergstation

Öffnungszeiten

Kontakt

Mo - So 08:00–18:00

Folgt uns