"select `user`.`id`, `vt`.`id` as `fff` from `user` left join `vendor_styles` on `user`.`id` = `vendor_styles`.`vendor_id` left join `vendor_days` on `user`.`id` = `vendor_days`.`vendor_id` inner join `vendor_timing` as `vt` on `vt`.`vendor_day_id` = `vendor_days`.`id` left join `favourites` on `user`.`id` = `favourites`.`vendor_id` where `style_id` in (?) and `flag` = ? and ('09:15:00' between vt.available_time and vt.available_end_time) is null and ('10:45:00' between bt.available_time and bt.available_end_time) is null group by `user`.`id`"