Historische Fundgrube (Ingolstadt)

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