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 = 149 AND cs.division_id LIKE 'SW' AND cs.category_id = 'SOHP' 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  SOHP  N6SS AZ 2003 194,670 1,016 90   Central Arizona DX Assn                  
2  SOHP  AC6DD SB 2003 88,640 526 80                    
3  SOHP  K6SE LAX 2003 57,477 379 69                    
4  SOHP  WA5VGI SB 2003 48,251 373 61   Southern California DX Club                  
5  SOHP  W6HG ORG 2003 35,728 302 58                    
 
6  SOHP  W7YS AZ 2003 31,152 230 66   Northern Arizona DX Assn                  
7  SOHP  W7CB SB 2003 29,380 229 65   Southern California Contest Club                  
8  SOHP  K6NY SDG 2003 18,550 173 53                    
9  SOHP  K0DR AZ 2003 17,820 158 55                    
10  SOHP  KB7V ORG 2003 16,764 191 44                    
 
11  SOHP  K6NA SDG 2003 11,650 109 50   Southern California Contest Club                  
12  SOHP  WA6BOB LAX 2003 5,760 93 32   Southern California Contest Club                  
13  SOHP  NF7E AZ 2003 3,596 65 29   Northern Arizona DX Assn                  
14  SOHP  W6AQ LAX 2003 2,688 65 21   Hollywood Hills QRP 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.