asdas Alquiler de habitaciones en Fuentes Claras - Gabinohome.mobi

PAID
SELECT a.advert_type, a.id, a.active_state FROM web_adverts AS a LEFT JOIN web_client AS c ON c.id=a.id_client WHERE a.active_state=1 AND c.active_state=1 AND a.advert_type>1 AND a.id_advert_type='1' AND a.id_area='2939' AND a.id_region='44' AND a.id_country='es' AND NOT EXISTS ( SELECT * FROM web_bookings AS b WHERE b.id_advert = a.id AND (b.the_date BETWEEN '2019-07-16' AND '2019-07-19') ) AND a.capacity>=1

FREE - newer than 1 YEAR
SELECT a.advert_type, a.id, a.active_state FROM web_adverts AS a LEFT JOIN web_client AS c ON c.id=a.id_client WHERE a.active_state=1 AND c.active_state=1 AND a.advert_type=1 AND (a.date_mod >= DATE(NOW()) - INTERVAL 1 YEAR || a.date_add>=DATE(NOW())- INTERVAL 1 YEAR) AND a.id_advert_type='1' AND a.id_area='2939' AND a.id_region='44' AND a.id_country='es' AND NOT EXISTS ( SELECT * FROM web_bookings AS b WHERE b.id_advert = a.id AND (b.the_date BETWEEN '2019-07-16' AND '2019-07-19') ) AND a.capacity>=1

Booking - API
https://gabinohome:checkin0123@distribution-xml.booking.com/2.0/json/hotelAvailability?checkin=2019-07-16&checkout=2019-07-19&latitude=40.863660&longitude=-1.323606&room1=A&order_by=distance&radius=12&language=es¤cy=EUR&property_type=homestay&extras=hotel_details

FREE - older than 1 YEAR
SELECT a.advert_type, a.id, a.active_state FROM web_adverts AS a LEFT JOIN web_client AS c ON c.id=a.id_client WHERE a.active_state=1 AND c.active_state=1 AND a.advert_type=1 AND (a.date_mod <= DATE(NOW()) - INTERVAL 1 YEAR || a.date_add<=DATE(NOW())- INTERVAL 1 YEAR) AND a.id_advert_type='1' AND a.id_area='2939' AND a.id_region='44' AND a.id_country='es' AND NOT EXISTS ( SELECT * FROM web_bookings AS b WHERE b.id_advert = a.id AND (b.the_date BETWEEN '2019-07-16' AND '2019-07-19') ) AND a.capacity>=1 ORDER BY a.advert_type DESC, a.active_time DESC, a.date_mod DESC, a.date_add DESC, a.active_state ASC

Otros anuncios en Alquiler de habitaciones Fuentes Claras

Alquiler de habitaciones en Fuentes Claras. anuncios de Habitaciones en Fuentes Claras en alquiler vacacional y larga temporada con fotos y opiniones..