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 = 131 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'W1') 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
SO-MIX-LP  W3EP CT 2014 1,090,122 1,471 249   Yankee Clipper Contest Club                  
SO-MIX-LP  WX1S NH 2014 650,468 1,097 182                    
SO-MIX-LP  W1CCE EMA 2014 370,000 626 185   Yankee Clipper Contest Club                  
SO-MIX-LP  K1PU CT 2014 189,334 412 137   Meriden ARC                  
SO-MIX-LP  W1EME WMA 2014 154,476 360 126                    
 
SO-MIX-LP  W1MSW WMA 2014 134,400 336 120   Hampden County Radio Association                  
SO-MIX-LP  AE1P NH 2014 128,088 420 108   Yankee Clipper Contest Club                  
SO-MIX-LP  NT1K WMA 2014 103,452 345 111   Hampden County Radio Association                  
SO-MIX-LP  K1IX EMA 2014 92,196 303 117   Yankee Clipper Contest Club                  
10  SO-MIX-LP  N1ALO EMA 2014 89,022 408 111                    
 
11  SO-MIX-LP  K1ZK VT 2014 70,884 257 99                    
12  SO-MIX-LP  WA7PRC WMA 2014 67,914 216 99   Western Washington DX Club                  
13  SO-MIX-LP  NJ1Q CT 2014 66,800 279 100                    
14  SO-MIX-LP  N1BYT EMA 2014 58,520 289 95                    
15  SO-MIX-LP  WN1E WMA 2014 34,992 135 72                    
 
16  SO-MIX-LP  AC1J NH 2014 20,212 123 62   Granite State ARA                  
17  SO-MIX-LP  W1MJ EMA 2014 19,872 100 54   Yankee Clipper Contest Club                  
18  SO-MIX-LP  WA1VKO NH 2014 12,064 104 58   Contoocook Valley Radio Club                  
19  SO-MIX-LP  KB1MU WMA 2014 10,920 114 52                    
20  SO-MIX-LP  W1CRK EMA 2014 10,600 107 50                    
 
21  SO-MIX-LP  WA1N NH 2014 6,162 52 39   Granite State ARA                  
22  SO-MIX-LP  K1ARR VT 2014 4,340 57 35                    
23  SO-MIX-LP  KA1C ME 2014 4,148 48 34                    
24  SO-MIX-LP  W1OZ ME 2014 3,658 49 31                    
25  SO-MIX-LP  NS1O NH 2014 3,584 57 32   Contoocook Valley Radio Club                  
 
26  SO-MIX-LP  W1JN CT 2014 3,344 44 22                    
27  SO-MIX-LP  WR1B CT 2014 3,224 56 31                    
28  SO-MIX-LP  KB1WEZ CT 2014 2,160 46 24                    
29  SO-MIX-LP  N1FJ WMA 2014 120 7 6   Hampden County Radio Association                  
30  SO-MIX-LP  W1HFG EMA 2014 30 3 3                    
 

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

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