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 = 4 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 194 AND cs.section_id IN (SELECT section_id from ContestArrlSections) 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 or

Show Operators   Show Club  

❮❮First  ❮Prev     Page 2 of 2     Next❯  Last❯❯
RankCategoryCall SignQTHYearScoreQSOsMultsHoursOperatorsClub160 80 40 20 15 10
101  MSHP  VE3IGJ ON 2010 15,136 122 43   VE3IGJ VE3YTZ      2/2   25/14   97/27      
102  MSHP  W4PHS TN 2010 14,832 169 48        1/1   37/16   134/29   7/2   
103  MSHP  VE6AX AB 2010 13,920 102 40        1/1   6/2   95/35   1/1   1/1
104  MSHP  N4BCD AL 2010 13,650 113 50        1/1   16/12   75/30   24/5   3/2
105  MSHP  N5JB NTX 2010 13,454 116 31              118/31      
 
106  MSHP  W1CU CT 2010 13,100 116 25           1/1   114/23   1/1   
107  MSHP  ND4V GA 2010 12,272 88 52        1/1   5/5   71/39   5/4   6/3
108  MSHP  N2FF NLI 2010 11,583 79 39              56/19   24/20   
109  MSHP  NO2J WNY 2010 11,070 108 41   N2LID NO2J         15/5   64/27   26/7   3/2
110  MSHP  KR7LD ID 2010 8,289 119 27   KR7LD N7HUG            123/27      
 
111  MSHP  AE7AB MT 2010 7,820 102 34   AE7AB KF7CLI         23/8   86/26      
112  MSHP  W6XK SJV 2010 5,600 56 28           4/4   49/19   5/5   
113  MSHP  N6MI LAX 2010 4,848 60 24           50/15   11/9      
114  MSHP  AB1KW NH 2010 3,712 44 32        4/2   28/18   14/12      
115  MSHP  N6DW SV 2010 3,000 34 25           24/16   10/9      
 
116  MSHP  K6RM SCV 2010 2,760 52 20              49/17   3/3   
117  MSHP  N0RQ NTX 2010 2,214 32 27              30/25   2/2   
118  MSHP  VE3XAT ON 2010 1,905 45 15              20/6   23/7   5/2
119  MSHP  WR4U KY 2010 1,349 33 19   KJ4IKN WR4U      1/1   11/7   28/11      
120  MSHP  W4HIJ GA 2010 1,144 26 22           9/8   13/9   2/2   3/3
 
121  MSHP  KC0WWV IA 2010 1,066 34 13              33/10   3/2   1/1
122  MSHP  WA7SLH AZ 2010 448 22 8           17/5   6/3      
123  MSHP  N0BK MN 2010 350 13 10              8/5   3/3   2/2
124  MSHP  N6MWX NNJ 2010 65 5 5              5/5      

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

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