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

Sorry, no manufacturers associated with your login.