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 = 13 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 72 AND cs.section_id IN (SELECT section_id from ContestArrlSections) AND cs.category_id = 'SOHP-80' 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-80  W1MK EMA 2008 250,821 961 87   Yankee Clipper Contest Club      961/87            
2  SOHP-80  KT1V NH 2008 231,588 919 84   Yankee Clipper Contest Club      919/84            
3  SOHP-80  K9DX IL 2008 215,004 779 92   Society of Midwest Contesters      779/92            
4  SOHP-80  KV0Q CO 2008 90,771 383 79   Grand Mesa Contesters of Colorado      383/79            
5  SOHP-80  W6NV EB 2008 65,925 293 75   Northern California Contest Club      293/75            
 
6  SOHP-80  K9AY WI 2008 50,820 242 70   Society of Midwest Contesters      242/70            
7  SOHP-80  K1GU TN 2008 48,441 241 67   Tennessee Contest Group      241/67            
8  SOHP-80  NT2A NLI 2008 32,232 158 68   Yankee Clipper Contest Club      158/68            
9  SOHP-80  K8BN AZ 2008 27,264 142 64   Central Arizona DX Assn      142/64            
10  SOHP-80  NA4CW SFL 2008 27,027 143 63   Florida Contest Group      143/63            
 
11  SOHP-80  K8OQL WV 2008 25,728 134 64   Potomac Valley Radio Club      134/64            
12  SOHP-80  W5QP AR 2008 24,960 130 64        130/64            
13  SOHP-80  K9CS IL 2008 24,180 130 62   Society of Midwest Contesters      130/62            
14  SOHP-80  W2TX SFL 2008 22,176 132 56        132/56            
15  SOHP-80  K1UM NFL 2008 18,444 106 58   Florida Contest Group      106/58            
 
16  SOHP-80  W3SO WPA 2008 17,940 115 52   W3YOZ Potomac Valley Radio Club      115/52            
17  SOHP-80  K2LP EMA 2008 15,840 110 48                    
18  SOHP-80  WD5K NTX 2008 14,382 94 51   North Texas Contest Club      94/51            
19  SOHP-80  VE3RER ON 2008 12,936 98 44   Contest Club Ontario      98/44            
20  SOHP-80  NT6K SV 2008 11,655 105 37   Northern California Contest Club      105/37            
 
21  SOHP-80  K2SZ SNJ 2008 10,731 73 49   South Jersey DX Association      73/49            
22  SOHP-80  VE2DWA QC 2008 10,530 78 45        78/45            
23  SOHP-80  K6OY SCV 2008 9,870 70 47   Northern California Contest Club      70/47            
24  SOHP-80  W5HD LA 2008 8,514 66 43        66/43            
25  SOHP-80  WB8K OH 2008 7,872 64 41   North Coast Contesters      64/41            
 
26  SOHP-80  W8WVU MI 2008 7,254 62 39                    
27  SOHP-80  WB2AMU NLI 2008 6,660 60 37                    
28  SOHP-80  K0GEO STX 2008 3,720 40 31        40/31            
29  SOHP-80  N9LJX IN 2008 2,790 31 30   Society of Midwest Contesters      31/30            
30  SOHP-80  VA7MM BC 2008 1,566 29 18        29/18            
 
31  SOHP-80  W5JBV NFL 2008 429 13 11                    

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

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