select DISTINCT weeks.week_id,weeks.week_name,weeks.start_date,weeks.end_date from weeks inner join apartment_rate_weeks as arw on weeks.week_id=arw.week_id where weeks.isdeleted = 0 AND start_date >= '2018-05-24 18:12:50' and category_id='14' and category_period_id ='0' group by week_id

14

SELECCIONA SEMANA

PAÍS DESDE EL QUE VUELAS

AEROPUERTO DE ORIGEN

POR FAVOR, SELECCIONA EL NÚMERO DE PERSONAS

(NÚMERO MÁXIMO DE PLAZAS PARA RESERVAR EN EL VUELO : 9)

ROOMS

ADULTOS

All the flights and flight-inclusive holidays on this website are financially protected by the ATOL scheme. When you pay you will be supplied with an ATOL Certificate.Please ask for it and check to ensure that everything you booked (flights, hotels and other services) is listed on it. Please see our booking conditions for further information or for more information about financial protection and the ATOL Certificate go to: www.atol.org.uk/ATOLCertificate