SELECT `p`.`playername` as playername, `l`.COUNT(*) as count, `l`.`time` as time
FROM `deity_creative_players` p, `deity_creative_likes` l
WHERE `p`.`playername` = `l`.`owner`
GROUP BY playername
ORDER BY count DESC, time DESC;