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 = 20 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 159 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'W9') AND cs.category_id = 'SOHP' 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  SOHP  K9AY WI 2013 308,374 1,361 107   Society of Midwest Contesters                  
2  SOHP  K9NR IL 2013 224,224 1,114 98   Society of Midwest Contesters                  
3  SOHP  N0IJ WI 2013 138,650 724 94   Minnesota Wireless Assn                  
4  SOHP  K9MA WI 2013 122,206 704 86                    
5  SOHP  W9AV WI 2013 109,212 725 76   Society of Midwest Contesters                  
 
6  SOHP  AB9H IL 2013 69,412 519 67   Society of Midwest Contesters                  
7  SOHP  K9WWT IN 2013 69,144 518 67                    
8  SOHP  K9OZ IL 2013 68,379 497 69   Society of Midwest Contesters                  
9  SOHP  W8FIB IN 2013 61,124 406 74                    
10  SOHP  NS9I WI 2013 60,606 399 74                    
 
11  SOHP  K3WA IL 2013 53,400 350 75   Society of Midwest Contesters                  
12  SOHP  W9OP WI 2013 51,840 354 72                    
13  SOHP  WA9CWX WI 2013 46,002 352 66                    
14  SOHP  K9ZM IL 2013 38,106 252 73   Society of Midwest Contesters                  
15  SOHP  W9IE IL 2013 36,480 287 64   Society of Midwest Contesters                  
 
16  SOHP  KJ9C IN 2013 26,448 227 58   Society of Midwest Contesters                  
17  SOHP  AA9A WI 2013 25,593 226 57                    
18  SOHP  K0TQ IN 2013 21,620 228 47                    
19  SOHP  K1TN WI 2013 18,565 198 47                    
20  SOHP  WX9U IL 2013 18,315 162 55   Society of Midwest Contesters                  
 
21  SOHP  W3HDH IL 2013 8,200 102 41   Society of Midwest Contesters                  
22  SOHP  K9CC IL 2013 6,552 95 36   Society of Midwest Contesters                  
23  SOHP  W9IIX IL 2013 3,248 57 29   Society of Midwest Contesters                  
24  SOHP  K9EA IN 2013 735 16 15                    

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

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