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 = 21 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 130 AND cs.dxcc_prefix = 'JA' AND cs.category_id = 'MSLP' 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 Asia or All DX

Show Operators   Show Club  

❮❮First  ❮Prev     Page 1 of 1     Next❯  Last❯❯
RankCategoryCall SignQTHYearScoreQSOsMultsHoursOperatorsClub160 80 40 20 15 10
1  MSLP  JM1NKT JA 2013 426,570 694 177                    
2  MSLP  JR2SCJ JA 2013 341,600 641 175   JA1KFX JR2SCJ                  
3  MSLP  7K4VPV JA 2013 63,948 223 73                    
4  MSLP  JF1KWG JA 2013 40,136 182 58                    
5  MSLP  JA0VTK JA 2013 21,156 123 43                    
 
6  MSLP  JA1XCZ JA 2013 18,624 98 48                    
7  MSLP  JA7RQK JA 2013 15,300 86 45                    
8  MSLP  JG1WCT JA 2013 10,500 99 50                    
9  MSLP  JO3PSJ JA 2013 9,600 76 32                    
10  MSLP  JH1GBO JA 2013 5,888 66 23                    
 
11  MSLP  JA1KEB JA 2013 5,568 49 29                    
12  MSLP  JG1ELE JA 2013 728 26 14                    

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

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