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

Infopoint Pertisau | Holiday Region Achensee

Accommodations

Experiences

Infopoint Pertisau

Name: Tourismusverband Achensee
Address: Achenseestraße 63, Austria, Maurach am Achensee, 6212
Telephone: +43 5 95300-0
Price range: [€€]

icon WiFi © Achensee Tourismus

Lake Achensee is ONLINE and so are our guests. With the Achensee Free WiFi service you can surf the net for free and without any hassle during your stay at Lake Achensee.

less

opening hours

Open daily, 00:00–24:00

Show on map

Achensee Tourismus

Seepromenade

6213 Pertisau am Achensee

+43 5 95300-0

info@achensee.com

https://www.achensee.com

Infopoint Pertisau

opening hours

Contact

Mon - Sun 08:00–18:00

Follow us