Launch site Zwölferkopf (Pertisau)
There are three launch sites next to the top station of the Karwendel cable car. One of these launch sites faces north, while the other two face west.
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(2 items) 0 => '31' (2 chars) 1 => '96' (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)
There are three launch sites next to the top station of the Karwendel cable car. One of these launch sites faces north, while the other two face west.