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 = 13 AND YEAR(EventInstances.start_date) >= EventInfo.first_results_year AND cs.category_id <> 'Checklog' AND cs.instance_id = 82 AND cs.dxcc_prefix IN (SELECT dxcc_prefix FROM ContestDxccEntities) 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 5 of 5     Next❯  Last❯❯
RankCategoryCall SignQTHYearScoreQSOsMultsHoursOperatorsClub160 80 40 20 15 10
401  SOLP  JL2OGZ/2 JA 2018 624 16 13           8/7   8/6      
402  SOLP  9A4GD 9A 2018 546 14 13           14/13         
  SOLP  JQ1COB JA 2018 546 14 14     4/4   7/7   3/3         
404  SOLP  R1AU UA 2018 540 15 12           6/4   9/8      
405  SOLP  IW1CBG I 2018 468 13 12           4/4   9/8      
 
406  SOLP  G3WRR G 2018 432 14 12           8/6   6/6      
  SOLP  YD1TJJ YB 2018 432 16 9           14/7      2/2   
408  SOLP  EA3CWT EA 2018 429 14 11           3/3   10/7   1/1   
409  SOLP  M0TQR G 2018 420 14 10              13/9   1/1   
410  SOLP  IU6AIG I 2018 390 13 10           10/7   3/3      
 
411  SOLP  G4BEE G 2018 336 14 8           10/5   4/3      
412  SOLP  YE3AA YB 2018 324 12 9           12/9         
413  SOLP  JA1TQE JA 2018 288 12 8           10/6   2/2      
414  SOLP  JI1TBQ JA 2018 273 13 7              13/7      
415  SOLP  HS3ANP HS 2018 252 12 7           9/5   3/2      
 
416  SOLP  PY1NP PY 2018 240 10 8              4/3   6/5   
  SOLP  RV3VR UA 2018 240 12 8              12/8      
418  SOLP  RK1NA UA 2018 210 11 7              11/7      
419  SOLP  EA2GM EA 2018 192 9 8              9/8      
  SOLP  LU6FLZ LU 2018 192 8 8              2/2   3/3   3/3
 
  SOLP  PY7OJ PY 2018 192 9 8              9/8      
422  SOLP  F4DBD F 2018 189 9 7        1/1      8/6      
  SOLP  OH3HS OH 2018 189 9 7              9/7      
424  SOLP  SM6BSK SM 2018 147 7 7           1/1   6/6      
  SOLP  YO7LYM YO 2018 147 7 7           2/2   5/5      
 
426  SOLP  HA9TA HA 2018 144 8 6           2/2   6/4      
427  SOLP  PY4TW PY 2018 132 23 2           4/1      19/1   
428  SOLP  DF3OL DL 2018 72 6 4        1/1   1/1   4/2      
  SOLP  DF9GH DL 2018 72 24 1           24/1         
430  SOLP  HB9GKM HB 2018 12 2 2           2/2         
 
431  SOLP  RW9AV UA9 2018 3 1 1              1/1      

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

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