SELECT p.playername, COUNT(m1.id) AS diamond_count, m2.cnt AS stone_count, ((COUNT(m1.id) / m2.cnt) * 100) AS diamond_ratio
FROM `lb-players` AS p
INNER JOIN `lb-main` AS m1 ON p.playerid = m1.playerid AND m1.replaced = 56 AND m1.TYPE = 0
INNER JOIN (SELECT playerid, COUNT(id) AS cnt FROM `lb-main` WHERE replaced = 1 AND TYPE = 0 GROUP BY playerid) AS m2 ON p.playerid = m2.playerid
GROUP BY p.playerid
ORDER BY ((COUNT(m1.id) / m2.cnt) * 100) DESC
LIMIT 50;