$result = $db->query(" SELECT hlstats_Players.lastName AS name, Count(hlstats_Frags_Kills.kills) AS kills, Count(hlstats_Frags_Kills.deaths) AS deaths, hlstats_Frags_Kills.playerId as victimId, IFNULL(Count(hlstats_Frags_Kills.kills)/Count(hlstats_Frags_Kills.deaths), IFNULL(FORMAT(Count(hlstats_Frags_Kills.kills), 2), '-')) AS kpd FROM hlstats_Frags_Kills INNER JOIN hlstats_Players ON hlstats_Frags_Kills.playerId = hlstats_Players.playerId INNER JOIN hlstats_PlayerUniqueIds ON hlstats_PlayerUniqueIds.playerId = hlstats_Players.playerId WHERE hlstats_PlayerUniqueIds.uniquieId NOT LIKE 'BOT:%' GROUP BY hlstats_Frags_Kills.playerId HAVING Count(hlstats_Frags_Kills.kills) >= $killLimit ORDER BY $tblPlayerKillStats->sort $tblPlayerKillStats->sortorder, $tblPlayerKillStats->sort2 $tblPlayerKillStats->sortorder");