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.division_id LIKE 'CL' AND cs.category_id = 'SO-MIX-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-MIX-LP  W9GT IN 2013 222,272 514 151   Fort Wayne Radio Club                  
2  SO-MIX-LP  N9WKW IN 2013 200,842 419 137   Society of Midwest Contesters                  
3  SO-MIX-LP  KD9MS IL 2013 139,706 346 119   Society of Midwest Contesters                  
4  SO-MIX-LP  NM9P IN 2013 64,260 255 85                    
5  SO-MIX-LP  K9MU WI 2013 56,564 276 79   Minnesota Wireless Assn                  
 
6  SO-MIX-LP  KC9QPM IL 2013 51,510 214 85   Society of Midwest Contesters                  
7  SO-MIX-LP  K9PMV IL 2013 49,912 195 68   Metro DX Club                  
8  SO-MIX-LP  AJ9C IN 2013 44,370 182 85   Society of Midwest Contesters                  
9  SO-MIX-LP  WB8RFB IL 2013 42,918 185 69   Society of Midwest Contesters                  
10  SO-MIX-LP  WA9FIH IL 2013 40,964 201 77   Six Meter Club of Chicago                  
 
11  SO-MIX-LP  K9BTQ WI 2013 40,896 219 71   West Allis RAC                  
12  SO-MIX-LP  WB9HFK IL 2013 38,870 188 65                    
13  SO-MIX-LP  KC9CDW WI 2013 32,696 245 67                    
14  SO-MIX-LP  WB8BZK IL 2013 30,814 145 71   Society of Midwest Contesters                  
15  SO-MIX-LP  W9WLX WI 2013 23,760 118 55   West Allis RAC                  
 
16  SO-MIX-LP  WB9TFH WI 2013 23,664 161 68   Badger Contesters                  
17  SO-MIX-LP  KC9IL IL 2013 22,400 125 56   Society of Midwest Contesters                  
18  SO-MIX-LP  K9JE IL 2013 22,176 144 63   Society of Midwest Contesters                  
19  SO-MIX-LP  WR9Y WI 2013 21,902 134 47                    
20  SO-MIX-LP  K9DWS WI 2013 13,566 138 51                    
 
21  SO-MIX-LP  K9WD WI 2013 13,152 113 48                    
22  SO-MIX-LP  KV9W IN 2013 12,502 127 47   Society of Midwest Contesters                  
23  SO-MIX-LP  WA9ETL WI 2013 9,114 96 49                    
24  SO-MIX-LP  WS9E WI 2013 3,744 156 24                    
25  SO-MIX-LP  N9LYE IL 2013 2,772 62 22   Society of Midwest Contesters                  
 
26  SO-MIX-LP  W9VQ IL 2013 2,480 35 20   Society of Midwest Contesters                  
27  SO-MIX-LP  KC9TQF IL 2013 1,216 33 19   Six Meter Club of Chicago                  
28  SO-MIX-LP  K9JG IL 2013 340 16 10                    
29  SO-MIX-LP  AA9SR WI 2013 112 8 8   West Allis RAC                  

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

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