h: SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-6.454967) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-78.838264) ) + sin( radians(-6.454967) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -6.9046271677464 AND -6.0053068322536 ) AND ( longitude BETWEEN -79.29079296445 AND -78.38573503555 ) SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-6.454967) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-78.838264) ) + sin( radians(-6.454967) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -6.9046271677464 AND -6.0053068322536 ) AND ( longitude BETWEEN -79.29079296445 AND -78.38573503555 ) AND hoteltype_id IN(207,213,209,227,221,232,228,220,223,230,229) ORDER BY CASE WHEN minrate <1 THEN 1 ELSE 0 END, gabino_date_update DESC, review_score DESC,distance ASC h: SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-6.454967) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-78.838264) ) + sin( radians(-6.454967) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -6.9046271677464 AND -6.0053068322536 ) AND ( longitude BETWEEN -79.29079296445 AND -78.38573503555 ) SELECT hotel_id, latitude, longitude, ( 6371 * acos( cos( radians(-6.454967) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-78.838264) ) + sin( radians(-6.454967) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN -6.9046271677464 AND -6.0053068322536 ) AND ( longitude BETWEEN -79.29079296445 AND -78.38573503555 ) AND hoteltype_id IN(207,213,209,227,221,232,228,220,223,230,229) ORDER BY CASE WHEN minrate <1 THEN 1 ELSE 0 END, gabino_date_update DESC, review_score DESC,distance ASC LIMIT 0,10 Casas de alquiler en Cajamarca, 3 Casas - Gabinohome
Anuncios parecidos
Casas de alquiler en Cajamarca sin comisiones. Casas en Cajamarca con fotos y opiniones, contacto directo. Casas de alquiler en Cajamarca. 1a
RSS
 · My AOL  · MyYahoo  · Bloglines
¿Quiere recibir alertas con anuncios nuevos en Cajamarca?
Casas de alquiler en Cajamarca :
loading