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