JOIN (SELECT g.x,g.y, sum(p.value) AS nfvalue
FROM galaxies g join current_planet_stats p on g.x = p.x AND g.y = p.y
WHERE g.tick = (SELECT max(tick) from galaxies)
JOIN (SELECT g.x,g.y, sum(p.value) AS nfvalue
FROM galaxies g join current_planet_stats p on g.x = p.x AND g.y = p.y
WHERE g.tick = (SELECT max(tick) from galaxies)