FROM (SELECT username,defense_points,c.id,count(f.target) AS fleets
, count(NULLIF(f.landing_tick + f.eta -1 = f.back,TRUE)) AS recalled
FROM users u JOIN calls c ON c.member = u.uid
LEFT OUTER JOIN (
SELECT * FROM launch_confirmations JOIN fleets USING (fid)
FROM (SELECT username,defense_points,c.id,count(f.target) AS fleets
, count(NULLIF(f.landing_tick + f.eta -1 = f.back,TRUE)) AS recalled
FROM users u JOIN calls c ON c.member = u.uid
LEFT OUTER JOIN (
SELECT * FROM launch_confirmations JOIN fleets USING (fid)