Umgebungskarte

SELECT id, lat, lng, name, ( 6368 * SQRT(2*(1-cos(RADIANS(lng)) * cos(0.20202688746659) * (sin(RADIANS(lat)) * sin(0.84015169021322) + cos(RADIANS(lat)) * cos(0.84015169021322)) - sin(RADIANS(lng)) * sin(0.20202688746659)))) AS entfernung FROM denkmal WHERE 6368 * SQRT(2*(1-cos(RADIANS(lng)) * cos(0.20202688746659) * (sin(RADIANS(lat)) * sin(0.84015169021322) + cos(RADIANS(lat)) * cos(0.84015169021322)) - sin(RADIANS(lng)) * sin(0.20202688746659))) <= 25 ORDER BY entfernung
Revolutionszeitung
Revolutionszeitung