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` <= 1780769340) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780769340))))) ORDER BY RAND() ASC LIMIT 10

Extbase Variable Dump

array(11 items)
   dcValue1 => array(3 items)
      0 => '131' (3 chars)
      1 => '135' (3 chars)
      2 => '771' (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)

Sports Guide - Rene Delmas | Holiday Region Achensee

Accommodations

Experiences

Sports Guide - Rene Delmas

Sports Guide logo © Sports Guide - Rene Delmas

sports guide Rene Delmas © Sports Guide - Rene Delmas

Rene Delmas - bike guide and certified hiking guide © Rene Delmas

Guided, adventurous hiking or (e-)bike tours. From sightseeing, an unforgettable sunrise tour to an ambitious day tour. Individually tailored to you! A holiday like you imagine it!

Tours can be booked online on www.achen-see.at.

Note: Rene Delmas also runs the Tiroler Langlaufschule Nordic Sports Eben am Achensee.

less

opening hours

Please contact the provider directly to arrange an appointment.

Show on map

Rene Delmas

Neumauracher Straße 66

6212 Maurach am Achensee

+43 (664) 9216888

sportsguide@achen-see.at

https://www.achen-see.at

Sports Guide - Rene Delmas

opening hours

Contact

Mon - Sun 08:00–18:00

Follow us