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 = 70 AND cs.section_id LIKE 'VA' AND cs.category_id = 'SOHP' 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 scores for U.S. Call Area 4 or Roanoke Division or All W/VE

Show Operators   Show Club  

❮❮First  ❮Prev     Page 1 of 1     Next❯  Last❯❯
RankCategoryCall SignQTHYearScoreQSOsMultsHoursOperatorsClub160 80 40 20 15 10
1  SOHP  W4RX VA 2006 3,175,326 2,607 406   K0DQ Potomac Valley Radio Club   54/40   180/63   900/99   778/90   660/94   35/20
2  SOHP  N2YO VA 2006 2,916,114 2,606 373   Potomac Valley Radio Club   66/41   316/74   671/77   1,089/85   441/82   23/14
3  SOHP  W4YE VA 2006 726,756 853 284   Potomac Valley Radio Club   8/8   116/50   208/69   349/73   150/70   22/14
4  SOHP  KT4U VA 2006 378,378 539 234     36/26   50/41   105/54   273/70   70/41   5/2
5  SOHP  W2YE VA 2006 189,000 350 180   Sterling Park ARC   35/26   75/41   91/39   96/41   53/33   
 
6  SOHP  K7CS VA 2006 174,573 357 163   Sterling Park ARC      71/39   115/50   131/42   40/32   
7  SOHP  N4MM VA 2006 163,620 303 180   Potomac Valley Radio Club                  
8  SOHP  WB3BEL VA 2006 121,032 246 164     43/32   60/36   56/33   41/30   44/31   2/2
9  SOHP  K4FOM VA 2006 71,280 240 99                    
10  SOHP  N4DJ VA 2006 39,000 130 100     13/12   32/27   47/32   25/18   13/11   
 
11  SOHP  WB4LNT VA 2006 36,549 131 93        17/14   32/23   46/27   36/29   
12  SOHP  W4/AH6HJ VA 2006 34,176 128 89     1/1   46/35   36/22      38/25   7/6
13  SOHP  KG3V VA 2006 4,305 41 35   Fauquier ARA         19/17   15/12   7/6   
14  SOHP  N3JB VA 2006 3,720 40 31     6/8   34/23            

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

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