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 = 18 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 43 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.

 

Show Operators   Show Club  

❮❮First  ❮Prev     Page 1 of 1     Next❯  Last❯❯
RankCategoryCall SignQTHYearScoreQSOsMultsHoursOperatorsClub160 80 40 20 15 10
MSHP  KA1ARB NC 2007 219,840 1,374 80 24.0  KA1ARB WB1ADR Potomac Valley Radio Club      667/0   356/0   328/0   23/0   
MSHP  K4TS VA 2007 161,280 1,008 80 24.0  AF4UU K4GMH W4IM Potomac Valley Radio Club      492/0   296/0   212/0   8/0   
MSHP  NY4A NC 2007 156,800 980 80 24.0  AL4T K4QPL Potomac Valley Radio Club      507/0   342/0   115/0   16/0   
MSHP  K4IX VA 2007 116,000 725 80 23.0  AG4JT KU4EC W0CN W4PRO W4TVG W4WV W4ZYT WB4DNL Potomac Valley Radio Club      244/0   126/0   266/0   89/0   
MSHP  KC4D VA 2007 80,422 509 79 23.0  KC4D W4DF WA4RTS WB4ZPF Potomac Valley Radio Club      336/0   37/0   127/0   9/0   
 
MSHP  W4MY NC 2007 73,440 459 80 22.0  KC4HDI KI4QXS W4MY Potomac Valley Radio Club      303/0   87/0   56/0   13/0   
MSHP  KN4KL VA 2007 69,120 432 80 17.0  KI4IWS KN4KL KO4SJ N4ZBE W4OTN Potomac Valley Radio Club   8/0   146/0   83/0   176/0   19/0   
MSHP  KK4R VA 2007 42,090 305 69 12.0  KK4R WB7URZ      214/0   35/0   34/0   22/0   
MSHP  N4KIT VA 2007 30,800 200 77 15.0  KI4UNO N4KIT      75/0   61/0   59/0   5/0   
10  MSHP  WC4J VA 2007 19,710 135 73 9.0  KU4WH WC4J Potomac Valley Radio Club   8/0   70/0   12/0   42/0   3/0   
 
11  MSHP  AA8UL WV 2007 4,366 59 37 4.0  WA8KAN         21/0   20/0   18/0   

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

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