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 = 135 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'W1') AND cs.category_id = 'SOU-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  SOU-MIX-HP  W3EP CT 2018 199,120 600 95 21.2                   
2  SOU-MIX-HP  K1ZZ CT 2018 66,480 303 60 7.4  Yankee Clipper Contest Club                  
3  SOU-MIX-HP  NV1Q EMA 2018 47,520 229 66 12.8  Hampden County Radio Association                  
4  SOU-MIX-HP  K1GQ NH 2018 29,440 187 40 4.5                   
5  SOU-MIX-HP  AB1JV RI 2018 27,280 134 62 7.2                   
 
6  SOU-MIX-HP  K1BG WMA 2018 18,216 131 36 3.2  Yankee Clipper Contest Club                  
7  SOU-MIX-HP  K1RX NH 2018 15,744 130 32 3.6  Yankee Clipper Contest Club                  
8  SOU-MIX-HP  W1CTN CT 2018 12,246 101 39 4.9  Yankee Clipper Contest Club                  
9  SOU-MIX-HP  W1SSN CT 2018 4,080 47 24                    
10  SOU-MIX-HP  W1GD WMA 2018 2,352 31 24 0.8  Yankee Clipper Contest Club                  
 
11  SOU-MIX-HP  KV1J EMA 2018 1,734 33 17 1.0  Yankee Clipper Contest Club                  
12  SOU-MIX-HP  WV1M CT 2018 864 27 12 1.0                   

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

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