select count(mfgr_code) as counter, mfgr_code from _i_store_barcode itemTable (nolock) where itemTable.item_num in ( 'EDA50-HB-R', 'FLC9000-1001R', 'CRD-TC51-HC1SC-01', 'CT40-CB-CNV-1', '3PTY-PCLIP-241389', 'CRD-TC51-5SCHG-01', 'CRD-MC33-4SC4BC-01', 'HCH-9033-CHG', 'ST1002', '94ACC0249', 'WA1210-G2', 'CRD4001-411EES', 'CHR-GM40-BK', 'CHR-GM40-WH', 'PT063D-1G', 'SAC9000-4000R', 'STB3508-C0007R', 'VM1003VMCRADLE', 'CT50-EB-1-R' ) group by mfgr_code order by mfgr_code