- my $f = $ND::DBH->prepare(qq{SELECT username,SUM(amount) AS amount
- FROM users u JOIN fleets f USING (uid) JOIN fleet_ships fs ON f.id = fs.fleet WHERE f.fleet = 0 AND ship ILIKE ? GROUP BY username ORDER BY amount DESC
- });
+ my $f = $ND::DBH->prepare(qq{SELECT username,SUM(fs.amount) AS amount
+ FROM users u
+ JOIN (SELECT DISTINCT ON (sender) sender AS planet,id FROM fleets
+ WHERE mission = 'Full fleet' AND name <> 'Unit'
+ ORDER BY sender,tick DESC,id DESC) f USING (planet)
+ JOIN fleet_ships fs ON f.id = fs.id
+ WHERE ship ILIKE ?
+ GROUP BY username ORDER BY amount DESC
+ });