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 = 120 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'W5') AND cs.category_id = 'SO-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  SO-MIX-LP  WD5K NTX 2003 566,650 1,058 175   North Texas Contest Club                  
2  SO-MIX-LP  WQ5L MS 2003 498,996 918 166                    
3  SO-MIX-LP  WQ5C STX 2003 341,310 672 155   Central Texas DX and Contest Club                  
4  SO-MIX-LP  W5MK AR 2003 276,224 718 128                    
5  SO-MIX-LP  W0VX NTX 2003 249,920 542 142   North Texas Contest Club                  
 
6  SO-MIX-LP  W5OT LA 2003 164,800 454 103   WA5TWL                  
7  SO-MIX-LP  K5QX NTX 2003 151,200 391 120                    
8  SO-MIX-LP  NI5F MS 2003 87,360 269 105                    
9  SO-MIX-LP  AD6G STX 2003 69,552 243 92                    
10  SO-MIX-LP  WB5BYO NTX 2003 62,608 211 91                    
 
11  SO-MIX-LP  WX5I STX 2003 58,864 196 104                    
12  SO-MIX-LP  WK5K NTX 2003 51,590 205 77                    
13  SO-MIX-LP  K5IX STX 2003 48,750 195 75   Texas DX Society                  
14  SO-MIX-LP  NE0P OK 2003 40,200 182 67   Lawton Fort Sill ARC                  
15  SO-MIX-LP  KC5R LA 2003 38,090 167 65                    
 
16  SO-MIX-LP  KD5OMJ OK 2003 29,540 136 70                    
17  SO-MIX-LP  N5PU MS 2003 25,984 116 64                    
18  SO-MIX-LP  K5EJL STX 2003 6,156 69 27   Central Texas DX and Contest Club                  
19  SO-MIX-LP  WT5U STX 2003 3,348 45 31                    

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

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