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 'RM' 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
1  SOLP  N0POH CO 2006 65,637 383 143   Grand Mesa Contesters of Colorado                  
2  SOLP  KC0UYK CO 2006 62,338 427 142                    
3  SOLP  W0ETT WY 2006 60,060 411 140   Grand Mesa Contesters of Colorado                  
4  SOLP  KU7Z UT 2006 35,112 262 132                    
5  SOLP  KO7X WY 2006 31,413 283 111   Grand Mesa Contesters of Colorado                  
 
6  SOLP  N0VR CO 2006 27,233 241 113                    
7  SOLP  N6ZZ NM 2006 24,190 205 118                    
8  SOLP  W7UT UT 2006 22,155 211 105   Utah's Dixie DX & Contest Club                  
9  SOLP  N0KM CO 2006 13,965 147 95                    
10  SOLP  KF0RT CO 2006 11,600 142 80                    
 
11  SOLP  K0SDW CO 2006 10,981 139 79                    
12  SOLP  K5RHR NM 2006 10,366 118 73                    
13  SOLP  KI0RN CO 2006 8,618 96 62                    
14  SOLP  NK5W NM 2006 5,418 103 42                    
15  SOLP  N0UGY CO 2006 4,773 71 43                    
 
16  SOLP  K0FX CO 2006 3,290 70 47   Grand Mesa Contesters of Colorado                  
17  SOLP  K7ICW NM 2006 3,036 64 46                    
18  SOLP  WA0YPL UT 2006 2,784 58 48                    
19  SOLP  K5KM NM 2006 2,331 63 37   Albuquerque DX Assn                  
20  SOLP  NJ7A UT 2006 966 34 21                    
 
21  SOLP  WA5ZUP NM 2006 630 30 21                    
22  SOLP  KE5HHU NM 2006 266 16 14                    
23  SOLP  KE7DLG WY 2006 49 7 7                    
24  SOLP  KC0WTR CO 2006 16 8 2                    

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

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