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)

Gemeindeamt Steinberg am Rofan | Holiday Region Achensee

Unterkünfte

Erlebnisse

Gemeindeamt Steinberg am Rofan

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

Auf Karte anzeigen

Gemeinde Steinberg am Rofan

Steinberg 29

6215 Steinberg am Rofan

+43 5 95300-0

info@achensee.com

https://www.achensee.com

Gemeindeamt Steinberg am Rofan

Kontakt

Mo - So 08:00–18:00

Folgt uns