select `users`.*, `users_details`.`slug`, `users_details`.`languages`, `users_details`.`flags`, `users_details`.`experience`, `users_details`.`specialisation`, `dhwaniservice`.`price`, `dhwaniservice`.`astro_price`from`users` left join `users_details` on `users_details`.`user_id` = `users`.`id` inner join `dhwaniservice` on `users`.`id` = `dhwaniservice`.`astro_id` where `users_details`.`is_codhwanishopservice_disabled` = '1' and `user_type` = 'ASTROLOGER' and `dhwaniservice`.`name` = 332 and `users`.`status` = '1' and `users_details`.`user_id`in (46540, 70077, 3267, 345) order by `dhwaniservice`.`astro_price` desc
select count(*) as aggregate from`tbl_call_chat_request` where `expert_id` = 3267 and `request_status` = 5 and `tbl_call_chat_request`.`deleted_at` is null
select count(*) as aggregate from`tbl_call_chat_request` where `expert_id` = 345 and `request_status` = 5 and `tbl_call_chat_request`.`deleted_at` is null
select count(*) as aggregate from`tbl_call_chat_request` where `expert_id` = 70077 and `request_status` = 5 and `tbl_call_chat_request`.`deleted_at` is null
select count(*) as aggregate from`tbl_call_chat_request` where `expert_id` = 46540 and `request_status` = 5 and `tbl_call_chat_request`.`deleted_at` is null