- sec_centres,NULLIF(structures,0) AS structures,dists,last_covop,
- u.username,max_bank_hack(metal,crystal,eonium,p.value,(SELECT value FROM
- current_planet_stats WHERE id = ?)) AS MaxResHack, planet_status, relationship
- FROM covop_targets c JOIN current_planet_stats p ON p.id = c.planet
- LEFT OUTER JOIN users u ON u.uid = c.covop_by) AS foo
- $where});
- $query->execute($self->{PLANET});
+ seccents,NULLIF(ss.total::integer,0) AS structures,distorters
+ ,max_bank_hack(metal,crystal,eonium,p.value
+ ,(SELECT value FROM current_planet_stats WHERE id = ?)) AS MaxResHack
+ , planet_status, relationship,gov
+ FROM current_planet_stats p
+ LEFT OUTER JOIN planet_scans ps ON p.id = ps.planet
+ LEFT OUTER JOIN structure_scans ss ON p.id = ss.planet
+ ) AS foo
+ LEFT OUTER JOIN (SELECT id,max(tick) AS tick FROM covop_attacks GROUP BY id) co USING (id)
+ WHERE (metal IS NOT NULL OR seccents IS NOT NULL)
+ $where
+ }) or warn $DBH->errstr;
+ $query->execute($self->{PLANET}) or warn $DBH->errstr;