1 resultat(s) trouvé(s)
par ordre de distance par rapport à la commune de etaves-et-bocquiauxSELECT *,(6371 * ACOS(COS(RADIANS(49.938709)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(3.454969)) + SIN(RADIANS(49.938709)) * SIN(RADIANS(latitude)))) AS distance FROM hotel_booking where ((zip=02110) OR (zip=02110)) AND hotel_type_id <> '204' HAVING distance <= 5 ORDER BY distance