select top #_maxItems# mfr_id, mfr_name from tblManufacturers with (nolock) where mfr_id in () and mfr_name like and ( ( mfr_name like ) and 1 = 1 ) order by mfr_name #_data#