Coburg (Coburg)

SELECT id, ort, fachwort, ( 6368 * SQRT(2*(1-cos(RADIANS(lng)) * cos(0.19141623856424) * (sin(RADIANS(lat)) * sin(0.87716621760115) + cos(RADIANS(lat)) * cos(0.87716621760115)) - sin(RADIANS(lng)) * sin(0.19141623856424)))) AS entfernung FROM literatur WHERE 6368 * SQRT(2*(1-cos(RADIANS(lng)) * cos(0.19141623856424) * (sin(RADIANS(lat)) * sin(0.87716621760115) + cos(RADIANS(lat)) * cos(0.87716621760115)) - sin(RADIANS(lng)) * sin(0.19141623856424))) <= 10 ORDER BY entfernung