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

Achenseehof

the wall height is 18 meters at the Achenseehof climbing garden
the wall height is 18 meters at the Achenseehof climbing garden © Achensee Tourismus
the wall height is 18 meters at the Achenseehof climbing garden
Achenseehof climbing garden - ideal for children and teenagers © Achensee Tourismus
the wall height is 18 meters at the Achenseehof climbing garden
Climbing garden Achenseehof - located on the lakeside path in Achenkirch © Achensee Tourismus
the wall height is 18 meters at the Achenseehof climbing garden
Achenseehof climbing garden - 9 to 18 meters high © Achensee Tourismus
the wall height is 18 meters at the Achenseehof climbing garden
Achenseehof - a climbing garden located directly on the lake shore © Achensee Tourismus
the wall height is 18 meters at the Achenseehof climbing garden
The Achenseehof is ideal for beginners in climbing. © Achensee Tourismus

The Achenseehof climbing crag in Achenkirch is located directly on the shores of Lake Achensee and expands Lake Achensee’s diverse climbing opportunities.

It offers 20 routes ranging from 9 to 18 metres in length – suitable for both climbing enthusiasts and novice climbers.

more
less

Infrastructure on site

Area Achenseehof
to resources
Achenseehof
to resources
Open
GPX File
Difficulty
webx_gs_difficulty_

Infrastructure on site

Area Achenseehof
to resources
Achenseehof
to resources
EN

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

Open cookie settings
TVB Achensee KI Assist