Logblock - Get ore counts for all players

SELECT
    P.playername,
    P.playerid,
    P.onlinetime,
    P.lastlogin,
( SELECT COUNT(SW.id) AS intDiamondOre FROM `lb-survivalworld` SW
  WHERE SW.playerid = P.playerid AND replaced = 56 AND TYPE = 0 AND DATE > Date_Add(CURRENT_DATE(), INTERVAL '-#intDays#' DAY)) AS intDiamondOre,
( SELECT COUNT(SW.id) AS intGoldOre FROM `lb-survivalworld` SW
  WHERE SW.playerid = P.playerid AND replaced = 14 AND TYPE = 0 AND DATE > Date_Add(CURRENT_DATE(), INTERVAL '-#intDays#' DAY)) AS intGoldOre,
( SELECT COUNT(SW.id) AS intIronOre FROM `lb-survivalworld` SW
  WHERE SW.playerid = P.playerid AND replaced = 15 AND TYPE = 0 AND DATE > Date_Add(CURRENT_DATE(), INTERVAL '-#intDays#' DAY)) AS intIronOre,
( SELECT COUNT(SW.id) AS intLapisOre FROM `lb-survivalworld` SW
  WHERE SW.playerid = P.playerid AND replaced = 21 AND TYPE = 0 AND DATE > Date_Add(CURRENT_DATE(), INTERVAL '-#intDays#' DAY)) AS intLapisOre,
( SELECT COUNT(SW.id) AS intCoalOre FROM `lb-survivalworld` SW
  WHERE SW.playerid = P.playerid AND replaced = 16 AND TYPE = 0 AND DATE > Date_Add(CURRENT_DATE(), INTERVAL '-#intDays#' DAY)) AS intCoalOre,
( SELECT COUNT(SW.id) AS intEmeraldOre FROM `lb-survivalworld` SW
  WHERE SW.playerid = P.playerid AND replaced = 129 AND TYPE = 0 AND DATE > Date_Add(CURRENT_DATE(), INTERVAL '-#intDays#' DAY)) AS intEmeraldOre,
( SELECT COUNT(SW.id) AS intRedstoneOre FROM `lb-survivalworld` SW
  WHERE SW.playerid = P.playerid AND (replaced = 73 OR replaced = 74) AND TYPE = 0 AND DATE > Date_Add(CURRENT_DATE(), INTERVAL '-#intDays#' DAY)) AS intRedstoneOre,
( SELECT COUNT(SW.id) AS intTotalOre FROM `lb-survivalworld` SW
  WHERE SW.playerid = P.playerid AND replaced IN ('56','14','15','21','16','129','73','74') AND TYPE = 0 AND DATE > Date_Add(CURRENT_DATE(), INTERVAL '-#intDays#' DAY)) AS intTotalOre
FROM `lb-players` P
WHERE P.onlinetime > 600
AND P.lastlogin > Date_Add(CURRENT_DATE(), INTERVAL '-30' DAY)
ORDER BY intTotalOre DESC, intDiamondOre DESC, intEmeraldOre DESC, intGoldOre DESC, intLapisOre DESC, intIronOre DESC, intRedstoneOre DESC, intCoalOre DESC , P.playername