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

Extbase Variable Dump

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

Karwendeltäler | Holiday Region Achensee

Unterkünfte

Erlebnisse

Karwendeltäler

der Ort Pertisau - rechts der Parkplatz Karwendeltäler © Achensee Tourismus

Icon Parkplatz © Achensee Tourismus

Am Automaten kann auch ein Mehrtagesticket gelöst werden – einfach die gewünschte Anzahl an Tagen einstellen. Das Ticket gut sichtbar hinter die Windschutzscheibe legen.

mehr

weniger

Öffnungszeiten

Ganzjährig

Auf Karte anzeigen

Gemeindeamt Eben am Achensee

Naturparkstraße 81

6212 Maurach am Achensee

+43 (5243) 5202

gemeinde@eben-achensee.gv.at

https://www.eben-achensee.gv.at

Karwendeltäler

Öffnungszeiten

Kontakt

Mo - So 08:00–18:00

Folgt uns