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` <= 1780771920) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780771920))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(2 items)
      0 => '31' (2 chars)
      1 => '96' (2 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)
Tandem Achensee | Holiday Region Achensee
Accommodations
Experiences

Tandem Achensee

logo Tandem Achensee
tandem jump from Rofan - behind it the Rofan mountains © Tandem Achensee
logo Tandem Achensee
tandem jump in Maurach - with a view of Pertisau and Lake Achensee © Tandem Achensee
logo Tandem Achensee
tandem Tandem jump in Maurach - with a view of Lake Achensee © Tandem Achensee
logo Tandem Achensee
logo Tandem Achensee © Tandem Achensee
logo Tandem Achensee
at the launch site in the Rofan mountains in Maurach © Tandem Achensee

Infrastructure on site

Car park Rofan Seilbahn 1
to resources
Rofan cable car
to resources

opening hours

The flight times depend on the operating times of the Rofan cable car. However, appointments can also be arranged with the provider outside these operating hours. Please contact the provider directly to make an appointment - by phone, WhatsApp or email. Tandem Achensee can be reached by phone daily from 08:00 to 19:00.

Show on map

Markus Enthofer
Häuserergasse 7/1
6212 Maurach am Achensee
+43 (650) 4907723
info@tandem-achensee.at
https://www.tandem-achensee.at

Infrastructure on site

Car park Rofan Seilbahn 1
to resources
Rofan cable car
to resources
EN

The item cannot be displayed. To see the item, accept the marketing cookies.

Open cookie settings
TVB Achensee KI Assist