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 = 3 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 208 AND cs.division_id LIKE 'NW' AND cs.category_id = 'SOLP' 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
SOLP  K7BG MT 2006 84,372 474 178   Northern Rockies DX Association                  
SOLP  W7ID ID 2006 33,875 271 125                    
SOLP  W7MY EWA 2006 29,845 216 127   Pacific Northwest VHF Society                  
SOLP  N6KW WWA 2006 27,499 253 107   Pacific Northwest VHF Society                  
SOLP  N9ADG WWA 2006 26,320 280 94   Pacific Northwest VHF Society                  
 
SOLP  K7YO OR 2006 23,318 199 89   Pacific Northwest VHF Society                  
SOLP  W7MEM ID 2006 20,492 169 109                    
SOLP  KD7TJC WWA 2006 17,640 190 84   Pacific Northwest VHF Society                  
SOLP  KB7ME WWA 2006 16,428 182 74   Pacific Northwest VHF Society                  
10  SOLP  K7WA WWA 2006 14,840 197 70   Pacific Northwest VHF Society                  
 
11  SOLP  N7DB OR 2006 13,735 183 67                    
12  SOLP  W7QH OR 2006 11,470 135 74                    
13  SOLP  KA6T OR 2006 11,403 158 63   Pacific Northwest VHF Society                  
14  SOLP  K0IP ID 2006 10,665 135 79                    
15  SOLP  W0MU MT 2006 9,044 119 76                    
 
16  SOLP  KG7P WWA 2006 7,800 111 60   Pacific Northwest VHF Society                  
17  SOLP  KA7RRA WWA 2006 5,088 104 48                    
18  SOLP  W7FKI WWA 2006 4,116 91 42   Pacific Northwest VHF Society                  
19  SOLP  N7CFO WWA 2006 3,920 82 40   Pacific Northwest VHF Society                  
20  SOLP  K7HSJ OR 2006 3,634 66 46   Pacific Northwest VHF Society                  
 
21  SOLP  WA7PVE WWA 2006 2,325 75 31                    
22  SOLP  K6UM OR 2006 2,310 66 35   Pacific Northwest VHF Society                  
23  SOLP  KI7Y OR 2006 1,914 58 33   Willamette Valley DX Club                  
24  SOLP  K7SMA OR 2006 1,775 65 25                    
25  SOLP  W6LLP EWA 2006 1,736 49 31   Pacific Northwest VHF Society                  
 
26  SOLP  WR7X OR 2006 1,400 50 28   Pacific Northwest VHF Society                  
27  SOLP  KW7N EWA 2006 1,353 41 33                    
28  SOLP  K7VIT OR 2006 901 49 17                    
29  SOLP  WA6KHG OR 2006 550 23 22                    
30  SOLP  WB7QBS WWA 2006 240 15 8                    
 
31  SOLP  KB7IOG/M WWA 2006 60 10 4   Pacific Northwest VHF Society                  

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

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