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
});