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

Alpen Caravan Park Achensee | Holiday Region Achensee

Unterkünfte

Erlebnisse

Alpen Caravan Park Achensee

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

Alpen Caravan Park Achensee

Sixenstraße 17

6215 Achenkirch am Achensee

+43 5 95300-0

info@achensee.com

https://www.achensee.com

Alpen Caravan Park Achensee

Öffnungszeiten

Kontakt

Mo - So 08:00–18:00

Folgt uns