SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-11.283809) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-74.633848) ) + sin( radians(-11.283809) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -11.733469167746 AND -10.834148832254 ) AND ( longitude BETWEEN -75.092371429733 AND -74.175324570267 ) AND hoteltype_id IN(216,220,208,229,201,219,218,227,209,224,207) ORDER BY CASE WHEN minrate <1 THEN 1 ELSE 0 END, gabino_date_update DESC, review_score DESC,distance ASC SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-11.283809) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-74.633848) ) + sin( radians(-11.283809) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -11.733469167746 AND -10.834148832254 ) AND ( longitude BETWEEN -75.092371429733 AND -74.175324570267 ) AND hoteltype_id IN(216,220,208,229,201,219,218,227,209,224,207) ORDER BY CASE WHEN minrate <1 THEN 1 ELSE 0 END, gabino_date_update DESC, review_score DESC,distance ASC LIMIT 0,10 Alquiler de departamentos en Satipo - Gabinohome
Anuncios parecidos
Alquiler de departamentos en Satipo con fotos y opiniones. 0 Departamentos en Satipo por corta y larga temporada.
loading