Unnamed

SELECT x1.x, x1.y, x1.pop, x1.village,x1.player, 
SQRT(POW(x_world.x-73,2)+POW(x_world.y-5,2)) AS distance 
FROM x_world 
RIGHT JOIN x_world as x1 
ON x_world.player = x1.player
LIMIT 50