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 = 14 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 97 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'VE') AND cs.category_id = 'SOHP-20' 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-20  VE3XN ON 2009 364,746 1,147 106   Contest Club Ontario                  
2  SOHP-20  VE5ZX SK 2009 214,524 716 101   Saskatchewan Contest Club            716/101      
3  SOHP-20  VE6SF AB 2009 79,212 337 82              337/82      
4  SOHP-20  VA7JW BC 2009 41,688 196 72              196/72      
5  SOHP-20  VO2NS NL 2009 36,570 233 53              233/53      
 
6  SOHP-20  VE7FE BC 2009 32,424 195 56              195/56      
7  SOHP-20  VE3RHD ON 2009 8,640 72 40              72/40      
8  SOHP-20  VA7ALK BC 2009 4,650 62 25              62/25      
9  SOHP-20  VA3WPV ON 2009 3,240 41 27              41/27      
10  SOHP-20  VE3AJ ON 2009 1,653 31 19   Contest Club Ontario            31/19      
 
11  SOHP-20  VA3RJ ON 2009 1,026 19 19   Contest Club Ontario            19/19      
12  SOHP-20  VA7GAP BC 2009 816 34 8                    
13  SOHP-20  VE3JOG ON 2009 108 6 6                    

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

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