);
my $ships = $dbh->prepare(q{
-SELECT id, amount FROM fleet_ships fs JOIN ship_stats s ON s.name = fs.ship
+SELECT id, amount FROM fleet_ships fs JOIN ship_stats s USING (ship)
WHERE fid = $1
});
SELECT $1,pid,array_to_string(array_agg(
fleet || ': eta=' || eta || ', amount=' || amount || ', type=' || shiptype
|| ' landing=' || landing_tick || 'back=' || landing_tick + eta
- ),'\n')
+ ),E'\n')
FROM calls c
JOIN incomings i USING (call)
JOIN current_planet_stats p USING (pid)