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

Informationsbüro Achenkirch | Holiday Region Achensee

Unterkünfte

Erlebnisse

Informationsbüro Achenkirch

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

Informationsbüro Achenkirch

Untere Dorfstraße 387

6215 Achenkirch am Achensee

+43 5 95300-0

info@achensee.com

https://www.achensee.com

Informationsbüro Achenkirch

Öffnungszeiten

Kontakt

Mo - So 08:00–18:00

Folgt uns