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.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'W6') AND cs.category_id = 'SO-CW-LP' 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  SO-CW-LP  NC6V ORG 2013 248,868 676 93                    
2  SO-CW-LP  KM6Z LAX 2013 190,464 521 93                    
3  SO-CW-LP  W6AWW LAX 2013 153,792 436 89                    
4  SO-CW-LP  N6MU ORG 2013 147,784 406 91   Southern California Contest Club                  
5  SO-CW-LP  K6AAB SJV 2013 138,624 361 96   Northern California Contest Club                  
 
6  SO-CW-LP  WA6DBC SDG 2013 129,344 354 94                    
7  SO-CW-LP  AC6VN ORG 2013 122,176 374 83   Southern California Contest Club                  
8  SO-CW-LP  KZ2V SCV 2013 99,712 305 82   Northern California Contest Club                  
9  SO-CW-LP  N3PV SDG 2013 67,760 245 70                    
10  SO-CW-LP  N6PN EB 2013 60,732 243 63   Northern California Contest Club                  
 
11  SO-CW-LP  K6KQV SCV 2013 58,320 243 60   Northern California Contest Club                  
12  SO-CW-LP  AA6EE SDG 2013 56,196 223 63                    
13  SO-CW-LP  KD6WKY EB 2013 37,536 188 51   Northern California Contest Club                  
14  SO-CW-LP  N6CHU ORG 2013 37,524 160 59                    
15  SO-CW-LP  AA6DX SF 2013 35,568 164 57                    
 
16  SO-CW-LP  KI6OY EB 2013 22,680 130 45   Northern California Contest Club                  
17  SO-CW-LP  NC6Q LAX 2013 16,692 110 39   Southern California Contest Club                  
18  SO-CW-LP  N6BHX EB 2013 15,444 100 39                    
19  SO-CW-LP  WE6C SV 2013 13,552 84 44   Mother Lode DX/Contest Club                  
20  SO-CW-LP  K0DTJ SCV 2013 10,880 80 34                    
 
21  SO-CW-LP  K9JM SV 2013 10,656 73 37   Northern California Contest Club                  
22  SO-CW-LP  K6DGQ SV 2013 5,936 60 28                    
23  SO-CW-LP  K6JF SJV 2013 1,500 25 15                    

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

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