SELECT DISTINCT(t1.oferta_id) FROM ofertas as t1, ofertas_restricciones as t2, alojamientos as t4 WHERE t1.interna = 0 AND t1.oferta_id = t2.oferta_id AND t1.alojamiento_id = t4.id AND t4.member_id = 420 AND t2.f_fin>='2018-04-18' AND t2.f_inicio <= '2019-12-31' AND t1.tipo_oferta_id <> '7'
Pensión Terminal
No Reembolsable
No Reembolsable ...
Feel At Home Malaga
No reembolsable
No reembolsable ...
