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

Panorama-Restaurant Kanzelkehre | Holiday Region Achensee

Unterkünfte

Erlebnisse

Panorama-Restaurant Kanzelkehre

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

Panorama-Restaurant Kanzelkehre

Astenberg 510

6210 Wiesing

+43 5 95300-0

info@achensee.com

https://www.achensee.com

Panorama-Restaurant Kanzelkehre

Öffnungszeiten

Kontakt

Mo - So 08:00–18:00

Folgt uns