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
insert into block (player, id)
select 'meka','15'
union
select 'blou','18'
union
select 'blou','15'
union
select 'blou','16'
union
select 'blou','15'
union
select 'meka','15'
union
select 'meka','16'