SELECT DISTINCT c.ville_codepostaux, c.num_codepostaux ,
ROUND(SQRT( POW((69.1 * (48.8501222 - a.latitude)), 2) + POW((53 * (2.4349277 - a.longitude)), 2)), 1) AS distance
FROM
client_geo a, client b, codepostaux c
WHERE
a.num_client = b.num_client
and
b.num_codepostaux = c.num_codepostaux
GROUP BY c.ville_codepostaux
ORDER BY distance
ASC limit 5
Baby-sitter de LES PONTS DE CE cherchent Enfants et Bébés à garder | babynounou.fr
