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 = 130 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'W5') AND cs.category_id = 'SO-PH-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-PH-HP  NR5M STX 2013 818,736 2,778 148   DFW Contest Group                  
2  SO-PH-HP  W5PR STX 2013 744,892 2,576 146   Texas DX Society                  
3  SO-PH-HP  K5TR STX 2013 614,040 2,212 140   WM5R Central Texas DX and Contest Club                  
4  SO-PH-HP  WA5ZUP NM 2013 375,002 1,940 97                    
5  SO-PH-HP  WA5OYU MS 2013 330,106 1,252 133                    
 
6  SO-PH-HP  AG5Z MS 2013 204,974 855 121   599 DX Association                  
7  SO-PH-HP  AD5XD NTX 2013 183,192 907 102   DFW Contest Group                  
8  SO-PH-HP  NT5V NTX 2013 182,952 933 99   DFW Contest Group                  
9  SO-PH-HP  KW5JC OK 2013 43,920 254 90                    
10  SO-PH-HP  K5PO AR 2013 26,586 214 63                    
 
11  SO-PH-HP  K7RB NTX 2013 17,706 229 39   DFW Contest Group                  
12  SO-PH-HP  N5BLY MS 2013 17,080 143 61   599 DX Association                  
13  SO-PH-HP  W5TKZ STX 2013 15,688 152 53   Brazos Valley ARC                  
14  SO-PH-HP  KC5SB OK 2013 672 24 14                    

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

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