(s.size::int8*(1464-tick())*250)/100 + score + (resources/planets*LEAST(members,60))/300 AS nscore3,
(s.size::int8*(1464-tick())*250)/100 AS scoregain3
FROM (SELECT alliance_id AS id,sum(metal+crystal+eonium) AS resources, count(*) AS planets
(s.size::int8*(1464-tick())*250)/100 + score + (resources/planets*LEAST(members,60))/300 AS nscore3,
(s.size::int8*(1464-tick())*250)/100 AS scoregain3
FROM (SELECT alliance_id AS id,sum(metal+crystal+eonium) AS resources, count(*) AS planets