Rename the shipname attribute

[ndwebbie.git] / lib / NDWeb / Controller / Calls.pm

diff --git a/lib/NDWeb/Controller/Calls.pm b/lib/NDWeb/Controller/Calls.pm
index 0ba04a513c40f2ceabe72a14b0bab6b504afb216..dac7f32b5a1ec279014b9a3754cd463c5108fd55 100644 (file)
--- a/lib/NDWeb/Controller/Calls.pm
+++ b/lib/NDWeb/Controller/Calls.pm
@@ -161,7 +161,7 @@ WITH lc AS (
        SELECT fid,(sum(amount*(metal+crystal+eonium)) / value)::int  AS value_ratio
        FROM lcp
                JOIN fleet_ships fs USING (fid)
-               JOIN ship_stats s ON s.name = fs.ship
+               JOIN ship_stats s USING (ship)
        GROUP BY fid, value
 )
 SELECT DISTINCT ON (x,y,z,pid,name,amount,back) fid,mission, name, eta