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 = 105 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'VE') 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  VE2HIT QC 2017 90,972 233 133   Contest Group du Quebec      36/25   75/45   69/34   44/23   9/6
2  SOLP  VA1XH MAR 2017 76,638 245 106           91/45   127/42   27/19   
3  SOLP  VE2BVV QC 2017 49,329 195 87        10/10      140/54   45/23   
4  SOLP  VA3GD ONE 2017 46,035 160 99        19/17   30/21   61/33   45/23   5/5
5  SOLP  VE5SKI SK 2017 36,735 158 79        4/4   12/9   85/37   57/29   
 
6  SOLP  VE3EZB ONE 2017 35,100 135 90              77/49   54/37   4/4
7  SOLP  VE3IAE ONE 2017 32,850 153 73   Contest Club Ontario            120/54   33/19   
8  SOLP  VA3QWW ONE 2017 31,488 131 82        5/5   13/11   51/30   52/26   10/10
9  SOLP  VE3CNA GH 2017 31,416 145 77           18/12   97/43   27/19   3/3
10  SOLP  VE3MW ONE 2017 30,375 129 81     4/4   15/14   16/13   59/31   35/19   
 
11  SOLP  VE3RR ONE 2017 22,344 109 76        18/17   4/3   56/36   31/20   
12  SOLP  VA3CME ONE 2017 17,325 111 55              86/41   23/13   2/1
13  SOLP  VE3CKG ONS 2017 11,859 68 59              34/28   28/25   6/6
14  SOLP  VE3TU ONS 2017 10,437 73 49   Contest Club Ontario         9/7   37/21   22/16   5/5
15  SOLP  VE1JS MAR 2017 9,675 80 43   Maritime Contest Club         2/2   63/33   15/8   
 
16  SOLP  VE3VN ONE 2017 9,261 63 49   Contest Club Ontario      49/37   12/10   2/2      
17  SOLP  VA1MC MAR 2017 8,385 65 43           19/11   31/20   15/12   
18  SOLP  VE3KKQ ONS 2017 7,134 59 41        1/1   19/14   17/13   22/13   
19  SOLP  VA3KVI ONS 2017 6,438 58 37           33/23      25/14   
20  SOLP  VE4VJR MB 2017 5,130 47 38        4/4   7/7   36/27      
 
21  SOLP  VE8GER TER 2017 4,575 61 25        1/1   7/4   53/20      
22  SOLP  VE7BGP BC 2017 3,612 44 28   Nanaimo Amateur Radio Association      1/1   4/4   20/11   19/12   
23  SOLP  VA3BAH ONE 2017 2,880 34 30           12/11   22/19      
24  SOLP  VE1FAL MAR 2017 1,326 26 17           1/1   19/11   6/5   
25  SOLP  VO1PIB NL 2017 1,275 25 17           6/5   17/10   2/2   
 
26  SOLP  CF7XNL BC 2017 1,152 26 16              16/12   10/4   
27  SOLP  VE3PYJ GH 2017 945 21 15           5/5   16/10      
28  SOLP  VA3FUZ GH 2017 429 13 13           6/6   5/5   2/2   
29  SOLP  VA3FN ONS 2017 300 11 10           4/4   5/4   2/2   
30  SOLP  VA2HK QC 2017 297 11 9           7/5   4/4      
 
31  SOLP  VE7SXM BC 2017 135 9 5              9/5      
32  SOLP  VE6KEE AB 2017 36 4 4              4/4      
33  SOLP  VA6MER AB 2017 6 2 2        1/1      1/1      

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

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