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