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` INNER JOIN `tx_webxgsmap_resource_objecttype_mm` `mm_object_type` ON `r`.`uid` = `mm_object_type`.`uid_local` WHERE (`mm_category`.`uid_foreign` IN (:dcValue1)) AND (`mm_object_type`.`uid_foreign` IN (: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`.`object_type` <> :dcValue11) AND (`r`.`sys_language_uid` = :dcValue12) AND (((`r`.`deleted` = 0) AND (`r`.`hidden` = 0) AND (`r`.`starttime` <= 1780765860) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780765860))))) ORDER BY RAND(771) ASC LIMIT 10
Extbase Variable Dump
array(12 items)
   dcValue1 => array(1 item)
      0 => '42' (2 chars)
   dcValue2 => array(1 item)
      0 => '42' (2 chars)
   dcValue3 => 'sportclimbing_2018_route' (24 chars)
   dcValue4 => 'sportclimbing_2018_sector' (25 chars)
   dcValue5 => 'sportclimbing_2018' (18 chars)
   dcValue6 => 'gdi_piste' (9 chars)
   dcValue7 => 'gdi_lift' (8 chars)
   dcValue8 => 'climbing_route_2018_route' (25 chars)
   dcValue9 => 'climbing_route_2018_sector' (26 chars)
   dcValue10 => 'event' (5 chars)
   dcValue11 => 'event_phoenix' (13 chars)
   dcValue12 => 1 (integer)
Minigolf Achensee | Family Holidays Tirol Austria
Putt the ball through tricky obstacles!

Minigolf at Lake Achensee

Minigolf is a version of the sport of golf enjoyed by people of all ages and abilities. The game is all about navigating through obstacles to get your ball in the hole in as few shots as possible. A tournament minigolf course has 18 lanes where children and adults can have a proper competition or just enjoy a fun round of crazy golf.

0 Search results

You may also be interested in

golfsimulator.jpg

Golf simulators

golfen-am-achensee-4.jpg

Planning your golf holidays

golfen-am-achensee-5.jpg

Golf Tirol Card

TVB Achensee KI Assist