- FROM (SELECT tick,SUM(size) AS memsize,SUM(score) AS memscore
- FROM planets p JOIN planet_stats ps USING (id)
- WHERE p.alliance_id = $1 GROUP BY tick) p
- JOIN alliance_stats a ON a.tick = p.tick
- WHERE a.id = $1
- AND a.tick > (SELECT max(tick) - 50 FROM alliance_stats)
+ FROM (SELECT tick,aid,SUM(size) AS memsize,SUM(score) AS memscore
+ FROM alliances a
+ JOIN planets p USING (alliance)
+ JOIN planet_stats ps USING (pid)
+ GROUP BY tick,aid ) p
+ JOIN alliance_stats a USING (aid,tick)
+ WHERE aid = $1
+ AND tick > (SELECT max(tick) - 50 FROM alliance_stats)