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 = 20 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 162 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'W6') AND cs.category_id = 'SOUHP' 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  SOUHP  W6DR SCV 2016 104,931 570 89   Northern California Contest Club                  
2  SOUHP  W1SRD SV 2016 90,610 515 85   Northern California Contest Club                  
3  SOUHP  N6WM EB 2016 58,720 334 80   Pizza Lovers 259                  
4  SOUHP  KH6DX PAC 2016 58,000 304 80                    
5  SOUHP  K6IJ SV 2016 51,452 328 76   Mother Lode DX/Contest Club                  
 
6  SOUHP  K6SRZ SF 2016 35,770 242 70   Redwood Empire DX Assn                  
7  SOUHP  K6NV SV 2016 34,599 296 57   Northern California Contest Club                  
8  SOUHP  W6SX SJV 2016 34,048 260 64   Northern California Contest Club                  
9  SOUHP  N6IE SF 2016 25,675 193 65   Northern California Contest Club                  
10  SOUHP  K9JM SV 2016 23,485 185 61   Northern California Contest Club                  
 
11  SOUHP  K6MM SCV 2016 19,875 183 53   Northern California Contest Club                  
12  SOUHP  NC6B SB 2016 19,824 153 59   Southern California Contest Club                  
13  SOUHP  N6PE ORG 2016 16,131 134 57   Southern California Contest Club                  
14  SOUHP  W6SR SV 2016 15,438 117 62                    
15  SOUHP  ND6P LAX 2016 11,997 135 43                    
 
16  SOUHP  W6TK SB 2016 11,074 101 49   Southern California Contest Club                  
17  SOUHP  K6RC SV 2016 10,994 115 46   Northern California Contest Club                  
18  SOUHP  KF6I ORG 2016 896 28 16                    
19  SOUHP  K6RR ORG 2016 216 12 9   Southern California Contest Club                  
20  SOUHP  NE6I SDG 2016 36 3 3   Southern California Contest Club                  
 

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

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