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 = 961 AND cs.section_id IN (SELECT section_id from ContestArrlSections) AND cs.category_id = 'SOHP-80' 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-80  W1HI RI 2021 17,748 118 51 11.2  Yankee Clipper Contest Club      118/51            
2  SOHP-80  VA3SK ONN 2021 5,088 55 32 3.0  Contest Club Ontario      55/32            
3  SOHP-80  NY1E ME 2021 1,860 32 20 1.8       32/20            
4  SOHP-80  VE9ML MAR 2021 1,620 30 18 1.6       30/18            
5  SOHP-80  WB4DNL VA 2021 1,020 20 17 9.0                   
 
6  SOHP-80  K4ESE NC 2021 672 16 14 1.7  Carolina DX Association      16/14            
7  SOHP-80  AF8C OH 2021 363 12 11 2.0  West Park Radiops      12/11            
8  SOHP-80  NG0C MN 2021 144 8 6 0.4  Minnesota Wireless Assn      8/6            
9  SOHP-80  K4HPS NC 2021 75 7 5 5.7       7/5            
10  SOHP-80  WZ6ZZ EB 2021 36 4 3 4.9       4/3            
 
11  SOHP-80  VE2GT QC 2021 3 1 1        1/1            

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

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