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` <= 1786470720) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1786470720))))) 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 => 1 (integer)
Scholastika 2 | Holiday Region Achensee
Accommodations
Experiences

Scholastika 2

icon parking lot
icon parking lot © Achensee Tourismus

Please note: Bus parking spaces are reserved exclusively for restaurant guests. No bus turning area at the private car parks. Camping in car parks outside official campsites is not allowed.

more
less

opening hours

open until 23:59
Next 7 days
Tuesday
11.08.2026
00:00 - 23:59
Wednesday
12.08.2026
00:00 - 23:59
Thursday
13.08.2026
00:00 - 23:59
Friday
14.08.2026
00:00 - 23:59
Saturday
15.08.2026
00:00 - 23:59
Sunday
16.08.2026
00:00 - 23:59
Monday
17.08.2026
00:00 - 23:59
more less
Tuesday
18.08.2026
00:00 - 23:59
Wednesday
19.08.2026
00:00 - 23:59
Thursday
20.08.2026
00:00 - 23:59
Friday
21.08.2026
00:00 - 23:59
Saturday
22.08.2026
00:00 - 23:59
Sunday
23.08.2026
00:00 - 23:59
Monday
24.08.2026
00:00 - 23:59
now open
Show on map

Parkplatz Scholastika 2
Seestraße 12
6215 Achenkirch am Achensee
+43 (5246) 6210
info@scholastika.at
https://www.scholastika.at
EN

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

Open cookie settings
TVB Achensee KI Assist