Hotel Campoamor
SELECT DISTINCT(t1.oferta_id) FROM ofertas as t1, ofertas_restricciones as t2 WHERE t1.interna = 0 AND t1.oferta_id = t2.oferta_id AND t1.alojamiento_id = '6268' AND t2.f_fin>='2017-08-18' AND t2.f_inicio <= '2017-12-16' AND t1.tipo_oferta_id <> '7' ORDER BY t1.prioridad
Hotel Campoamor
Offer: 11% discount from 12/05/2016 to 31/12/2017
11% discount. Offer from reservation 12/05/2016 to 31/12/2017. Minimum Stay 3 night ...
Hotel Campoamor
Offer: Special Offer from 24/08/2016 to 31/12/2017
Special Offer. Offer from reservation 24/08/2016 to 31/12/2017 ...
Hotel Campoamor
Offer: Special Offer from 24/08/2016 to 31/12/2017
Special Offer. Offer from reservation 24/08/2016 to 31/12/2017. Minimum Stay 2 night ...
Hotel Campoamor
Offer Non Refundable - 10% discount from 12/05/2016 to 31/12/2017
Non Refundable - 10% discount. Offer from reservation 12/05/2016 to 31/12/2017 ...
Hotel Campoamor
Offer Non Refundable - 5% discount from 01/01/2017 to 31/12/2017
Non Refundable - 5% discount. Offer from reservation 01/01/2017 to 31/12/2017 ...
Hotel Campoamor
Offer Last Minute - 20% discount
Last Minute - 20% discount ...
