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 = 129 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  N0NI IA 2012 631,584 1,110 172 25.0  N0AC N0NI N0XR Iowa DX and Contest Club                  
2  MSHP  N0AT MN 2012 486,542 968 161 24.0  K0BBC N0AT Minnesota Wireless Assn                  
3  MSHP  K0DU CO 2012 424,764 809 171 26.0  K0CL K0UK Grand Mesa Contesters of Colorado                  
4  MSHP  KD0S SD 2012 254,332 595 146 20.0  KD0S WD0T                  
5  MSHP  K0PK MN 2012 146,452 415 94 16.0  Minnesota Wireless Assn                  
 
6  MSHP  W0TT MO 2012 127,400 361 98 15.0  Mississippi Valley DX/Contest Club                  
7  MSHP  K0KX MN 2012 92,276 227 118 10.0  Minnesota Wireless Assn                  
8  MSHP  AA0AW MN 2012 68,968 261 74 7.0  Minnesota Wireless Assn                  
9  MSHP  N0TA CO 2012 56,538 192 81 11.0  Grand Mesa Contesters of Colorado                  
10  MSHP  K0EU CO 2012 55,200 203 80 5.0  Grand Mesa Contesters of Colorado                  
 
11  MSHP  W0HBH MO 2012 22,800 105 57 5.0  Mississippi Valley DX/Contest Club                  
12  MSHP  KC0RSX MN 2012 3,720 47 30 4.0  Winona ARC                  
13  MSHP  AA0A MO 2012 3,528 60 28 4.0                   
14  MSHP  K4IU MN 2012 1,944 29 18 1.0  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.