|< 1 2 3 >| | 27 Einträge, 3 Seiten |
mysql> SELECT name, wohnort, postleitzahl, (ACOS((SIN(RADIANS(48.7667))*SIN(RADIANS(lat))) + (COS(RADIANS(48.7667))*COS(RADIANS(lat))*COS(RADIANS(lon)-RADIANS(9.18333)))) * 6378.388) AS e FROM defaultusers WHERE (ACOS((SIN(RADIANS(48.7667))*SIN(RADIANS(lat))) + (COS(RADIANS(48.7667))*COS(RADIANS(lat))*COS(RADIANS(lon)-RADIANS(9.18333)))) * 6378.388) <= 20 ORDER BY e ASC;
|< 1 2 3 >| | 27 Einträge, 3 Seiten |