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 = 21 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 132 AND cs.division_id LIKE 'HU' AND cs.category_id = 'SO-MIX-HP' 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  SO-MIX-HP  W2XL ENY 2015 406,896 778 168   Hudson Valley Contesters and DXers                  
2  SO-MIX-HP  WA2CP NLI 2015 192,240 554 135   KC2GOW Camp Pouch Amateur Radio Association                  
3  SO-MIX-HP  K2TTT NNJ 2015 115,632 365 88   Frankford Radio Club                  
4  SO-MIX-HP  N2JNE ENY 2015 24,276 128 51   Hudson Valley Contesters and DXers                  
5  SO-MIX-HP  WB2PJH NNJ 2015 23,868 136 51   Frankford Radio Club                  
 
6  SO-MIX-HP  W2JTM ENY 2015 20,212 165 62                    
7  SO-MIX-HP  N2FF NLI 2015 19,716 125 62   Order of Boiled Owls of New York                  
8  SO-MIX-HP  W2UDT NNJ 2015 14,478 94 57   Frankford Radio Club                  
9  SO-MIX-HP  W2ANQ NLI 2015 7,098 58 39   Great South Bay ARC                  
10  SO-MIX-HP  KD2D ENY 2015 3,100 50 31                    
 
11  SO-MIX-HP  KC2TVJ ENY 2015 128 9 8                    

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

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