,((resources/planets*scoremem)/300 + (hidden/planets*scoremem)/100)::bigint AS scoregain2
,(score + (resources/planets*scoremem)/300
+ (hidden/planets*scoremem)/100)::bigint AS nscore2
,((resources/planets*scoremem)/300 + (hidden/planets*scoremem)/100)::bigint AS scoregain2
,(score + (resources/planets*scoremem)/300
+ (hidden/planets*scoremem)/100)::bigint AS nscore2
FROM (SELECT alliance_id AS id,sum(metal+crystal+eonium) AS resources
, sum(hidden) AS hidden, count(*) AS planets
FROM planets p join current_planet_scans c ON p.id = c.planet
FROM (SELECT alliance_id AS id,sum(metal+crystal+eonium) AS resources
, sum(hidden) AS hidden, count(*) AS planets
FROM planets p join current_planet_scans c ON p.id = c.planet