News

SELECT DISTINCT(t1.oferta_id) as oferta_id, t1.alojamiento_id FROM ofertas as t1, ofertas_restricciones as t3, alojamientos as t2 WHERE (t2.member_id=1216 OR t1.alojamiento_id IN (SELECT alojamientos_id FROM administradores_alojamientos WHERE members_id=1216)) AND t1.alojamiento_id = t2.id AND t1.oferta_id=t3.oferta_id AND t3.f_fin>'2017-01-25' ORDER BY descuento DESC
SELECT DISTINCT(t1.oferta_id) as oferta_id, t1.alojamiento_id FROM ofertas as t1, ofertas_restricciones as t3 WHERE t1.alojamiento_id = 1721 AND t1.oferta_id=t3.oferta_id AND t3.f_fin>'2017-01-25' ORDER BY descuento DESC

Showing 1 - 10

  1. 1

Showing 1 - 10

  1. 1

Hospedaje Romero. Calle Gran Vía, 64 | 28013 Madrid Tel: 59 915 76 61. Email: reservas@hospedajeromero.com

Social network

This website uses cookies to ensure you get the best experience on our website. Read the Cookies Policy. By clicking any link on this page you are giving your consent for us to set cookies.
Cookies Policy +