requete top mineur tout minerai confondu :
SELECT player,COUNT(*) AS total FROM block GROUP BY player ORDER BY total DESC
requete top mineur d'un block en particulier :
SELECT player,COUNT(*) AS total FROM block WHERE id='15' GROUP BY player ORDER BY total DESC
-
https://links.infomee.fr/shaare/0htx0w