select 
  h.id,
  h.name,
  h.address,
  h.city,
  count(hv.hotel_id),
  h.created_at,
  h.updated_at
from hotels h
left join hotel_videos hv on h.id = hv.hotel_id
where provider != 'AIRBNB' 
  and h.deleted_at is null 
  and city = $1 
  and hv.url is not null
  and name ilike '%$2%'
group by h.id

select 
  h.id,
  h.name,
  h.address,
  h.city,
  count(hv.hotel_id),
  h.created_at,
  h.updated_at
from hotels h
left join hotel_videos hv on h.id = hv.hotel_id
where provider != 'AIRBNB' 
  and h.deleted_at is null 
  and city = $1 
  and hv.url is not null
  and name ilike '%$2%'
group by h.id