X-Git-Url: https://ruin.nu/git/?p=NDIRC.git;a=blobdiff_plain;f=Delling.pm;h=f19bf2a366271e06525641a03ffbe6115be75874;hp=bb6b97e8b9a635541fe311cefbacc87fe33c700b;hb=effc5281e94e0fa16f1fd08bf848f607a306d0c0;hpb=cbe172da35e963a0e3205af1337e7b5efee24c13

diff --git a/Delling.pm b/Delling.pm
index bb6b97e..f19bf2a 100644
--- a/Delling.pm
+++ b/Delling.pm
@@ -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
 		});