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 = 128 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'VE') 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
1  SO-MIX-LP  VE3CX ON 2011 257,174 581 149 12.0  Contest Club Ontario                  
2  SO-MIX-LP  VE4YU MB 2011 234,472 466 158 10.0                   
3  SO-MIX-LP  VE3IAE ON 2011 221,078 467 143 17.0  Contest Club Ontario                  
4  SO-MIX-LP  VE7WO BC 2011 203,294 584 91 10.0  Orca DX and Contest Club                  
5  SO-MIX-LP  VX2AWR QC 2011 189,810 425 135 13.0  VE2AWR                  
 
6  SO-MIX-LP  VE5UO SK 2011 186,456 534 102 10.0                   
7  SO-MIX-LP  VE9ML MAR 2011 182,972 474 149 17.0  Maritime Contest Club                  
8  SO-MIX-LP  VE5SF SK 2011 159,160 552 92 8.0  Saskatchewan Contest Club                  
9  SO-MIX-LP  VE1ZA MAR 2011 122,472 416 108 5.0  Maritime Contest Club                  
10  SO-MIX-LP  VE1JS MAR 2011 115,920 415 120 10.0  Maritime Contest Club                  
 
11  SO-MIX-LP  VE3FH ON 2011 113,000 319 113 15.0  Contest Club Ontario                  
12  SO-MIX-LP  VA7AM BC 2011 111,520 702 80 12.0  Orca DX and Contest Club                  
13  SO-MIX-LP  VE3JI ON 2011 95,904 309 111 10.0  Contest Club Ontario                  
14  SO-MIX-LP  VE5AAD SK 2011 71,390 411 59                    
15  SO-MIX-LP  VE3NE ON 2011 56,684 200 74 10.0  Contest Club Ontario                  
 
16  SO-MIX-LP  VA7DXC BC 2011 48,380 202 82 9.0  Orca DX and Contest Club                  
17  SO-MIX-LP  VA7CPC BC 2011 46,576 177 82 8.0                   
18  SO-MIX-LP  VE9OA MAR 2011 41,984 158 82 8.0                   
19  SO-MIX-LP  VE2AXO QC 2011 40,052 166 62 5.0  Contest Group du Quebec                  
20  SO-MIX-LP  VE3RCN ON 2011 35,000 147 70 4.0  Contest Club Ontario                  
 
21  SO-MIX-LP  VE7BC BC 2011 27,832 134 71 5.0  BC DX Club                  
22  SO-MIX-LP  VA3KAI ON 2011 24,426 124 59 5.0  Contest Club Ontario                  
23  SO-MIX-LP  VE6SH AB 2011 16,700 163 50 2.0                   
24  SO-MIX-LP  VE7BGP BC 2011 16,124 100 58 6.0  Nanaimo Amateur Radio Association                  
25  SO-MIX-LP  VE8DW TER 2011 11,660 109 53 7.0                   
 
26  SO-MIX-LP  VE3LXL ON 2011 3,216 38 24 4.0                   

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

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