Host: localhost
Database : blameth_pixel
Generation Time: Jun 08, 2004 at 09:53 AM
Generated by: phpMyAdmin 2.5.6 / MySQL 4.0.18-standard
SQL-query:
SELECT users.name, users.posts AS storedposts, count( f_posts.id ) AS
realposts, users.posts - count( f_posts.id ) AS difference
FROM users
RIGHT JOIN f_posts ON f_posts.author = users.name
WHERE users.name IS NOT NULL GROUP BY users.name
HAVING realposts != storedposts
ORDER BY difference DESC LIMIT 0 , 200;
Rows: 154
| Username | Post Count From Users Table | Actual Post Count | Difference (sorted descending) |
|---|---|---|---|
| The Pope | 4195 | 3669 | 526 |
| ReadMe | 2033 | 1535 | 498 |
| C1 | 5563 | 5099 | 464 |
| DreamEater | 359 | 79 | 280 |
| psymon | 1471 | 1244 | 227 |
| Meiapaul | 1618 | 1453 | 165 |
| XxfuzzballxX | 1475 | 1326 | 149 |
| Genki | 116 | 1 | 115 |
| ZoGgEr! | 2415 | 2322 | 93 |
| The Wishmaster | 1776 | 1690 | 86 |
| routine_error | 1028 | 945 | 83 |
| OPTiSSiMUS | 836 | 758 | 78 |
| Dumazz | 424 | 355 | 69 |
| SPAZ | 707 | 664 | 43 |
| Archamond | 1343 | 1301 | 42 |
| Dingbats | 1422 | 1385 | 37 |
| Purewormowns | 91 | 54 | 37 |
| tundraH | 468 | 433 | 35 |
| Duke | 1042 | 1011 | 31 |
| Squelchymcphee | 470 | 440 | 30 |
| HarrY | 1284 | 1254 | 30 |
| Thor | 314 | 287 | 27 |
| CORMEGA | 27 | 3 | 24 |
| Wormy42 | 31 | 10 | 21 |
| bob | 196 | 176 | 20 |
| MrrLL | 1224 | 1206 | 18 |
| Sigmund | 32 | 14 | 18 |
| madknifa | 360 | 343 | 17 |
| CBWhiz | 704 | 689 | 15 |
| Jackbob | 140 | 125 | 15 |
| Borulf | 29 | 14 | 15 |
| networm | 66 | 51 | 15 |
| The candy Man | 597 | 584 | 13 |
| Fiend | 223 | 210 | 13 |
| Squiffel | 50 | 38 | 12 |
| Evil Bunny | 42 | 31 | 11 |
| white_duck | 369 | 358 | 11 |
| VERMxNINJA | 17 | 6 | 11 |
| Bouncingfrosty | 19 | 8 | 11 |
| XxPYRO!xX | 50 | 39 | 11 |
| Sonicrazy | 46 | 36 | 10 |
| wewevonsheepie | 44 | 34 | 10 |
| xXNeBoShXx | 76 | 66 | 10 |
| Roy | 21 | 14 | 7 |
| HHC | 85 | 79 | 6 |
| Glenn | 1126 | 1120 | 6 |
| tEfLoN | 82 | 77 | 5 |
| Lyndon | 29 | 24 | 5 |
| Dvious | 156 | 151 | 5 |
| ViolatoR | 15 | 11 | 4 |
| name | storedposts | realposts | difference |
| Jimbo | 15 | 11 | 4 |
| guiworm | 32 | 28 | 4 |
| Truth Teller | 12 | 9 | 3 |
| Thnikkaman | 150 | 147 | 3 |
| xkillAx | 119 | 116 | 3 |
| xXBioFusionXx | 36 | 33 | 3 |
| Nameless_Soldier | 158 | 155 | 3 |
| homlepong | 6 | 3 | 3 |
| ishay | 3 | 1 | 2 |
| HeadstrongRocker | 14 | 12 | 2 |
| SEMISKROOD | 30 | 28 | 2 |
| !Seigmann! | 8 | 6 | 2 |
| BOWZER | 6 | 4 | 2 |
| wormkiller | 11 | 9 | 2 |
| SPAM | 6 | 4 | 2 |
| Antemannen | 9 | 7 | 2 |
| DarkOne | 218 | 216 | 2 |
| Bird | 43 | 41 | 2 |
| thingeox | 106 | 104 | 2 |
| Daminite | 33 | 31 | 2 |
| Star Worms | 615 | 613 | 2 |
| fuzzball | 16 | 15 | 1 |
| sumbody | 3 | 2 | 1 |
| MATIX4marcJ | 2 | 1 | 1 |
| Djoszee | 21 | 20 | 1 |
| Maskit | 4 | 3 | 1 |
| TR Meowth | 8 | 7 | 1 |
| TonY | 58 | 57 | 1 |
| ZeptOr | 33 | 32 | 1 |
| MaxDamage | 9 | 8 | 1 |
| Zippeurfou | 2 | 1 | 1 |
| Worm Warrior | 11 | 10 | 1 |
| ninjabunny | 2 | 1 | 1 |
| Squirrel | 83 | 82 | 1 |
| Cow | 9 | 8 | 1 |
| xXHarryTripperXx | 18 | 17 | 1 |
| Verm-o-maniac | 12 | 11 | 1 |
| Martin | 19 | 18 | 1 |
| Docta_Shade | 261 | 260 | 1 |
| Darigaaz | 8 | 7 | 1 |
| jay pker | 3 | 2 | 1 |
| sperzie | 2 | 1 | 1 |
| Mysterio | 1 | 2 | -1 |
| !Sugar! | 9 | 10 | -1 |
| Misterags | 14 | 15 | -1 |
| Boba | 0 | 1 | -1 |
| DeathBringer | 70 | 71 | -1 |
| Fool | 0 | 1 | -1 |
| Soulhunter | 7 | 8 | -1 |
| dave | 0 | 1 | -1 |
| name | storedposts | realposts | difference |
| wow13 | 36 | 37 | -1 |
| Megaman | 1 | 2 | -1 |
| Simon (swed simon) | 4 | 5 | -1 |
| jlb | 12 | 13 | -1 |
| MattyxWX | 5 | 6 | -1 |
| Rogue | 11 | 12 | -1 |
| pro-play | 0 | 1 | -1 |
| FiZiX | 4 | 5 | -1 |
| ice | 0 | 1 | -1 |
| syh | 0 | 1 | -1 |
| Cell l3lock | 1 | 2 | -1 |
| c0ld | 0 | 1 | -1 |
| Eric | 6 | 7 | -1 |
| Pioneer322 | 6 | 7 | -1 |
| Eskimos are gay | 0 | 1 | -1 |
| tom | 0 | 1 | -1 |
| worminator | 3 | 4 | -1 |
| v1p3rau | 0 | 1 | -1 |
| Citizen66 | 11 | 12 | -1 |
| Quasi Qubit | 13 | 14 | -1 |
| Chicken23 | 0 | 1 | -1 |
| Nick | 0 | 1 | -1 |
| mtlAngelus | 12 | 13 | -1 |
| AleX | 0 | 1 | -1 |
| hud | 1 | 2 | -1 |
| blackwing | 1 | 3 | -2 |
| llHorsePowerll | 3 | 5 | -2 |
| Almost | 2 | 4 | -2 |
| WillyWonka | 0 | 2 | -2 |
| UnKnown X | 5 | 7 | -2 |
| raven_19702003 | 0 | 2 | -2 |
| Killer | 0 | 2 | -2 |
| EthoCryptiC | 10 | 12 | -2 |
| Guy | 0 | 3 | -3 |
| thewalrus | 8 | 11 | -3 |
| Blinx | 40 | 43 | -3 |
| sam | 0 | 3 | -3 |
| skin_n_bones | 22 | 25 | -3 |
| Annelid | 89 | 93 | -4 |
| XxMalcolmxX | 1 | 5 | -4 |
| Bloopy | 1049 | 1053 | -4 |
| Evil Pixel | 51 | 57 | -6 |
| CousCous022 | 2 | 8 | -6 |
| Eiko | 3 | 9 | -6 |
| Flash | 12 | 20 | -8 |
| dansm | 20 | 28 | -8 |
| CousCous | 23 | 34 | -11 |
| Slaya | 23 | 36 | -13 |
| igotworms | 969 | 983 | -14 |
| ricky | 5 | 22 | -17 |
| name | storedposts | realposts | difference |
| PyrOmaniek | 57 | 78 | -21 |
| joetheeskimo5 | 144 | 167 | -23 |
| XxpyroxX | 2 | 63 | -61 |
| TheAbdBoy | 301 | 1038 | -737 |