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 = 130 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'W9') AND cs.category_id = 'SO-CW-LP' 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-CW-LP  K9QVB IL 2013 470,184 862 137   Society of Midwest Contesters                  
2  SO-CW-LP  W9ILY IL 2013 303,056 615 124   Metro DX Club                  
3  SO-CW-LP  WO9S IL 2013 176,400 445 100   Society of Midwest Contesters                  
4  SO-CW-LP  K9CS IL 2013 168,096 410 103   Metro DX Club                  
5  SO-CW-LP  K9GY IL 2013 108,864 326 84   Society of Midwest Contesters                  
 
6  SO-CW-LP  WD9DZV IL 2013 104,152 288 94   Northern Illinois DX Assn                  
7  SO-CW-LP  N9CK WI 2013 96,840 270 90   Society of Midwest Contesters                  
8  SO-CW-LP  WC9C IN 2013 93,272 266 89                    
9  SO-CW-LP  N9XX WI 2013 84,512 279 76   Society of Midwest Contesters                  
10  SO-CW-LP  KB9S WI 2013 77,672 268 73   Minnesota Wireless Assn                  
 
11  SO-CW-LP  WT9U IN 2013 70,152 240 74   Society of Midwest Contesters                  
12  SO-CW-LP  W9TN IN 2013 61,632 215 72   Society of Midwest Contesters                  
13  SO-CW-LP  K9JU IL 2013 51,480 197 66                    
14  SO-CW-LP  WA9LEY IL 2013 44,164 184 61                    
15  SO-CW-LP  KO0Z IL 2013 30,680 150 59                    
 
16  SO-CW-LP  W9CHD WI 2013 26,320 140 47   Milwaukee Radio Amateurs Club                  
17  SO-CW-LP  N9CO IL 2013 19,740 105 47   Society of Midwest Contesters                  
18  SO-CW-LP  W9SE IL 2013 14,824 115 34   Society of Midwest Contesters                  
19  SO-CW-LP  K9GS WI 2013 3,864 42 23   Society of Midwest Contesters                  
20  SO-CW-LP  WU9D IN 2013 1,056 22 12   Society of Midwest Contesters                  
 
21  SO-CW-LP  KC9ELU IN 2013 128 9 4                    

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

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