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 'W4') 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  K0EJ TN 2015 322,944 762 116   Tennessee Contest Group                  
2  SO-MIX-HP  KT4Q NFL 2015 156,864 557 114   Florida Contest Group                  
3  SO-MIX-HP  NN3W VA 2015 135,184 310 136   Potomac Valley Radio Club                  
4  SO-MIX-HP  K4MF SFL 2015 66,542 208 97   Florida Contest Group                  
5  SO-MIX-HP  K4ADR SFL 2015 46,400 201 80   Florida Contest Group                  
 
6  SO-MIX-HP  N4LZ NFL 2015 36,920 160 71   Florida Contest Group                  
7  SO-MIX-HP  N4WE AL 2015 34,384 161 56   Alabama Contest Group                  
8  SO-MIX-HP  N4KH AL 2015 21,902 127 47   Alabama Contest Group                  
9  SO-MIX-HP  ND2O NC 2015 18,816 124 64                    
10  SO-MIX-HP  K4QPL NC 2015 13,818 87 49   Potomac Valley Radio Club                  
 
11  SO-MIX-HP  WX4US NFL 2015 12,556 146 43                    
12  SO-MIX-HP  W7HJ VA 2015 4,970 37 35   Potomac Valley Radio Club                  
13  SO-MIX-HP  KK4PC AL 2015 3,300 67 25                    
14  SO-MIX-HP  K4AB AL 2015 1,768 27 17   Alabama Contest Group                  
15  SO-MIX-HP  KF6JG TN 2015 888 40 12                    
 

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

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