5-Gipfel-Klettersteig - Seekarlspitze
Der Klettersteig an der Seekarlspitze im Rofangebirge führt in den Nordwandbereich und punktet mit atemberaubenden Tiefblicken. Die eindrucksvollste Passage ist gleich zu Beginn die Querung der Nordwand.
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` <= 1780771920) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780771920))))) ORDER BY RAND() ASC LIMIT 10
array(11 items) dcValue1 => array(1 item) 0 => '47' (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 => 0 (integer)
Der Klettersteig an der Seekarlspitze im Rofangebirge führt in den Nordwandbereich und punktet mit atemberaubenden Tiefblicken. Die eindrucksvollste Passage ist gleich zu Beginn die Querung der Nordwand.