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 = 21 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 128 AND cs.section_id IN (SELECT section_id FROM ContestArrlSections WHERE area_id LIKE 'VE') AND cs.category_id = 'SO-PH-LP' 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  SO-PH-LP  VA3YP ON 2011 264,186 1,142 117 13.0  Contest Club Ontario                  
2  SO-PH-LP  VE4TV MB 2011 190,512 901 108 19.0                   
3  SO-PH-LP  VE8GER TER 2011 108,758 613 89 17.0                   
4  SO-PH-LP  VA3PC ON 2011 99,990 499 101 13.0  Contest Club Ontario                  
5  SO-PH-LP  VE3VE ON 2011 70,512 341 104 14.0  Contest Club Ontario                  
 
6  SO-PH-LP  VE3TU ON 2011 57,428 294 98 11.0  Contest Club Ontario                  
7  SO-PH-LP  VE1SQ MAR 2011 41,412 241 87 11.0  Maritime Contest Club                  
8  SO-PH-LP  VE3JOC ON 2011 23,246 198 59 13.0                   
9  SO-PH-LP  VA3GD ON 2011 21,700 178 62 9.0                   
10  SO-PH-LP  VE7WWW BC 2011 20,634 183 57 13.0                   
 
11  SO-PH-LP  VA3WU ON 2011 18,328 158 58 5.0                   
12  SO-PH-LP  VE7NS BC 2011 16,720 153 55 5.0  Orca DX and Contest Club                  
13  SO-PH-LP  VA2UTC QC 2011 15,200 153 50 13.0                   
14  SO-PH-LP  VE2PIJ QC 2011 13,908 123 57 14.0  Contest Group du Quebec                  
15  SO-PH-LP  VE3MEW ON 2011 12,768 116 56 13.0                   
 
16  SO-PH-LP  VA3ZAK ON 2011 12,288 134 48 16.0                   
17  SO-PH-LP  VA3UG ON 2011 11,960 116 52 4.0                   
18  SO-PH-LP  VE3YCR ON 2011 11,564 118 49                    
19  SO-PH-LP  VE3DVY ON 2011 9,996 106 49 8.0                   
20  SO-PH-LP  VA3GKO ON 2011 7,722 99 39 4.0  Contest Club Ontario                  
 
21  SO-PH-LP  VA3ECJ ON 2011 7,280 96 40 11.0                   
22  SO-PH-LP  VG1CQ MAR 2011 7,144 96 38 2.0                   
23  SO-PH-LP  VA7AQD BC 2011 6,264 88 36 7.0                   
24  SO-PH-LP  VE2NMB QC 2011 4,216 67 34 5.0                   
25  SO-PH-LP  VE2DRO QC 2011 4,200 62 35 5.0                   
 
26  SO-PH-LP  VE5KS SK 2011 1,426 32 23 1.0                   
27  SO-PH-LP  VE7EMI BC 2011 1,288 29 23 3.0                   
28  SO-PH-LP  VA3TPV ON 2011 646 19 17 1.0                   
29  SO-PH-LP  VE2DDZ QC 2011 396 19 11 2.0                   
30  SO-PH-LP  VE3SKX ON 2011 390 15 13 1.0                   
 
31  SO-PH-LP  VE3RYC ON 2011 126 9 9 2.0                   

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

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