SELECT cc.category_name , cs.category_id , cs.callsign , cs.host_callsign , YEAR(EventInstances.start_date) as yyyy , cs.score , cs.q_total , cs.m_total , cs.section_id , cs.dxcc_prefix , CASE WHEN cs.event_id = 1 AND vhf_region_id BETWEEN 1 AND 17 THEN vhf_region_id WHEN cs.event_id = 1 AND vhf_region_id NOT BETWEEN 1 AND 17 THEN 18 ELSE NULL END AS vhf_region_id , FORMAT(EXTRACTVALUE(cs.details,'minutes_on')/60.0,1) AS hours_on , GROUP_CONCAT(co.callsign ORDER BY co.callsign SEPARATOR ' ') AS ops , CASE WHEN cs.club_status > 10 THEN NULL ELSE cs.clb_abbr END AS club_abbr , CASE WHEN cs.club_status > 10 THEN NULL ELSE ContestClubs.clb_name END AS club_name , cs.details , cs.score_id , cs.late_log_flag FROM ContestScores cs JOIN ContestCategories cc ON cs.category_id = cc.category_id JOIN EventInstances ON cs.instance_id = EventInstances.instance_id JOIN EventInfo ON cs.event_id = EventInfo.event_id LEFT OUTER JOIN ContestOperators co ON cs.score_id = co.score_id LEFT OUTER JOIN ContestArrlSections cas ON cs.section_id = cas.section_id LEFT OUTER JOIN ContestClubs ON cs.clb_abbr = ContestClubs.clb_abbr WHERE cs.event_id = 21 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 120 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'W0') AND cs.category_id = 'MSHP' GROUP BY cs.score_id ORDER BY cs.score DESC

Contest Scores

From the list below, select the contest or call sign for which you want to view scores and then click on Go.

 

or

Show Operators   Show Club  

❮❮First  ❮Prev     Page 1 of 1     Next❯  Last❯❯
RankCategoryCall SignQTHYearScoreQSOsMultsHoursOperatorsClub160 80 40 20 15 10
1  MSHP  K0DU CO 2003 696,924 1,656 162   K0CL K0DU K0UK N0ZA Grand Mesa Contesters of Colorado                  
2  MSHP  KR0B MN 2003 591,624 1,280 162   K0KP KB0KQA KJ0B KR0B KS0T N0BKL N0RA Minnesota Wireless Assn                  
3  MSHP  KD0S SD 2003 524,560 1,066 166   KC0OCH KD0S WD0T                  
4  MSHP  W0NO KS 2003 506,506 1,054 161   AB0S W0NO                  
5  MSHP  KB0VVT MO 2003 490,656 1,085 152   KB0VVT KG0US Kansas City DX Club                  
 
6  MSHP  K0GAS CO 2003 446,020 1,092 145   K0GAS KJ0G Grand Mesa Contesters of Colorado                  
7  MSHP  K0JPL MO 2003 287,076 731 141   K0JPL N5TN Society of Midwest Contesters                  
8  MSHP  K0AD MN 2003 118,524 368 102   Minnesota Wireless Assn                  
9  MSHP  W0CP CO 2003 83,600 396 95   K0ZV W0CP Western Wireless Contest Club                  
10  MSHP  N7IV ND 2003 58,302 222 79   N7IV W0FOB                  
 
11  MSHP  W0EF MN 2003 26,592 190 48   K0AD K0BUD KC0LBT KC0MNU KC0QJP KN0F N0MGQ W0AMT WB0N WG0M Minnesota Wireless Assn                  
12  MSHP  K0SV MN 2003 16,116 113 51   K0SV KC0IRY Minnesota Wireless Assn                  

❮❮First  ❮Prev     Page 1 of 1     Next❯  Last❯❯

Scores in italics were received after the deadline and/or are not eligible for awards.