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 = 14 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 96 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  W9RE IN 2008 1,198,194 1,392 289   Society of Midwest Contesters   36/30   194/65   149/53   869/98   119/36   25/7
2  SOHP  WB9Z IL 2008 1,031,610 1,277 274   Society of Midwest Contesters   26/24   98/56   171/53   864/97   98/36   20/8
3  SOHP  N0IJ WI 2008 310,752 506 208   Minnesota Wireless Assn   17/16   58/41   67/36   275/82   86/31   3/2
4  SOHP  K9BGL IL 2008 255,021 505 169   Society of Midwest Contesters   7/6   48/32   43/24   307/71   77/28   23/8
5  SOHP  W9JA WI 2008 159,960 322 172     9/8   36/27   50/34   148/70   74/30   5/3
 
6  SOHP  WA9IVH IL 2008 40,824 169 84   Society of Midwest Contesters      1/1   12/12   84/44   72/27   
7  SOHP  N9WKW IN 2008 17,487 91 67        6/6   13/11   41/29   29/19   2/2
8  SOHP  W9SE IL 2008 17,460 98 60   Society of Midwest Contesters         24/17   30/21   44/22   
9  SOHP  K9VS WI 2008 9,450 74 45   Badger Contesters            64/37   10/8   
10  SOHP  AK9Y IL 2008 8,844 70 44   Metro DX Club            42/29   28/15   
 
11  SOHP  K9JIG WI 2008 7,695 58 45   Northeast Wisconsin DX Assn            35/28   23/17   
12  SOHP  N9JZN IL 2008 5,292 51 36           11/8   31/21   9/7   

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

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