select count(mfgr_code) as counter, mfgr_code from _i_store_barcode itemTable (nolock) where itemTable.item_num in ( 'DS3678-HP3U4210SFW', 'NUSCAN 4100B', 'DS3678-ER2F003VZWW', 'CX3736-2388', 'CX3756-2408', 'LI4278-TRBU0100ZWR', 'LI4278-TRWU0100ZWR', '633809007149', 'GM4401-WH-910', 'PM9500-BK910-RTK10', 'GBT4500-HC-WLC', '633808920623', 'CX3357-1679', 'PM9500-DKHP910RK10', 'RS51B0-LESNWR', 'DS8178-SR7U210SPFW', 'DBT6400-BK', 'NUSCAN 5200TR', '8680I300-2', '8680I301-2', 'DS8178-SRSF007ZZWW', '1952GSR-2USB-9BF-N', 'ION-SG1-BCU-S', 'CX3391-1849', 'CX3406-1864', 'CX3419-1838', '1952GSR-2USB5BFEZN', 'MS912-KUBB00-TG', '1911IER-3USB-5-G', 'DS8178-DL7U2100PFW', 'DS8178-SR0F007ZZWW', 'DS8178-SR6U2100P2W', 'RS51B0-LBBHWR', 'RS51B0-LBDNWR', 'RS51B0-TEDNWR', '1952HHD-5USB-5BF-N', 'QBT2131-BK', 'QBT2131-BK-BTK2', 'QBT2101-BK-BTK+', '1952GSR-2-BF-N', 'PBT9300-ARRB', 'PM9300-DAR910RB', 'CX3760-2412', 'DS8178-HCMF00BVMWW', 'DS3678-DP2F003VZWW', 'DS8178-HCBU210MS5W', 'GM4500-BK-910K1', 'CX3402-1860', 'LI3678-SR0F003VZWW', 'RS51B0-TBSNWR', '178495', '1952GSR-2USB-5BF-N', '1902HHD-0USB-8FAP', 'CS4070-SR00004ZMWW', 'CX3359-1681', 'DS2278-SR00006ZZWW', 'DS2278-SR7U2100PRW', 'DS2278-SR7UMC00AZW', 'DS3678-SR0F003VZWW', 'CX3465-1933', 'DS3678-DP3U4212S1W', '1952HSR-5USB-9-N', 'GM4500-HC-910-WLC', 'RS60B0-SRSFWR', 'RS60B0-SRSNWR', 'CX3390-1848', 'PBT9100-RB', 'PM9100-DK910RB', 'PM9100-910RBK20', '8680I200-2', 'LI3678-ER3U4210S1W', 'NUSCAN 2500CR', 'NUSCAN 2500TB', 'NUSCAN 3500TB' ) group by mfgr_code order by mfgr_code