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 >= '2017-10-16 23:05:48' and category_id='37' and category_period_id ='7' group by week_id
37

PLEASE SELECT OCCUPANCY

(Maximum flight booking size 9)

ROOMS
Adults