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

Extbase Variable Dump

array(12 items)
   dcValue1 => array(1 item)
      0 => '197' (3 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)

Achensee free Wi-Fi | Free internet access Tirol

Surf the internet for free!

Free Wi-Fi in the Achensee region

Looking for upcoming events, the weather forecast, the best bike routes and ski tours? The Achensee region provides fast and easy internet access without registration required. Just log in and start surfing the web. How about posting a beautiful photo online or sharing it with your friends and loved ones at home? Next time they will join you!