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 = 160 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'W2') 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  WF2W WNY 2014 303,975 1,341 105                    
2  SOHP  K7GM NNY 2014 196,554 850 102                    
3  SOHP  K2UF ENY 2014 146,784 793 88                    
4  SOHP  NW2K WNY 2014 128,605 743 85   North Coast Contesters                  
5  SOHP  K2NV WNY 2014 121,344 758 79   Niagara Frontier Radiosport                  
 
6  SOHP  N2ED NNJ 2014 108,360 573 90   Frankford Radio Club                  
7  SOHP  W2GN WNY 2014 92,500 626 74                    
8  SOHP  K2TTT NNJ 2014 80,659 488 79   Frankford Radio Club                  
9  SOHP  WW2Y NNJ 2014 78,514 460 74   Frankford Radio Club                  
10  SOHP  K2ONP ENY 2014 44,990 410 55   Hudson Valley Contesters and DXers                  
 
11  SOHP  WU2M NNY 2014 43,483 371 59                    
12  SOHP  WB2HJV WNY 2014 27,318 235 58   Rochester (NY) DX Assn                  
13  SOHP  K3OX SNJ 2014 20,557 164 61   Frankford Radio Club                  
14  SOHP  K2YR ENY 2014 13,908 106 57                    
15  SOHP  N2NT NNJ 2014 10,062 117 43   Frankford Radio Club                  
 

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

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