Geschichtlich-Heimatkundliche Sammlung Ascheim (Aschheim)

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