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 = 20 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 158 AND cs.division_id LIKE 'RK' AND cs.category_id = 'MSHP' 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  MSHP  N3UA VA 2012 394,208 1,350 127   Central Virginia Contest Club                  
2  MSHP  N1LN NC 2012 387,321 1,438 121   N1LN N3ND N4CW W0UCE Potomac Valley Radio Club                  
3  MSHP  W4PM VA 2012 248,724 1,078 108   K4OSO W4HZ W4PM @W4HZ Central Virginia Contest Club                  
4  MSHP  KC4D VA 2012 227,910 1,003 107   K2KW KC4D KK4XX Potomac Valley Radio Club                  
5  MSHP  K2AV NC 2012 227,794 998 106   Potomac Valley Radio Club                  
 
6  MSHP  NR4M VA 2012 218,448 866 111   K7SV NR4M Potomac Valley Radio Club                  
7  MSHP  W4NF VA 2012 202,633 1,003 97   Potomac Valley Radio Club                  
8  MSHP  W4PK VA 2012 160,281 758 99   Potomac Valley Radio Club                  
9  MSHP  K2SX SC 2012 127,248 707 88                    
10  MSHP  N4HB VA 2012 126,810 683 90                    
 
11  MSHP  WJ2D NC 2012 123,453 593 99                    
12  MSHP  W4RM VA 2012 117,513 554 99   Potomac Valley Radio Club                  
13  MSHP  KG4W VA 2012 112,608 567 92   Central Virginia Contest Club                  
14  MSHP  N4RV VA 2012 77,556 390 92   Potomac Valley Radio Club                  
15  MSHP  N3MK VA 2012 62,566 354 82   Potomac Valley Radio Club                  
 
16  MSHP  K0ZR VA 2012 41,276 300 68   Loudoun ARG                  
17  MSHP  K1GG VA 2012 36,778 256 71   Potomac Valley Radio Club                  
18  MSHP  AA4V SC 2012 30,336 229 64   Low Country Contest Club                  
19  MSHP  W3YY VA 2012 21,653 170 59   Potomac Valley Radio Club                  
20  MSHP  N3BM VA 2012 20,900 208 50   Potomac Valley Radio Club                  
 
21  MSHP  N4DWK VA 2012 9,890 102 46   Central Virginia Contest Club                  
22  MSHP  W4PFM VA 2012 8,316 94 42   Potomac Valley Radio Club                  
23  MSHP  K4XD NC 2012 6,437 77 41   Potomac Valley Radio Club                  
24  MSHP  W4JVN VA 2012 3,472 57 28   Potomac Valley Radio Club                  
25  MSHP  KA3EHL VA 2012 112 8 7   Woodbridge Wireless                  
 

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

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