Host: localhost
Database : blameth_pixel
Generation Time: Jun 08, 2004 at 10:06 AM
Generated by: phpMyAdmin 2.5.6 / MySQL 4.0.18-standard
SQL-query:
SELECT users.name, users.threads AS storedthreads, count( f_threads.id
) AS realthreads, users.threads - count( f_threads.id ) AS difference
FROM users
RIGHT JOIN f_threads ON f_threads.author = users.name
WHERE users.name IS NOT NULL GROUP BY users.name
HAVING realthreads != storedthreads
ORDER BY difference DESC LIMIT 0 , 200;
Rows: 72
| Username | Threads form Users Table | Actual Threads | Difference (sorted descending) |
|---|---|---|---|
| ReadMe | 74 | 53 | 21 |
| HHC | 23 | 19 | 4 |
| Meiapaul | 53 | 50 | 3 |
| Squiffel | 10 | 7 | 3 |
| Evil Bunny | 6 | 3 | 3 |
| Jackbob | 16 | 14 | 2 |
| DreamEater | 3 | 1 | 2 |
| ZeptOr | 8 | 7 | 1 |
| XxPYRO!xX | 5 | 4 | 1 |
| sumbody | 2 | 1 | 1 |
| Lyndon | 5 | 4 | 1 |
| tundraH | 18 | 17 | 1 |
| tEfLoN | 6 | 5 | 1 |
| Sonicrazy | 4 | 5 | -1 |
| dansm | 5 | 6 | -1 |
| Squelchymcphee | 6 | 7 | -1 |
| Eiko | 0 | 1 | -1 |
| skin_n_bones | 10 | 11 | -1 |
| Eric | 2 | 3 | -1 |
| pro-play | 0 | 1 | -1 |
| v1p3rau | 0 | 1 | -1 |
| TonY | 10 | 11 | -1 |
| Misterags | 2 | 3 | -1 |
| Fiend | 23 | 24 | -1 |
| Eskimos are gay | 0 | 1 | -1 |
| sam | 0 | 1 | -1 |
| c0ld | 0 | 1 | -1 |
| XxfuzzballxX | 36 | 37 | -1 |
| Megaman | 1 | 2 | -1 |
| DeathBringer | 5 | 6 | -1 |
| Rogue | 0 | 1 | -1 |
| WillyWonka | 0 | 1 | -1 |
| Killer | 0 | 1 | -1 |
| Simon (swed simon) | 2 | 3 | -1 |
| AleX | 0 | 1 | -1 |
| psymon | 50 | 51 | -1 |
| CousCous | 1 | 2 | -1 |
| MattyxWX | 1 | 2 | -1 |
| Cell l3lock | 0 | 1 | -1 |
| Chicken23 | 0 | 1 | -1 |
| Thor | 24 | 25 | -1 |
| Blinx | 7 | 8 | -1 |
| HarrY | 35 | 36 | -1 |
| Pioneer322 | 0 | 1 | -1 |
| ZoGgEr! | 42 | 43 | -1 |
| tom | 0 | 1 | -1 |
| worminator | 2 | 3 | -1 |
| routine_error | 19 | 20 | -1 |
| Flash | 2 | 4 | -2 |
| llHorsePowerll | 2 | 4 | -2 |
| raven_19702003 | -1 | 1 | -2 |
| !Sugar! | 0 | 2 | -2 |
| CBWhiz | 64 | 66 | -2 |
| SPAZ | 17 | 19 | -2 |
| syh | -1 | 1 | -2 |
| PyrOmaniek | 10 | 12 | -2 |
| UnKnown X | 1 | 3 | -2 |
| Glenn | 10 | 12 | -2 |
| wow13 | 5 | 7 | -2 |
| Star Worms | 20 | 23 | -3 |
| thewalrus | 0 | 3 | -3 |
| Archamond | 65 | 68 | -3 |
| Dingbats | 36 | 39 | -3 |
| The Wishmaster | 58 | 62 | -4 |
| TheAbdBoy | 121 | 125 | -4 |
| ricky | 0 | 4 | -4 |
| C1 | 136 | 140 | -4 |
| Bloopy | 64 | 69 | -5 |
| joetheeskimo5 | 7 | 12 | -5 |
| XxpyroxX | 2 | 7 | -5 |
| The Pope | 65 | 73 | -8 |
| Duke | 55 | 75 | -20 |