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.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'W8') 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  N8HR OH 2007 226,560 1,416 80 24.0  K8DX KC8BEW KC8TAD KE8YP KF8NZ W8FHF W8TJT WX8J WZ8P      701/0   462/0   227/0   26/0   
MSHP  NT8V MI 2007 142,720 892 80 24.0  AC8W K8DD K8WMW WD8OEP Mad River Radio Club      444/0   300/0   101/0   47/0   
MSHP  WC8VOA OH 2007 73,304 476 77 24.0  K8BAX KB8ZYE N8JR W8CDA W8FEJ W8ND West Chester ARA   48/0   290/0   29/0   38/0   71/0   
MSHP  K8MSF OH 2007 72,224 488 74 23.0  K8MSF WD5HIO      260/0   183/0   20/0   25/0   
MSHP  W8AJF OH 2007 54,458 373 73 16.0  KC8SHA KD8AQL W8AJF West Park Radiops      167/0   175/0   31/0      
 
MSHP  W8GTZ MI 2007 51,262 361 71 17.0  KC8NAH N8MR Motor City Radio Club   15/0   42/0   104/0   57/0   43/0   
MSHP  WT8O OH 2007 37,062 261 71 21.0  K8SAS W8EBB WT8O      105/0   62/0   94/0      
MSHP  N8FE MI 2007 35,720 235 76 15.0  N8FE N8UZE Hazel Park ARC      58/0   99/0   78/0      
MSHP  K8EO MI 2007 31,878 207 77 16.0  K8EO K8RO N8PYN N8REZ L'anse Creuse ARC      148/0   24/0   24/0   11/0   
10  MSHP  W8EDU OH 2007 30,240 240 63 11.0  KB0USR KB3HTS W8WTS Mad River Radio Club      55/0   74/0   111/0      
 
11  MSHP  KC8PKY MI 2007 27,160 194 70 16.0  KC8OBH KC8PKY Motor City Radio Club   4/0   43/0   99/0   35/0   13/0   
12  MSHP  W8ZHO MI 2007 21,420 153 70 14.0  AB8SC KC8MDL N8YJT      97/0   22/0   34/0      
13  MSHP  N8YB OH 2007 10,944 114 48 12.0  KC8GHZ N8YB      5/0   97/0   12/0      
14  MSHP  AA8UL WV 2007 4,366 59 37 4.0  WA8KAN         21/0   20/0   18/0   
15  MSHP  N8FAU MI 2007 2,816 44 32 6.0  KC8YVF N8FAU   2/0   17/0   14/0   11/0      
 

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

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