xars456
SELECT ROW_NUMBER() OVER (ORDER BY "sea_lantern" DESC), tu.playername, t."sea_lantern"
FROM "public"."T_player_stats_used" t
INNER JOIN (
SELECT uuid, max("lastUpdate") AS "latestDate"
FROM "public"."T_player_stats_used"
GROUP BY uuid
) tm ON t.uuid = tm.uuid and t."lastUpdate" = tm."latestDate"
INNER JOIN (
SELECT uuid, playername
FROM "public"."T_player_info"
WHERE "banned" = False
) tu ON t.uuid = tu.uuid WHERE "sea_lantern" >= 1 ORDER BY ("sea_lantern") DESC LIMIT 100