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 = 13 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 81 AND cs.division_id LIKE 'DL' AND cs.category_id = 'SOULP' 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  SOULP  W4TTM TN 2017 86,583 218 133   Bristol (TN) ARC   1/1   31/23   80/40   39/28   53/32   14/9
2  SOULP  KG5HVO LA 2017 60,180 173 118        4/4   65/42   47/34   43/30   14/8
3  SOULP  WB5OZA LA 2017 23,793 107 77        1/1   24/18   39/30   43/28   
4  SOULP  W4JUU TN 2017 19,608 91 76   Cleveland ARC      12/12   34/25   34/28   8/8   3/3
5  SOULP  K7ZYV MS 2017 18,768 96 68        1/1   18/13   29/21   41/27   7/6
 
6  SOULP  WB9G LA 2017 17,748 87 68           18/17   22/18   29/20   18/13
7  SOULP  W4HVH LA 2017 15,624 86 62           17/13   30/25   17/12   22/12
8  SOULP  N4ARO TN 2017 13,020 74 62   Tennessee Contest Group   15/13   36/30   15/11      8/8   
9  SOULP  W4LSV TN 2017 5,031 43 39           17/15   17/15   9/9   
10  SOULP  NT5I LA 2017 4,884 45 37              29/24   16/13   
 

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

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