2 resultat(s) trouvé(s)
par ordre de distance par rapport à la commune de ligneresSELECT *,(6371 * ACOS(COS(RADIANS(48.6641998)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(0.32934600)) + SIN(RADIANS(48.6641998)) * SIN(RADIANS(latitude)))) AS distance FROM hotel_booking where ((zip=61160) OR (zip=61390) OR (zip=61230) OR (zip=61240) OR (zip=61230) OR (zip=61240) OR (zip=61500) OR (zip=61230) OR (zip=61230) OR (zip=61230) OR (zip=61240)) AND hotel_type_id <> '204' HAVING distance <= 3 ORDER BY distance