select count(mfgr_code) as counter, mfgr_code from _i_store_barcode itemTable (nolock) where itemTable.item_num in ( '1400-900005G', 'BTRY-MC30KAB02-03', 'BTRY-MC55EAB02-10H', 'BTRY-MC55EAB02-50H', 'BTRY-MC21EAB0E', '1400-900035G', 'WA3026', 'BTRY-NWTRS-33MA-02', 'BTRY-MC31KAB02-10', '318-052-031', '1400-202501G', 'BTRY-MC55EAB02', 'BTRY-MC7XEAB0H', 'BTRY-MC95IABA0', 'BTRY-MC3XKAB0E-50', 'BTRY-MC31KAB02-50', '99EX-BTSC-1', 'BAT-MOB00', 'BTRY-MC32-01-01', 'BTRY-MC7XEAB00', 'BTRY-LS42RAA0E-01', 'BTRY-MC31KAB02', 'BTRY-WT40IAB0E', '318-026-004', '318-055-002', 'BTRY-TC7X-46MAH-01', 'BTRY-MC40EAB0E-10R', 'RBP-QMBT2X-BK', 'BTRY-MCXX-3080-10R', 'BTRY-MC55EAB02-10', 'BTRY-MCXX-3080-01R', 'BTRY-MC40EAB0E-01R' ) group by mfgr_code order by mfgr_code