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 = 3 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 208 AND cs.division_id LIKE 'MW' AND cs.category_id = 'SOLP' 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  SOLP  N0LL KS 2006 159,094 731 211                    
2  SOLP  WB0CQO IA 2006 32,065 265 121                    
3  SOLP  W0VD MO 2006 25,520 220 116                    
4  SOLP  N0YK KS 2006 24,592 222 106                    
5  SOLP  W0KT NE 2006 20,900 208 100                    
 
6  SOLP  WA0FQK MO 2006 13,875 185 75                    
7  SOLP  K9YV MO 2006 11,473 149 77                    
8  SOLP  N0JJQ IA 2006 11,310 145 78                    
9  SOLP  KC0TAS KS 2006 11,055 165 67                    
10  SOLP  AE0G NE 2006 10,449 129 81                    
 
11  SOLP  KC0RAD IA 2006 8,362 104 74                    
12  SOLP  N0UU KS 2006 8,260 140 59                    
13  SOLP  KA0OXN KS 2006 7,668 108 71                    
14  SOLP  KC0TDJ IA 2006 7,169 107 67                    
15  SOLP  KC0ATQ KS 2006 6,161 97 61                    
 
16  SOLP  AB0RX MO 2006 5,320 95 56   Society of Midwest Contesters                  
17  SOLP  AA0MZ KS 2006 4,648 83 56   Kansas City DX Club                  
18  SOLP  NB0Z KS 2006 3,476 79 44                    
19  SOLP  KA0EIC KS 2006 2,928 61 48                    
20  SOLP  KC0GLA KS 2006 2,655 59 45   Trojan ARC                  
 
21  SOLP  KC0DEB KS 2006 2,088 58 36                    
22  SOLP  K0ZS MO 2006 2,028 52 39                    
23  SOLP  WN0L NE 2006 1,980 45 44   Heartland DX Association                  
24  SOLP  N0LD KS 2006 924 32 28                    
25  SOLP  KC0VRK NE 2006 728 28 26   Lincoln ARC                  
 
26  SOLP  N0UIM MO 2006 128 16 8                    

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

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