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 = 20 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 156 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'VE') 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  VY2ZM MAR 2010 864,753 1,989 141   K1ZM                  
2  SOHP  VE3EJ ON 2010 586,929 1,745 133                    
3  SOHP  VA2EW QC 2010 397,625 1,344 125   Contest Group du Quebec                  
4  SOHP  VE3MMQ ON 2010 278,415 1,070 115   Contest Club Ontario                  
5  SOHP  VE7CC BC 2010 187,357 854 103   BC DX Club                  
 
6  SOHP  VE3CX ON 2010 173,910 913 93   Contest Club Ontario                  
7  SOHP  VE5UA AB 2010 172,710 834 101                    
8  SOHP  VA2WDQ QC 2010 141,329 684 97   Contest Group du Quebec                  
9  SOHP  VE5UF SK 2010 120,211 644 91   Saskatchewan Contest Club                  
10  SOHP  VE9AA MAR 2010 110,688 535 96   Maritime Contest Club                  
 
11  SOHP  VE6BBP AB 2010 103,252 609 83                    
12  SOHP  VE3CUI ON 2010 87,516 566 78   Contest Club Ontario                  
13  SOHP  VO1TA NL 2010 44,226 223 78   East Coast Canada Contest Club                  
14  SOHP  VE3MM ON 2010 37,920 314 60   Contest Club Ontario                  
15  SOHP  VE7JKZ BC 2010 33,930 254 65                    
 
16  SOHP  VE3KZ ON 2010 32,147 258 61   Contest Club Ontario                  
17  SOHP  VO1HP NL 2010 29,678 137 71                    
18  SOHP  VE2EZD QC 2010 24,920 219 56   Contest Group du Quebec                  
19  SOHP  VE3OI ON 2010 23,814 172 63   Contest Club Ontario                  
20  SOHP  VE6TL AB 2010 23,232 172 66   Alberta Clippers                  
 
21  SOHP  VE3BNO ON 2010 14,628 158 46   Contest Club Ontario                  
22  SOHP  VE7XF BC 2010 11,000 101 55   Orca DX and Contest Club                  
23  SOHP  VE3EBN ON 2010 8,320 107 40   Contest Club Ontario                  
24  SOHP  VA5SAM SK 2010 280 10 8                    

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

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