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 = 14 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 100 AND cs.division_id LIKE 'PC' 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  N6JV SV 2012 846,153 1,103 259   Mother Lode DX/Contest Club         87/45   244/76   462/90   310/48
2  SOUHP  W6SR SV 2012 425,565 590 245   Mother Lode DX/Contest Club   7/6   20/15   40/30   94/72   306/78   123/44
3  SOUHP  K7XC NV 2012 290,667 382 257   Northern California Contest Club   9/8   39/28   69/43   95/76   117/59   53/43
4  SOUHP  K6RIM SF 2012 277,296 438 212   Northern California Contest Club         23/20   126/71   180/78   109/43
5  SOUHP  W5DQ SJV 2012 204,417 341 201     1/1   18/16   37/26   70/53   139/66   76/39
 
6  SOUHP  W6NF NV 2012 166,704 303 184   Northern California Contest Club      8/6   38/25   69/57   111/53   77/43
7  SOUHP  K7LV NV 2012 108,093 272 137           48/33   49/28   87/40   88/36
8  SOUHP  W6DPD SJV 2012 49,932 148 114   Northern California Contest Club            49/40   63/46   36/28
9  SOUHP  K6III SV 2012 48,195 155 105   Northern California Contest Club         10/8   48/36   48/31   49/30
10  SOUHP  W6SZN SV 2012 45,144 182 88   Northern California Contest Club            24/24   83/34   75/30
 
11  SOUHP  K6ST SV 2012 36,735 158 79   Northern California Contest Club         16/12   41/22   38/21   63/24
12  SOUHP  WB6CZG SV 2012 33,948 143 82   Northern California Contest Club         3/3   46/26   49/28   45/25
13  SOUHP  W1RH SV 2012 28,875 128 77   Mother Lode DX/Contest Club            48/33   22/17   58/27
14  SOUHP  W6DE SV 2012 27,306 113 82   Mother Lode DX/Contest Club   4/4   32/23   51/39   26/16      
15  SOUHP  K7MKL NV 2012 20,520 124 57   Northern California Contest Club      1/1   17/14   72/29   34/13   
 
16  SOUHP  W6GJB SCV 2012 10,767 100 37   Northern California Contest Club         57/15   13/7   8/6   22/9
17  SOUHP  W6FB SCV 2012 9,324 77 42   Northern California Contest Club      3/2   7/6   17/7   27/13   23/14
18  SOUHP  N6MW SCV 2012 4,305 41 35           2/2   14/10   16/15   9/8
19  SOUHP  W6PK SCV 2012 3,465 37 33   Northern California Contest Club            26/24   2/2   9/7

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

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