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 = 126 AND cs.dxcc_prefix IN (SELECT dxcc_prefix FROM ContestDxccEntities WHERE continent_id LIKE 'EU') AND cs.category_id = 'SO-PH-HP' 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
SO-PH-HP  IZ4DPV I 2009 30,528 320 48                    
SO-PH-HP  EA5DFV EA 2009 28,618 349 41                    
SO-PH-HP  DL5L DL 2009 23,306 272 43   DG0OKW                  
SO-PH-HP  IZ4AMS I 2009 21,436 237 46                    
SO-PH-HP  G0AEV G 2009 20,244 244 42                    
 
SO-PH-HP  OE3DWC OE 2009 16,800 211 40                    
SO-PH-HP  CT2IOV CT 2009 16,058 220 37                    
SO-PH-HP  IT9YVO I 2009 13,552 246 28                    
SO-PH-HP  S56P S5 2009 9,180 136 34                    
10  SO-PH-HP  DD5FZ DL 2009 8,990 157 29                    
 
11  SO-PH-HP  IZ5ILU I 2009 5,488 101 28                    
12  SO-PH-HP  GW4BLE GW 2009 3,382 89 19                    
13  SO-PH-HP  UT7QL UR 2009 2,478 61 21                    
14  SO-PH-HP  IK8YFU I 2009 2,436 61 21                    
15  SO-PH-HP  SP5GMM SP 2009 1,800 46 20                    
 
16  SO-PH-HP  F6KCP F 2009 1,560 52 15   F5VHN                  
17  SO-PH-HP  PD1DX PA 2009 1,540 56 14                    
18  SO-PH-HP  EH5A EA 2009 306 17 9   EA5DIT                  
19  SO-PH-HP  IK2XYI I 2009 210 15 7                    
20  SO-PH-HP  YT7AO YU 2009 48 6 4                    
 
21  SO-PH-HP  IZ8PPJ I 2009 36 6 3                    

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

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