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` <= 1780765500) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780765500))))) ORDER BY RAND(969) ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(2 items)
      0 => '98' (2 chars)
      1 => '216' (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)
Hundebadestrand | Holiday Region Achensee

Hundebadestrand

An der Seepromenade in Pertisau (Höhe Tunnel/Lawinengalerie) gibt es einen eigenen Hundebadestrand. Dieser eingezäunte Badebereich ist ca. 800m² groß und verfügt über einen Spender für Hundekotbeutel, Sitzbänke und zwei Metallstiegen mit hundefreundlichen Lochblechstufen zum Wasser sowie einer Rampe, die den Ausstieg aus dem Wasser für Hunde erleichtert.   

mehr
weniger
TVB Achensee KI Assist