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.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'W2') AND cs.category_id = 'SOU-MIX-LP' 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  SOU-MIX-LP  KD2RD NLI 2015 412,452 717 171                    
2  SOU-MIX-LP  K2DFC NNJ 2015 155,184 385 122   Sussex County ARC                  
3  SOU-MIX-LP  WA2JQK ENY 2015 90,390 236 131   Hudson Valley Contesters and DXers                  
4  SOU-MIX-LP  WR2G NNJ 2015 53,756 192 89                    
5  SOU-MIX-LP  K2TER WNY 2015 36,000 171 72   Rochester (NY) DX Assn                  
 
6  SOU-MIX-LP  KE2D SNJ 2015 33,660 145 66   South Jersey Radio Assn                  
7  SOU-MIX-LP  KC2LRC WNY 2015 12,960 97 48                    
8  SOU-MIX-LP  K2SI WNY 2015 4,864 52 32   Rochester (NY) DX Assn                  
9  SOU-MIX-LP  WB2TPS NLI 2015 2,024 24 23                    
10  SOU-MIX-LP  W2VM WNY 2015 1,196 25 13   Niagara Frontier Radiosport                  
 
11  SOU-MIX-LP  N2PQJ NLI 2015 220 11 10                    

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

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