Unnamed

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