55 resultat(s) trouvé(s)
par ordre de distance par rapport à la commune de saint-georges-la-riviereSELECT *,(6371 * ACOS(COS(RADIANS(49.3643234)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(-1.7286804)) + SIN(RADIANS(49.3643234)) * SIN(RADIANS(latitude)))) AS distance FROM hotel_booking where ((zip=50270) OR (zip=50270) OR (zip=50270) OR (zip=50580) OR (zip=50270)) AND hotel_type_id <> '204' HAVING distance <= 3 ORDER BY distance LIMIT 30,10