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.division_id LIKE 'AT' 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  K3LR WPA 2021 621,528 1,795 116 29.8  N2NC            1,795/116      
2  SOHP-20  N3MWQ DE 2021 12,987 113 39 10.3             113/39      
3  SOHP-20  K2QB WNY 2021 3,960 57 24 2.0  Niagara Frontier Radiosport            57/24      
4  SOHP-20  KC3HRS EPA 2021 2,205 35 21 2.6             35/21      
5  SOHP-20  KC3AEZ EPA 2021 2,079 35 21 5.1             35/21      
 
6  SOHP-20  N2DD WNY 2021 1,344 29 16 1.7  Rochester (NY) DX Assn            29/16      
7  SOHP-20  W7LG WPA 2021 1,248 32 13 2.1             32/13      
8  SOHP-20  N3ACP EPA 2021 855 20 15 2.3             20/15      
9  SOHP-20  KE3AO MDC 2021 90 7 5 0.9             7/5      
10  SOHP-20  K2MFW SNJ 2021 75 7 5 0.6             7/5      
 
11  SOHP-20  KN1OLA WPA 2021 36 4 3 0.2             4/3      
12  SOHP-20  W2STM WNY 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.