closet_planet.sql

SELECT my_ships.id as ship_id, (
	SELECT planets.id 
	FROM planets 
	WHERE id NOT IN(SELECT id FROM planets WHERE conqueror_id=2599)
	ORDER BY SQRT(((planets.location_x::bigint+-my_ships.location_x::bigint)^2)  + ((my_ships.location_y::bigint-planets.location_y::bigint)^2)) 
	ASC OFFSET 0 LIMIT 1) as planet_id
FROM my_ships;