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` <= 1791589920) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1791589920))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(2 items)
      0 => '107' (3 chars)
      1 => '1311' (4 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)
FAMILY-Eldorado - Atoll Achensee | Holiday Region Achensee

FAMILY-Eldorado - Atoll Achensee

Right next to the Atoll Achensee in the FAMILY eldorado, the adventure ship St. Benedikt is a popular attraction for young visitors. After cruising on Lake Achensee for almost 60 years, the 31-metre-long ship was taken out of service and converted into an outdoor play paradise. Do your children love playing pirates? There is a play tower, suspension bridge, bird’s nest tree and climbing net for young adventurers to explore. In addition, a low ropes course, swing set, seesaw and flying fox offer plenty of opportunities for kids to let off some steam. The XXL sandbox and the open and tube slides will keep smaller children entertained.

more
less

Infrastructure on site

SEE-Bad - Atoll Achensee
Atoll Achensee
Lagoon - Atoll Achensee
BEACH-Bar Atoll Achensee
SNACK-Bar Atoll Achensee

opening hours

opens at 09:00
Next 7 days
Saturday
10.10.2026
09:00 - 19:00
Sunday
11.10.2026
09:00 - 19:00
Monday
12.10.2026
09:00 - 19:00
Tuesday
13.10.2026
09:00 - 19:00
Wednesday
14.10.2026
09:00 - 19:00
Thursday
15.10.2026
09:00 - 19:00
Friday
16.10.2026
09:00 - 19:00
more less
Saturday
17.10.2026
09:00 - 19:00
Sunday
18.10.2026
09:00 - 19:00
Monday
19.10.2026
09:00 - 19:00
Tuesday
20.10.2026
09:00 - 19:00
Wednesday
21.10.2026
09:00 - 19:00
Thursday
22.10.2026
09:00 - 19:00
Friday
23.10.2026
09:00 - 19:00
open today

Atoll Achensee

Infrastructure on site

SEE-Bad - Atoll Achensee
Atoll Achensee
Lagoon - Atoll Achensee
BEACH-Bar Atoll Achensee
SNACK-Bar Atoll Achensee
TVB Achensee KI Assist