select 
  unit.*, unit.id as bedrooms_data, 
    unit.id as beds_data, 
    unit.id as bathrooms_data, 
    unit.id as living_space_square_data, 
    unit.id as guests_privacy_data, 
    unit.id as floor_data, 
    unit.id as elevator_data, 
    unit.id as outdoor_type_data, 
    unit.id as parking_data, 
    unit.id as ical_link_data, 
    unit_availability_date.booking_date as booking_date, 
    unit_availability_date.start_date as start_date, 
    unit_availability_date.end_date as end_date, 
    agency.name as agency_name 
from unit 
left join hotel on hotel.id = unit.hotel_id 
left join agency on agency.id = hotel.agency_id 
right join unit_availability_date on unit_availability_date.unit_id = unit.id
inner join unit_setting_value as usv on usv.unit_id = unit.id 
where usv.build_setting_id IN (15,23,16,19,17,35,36,21,37,2) and unit.id IN (
    select unit.id 
    from unit 
    inner join unit_availability_date on unit_availability_date.unit_id = unit.id 
    where ((booking_date = '2017-12-25' AND status_id = '1') OR (start_date = '2017-12-25' AND status_id = '2') OR (end_date = '2017-12-25' AND status_id = '2')) 
    group by unit.id
) AND booking_date = '2017-12-25' and unit.id IN (
    select unit.id 
    from unit 
    inner join unit_availability_date on unit_availability_date.unit_id = unit.id 
    where (booking_date >= '2017-12-25' AND booking_date <= '2017-12-31')
    group by unit.id 
  having SUM(unit_availability_date.status_id = 1) = COUNT(*)
) and unit.deleted_at is null 
group by unit.id
limit 50 offset 0