DJ1YFK LOTW confirmation rate by DXCC July 20th 2008 Overall LOTW rate: 16.1% +----------+-------+------+--------+ | dxcc | sent | rxed | ratio | +----------+-------+------+--------+ | TJ | 4 | 4 | 100.00 | | 5U | 6 | 6 | 100.00 | | HH | 1 | 1 | 100.00 | | BS7 | 1 | 1 | 100.00 | | HV | 2 | 2 | 100.00 | | 9Q | 1 | 1 | 100.00 | | BV9P | 1 | 1 | 100.00 | | TR | 1 | 1 | 100.00 | | ZL8 | 2 | 2 | 100.00 | | 3Yp | 1 | 1 | 100.00 | | KH7K | 1 | 1 | 100.00 | | S0 | 4 | 4 | 100.00 | | T33 | 2 | 2 | 100.00 | | XT | 4 | 4 | 100.00 | | KH8s | 1 | 1 | 100.00 | | 3D2 | 1 | 1 | 100.00 | | HC8 | 33 | 30 | 90.91 | | TZ | 8 | 7 | 87.50 | | VU7 | 8 | 7 | 87.50 | | D6 | 7 | 6 | 85.71 | | 1A | 6 | 5 | 83.33 | | HZ | 22 | 18 | 81.82 | | 5R | 5 | 4 | 80.00 | | 3B9 | 8 | 6 | 75.00 | | 9V | 18 | 13 | 72.22 | | ZF | 51 | 34 | 66.67 | | ZD8 | 3 | 2 | 66.67 | | VP2M | 8 | 5 | 62.50 | | GJ | 46 | 28 | 60.87 | | GD | 48 | 29 | 60.42 | | KH2 | 10 | 6 | 60.00 | | VK9N | 5 | 3 | 60.00 | | JX | 5 | 3 | 60.00 | | FH | 5 | 3 | 60.00 | | PJ2 | 44 | 26 | 59.09 | | 8P | 41 | 24 | 58.54 | | P4 | 102 | 59 | 57.84 | | KP2 | 28 | 16 | 57.14 | | J3 | 14 | 8 | 57.14 | | S9 | 7 | 4 | 57.14 | | YK | 7 | 4 | 57.14 | | KL | 33 | 18 | 54.55 | | 9M2 | 24 | 13 | 54.17 | | 9K | 24 | 13 | 54.17 | | CT3 | 137 | 73 | 53.28 | | 5A | 14 | 7 | 50.00 | | HR | 6 | 3 | 50.00 | | A2 | 4 | 2 | 50.00 | | TL | 2 | 1 | 50.00 | | 4U1I | 12 | 6 | 50.00 | | ZL7 | 2 | 1 | 50.00 | | 4U1U | 2 | 1 | 50.00 | | HK0a | 2 | 1 | 50.00 | | YV0 | 2 | 1 | 50.00 | | CY9 | 2 | 1 | 50.00 | | A9 | 2 | 1 | 50.00 | | FJ | 2 | 1 | 50.00 | | D4 | 21 | 10 | 47.62 | | FY | 15 | 7 | 46.67 | | XE | 26 | 12 | 46.15 | | ZP | 13 | 6 | 46.15 | | VP5 | 30 | 13 | 43.33 | | EY | 21 | 9 | 42.86 | | 3X | 7 | 3 | 42.86 | | LX | 88 | 37 | 42.05 | | J5 | 5 | 2 | 40.00 | | TF | 50 | 20 | 40.00 | | VP2V | 8 | 3 | 37.50 | | K | 12468 | 4388 | 35.19 | | GM | 558 | 190 | 34.05 | | VE | 1050 | 353 | 33.62 | | S7 | 3 | 1 | 33.33 | | YA | 6 | 2 | 33.33 | | TU | 9 | 3 | 33.33 | | SV5 | 61 | 20 | 32.79 | | 9H | 77 | 25 | 32.47 | | V2 | 27 | 8 | 29.63 | | C6 | 28 | 8 | 28.57 | | CU | 56 | 16 | 28.57 | | KH6 | 7 | 2 | 28.57 | | LA | 582 | 166 | 28.52 | | J7 | 18 | 5 | 27.78 | | 4O | 40 | 11 | 27.50 | | EA8 | 271 | 72 | 26.57 | | ZL | 88 | 23 | 26.14 | | EA6 | 106 | 27 | 25.47 | | CP | 4 | 1 | 25.00 | | SM | 1746 | 431 | 24.68 | | ZC4 | 37 | 9 | 24.32 | | CT | 183 | 43 | 23.50 | | OE | 258 | 60 | 23.26 | | GI | 79 | 18 | 22.78 | | HK | 22 | 5 | 22.73 | | HB | 470 | 106 | 22.55 | | C5 | 9 | 2 | 22.22 | | A7 | 18 | 4 | 22.22 | | EA | 986 | 217 | 22.01 | | CE9 | 14 | 3 | 21.43 | | PA | 1306 | 276 | 21.13 | | VR | 19 | 4 | 21.05 | | 3A | 19 | 4 | 21.05 | | 5B | 269 | 54 | 20.07 | | KG4 | 5 | 1 | 20.00 | | JT | 20 | 4 | 20.00 | | 3B6 | 5 | 1 | 20.00 | | VP8h | 5 | 1 | 20.00 | | C3 | 5 | 1 | 20.00 | | 8R | 5 | 1 | 20.00 | | 9X | 5 | 1 | 20.00 | | ZS | 41 | 8 | 19.51 | | EX | 68 | 13 | 19.12 | | GU | 105 | 20 | 19.05 | | SV9 | 60 | 11 | 18.33 | | V3 | 34 | 6 | 17.65 | | CN | 51 | 9 | 17.65 | | LY | 1622 | 282 | 17.39 | | 4X | 191 | 33 | 17.28 | | VU | 29 | 5 | 17.24 | | ON | 639 | 109 | 17.06 | | YN | 12 | 2 | 16.67 | | ZB | 18 | 3 | 16.67 | | YV | 84 | 14 | 16.67 | | VP2E | 6 | 1 | 16.67 | | G | 4416 | 733 | 16.60 | | SV | 344 | 56 | 16.28 | | F | 1321 | 214 | 16.20 | | OH0 | 145 | 23 | 15.86 | | UK | 38 | 6 | 15.79 | | VK | 99 | 15 | 15.15 | | JA | 1215 | 179 | 14.73 | | J2 | 7 | 1 | 14.29 | | VP9 | 14 | 2 | 14.29 | | JY | 21 | 3 | 14.29 | | EI | 224 | 31 | 13.84 | | S5 | 1122 | 150 | 13.37 | | PY | 233 | 31 | 13.30 | | YO | 1077 | 141 | 13.09 | | ES | 354 | 46 | 12.99 | | SP | 2226 | 285 | 12.80 | | 9G | 16 | 2 | 12.50 | | FG | 16 | 2 | 12.50 | | CX | 32 | 4 | 12.50 | | BY | 57 | 7 | 12.28 | | OZ | 432 | 51 | 11.81 | | JW | 34 | 4 | 11.76 | | V5 | 17 | 2 | 11.76 | | HS | 44 | 5 | 11.36 | | OH | 1270 | 144 | 11.34 | | 5H | 18 | 2 | 11.11 | | XU | 9 | 1 | 11.11 | | 4L | 65 | 7 | 10.77 | | YL | 955 | 100 | 10.47 | | LZ | 1112 | 114 | 10.25 | | SU | 20 | 2 | 10.00 | | OA | 10 | 1 | 10.00 | | R1MV | 10 | 1 | 10.00 | | ST | 10 | 1 | 10.00 | | OK | 2762 | 273 | 9.88 | | LU | 167 | 16 | 9.58 | | I | 1536 | 146 | 9.51 | | KP4 | 53 | 5 | 9.43 | | 7Q | 11 | 1 | 9.09 | | HB0 | 44 | 4 | 9.09 | | UA | 9598 | 833 | 8.68 | | IS | 105 | 9 | 8.57 | | FM | 24 | 2 | 8.33 | | UR | 4109 | 331 | 8.06 | | DL | 11297 | 902 | 7.98 | | V4 | 13 | 1 | 7.69 | | 6Y | 14 | 1 | 7.14 | | YB | 42 | 3 | 7.14 | | 3B8 | 14 | 1 | 7.14 | | UA2 | 184 | 13 | 7.07 | | EU | 721 | 49 | 6.80 | | HA | 1811 | 123 | 6.79 | | TK | 45 | 3 | 6.67 | | EA9 | 31 | 2 | 6.45 | | UA9 | 3042 | 186 | 6.11 | | OX | 18 | 1 | 5.56 | | 9A | 1034 | 56 | 5.42 | | HI | 19 | 1 | 5.26 | | CM | 39 | 2 | 5.13 | | OJ0 | 21 | 1 | 4.76 | | DU | 22 | 1 | 4.55 | | ER | 138 | 6 | 4.35 | | YI | 23 | 1 | 4.35 | | TA | 97 | 4 | 4.12 | | 4J | 56 | 2 | 3.57 | | GW | 304 | 9 | 2.96 | | E7 | 257 | 6 | 2.33 | | OM | 809 | 13 | 1.61 | | UN | 357 | 4 | 1.12 | | YU | 1383 | 14 | 1.01 | | OY | 137 | 1 | 0.73 | | HP | 18 | 0 | 0.00 | | V8 | 1 | 0 | 0.00 | | Z2 | 2 | 0 | 0.00 | | FW | 1 | 0 | 0.00 | | D2 | 2 | 0 | 0.00 | | AP | 4 | 0 | 0.00 | | EL | 3 | 0 | 0.00 | | FK | 1 | 0 | 0.00 | | T7 | 8 | 0 | 0.00 | | 3DA | 2 | 0 | 0.00 | | PY0F | 5 | 0 | 0.00 | | TY | 1 | 0 | 0.00 | | XW | 4 | 0 | 0.00 | | 9Y | 11 | 0 | 0.00 | | Z3 | 158 | 0 | 0.00 | | 1S | 2 | 0 | 0.00 | | 7P | 1 | 0 | 0.00 | | JDo | 1 | 0 | 0.00 | | P2 | 1 | 0 | 0.00 | | 9M6 | 16 | 0 | 0.00 | | 5V | 1 | 0 | 0.00 | | EP | 6 | 0 | 0.00 | | T8 | 2 | 0 | 0.00 | | ZK2 | 1 | 0 | 0.00 | | 3V | 45 | 0 | 0.00 | | KH0 | 2 | 0 | 0.00 | | PZ | 12 | 0 | 0.00 | | XX9 | 1 | 0 | 0.00 | | ZA | 41 | 0 | 0.00 | | C9 | 3 | 0 | 0.00 | | EZ | 7 | 0 | 0.00 | | VU4 | 1 | 0 | 0.00 | | 4S | 10 | 0 | 0.00 | | 9N | 12 | 0 | 0.00 | | 5W | 1 | 0 | 0.00 | | BV | 15 | 0 | 0.00 | | FO | 1 | 0 | 0.00 | | VP6d | 2 | 0 | 0.00 | | 3W | 7 | 0 | 0.00 | | R1FJ | 6 | 0 | 0.00 | | A4 | 38 | 0 | 0.00 | | OD | 21 | 0 | 0.00 | | VK9C | 4 | 0 | 0.00 | | 7X | 24 | 0 | 0.00 | | CE | 14 | 0 | 0.00 | | TN | 1 | 0 | 0.00 | | 5X | 2 | 0 | 0.00 | | FP | 6 | 0 | 0.00 | | J6 | 2 | 0 | 0.00 | | 9J | 21 | 0 | 0.00 | | 5N | 1 | 0 | 0.00 | | A6 | 32 | 0 | 0.00 | | SVa | 1 | 0 | 0.00 | | 9U | 7 | 0 | 0.00 | | 5Z | 13 | 0 | 0.00 | | ET | 7 | 0 | 0.00 | | FR | 6 | 0 | 0.00 | | TG | 1 | 0 | 0.00 | | ZD7 | 3 | 0 | 0.00 | | 8Q | 10 | 0 | 0.00 | | PJ7 | 23 | 0 | 0.00 | | TT | 2 | 0 | 0.00 | | 4W | 1 | 0 | 0.00 | | E4 | 6 | 0 | 0.00 | | HL | 40 | 0 | 0.00 | | 6W | 21 | 0 | 0.00 | | FS | 8 | 0 | 0.00 | | J8 | 3 | 0 | 0.00 | | TI | 27 | 0 | 0.00 | | VQ9 | 20 | 0 | 0.00 | | 9L | 1 | 0 | 0.00 | | HC | 11 | 0 | 0.00 | | S2 | 2 | 0 | 0.00 | | 5T | 2 | 0 | 0.00 | | EK | 18 | 0 | 0.00 | | T5 | 3 | 0 | 0.00 | +----------+-------+------+--------+ 270 rows in set (0.01 sec) mysql> mysql> select dxcc as thisdxcc, count(*) as sent, (select count(dxcc) from log_dj1yfk where dxcc=thisdxcc and qslrl='Y') as rxed, (100*(select count(dxcc) from log_dj1yfk where dxcc=thisdxcc and qslrl='Y')/count(*)) as ratio from log_dj1yfk where 1 group by dxcc order by ratio desc;