select count(*) 
from inquiry inq
inner join inquiry_batch bat
	on inq.inquiry_batch_id = bat.inquiry_batch_id
inner join inquiry_status stat
	on inq.inquiry_batch_id = stat.inquiry_batch_id
	and inq.inquiry_id = stat.inquiry_id
	and inq.current_status_id = stat.status_id
left join subscriber subs
	on subs.subscriber_nbr = inq.subscriber_nbr
inner join inquiry_batch_type [type]
	on [type].input_Type = bat.inquiry_batch_input_type
inner join inquiry_status_type s_type
	on s_type.inquiry_status_type = stat.inquiry_status_type
inner join user_assigned_data_concern usr_dc 
	on inq.data_concern_code = usr_dc.inquiry_data_concern_code
where stat.inquiry_status_type = 6 and stat.assignment_user_id is not null 
and usr_dc.[user_id] = @YourVariable 
and inq.country_wb_code IN (select usr_c.country_wb_code from user_assigned_country usr_c where usr_c.[user_id] = usr_dc.[user_id])