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 = 123 AND cs.dxcc_prefix IN (SELECT dxcc_prefix FROM ContestDxccEntities WHERE continent_id LIKE 'SA') 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  PP5JD PY 2006 281,320 1,095 130                    
2  SO-PH-LP  LU4DX LU 2006 256,956 1,139 114                    
3  SO-PH-LP  LW3DN LU 2006 118,776 615 98                    
4  SO-PH-LP  HK3JJH HK 2006 117,576 836 71                    
5  SO-PH-LP  CX1AV CX 2006 112,158 612 93                    
 
6  SO-PH-LP  LU8EOT LU 2006 95,408 543 89                    
7  SO-PH-LP  PY2DN PY 2006 61,596 359 87                    
8  SO-PH-LP  LR1F LU 2006 56,316 364 78   LU5FD                  
9  SO-PH-LP  LW1HR LU 2006 44,384 308 73                    
10  SO-PH-LP  PY2MTV PY 2006 33,600 249 70                    
 
11  SO-PH-LP  PY3FOX PY 2006 25,190 231 55                    
12  SO-PH-LP  LU5CAB LU 2006 24,120 208 60                    
13  SO-PH-LP  PY5KW PY 2006 21,230 203 55                    
14  SO-PH-LP  HC2AD HC 2006 11,180 134 43                    
15  SO-PH-LP  YV1RDX YV 2006 9,128 165 28                    
 
16  SO-PH-LP  LU1ARV LU 2006 8,428 101 43                    
17  SO-PH-LP  PU1KGG PY 2006 6,264 89 36                    
18  SO-PH-LP  PU2TES PY 2006 5,440 82 34                    
19  SO-PH-LP  PY2BN PY 2006 5,180 73 37                    
20  SO-PH-LP  PP2RON PY 2006 2,646 65 21                    
 
21  SO-PH-LP  PY5WH PY 2006 2,150 46 25                    
22  SO-PH-LP  LO7D LU 2006 1,932 42 23   LW1DRH                  
23  SO-PH-LP  L40K LU 2006 1,596 57 14   LU6KA                  
24  SO-PH-LP  PY2KGB PY 2006 1,560 40 20                    
25  SO-PH-LP  PY4OG PY 2006 1,440 46 16                    
 
26  SO-PH-LP  PT7ZT PY 2006 1,058 23 23                    
27  SO-PH-LP  PY2BRZ PY 2006 682 34 11                    
28  SO-PH-LP  PY6KY PY 2006 96 12 4                    
29  SO-PH-LP  PV8IG PY 2006 78 13 3                    

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

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