-) f USING (planet) LEFT OUTER JOIN (
- SELECT planet, ship, SUM(fs.amount) AS amount, 3 - COUNT(DISTINCT fid) AS fleets
- FROM fleets f
- JOIN launch_confirmations USING (fid)
+) f USING (pid) LEFT OUTER JOIN (
+ SELECT t AS tick, pid, ship, SUM(fs.amount) AS amount
+ , 3 - COUNT(DISTINCT fid) AS fleets
+ FROM ticks
+ CROSS JOIN fleets f
+ JOIN (SELECT landing_tick, fid, back, eta FROM launch_confirmations) lc USING (fid)