use hlstatsx; select map, count(DISTINCT(playerId)) cnt from (SELECT map, playerId FROM `hlstats_Events_Chat` WHERE message = 'rtv' group by map, playerId) d group by map order by cnt desc, map asc

select map, count(DISTINCT(playerId)) cnt from (SELECT map, playerId FROM `hlstats_Events_Disconnects` group by map, playerId) d group by map order by cnt desc, map asc



select map, count(DISTINCT(playerId)) cnt from (SELECT map, playerId FROM `hlstats_Events_Connects` group by map, playerId) d group by map order by cnt desc, map asc