]> ruin.nu Git - NDIRC.git/blobdiff - Delling.pm
Column for shipname has been renamed
[NDIRC.git] / Delling.pm
index bb6b97e8b9a635541fe311cefbacc87fe33c700b..f19bf2a366271e06525641a03ffbe6115be75874 100644 (file)
@@ -207,7 +207,7 @@ FROM users u
        JOIN fleets f USING (fid)
        JOIN fleet_ships fs USING (fid)
        JOIN defense_missions dm ON f.fid = dm.fleet
-       JOIN ship_stats ss ON fs.ship = ss.name
+       JOIN ship_stats ss USING (ship)
 WHERE NOT dm.announced
 GROUP BY username,call,tick,dm.fleet,p.value
                });