select s1.servers, count(*) as players from ( select count(*) as servers from day218stats as d, server7stats as s where s.id=d.serverid and s.game=21 and s.yday=218 and s.year=2006 group by d.playerid ) as s1 group by s1.servers order by players desc;