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 = 131 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'W0') AND cs.category_id = 'SO-PH-HP' 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  SO-PH-HP  K0JU CO 2014 493,612 2,040 122                    
2  SO-PH-HP  WS7X CO 2014 399,272 1,737 116                    
3  SO-PH-HP  KD0LRG IA 2014 286,212 1,196 122                    
4  SO-PH-HP  K0RH KS 2014 236,874 1,073 111                    
5  SO-PH-HP  NC0B CO 2014 235,250 946 125                    
 
6  SO-PH-HP  K9MWM CO 2014 181,350 996 93   Grand Mesa Contesters of Colorado                  
7  SO-PH-HP  NU0C NE 2014 171,392 839 103   Lincoln ARC                  
8  SO-PH-HP  KQ0C CO 2014 135,240 649 105   Grand Mesa Contesters of Colorado                  
9  SO-PH-HP  AA0A MO 2014 107,198 595 91                    
10  SO-PH-HP  WB0LJK IA 2014 64,020 298 110                    
 
11  SO-PH-HP  K0RJW MN 2014 34,048 229 76   Minnesota Wireless Assn                  
12  SO-PH-HP  WB0GBI NE 2014 30,954 203 77                    
13  SO-PH-HP  W0PPF IA 2014 28,014 203 69                    
14  SO-PH-HP  N0WRK CO 2014 22,448 191 61                    
15  SO-PH-HP  KC0VTJ KS 2014 21,168 178 63                    
 
16  SO-PH-HP  N0XOC MN 2014 19,760 152 65   Minnesota Wireless Assn                  
17  SO-PH-HP  K0SIX MN 2014 18,832 214 44   Minnesota Wireless Assn                  
18  SO-PH-HP  NU0W MN 2014 13,800 101 69   Minnesota Wireless Assn                  
19  SO-PH-HP  AC0B MN 2014 11,200 116 50   Minnesota Wireless Assn                  
20  SO-PH-HP  NY0T KS 2014 6,560 80 41                    
 

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

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