No manufacturers associated with your login.

select mfr_name, mfr_id from tblManufacturers with (nolock) where mfr_id in () order by mfr_name

No manufacturers associated with your login.

select mfr_name, mfr_id from tblManufacturers where mfr_id = order by mfr_name --->

No manufacturers associated with your login.

select distinct category from tbl_BCRM_UserItemFavorites with (nolock) where fspro_userid = and nullif(category,'') is not null order by category