Sim aat

"PetitEtreMalfaisant;c-2202155" wrote:
woooot? so a "billion dollar game" can't do a proper count?
I'll give you the correct query for free.

SELECT count(*) 
FROM Guild
INNER JOIN Player ON Guild.id = Player.guild_id
INNER JOIN PlayerToon ON Player.id = PlayerToon.player_id
WHERE PlayerToon.toon_id = 

Actually their code does it on purpose to not count ppl who are inactive for long time. So in the end yours is wrong ;)