X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FInclude.pm;h=1974724f7951ad1f3694efcfd8d301d86f00f2a0;hb=6e1e01771cd86b3b58f4932aacb0cc496b5c376d;hp=5bea31bec699e2ee55594cd271935118ac824116;hpb=5d49b3579d2ad39f6ae9bc2dba37ebbf0334e0da;p=ndwebbie.git diff --git a/lib/NDWeb/Include.pm b/lib/NDWeb/Include.pm index 5bea31b..1974724 100644 --- a/lib/NDWeb/Include.pm +++ b/lib/NDWeb/Include.pm @@ -79,7 +79,7 @@ FROM (fleets i NATURAL JOIN users u) JOIN current_planet_stats t ON i.target = t.id JOIN current_planet_stats o ON i.sender = o.id WHERE $where -GROUP BY i.tick,i.mission,t.x,t.y,t.z,o.x,o.y,o.z,i.amount,i.ingal,u.username,t.alliance,o.alliance,t.nick,o.nick +GROUP BY i.tick,i.mission,t.x,t.y,t.z,o.x,o.y,o.z,i.amount,i.ingal,u.username,t.alliance,o.alliance,t.nick,o.nick,i.sender,i.target ORDER BY i.tick DESC, i.mission}; }