Seewaldhütte
Die Seewaldhütte wird von Mitgliedern der DAV Sektion Achensee ehrenamtlich betreut. Ausschank von Getränken.
Die Hütte ist von Mitte Juni bis Ende September 2025 an Samstagen geöffnet.
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` <= 1780772880) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780772880))))) ORDER BY RAND() ASC LIMIT 10
array(11 items) dcValue1 => array(1 item) 0 => '119' (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 => 0 (integer)
Die Seewaldhütte wird von Mitgliedern der DAV Sektion Achensee ehrenamtlich betreut. Ausschank von Getränken.
Die Hütte ist von Mitte Juni bis Ende September 2025 an Samstagen geöffnet.