X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FCalls.pm;h=dac7f32b5a1ec279014b9a3754cd463c5108fd55;hp=0ba04a513c40f2ceabe72a14b0bab6b504afb216;hb=8174fac466dde64437063677e2819d266c18a058;hpb=c018a7ccbb1fd8bdec5c8f97b151686ae933870b

diff --git a/lib/NDWeb/Controller/Calls.pm b/lib/NDWeb/Controller/Calls.pm
index 0ba04a5..dac7f32 100644
--- 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