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.dxcc_prefix IN (SELECT dxcc_prefix FROM ContestDxccEntities) AND cs.category_id = 'MSHP' GROUP BY cs.score_id ORDER BY cs.score DESC
From the list below, select the contest or call sign for which you want to view scores and then click on Go.
Show Operators Show Club
❮❮First ❮Prev Page 1 of 4 Next❯ Last❯❯
Rank | Category | Call Sign | QTH | Year | Score | QSOs | Mults | Hours | Operators | Club | 160 | 80 | 40 | 20 | 15 | 10 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | MSHP | D4C | D4 | 2011 | 4,351,000 | 3,962 | 380 | 36.0 | I2VXJ I4UFH IK2EGL IZ4DPV | |||||||
2 | MSHP | CW5W | CX | 2011 | 3,615,656 | 3,072 | 362 | 36.0 | CX2DK CX3AL CX4DX CX5TR CX7AF PY3VK | |||||||
3 | MSHP | EF8R | EA8 | 2011 | 3,565,078 | 3,646 | 347 | 28.0 | EA8AH EA8CAC | |||||||
4 | MSHP | PY2NDX | PY | 2011 | 3,420,348 | 3,237 | 354 | 35.0 | PY2EYE PY2KC PY2NA PY2NDX PY2YU | |||||||
5 | MSHP | HK1NA | HK | 2011 | 3,306,360 | 3,940 | 295 | 35.0 | HK1R HK1T HK1X | |||||||
6 | MSHP | LS1D | LU | 2011 | 3,235,680 | 3,304 | 315 | 36.0 | LU3CT LW1DTZ LW9EOC | |||||||
7 | MSHP | CX5BW | CX | 2011 | 3,123,778 | 3,163 | 301 | 36.0 | CX2AQ CX3DY CX5BW CX9AU | |||||||
8 | MSHP | EI7M | EI | 2011 | 2,859,864 | 2,667 | 348 | 22.0 | EI3JE EI3JZ EI3KD EI4BZ EI8IR | |||||||
9 | MSHP | PJ2T | PJ2 | 2011 | 2,758,288 | 2,886 | 298 | 33.0 | ||||||||
10 | MSHP | CR6K | CT | 2011 | 2,717,242 | 3,048 | 319 | 28.0 | CR7ADN CT1CJJ CT1ILT | |||||||
11 | MSHP | LR2F | LU | 2011 | 2,606,610 | 2,577 | 323 | 31.0 | LU1FM LU2FA LU5FF LU7DW LW7DX LW8DQ | |||||||
12 | MSHP | HD2A | HC | 2011 | 2,421,872 | 2,681 | 296 | 34.0 | HC2AQ HC2SL | |||||||
13 | MSHP | TM6M | F | 2011 | 2,419,054 | 2,274 | 341 | 28.0 | F1AKK F4DXW F5MUX | |||||||
14 | MSHP | ZX5J | PY | 2011 | 2,354,326 | 2,785 | 299 | 36.0 | ||||||||
15 | MSHP | LT1F | LU | 2011 | 2,275,336 | 2,878 | 287 | 36.0 | LU1FAM LU1FKR LU2FE LU2UDS LU2UF LU4ULT LU5UAE LU5UAS LU5UBI | |||||||
16 | MSHP | 4O3A | 4O | 2011 | 2,065,338 | 2,169 | 297 | 23.0 | 4O3A E74IW | |||||||
17 | MSHP | ED1R | EA | 2011 | 2,023,988 | 2,120 | 311 | 25.0 | DH1TW EA4SV EC1KR EC4DX | |||||||
18 | MSHP | NP4Z | KP4 | 2011 | 1,996,400 | 2,811 | 248 | 21.0 | ||||||||
19 | MSHP | E7DX | E7 | 2011 | 1,979,990 | 2,173 | 323 | 28.0 | E70R E70T E76C E77DX E77E | |||||||
20 | MSHP | UU7J | UR | 2011 | 1,974,560 | 2,307 | 301 | 26.0 | UU0JM UU1AZ | |||||||
21 | MSHP | 9A1A | 9A | 2011 | 1,897,110 | 1,992 | 321 | 28.0 | 9A5W 9A6A 9A7R 9A9A | |||||||
22 | MSHP | ZP5X | ZP | 2011 | 1,882,516 | 2,298 | 283 | 36.0 | LU8EOT LU9ESD ZP5DBC | |||||||
23 | MSHP | TM2B | F | 2011 | 1,869,246 | 1,667 | 339 | 25.0 | F4EGZ F8CIL F8DBF | |||||||
24 | MSHP | RL3A | UA | 2011 | 1,832,142 | 2,085 | 283 | 21.0 | R3CM R3DCX RL3FT RT3DX RZ3RX UA3ASZ UB4FAB | |||||||
25 | MSHP | 9A5Y | 9A | 2011 | 1,821,996 | 1,805 | 321 | 25.0 | 9A3LG 9A3NM | |||||||
26 | MSHP | EF7X | EA | 2011 | 1,799,616 | 1,840 | 309 | 29.0 | EA7GYS EA7KW | |||||||
27 | MSHP | TK5KP | TK | 2011 | 1,721,970 | 2,159 | 285 | 25.0 | TK5EP TK5MH | |||||||
28 | MSHP | DR1A | DL | 2011 | 1,553,500 | 1,862 | 325 | 26.0 | DB6JG DJ6ET DJ7EG DJ7EO DL6FBL DL9ECA | |||||||
29 | MSHP | CS2P | CT | 2011 | 1,547,520 | 2,152 | 248 | 26.0 | CT1BWU CT1BYK CT7ADH LZ1WR LZ3ND | |||||||
30 | MSHP | ED3A | EA | 2011 | 1,531,750 | 1,692 | 275 | 24.0 | EA3ATM EA3DW EA3GXJ EA3NT EA3OR | |||||||
31 | MSHP | II9P | I | 2011 | 1,496,196 | 1,770 | 299 | 31.0 | IT9ACN IT9AUG IT9BUN IT9CHU IT9CJC IT9EQO IT9GSF IT9NJE | |||||||
32 | MSHP | E73M | E7 | 2011 | 1,427,538 | 1,568 | 287 | 26.0 | E73M E74A | |||||||
33 | MSHP | IR8C | I | 2011 | 1,420,724 | 1,642 | 289 | 23.0 | IK8UND IZ8GCB IZ8GCE IZ8TDP | |||||||
34 | MSHP | TM0R | F | 2011 | 1,351,224 | 1,640 | 294 | 24.0 | F5BSB F5MNK | |||||||
35 | MSHP | DR1D | DL | 2011 | 1,325,722 | 1,501 | 277 | 27.0 | DL3KO PY2SEX | |||||||
36 | MSHP | VK4WIL | VK | 2011 | 1,321,672 | 1,857 | 253 | 34.0 | VK4HS VK4MN VK4QH VK4SN | |||||||
37 | MSHP | IQ1GE | I | 2011 | 1,290,500 | 1,391 | 290 | 24.0 | IK1HJS IK1QBT IK1YDB | |||||||
38 | MSHP | RN3F | UA | 2011 | 1,262,436 | 1,548 | 266 | 25.0 | RA1ZZ RK3AW RK3FM RK3FT RK3QS RW3F | |||||||
39 | MSHP | IQ2CJ | I | 2011 | 1,221,788 | 1,412 | 281 | 20.0 | IK2JUB IK2NCJ IK2PFL IW2HAJ | |||||||
40 | MSHP | EI9E | EI | 2011 | 1,181,688 | 1,697 | 212 | 20.0 | EI2FG EI5DI EI7FJ EI9HQ | |||||||
41 | MSHP | S53M | S5 | 2011 | 1,157,760 | 1,511 | 268 | 24.0 | ||||||||
42 | MSHP | PT3T | PY | 2011 | 1,147,068 | 1,621 | 258 | 36.0 | PY3BM PY3CQ PY3FJ PY3KN PY3MM PY3NZ | |||||||
43 | MSHP | KH6MB | KH6 | 2011 | 1,124,630 | 1,811 | 205 | 16.0 | ||||||||
44 | MSHP | HG1S | HA | 2011 | 1,095,168 | 1,371 | 276 | 23.0 | HA1DAI HA1TJ HA6NF | |||||||
45 | MSHP | EF3A | EA | 2011 | 1,093,716 | 1,338 | 234 | 20.0 | EA3KU | |||||||
46 | MSHP | IK2YCW | I | 2011 | 1,088,000 | 1,506 | 272 | 20.0 | ||||||||
47 | MSHP | OL7M | OK | 2011 | 1,085,314 | 1,453 | 233 | 24.0 | OK1CW OK1DF OK1HRA OK1MU OK2ZAW | |||||||
48 | MSHP | PA6Z | PA | 2011 | 1,071,104 | 1,274 | 256 | 22.0 | PA1HC PA2AWU PA4N PA5CA PH0AS | |||||||
49 | MSHP | OQ5M | ON | 2011 | 1,060,864 | 1,368 | 256 | 19.0 | ON5ZO | |||||||
50 | MSHP | F4ERS | F | 2011 | 1,046,504 | 1,456 | 257 | 20.0 | F4ERS F5CWU | |||||||
51 | MSHP | PI4TUE | PA | 2011 | 1,036,128 | 1,239 | 258 | 25.0 | ON9CC PA3GFE PA4AO PC5A | |||||||
52 | MSHP | ED5T | EA | 2011 | 1,032,120 | 1,462 | 244 | 25.0 | EA5GIE EA5GS EA5KV EA5ON EA5UF EA5YI EB5KT | |||||||
53 | MSHP | S57UN | S5 | 2011 | 1,015,648 | 1,156 | 272 | 24.0 | S52ZW S57UN | |||||||
54 | MSHP | CV5K | CX | 2011 | 991,990 | 1,987 | 227 | 36.0 | CX1CAK CX1CW CX2ABC CX2AQ CX5BE CX6DAP CX7BZ | |||||||
55 | MSHP | LZ5R | LZ | 2011 | 986,860 | 1,341 | 245 | 23.0 | LZ1UK LZ1YQ | |||||||
56 | MSHP | RU0FM | UA9 | 2011 | 983,876 | 1,703 | 223 | 20.0 | RA0FU RC0F RU0FM | |||||||
57 | MSHP | YR1C | YO | 2011 | 980,840 | 1,152 | 226 | 22.0 | YO4NA YO9GZU | |||||||
58 | MSHP | T77NM | T7 | 2011 | 972,726 | 1,778 | 223 | 21.0 | IK4DCX IZ4AKS T77NM | |||||||
59 | MSHP | JA6WIF | JA | 2011 | 964,656 | 1,508 | 232 | 33.0 | JA6WIF JA6WJL | |||||||
60 | MSHP | UA5A | UA | 2011 | 964,376 | 1,241 | 238 | 20.0 | RD3A UA5C UA5F | |||||||
61 | MSHP | DA2C | DL | 2011 | 960,432 | 1,422 | 214 | 17.0 | DK3DM DL8OBQ | |||||||
62 | MSHP | LU1DZ | LU | 2011 | 937,068 | 1,194 | 229 | 19.0 | LU1DZ LW2DX | |||||||
63 | MSHP | SK3GM | SM | 2011 | 931,840 | 1,172 | 256 | 26.0 | SM3UZS SM3VAC | |||||||
64 | MSHP | LZ9W | LZ | 2011 | 928,620 | 1,440 | 165 | 24.0 | LZ1ZD LZ3FM | |||||||
65 | MSHP | S51DX | S5 | 2011 | 924,774 | 1,317 | 237 | 25.0 | S51DX S57DX | |||||||
66 | MSHP | DK2OY | DL | 2011 | 915,572 | 1,102 | 266 | 23.0 | ||||||||
67 | MSHP | UX4U | UR | 2011 | 902,070 | 1,080 | 257 | 22.0 | ||||||||
68 | MSHP | IO5O | I | 2011 | 896,898 | 1,219 | 249 | 22.0 | IK5RLP IK5ROS IW5EFX IZ5BRW IZ5EME | |||||||
69 | MSHP | UA9CDV | UA9 | 2011 | 886,894 | 1,384 | 197 | 21.0 | ||||||||
70 | MSHP | CE1DY | CE | 2011 | 864,908 | 1,155 | 242 | 30.0 | CE1DY XQ1KZ | |||||||
71 | MSHP | DL6RAI | DL | 2011 | 852,688 | 989 | 274 | 17.0 | ||||||||
72 | MSHP | HG6N | HA | 2011 | 813,144 | 1,162 | 204 | 25.0 | HA6ND HA6ON | |||||||
73 | MSHP | JS3CTQ | JA | 2011 | 791,040 | 1,230 | 206 | 16.0 | ||||||||
74 | MSHP | 9A3B | 9A | 2011 | 787,842 | 1,008 | 253 | 23.0 | 9A1AA 9A2VR | |||||||
75 | MSHP | RL9AA | UA9 | 2011 | 783,692 | 1,338 | 182 | 18.0 | ||||||||
76 | MSHP | JH4UTP | JA | 2011 | 783,372 | 1,325 | 194 | 26.0 | ||||||||
77 | MSHP | LA6YEA | LA | 2011 | 767,144 | 1,214 | 206 | 13.0 | ||||||||
78 | MSHP | UA4HOX | UA | 2011 | 752,146 | 1,185 | 197 | 21.0 | ||||||||
79 | MSHP | JE1ZWT | JA | 2011 | 696,460 | 1,195 | 194 | 30.0 | JA1MML JE1EKT JF1VVR JG1VGX JI1ALP | |||||||
80 | MSHP | UT7E | UR | 2011 | 639,744 | 1,135 | 204 | 24.0 | UT4EO UT8EU UV5EOZ | |||||||
81 | MSHP | GM3W | GM | 2011 | 633,040 | 1,180 | 193 | 15.0 | GM3SEK MM0WNW | |||||||
82 | MSHP | OE2S | OE | 2011 | 625,636 | 826 | 241 | 12.0 | DJ5IW OE2VEL | |||||||
83 | MSHP | JA1YPA | JA | 2011 | 609,390 | 949 | 185 | 19.0 | JA1CTB JA1PEJ JE1PMQ JG4KEZ JR8VSE | |||||||
84 | MSHP | RT3T | UA | 2011 | 603,820 | 1,147 | 133 | 21.0 | ||||||||
85 | MSHP | UN8GV | UN | 2011 | 586,710 | 1,068 | 159 | 17.0 | ||||||||
86 | MSHP | PY4RGS | PY | 2011 | 568,920 | 870 | 165 | 25.0 | ||||||||
87 | MSHP | GW7X | GW | 2011 | 566,784 | 1,389 | 192 | 19.0 | GW4BLE MW0MWZ | |||||||
88 | MSHP | PA0O | PA | 2011 | 565,432 | 892 | 161 | 18.0 | ||||||||
89 | MSHP | YQ6A | YO | 2011 | 561,168 | 826 | 216 | 20.0 | YO6BHN | |||||||
90 | MSHP | EB2AM | EA | 2011 | 546,016 | 1,819 | 151 | 21.0 | ||||||||
91 | MSHP | OG2A | OH | 2011 | 511,664 | 713 | 226 | 11.0 | ||||||||
92 | MSHP | RN7F | UA | 2011 | 502,524 | 987 | 162 | 13.0 | ||||||||
93 | MSHP | G3P | G | 2011 | 501,960 | 898 | 141 | 21.0 | G3WPH | |||||||
94 | MSHP | UT5UDX | UR | 2011 | 495,320 | 676 | 244 | 11.0 | ||||||||
95 | MSHP | UV5U | UR | 2011 | 493,200 | 737 | 200 | 16.0 | UX1UA | |||||||
96 | MSHP | PI4CC | PA | 2011 | 478,400 | 917 | 184 | 14.0 | PA2A PA2EVR PD7RB | |||||||
97 | MSHP | LZ2PL | LZ | 2011 | 467,040 | 849 | 139 | 17.0 | ||||||||
98 | MSHP | RZ4FWW | UA | 2011 | 457,254 | 863 | 171 | 20.0 | RK4FL | |||||||
99 | MSHP | PY5ZD | PY | 2011 | 449,352 | 1,425 | 158 | 29.0 | ||||||||
100 | MSHP | LO7H | LU | 2011 | 439,280 | 1,468 | 152 | 32.0 | LU7HW | |||||||
❮❮First ❮Prev Page 1 of 4 Next❯ Last❯❯
Scores in italics were received after the deadline and/or are not eligible for awards.