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` <= 1780777140) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780777140))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(1 item)
      0 => '34' (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)
Einfach Fliegenfischen | Holiday Region Achensee
Accommodations
Experiences

Einfach Fliegenfischen

logo Einfach Fliegenfischen e.V.
fish pond in Pertisau © Einfach Fliegenfischen e.V.
logo Einfach Fliegenfischen e.V.
logo Einfach Fliegenfischen e.V. © Einfach Fliegenfischen e.V.

Einfach Fliegenfischen offers fly-fishing courses for beginners. Learn about the proper equipment, basic casting, and how to handle the fly rod. Courses are held at the fishing pond in Pertisau or at the Oberautalbach stream in Achenkirch. 

more
less

opening hours

Please contact the provider directly for opening times.

Show on map

Roman Sautner
gegenüber Bootshaus
6213 Pertisau am Achensee
+43 (699) 10021610
info@einfach-fliegenfischen.at
https://www.einfach-fliegenfischen.at
EN

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

Open cookie settings
TVB Achensee KI Assist