rendered paste bodyThe query:
SELECT distinct(playername) ,count(*) as c FROM `players` group by playername having c > 1
Should give an empty resultset. But this is not the case so when running the following query to give more detail:
SELECT *
FROM `players`
WHERE playername
IN (
SELECT playername AS pn
FROM `players`
GROUP BY playername
HAVING (
count( playername ) >1
)
)
ORDER BY playername
I get as a resultset:
Full Texts id playername ogame_playerid alliance_id rank points frank fpoints rrank rpoints last_stats_update noob banned vacation inactive long_inactive diplomatic_status spiolvl computech waffentech schildtech rpz energytech hypertech vbt impulse hra lasertech iontech plasmatech forschungsnetz gravi last_tech_update
Edit Delete 924 arshad23 124972 203 0 0 0 0 0 0 0000-00-00 00:00:00 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 2971 arshad23 NULL 203 742 14439 1027 8 677 91 2007-05-13 00:11:34 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 1609 Beserk 127562 0 0 0 0 0 0 0 0000-00-00 00:00:00 true false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 3373 Beserk NULL 0 1126 2002 916 25 1087 48 2007-05-13 00:11:46 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 861 dialga 124260 180 0 0 0 0 0 0 0000-00-00 00:00:00 true false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 3201 dialga NULL 180 1006 4499 924 23 809 76 2007-05-13 00:11:40 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 64 doell00s 101246 161 0 0 0 0 0 0 0000-00-00 00:00:00 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 2099 doell00s NULL 161 31 999076 23 31654 80 142 2007-05-14 12:14:22 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 216 ed hunter 108754 317 0 0 0 0 0 0 0000-00-00 00:00:00 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 2043 ed hunter NULL 317 182 346805 33 24547 325 121 2007-05-14 00:13:54 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 364 fabian 114171 294 0 0 0 0 0 0 0000-00-00 00:00:00 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 1910 fabian NULL 294 387 115970 396 606 421 113 2007-05-13 00:11:26 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 413 Falloutboy 115443 317 0 0 0 0 0 0 0000-00-00 00:00:00 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 1874 Falloutboy NULL 317 271 218292 257 1698 131 136 2007-05-13 00:11:18 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 380 ganjahz 114620 311 0 0 0 0 0 0 0000-00-00 00:00:00 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 2082 ganjahz NULL 311 82 637794 148 4919 236 128 2007-05-14 12:14:22 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 213 genadel00s 108493 161 0 0 0 0 0 0 0000-00-00 00:00:00 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 1993 genadel00s NULL 161 92 610036 64 14798 248 127 2007-05-14 12:14:22 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 749 Helmie 122594 234 0 0 0 0 0 0 0000-00-00 00:00:00 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 2140 Helmie NULL 234 115 513215 111 8329 22 152 2007-05-14 00:14:07 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 60 Henry Kissinger 101075 130 0 0 0 0 0 0 0000-00-00 00:00:00 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 1798 Henry Kissinger NULL 130 74 676050 145 5026 58 144 2007-05-14 12:14:22 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 691 hyper 121416 248 0 0 0 0 0 0 0000-00-00 00:00:00 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 2370 hyper NULL 248 281 207107 305 1246 166 134 2007-05-13 00:11:18 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 17 Joel 100231 134 0 0 0 0 0 0 0000-00-00 00:00:00 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 1792 Joel NULL 134 21 1127683 13 39003 53 145 2007-05-14 12:14:22 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 516 Justin ma 118203 200 518 54999 569 207 374 117 0000-00-00 00:00:00 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 2487 Justin ma NULL 200 764 12749 599 171 633 95 2007-05-13 00:11:34 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 605 Knight Falador 119778 205 0 0 0 0 0 0 0000-00-00 00:00:00 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Edit Delete 2350 Knight Falador NULL 205 451 78108 405 572 786 78 2007-05-13 00:11:37 false false false false false nothing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0000-00-00 00:00:00
Please note that the entries where the player_ID=NULL the values for ranking etc. differ from the accompanying entry with sensible player_ID
Yet, when for example we take player 'Joel' the values for the 'NULL player' are correct but the entry with sensible player_ID is not.
I have not tried to delete both entries. However I did try to delete the NULL value player. Only to see that on the next update it returns in the db.