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/?0htx0winsert 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'
-
https://links.infomee.fr/?2aWaDw