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 = 14 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 100 AND cs.division_id LIKE 'DL' AND cs.category_id = 'SOUHP' 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  SOUHP  N4ZZ TN 2012 446,892 674 223   Tennessee Contest Group         56/34   191/76   309/77   118/36
2  SOUHP  AA4DD TN 2012 403,323 579 233   Bristol (TN) ARC      28/23   76/44   151/66   194/60   130/40
3  SOUHP  AF4AI TN 2012 320,160 484 230     4/4   34/26   83/51   114/56   175/62   74/31
4  SOUHP  WD4K TN 2012 271,491 441 209   Tennessee Contest Group   5/5   13/10   56/35   199/79   104/50   64/30
5  SOUHP  W3TZ AR 2012 119,070 303 135           19/16   121/60   163/59   
 
6  SOUHP  N5KDV MS 2012 70,281 174 137        15/13   37/32   28/25   71/46   23/21
7  SOUHP  NS4X TN 2012 68,208 204 112           10/9   37/25   94/50   63/28
8  SOUHP  NM5Z MS 2012 63,903 182 119   599 DX Association         1/1   55/45   88/49   38/24
9  SOUHP  K1GU TN 2012 12,675 65 65   Tennessee Contest Group         15/15   15/15   16/16   19/19
10  SOUHP  W5KI AR 2012 288 12 8                 5/2   7/6
 

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

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