SELECT DISTINCT m.manufacturerName cross_brand, ao.oemSearch, ao.oemnumber, (SELECT ps_sub.id FROM products.products_suppliers ps_sub WHERE ps_sub.product_id = p.id AND ps_sub.supplier_id IN (224,226,223,225,227) LIMIT 1) AS id FROM article a /*LEFT JOIN supplier s ON s.supplierId=a.supplierId*/ LEFT JOIN article_oem ao ON ao.articleNumber=a.articleNumber AND ao.supplierId=a.supplierId LEFT JOIN manufacturer m ON m.manufacturerId=ao.manufacturerId LEFT JOIN products.brands b ON b.title=m.manufacturerName LEFT JOIN products.products p ON p.article=ao.oemSearch AND p.brand_id=b.id WHERE ( a.articleSearch IN ('YD505776', 'YP505775', '4PK1063', '4PK668', '4PK773', '5PK1023', '5PK1030', '5PK1103', '5PK1123', '5PK1220', '5PK1250', '5PK1255', '5PK778', '6PK1065', '6PK1070', '6PK1070S1', '6PK1078', '6PK1088', '6PK1088S1', '6PK1138', '6PK1255', '6PK1540', '6PK1548', '6PK1555', '6PK1560', '6PK1565', '6PK1600', '6PK1605', '6PK1640', '6PK1655', '6PK1835', '6PK1840', '6PK1880', '6PK2245', '6PK2253', '6PK700', 'YP100025', 'YP1000251', 'YP147024', 'YP300512', 'YP300554', 'YP321660', 'YP702417', 'YS137019') AND a.supplierId=4924) OR ( a.articleSearch IN ('6PK1070', '6PK1080', '5PK1025', '5PK1120', '6PK1075', '6PK1085', '6PK1555', '6PK1560', '6PK730') AND a.supplierId=454) OR ( a.articleSearch IN ('DC9602', 'DC0100', '6PK1080', '6PK1555', '5PK1030', '5PK1125', '6PK1070', '6PK1075', '6PK1084', '6PK1538', '6PK1548', '6PK1560', '6PK1564', 'DC2201', 'DC2322', 'DC91000', 'DC9107') AND a.supplierId=478) OR ( a.articleSearch IN ('1987947842', '1987947949', '1987945702', '1987945713', '1987945813', '1987946001', '1987946029', '1987946034', '1987946062', '1987946084', '1987947547', '1987947887', '1987947925', '1987947950', '1987948428', 'F000KR9391') AND a.supplierId=30) OR ( a.articleSearch IN ('BSG90615050', 'BSG90615052') AND a.supplierId=4455) OR ( a.articleSearch IN ('6091', '1600', '1690', '1696', '17700', '17800', '19639', '27300', '34100', '500006', '500112', '500223', '500251', '500251SP', '500524', '9400') AND a.supplierId=4679) OR ( a.articleSearch IN ('APV2511', '6PK1080', '6PK1550S', '5PK1025', '5PK1030', '5PK1100', '5PK1125', '5PK1220', '5PK1250', '5PK1450', '6PK1065', '6PK1069', '6PK1070', '6PK1076', '6PK1080DT', '6PK1080HD', '6PK1082', '6PK1085', '6PK1087', '6PK1140EE', '6PK1545', '6PK1555', '6PK1555S', '6PK1558', '6PK1565', '6PK698', '6PK730', 'APV2217', 'APV2297', 'APV2319', 'APV2490', 'APV2517', 'APV2562', 'APV2775', 'APV2959', 'APV3003', 'APV3029', '5PK1450E') AND a.supplierId=42) OR ( a.articleSearch IN ('0187ZZE150', '2787C70', '0488NA8W', '2187CB4KIT', '881286L1555') AND a.supplierId=4674) OR ( a.articleSearch IN ('102297', '30621', '104258', '14377', '19871', '21628', '28846', '28852', '28854', '28918', '28919', '28920', '28951', '28952', '28953', '31359', '37531', '37533', '37535', '38182', '38421', '38451', '39799', '39800', '40308', '45147') AND a.supplierId=101) OR ( a.articleSearch IN ('R54166', 'R34145') AND a.supplierId=271) OR ( a.articleSearch IN ('T38427', 'T36248', 'K016PK1550XS', 'K056PK1078', '6PK1078', '6PK1550XS', '5PK1023', '5PK1030', '5PK1103', '5PK1123', '5PK1220', '5PK1255', '5PK1453', '6PK1070', '6PK1080HD', '6PK1080XS', '6PK1088', '6PK1140SF', '6PK1255', '6PK1548', '6PK1555', '6PK1560', '6PK1565', '6PK700', '6PK730', 'T36249', 'T36430', 'T38176', 'T38190', 'T38323', 'T39024', 'T39026', 'T39246', 'T39282') AND a.supplierId=6665) OR ( a.articleSearch IN ('931263', '931272', '931253', '931334', '931480', '931874', '932116', '932337', '932392', '932424', '932053') AND a.supplierId=4862) OR ( a.articleSearch IN ('534016410', '532046810', '529000210', '529000310', '529003210', '529005310', '529005330', '529006010', '529007110', '529008410', '529009810', '529010310', '529010910', '529014110', '529014910', '529016310', '529019810', '529019910', '529023510', '529023910', '529024010', '529025710', '529027710', '529028910', '529029010', '529032710', '529032810', '529034410', '529037210', '529037610', '529037710', '529042010', '529046610', '529046620', '529046710', '529046720', '529046920', '529047510', '529047520', '529048010', '529048020', '529049610', '529051510', '529051520', '529052120', '531076010', '532044510', '532060010', '534010310', '534013730', '534030910', '534031910', '534040910', '537001310', '537001410', '537005210', '537009310', '537011810', '537013410', '537013910', '537019010', '537019410', '537025410', 'FB5PK1023', 'FB5PK1030', 'FB5PK1100', 'FB5PK1125', 'FB5PK1219', 'FB5PK1255', 'FB6PK1070', 'FB6PK1078', 'FB6PK1084', 'FB6PK1255', 'FB6PK1540', 'FB6PK1548', 'FB6PK1555', 'FB6PK1560', 'FB6PK1565', 'FB6PK730', 'FB6XPK1080', 'FB6XPK1550', '529000610', '532043610', '532050810', '537013810') AND a.supplierId=204) OR ( a.articleSearch IN ('PT3148', 'PB5208', 'PB7153', '6PK1078', '6PK1555', '6PK1070', '6PK1088', '6PK1548', '6PK1550', '6PK1560', 'PB5007', 'PB5129', 'PB5204', 'PB5241', 'PB5242', 'PB5290', 'PB5293', 'PB7201', 'PK5019', 'PT3119', 'PT3204', 'PT3210', 'PT3214', 'PT3246', 'PT3338') AND a.supplierId=4600) OR ( a.articleSearch IN ('1009031101', '0500061080', '0500061555', '0500051100', '0500051125', '0500051220', '0500051250', '0500051255', '0500060698', '0500060725', '0500061065', '0500061070', '0500061075', '0500061084', '0500061540', '0500061548', '0500061560', '0500061565', '1140090000', '2140090000') AND a.supplierId=144) OR ( a.articleSearch IN ('AG00302', 'AG03147', 'AG03048', '6PK1070', '6PK1080', '6PK1555', '6PK1560', 'AD15015', 'AD15044', 'AD15073', 'AD15077', 'AD15086', 'AD15092', 'AD15118', 'AD15172', 'AD15177', 'AD15201', 'AD15218', 'AD15221', 'AD15320', 'AD15366', 'AD15381', 'AD15450', 'AD15516', 'AD15539', 'AG00001', 'AG00008', 'AG00036', 'AG00180', 'AG03016', 'AG03153', 'AG03169', 'AG03336', 'AG03419') AND a.supplierId=6495) OR ( a.articleSearch IN ('6PK1080', '6PK1555', '5PK1020', '5PK1030', '5PK1076', '5PK1080', '5PK1085', '5PK1100', '5PK1110', '5PK1120', '5PK1135', '5PK1220', '5PK1230', '5PK1250', '5PK1255', '5PK1450', '5PK775', '5PK850', '6PK1063', '6PK1072', '6PK1094', '6PK1140', '6PK1255', '6PK1540', '6PK1545', '6PK1560', '6PK1562', '6PK1565', '6PK1600', '6PK1605', '6PK1655', '6PK1660', '6PK1835', '6PK1840', '6PK700', '6PK730', '6PK735', '6PK915') AND a.supplierId=4994) OR ( a.articleSearch IN ('0N1534S', '0N1529', '0N1529S', '0N1534', '0N1555', '0N1555S', '0N1709', '0N1709S1', '0N1709S2', '0N1738', '0N1979', '0N1979S', '0N2026', '0N2026S', '0N2198', '0N2198S', '0N2329', '0N2364') AND a.supplierId=129) OR ( a.articleSearch IN ('PT31058', 'PT31058B', 'PT31008', '6PK1080', '6PK1555', '5PK1100', '5PK1125', '5PK1219', '6PK1063', '6PK1070', '6PK1538', '6PK1550', '6PK1558', '6PK1560', '6PK1563', '6PK700', 'PT34110B1', 'PT34110B2', 'PT36240', 'PT36240B', 'PT52182', 'PT52196') AND a.supplierId=4558) OR ( a.articleSearch IN ('1626038', '1626027', '1626083', '1626194', '5PK1020', '5PK1030', '5PK1100', '5PK1120', '5PK1220', '5PK1253', '5PK1255', '6PK1072', '6PK1080', '6PK1094', '6PK1545', '6PK1555', '6PK1560', '6PK1564', '6PK698', '6PK730') AND a.supplierId=260) OR ( a.articleSearch IN ('VKM31058', 'VKM31008', 'VKMA31148', 'VKMV6PK1555', 'VKM34110', 'VKM36222', 'VKM36240', 'VKM38602', 'VKM61087', 'VKM65061', 'VKMA31012', 'VKMA31058', 'VKMA31083', 'VKMA31084', 'VKMA31098', 'VKMA31127', 'VKMA31147', 'VKMA31202', 'VKMA31207', 'VKMA31215', 'VKMA31216', 'VKMA33003', 'VKMA33012', 'VKMA33026', 'VKMA33101', 'VKMA33302', 'VKMA33308', 'VKMA34110', 'VKMA34215', 'VKMA36069', 'VKMA36222', 'VKMA36224', 'VKMA36226', 'VKMA36228', 'VKMA36230', 'VKMA36234', 'VKMA38202', 'VKMA38241', 'VKMA38242', 'VKMA38261', 'VKMA38265', 'VKMA64141', 'VKMA65038', 'VKMA65112', 'VKMAF31098', 'VKMAF36069', 'VKMV5PK1020', 'VKMV5PK1030', 'VKMV5PK1100', 'VKMV5PK1125', 'VKMV5PK1253', 'VKMV6PK1067', 'VKMV6PK1068', 'VKMV6PK1069', 'VKMV6PK1070', 'VKMV6PK1072', 'VKMV6PK1076', 'VKMV6PK1078', 'VKMV6PK1079', 'VKMV6PK1080', 'VKMV6PK1084', 'VKMV6PK1140', 'VKMV6PK1257', 'VKMV6PK1545', 'VKMV6PK1548', 'VKMV6PK1550', 'VKMV6PK1558', 'VKMV6PK1560', 'VKMV6PK1562', 'VKMV6PK1564', 'VKMV6PK698', 'VKMV6PK730', 'VKMV6PK733', 'VKMV6SK842') AND a.supplierId=50) OR ( a.articleSearch IN ('GA35724', 'GA35717', 'CA5PK1020', 'CA5PK1030', 'CA5PK1100', 'CA5PK1125', 'CA5PK1220', 'CA5PK1253', 'CA6PK1065', 'CA6PK1072', 'CA6PK1076', 'CA6PK1080', 'CA6PK1087', 'CA6PK1545', 'CA6PK1555', 'CA6PK1560', 'CA6PK1564', 'CA6PK1605', 'CA6PK698', 'CA6PK730', 'GA35264', 'GA35894', 'GA36531', 'GA36541', 'GA36907', 'GA37308', 'KA85700', 'KA85904', 'KA85905', 'KA85919', 'KA85928', 'KA85938', 'KA86603', 'KA86606', 'KA86615', 'GA36535') AND a.supplierId=110) OR ( a.articleSearch IN ('0340282SX', '0340470SX', '0340632SX', '0340114SX', '0340475SX', '0340562SX', '0340694SX', '0340951SX', '0341002SX', '0601065SX', '0601069SX', '0601076SX', '0601080SX', '0601082SX', '0601538SX', '0601545SX', '0601555SX', '0601558SX', '0601565SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('0719207', '0719177', '0719146', '0719148', '0719167', '0719211', '0719248', '0819066', '0819067', '0819202') AND a.supplierId=209) OR ( a.articleSearch IN ('19030359401', '11450585601', '11451807801', '21450593301', '91450860301', '91450860901', '99030860501', '99031766301', '99031766401') AND a.supplierId=4346) OR ( a.articleSearch IN ('KR6PK1555', 'KR6PK1070', 'KR6PK1075', 'KR6PK1080', 'KR6PK1538', 'KR6PK1548', 'KR6PK1560', 'SR1025', 'SR1316', 'SR1446', 'SR1536', 'SR1692', 'SR1905', 'SR1906', 'SR1917') AND a.supplierId=4894) OR ( a.articleSearch IN ('6PK1080', '6PK1555', '5PK1020', '5PK1030', '5PK1100', '5PK1125', '5PK1219', '5PK1255', '6PK1065', '6PK1070', '6PK1075', '6PK1084', '6PK1090', '6PK1140ELAST', '6PK1256', '6PK1538', '6PK1548', '6PK1560', '6PK1564', '6PK698', '6PK730', 'V85524', 'V85576') AND a.supplierId=6513) OR ( a.articleSearch IN ('13718', '13748') AND a.supplierId=4598) OR ( a.articleSearch IN ('19347456', '19347457') AND a.supplierId=6307) OR ( a.articleSearch IN ('A530202', 'A700665') AND a.supplierId=4364) OR (a.articleSearch='54765' AND a.supplierId=6558) OR ( a.articleSearch IN ('1570201', '1570270', '1570356', '1570368', '1570432', '1570468', '1570508') AND a.supplierId=317) OR ( a.articleSearch IN ('1125PK1023', '1126PK1070', '1126PK1075', '1126PK1078', '1126PK1080', '1126PK1555', '1126PK1560', '1126PK1563', '12802210', '12809903', '12809916', '9600080') AND a.supplierId=257) OR ( a.articleSearch IN ('MTBP019', 'TYBP012') AND a.supplierId=4631) OR (a.articleSearch='79897' AND a.supplierId=4495) OR ( a.articleSearch IN ('5PK1023', '5PK1030', '5PK1100', '5PK1125', '5PK1255', '601832', '651771', '654094', '654098', '654573', '654578', '654811', '654830', '655087', '6PK1084', '6PK1555', '6PK1560', '6PK730') AND a.supplierId=300) OR ( a.articleSearch IN ('RT1220', 'RT1237', 'RT1267', 'RT1406', 'RT1601', 'RT1870') AND a.supplierId=4737) OR ( a.articleSearch IN ('0380133', '0380139', '0380329', '0380422', '0380474', '0380545', '0380971', '0381007', '0381015', '0381128', '0381498', '0381507', '0382019', '060001', '060008', '060010', '060013', '060018', '060020', '060043', '060044', '060057', '060058', '060064') AND a.supplierId=4651) OR ( a.articleSearch IN ('160025210', '210156110', '210156210') AND a.supplierId=323) OR ( a.articleSearch IN ('A02204', 'A03248', 'A03304', 'A04600', 'A05760', 'A05916', 'A06900', 'A07652', 'A07744', 'A08504', 'A08608', 'A08828', 'A09980', 'AA1041', 'A03504', 'A06916') AND a.supplierId=4464) OR ( a.articleSearch IN ('0011016543', '0011023757', '0011023842', '0011026139', '0011028065', '0011028189', '0011028231') AND a.supplierId=4995) OR ( a.articleSearch IN ('AD06R1080', 'AD06R1546', 'AD06R1555', 'AD06R1560', 'ADA109607', 'ADT396512') AND a.supplierId=350) OR ( a.articleSearch IN ('BMS037', 'BMS039', 'BMS275', 'BMS277', 'BMS437', 'BMS442') AND a.supplierId=6888) OR ( a.articleSearch IN ('KCA0020', 'POA3554', 'TOA3212', 'TOA3524', 'TOA3745', 'TOA3772', 'TOA3865', 'TOA3969', 'TOA4412', 'TOA5467', 'TOA5569') AND a.supplierId=195) OR ( a.articleSearch IN ('E22011BTA', 'E22023BTA', 'E25008BTA', 'E2A5775BTA', 'E2G5274ABTA', 'E2G5274BBTA', 'E2V0001BTA', 'E2V6533BTA', 'E2W5776BTA', 'E3V0001BTA', 'E3W0023BTA') AND a.supplierId=4693) OR ( a.articleSearch IN ('605180', '608270', '803650', '808040', '816390', '817060', '821450', 'SZK02080', 'SZK03830', 'SZK04490', 'SZK04560') AND a.supplierId=6549) OR ( a.articleSearch IN ('20663', '30065', '563R8', '87960', '88386', '88548', '89124', '89216', '87621') AND a.supplierId=4463) OR ( a.articleSearch IN ('461357', '752380') AND a.supplierId=405) OR ( a.articleSearch IN ('5PK1025', '5PK1035', '5PK1253', '6PK1067', '6PK1069', '6PK1076', '6PK1550', '6PK730') AND a.supplierId=6411) OR ( a.articleSearch IN ('500938', '501302', '502637', '502669', '504209') AND a.supplierId=6263) OR ( a.articleSearch IN ('MR51025', 'MR51100', 'MR51125', 'MR51220', 'MR51250', 'MR51450', 'MR60700', 'MR60730', 'MR61065', 'MR61069', 'MR61076', 'MR61080', 'MR61081', 'MR61085', 'MR61087', 'MR61550', 'MR61558', 'MR61560') AND a.supplierId=89) OR ( a.articleSearch IN ('5PK1125', '5PK1220', '5PK1255', '6PK1070', '6PK1075', '6PK1080', '6PK1090', '6PK1255', '6PK1538', '6PK1548', '6PK1555', '6PK1565', '6PK730', 'P200008', 'P212001', 'P216009', 'P230002', 'P300008') AND a.supplierId=186) OR ( a.articleSearch IN ('031425', '03433', '03433TN', '03535') AND a.supplierId=4738) OR ( a.articleSearch IN ('A3058', 'A7007') AND a.supplierId=4396) OR ( a.articleSearch IN ('1112072', '1112072SP', '1112073', '1112080', '1215405', '1215415', '631014', '631502', '631506', '631512') AND a.supplierId=355) OR ( a.articleSearch IN ('DT31008', 'DT31058', 'DT31310', 'DT34110', 'DT36240', 'DT38602', 'DT61087') AND a.supplierId=4881) OR (a.articleSearch='EBT1933' AND a.supplierId=6364) OR ( a.articleSearch IN ('1606347080', '1606347180', '1606347380', '1606347580', '1606348180', '1606348280', '1606348780', '1606350680', '1606350780', '1606350880', '1606352880', '1606352980', '1609316280', '1609318380', '1609320280', '1609320480', '1611129480', '1612058880', '1612059580', '1612060080', '1612060880', '1612061380', '1612064380', '1612163080', '1612551780', '1616161780', '1616161980', '1631638580') AND a.supplierId=4391) OR (a.articleSearch='T1092' AND a.supplierId=267) OR ( a.articleSearch IN ('10339', '15115') AND a.supplierId=4834) OR (a.articleSearch='FT44522' AND a.supplierId=4938) OR ( a.articleSearch IN ('BP5PK1453', 'BP600', 'BP6PK1555') AND a.supplierId=4741) OR ( a.articleSearch IN ('5PK1023', '5PK1030', '5PK1103', '5PK1123', '5PK1220', '5PK1255', '5PK1453', '6PK0700', '6PK0730', '6PK1070', '6PK1078', '6PK1088', '6PK1140ST', '6PK1548', '6PK1550V', '6PK1555', '6PK1560', '6PK1565', 'FA20947', 'FA25139', 'FU99118', 'FU99602') AND a.supplierId=236) OR (a.articleSearch='14145014S' AND a.supplierId=4727) OR ( a.articleSearch IN ('796PK1560', '791174') AND a.supplierId=181) OR ( a.articleSearch IN ('296PK1538', '296PK1555', '296PK1560', '290169') AND a.supplierId=178) OR ( a.articleSearch IN ('J1051220', 'J1051250', 'J1051453', 'J1061000', 'J1061075', 'J1061255', 'J1061555', 'J1061563', 'J1065001', 'J1146014') AND a.supplierId=72) OR ( a.articleSearch IN ('1020K5', '1030K5', '1035K5', '1070K6', '1072K6', '1080K5', '1080K6', '1080K6TK', '1094K6', '1100K5', '1120K5', '1140SK6', '1220K5', '1253K5', '1255K5', '1545K6', '1550K6', '1555K6', '1560K6', '1564K6', '698K6', '730K6', 'T0246', 'T0262', 'T0439', 'T0522', 'T0550', 'T0553', 'T0563', '1017K5', '1557K6') AND a.supplierId=239) OR ( a.articleSearch IN ('14007190', '14013090', '14017082', '14017084', '14020102') AND a.supplierId=6359) OR ( a.articleSearch IN ('100827', '150766', '153089', '153093', '153568', '153573', '153806', '153825', '154082', '295PK1023', '295PK1030', '295PK1100', '295PK1125', '295PK1255', '296PK1084', '296PK1555', '296PK1560', '296PK730') AND a.supplierId=262) OR ( a.articleSearch IN ('DV5PK1023', 'DV6PK1070', 'DV6PK1075', 'DV6PK1078', 'DV6PK1080', 'DV6PK1555', 'DV6PK1560', 'DV6PK1563', 'TS210', 'TS903', 'TS916', 'TV080') AND a.supplierId=156) OR ( a.articleSearch IN ('128210', '128903', '128916', '5PK1023', '6PK1070', '6PK1075', '6PK1078', '6PK1080', '6PK1555', '6PK1560', '6PK1563', '96080') AND a.supplierId=481) OR ( a.articleSearch IN ('1118101400', '1118104100', '1118104200', '1118104300', '1118105200', '1118110600', '1118305500', '1218102600', '1218102800', '1418101900', '1418103200', '3318301100', '4118102200', '4118102500', '4818101300', '4818101400', '4918200400') AND a.supplierId=268) OR ( a.articleSearch IN ('R0073', 'R0160', 'R0223', 'R0224', 'R0329', 'R0360') AND a.supplierId=185) OR ( a.articleSearch IN ('DIP5509', 'DMV1037', 'DMV5509', 'DMV8011', 'DMV9106', 'DTP9025') AND a.supplierId=201) OR ( a.articleSearch IN ('5PK1020', '5PK1025', '5PK1030', '5PK1100', '5PK1125', '5PK1220', '5PK1250', '6PK1065', '6PK1067', '6PK1070', '6PK1075', '6PK1080', '6PK1085', '6PK1140', '6PK1545', '6PK1553', '6PK1558', '6PK1563', '6PK1565', '6PK700', '6PK730', 'RX31008', 'RX31058', 'RX34110') AND a.supplierId=387) OR ( a.articleSearch IN ('FI14400', 'FI14790', 'FI19130', 'FI21260', 'FI22070', 'FI24950', 'FI25410', 'FI5510', 'FI17290') AND a.supplierId=4462) OR ( a.articleSearch IN ('1220075', '1221302', '1222026', '1222032', '1223883', '1225355', '1226445', '1226450', '1226512', '1228640') AND a.supplierId=4546) OR (a.articleSearch='95207308' AND a.supplierId=4712) OR ( a.articleSearch IN ('1714001', '1715101', '1717301', '1719101', '1719201', '1874701', '2703301', '17140', '17151', '17173', '17191', '17192', '18747', '27033') AND a.supplierId=35) OR ( a.articleSearch IN ('5PK1450L', '6PK1063L', '6PK1070L', '6PK1075L', '6PK1080L', '6PK1080XL', '6PK1085L', '6PK1537L', '6PK1550L', '6PK1550XL', '6PK1555L', '6PK1560L', '6PK1563L', 'LA0151', 'LA0293', 'LA0409', 'LA0423', 'LA0435', 'LA0478', 'LA0636', 'LA0702', 'LAK0043', 'LAK0067', 'LAK0068', 'LAK0069', 'LAK0074', 'LAK0081', 'LAK0102', 'LAK0150', 'LAK0161') AND a.supplierId=4501) OR ( a.articleSearch IN ('331316170338', '331316170649', '331316170650', '331316170651', '331316171070', '331316171228', '340511001030', '340511001100', '340511001125', '340511001219', '340511001255', '340611000698', '340611000730', '340611001065', '340611001070', '340611001075', '340611001080', '340611001538', '340611001548', '340611001555', '340611001560') AND a.supplierId=4723) OR ( a.articleSearch IN ('23964', '24861', '251020', '251030', '251220', '260730', '261075', '261080', '261084', '261140E', '261540', '261548', '261555', '261560', '261564') AND a.supplierId=133) OR ( a.articleSearch IN ('5PK1125PCSMS', '5PK1130PCSMS', '5PK1219PCSMS', '5PK1250PCSMS', '6PK1065PCSMS', '6PK1070PCSMS', '6PK1075PCSMS', '6PK1080PCSMS', '6PK1538PCSMS', '6PK1545PCSMS', '6PK1548PCSMS', '6PK1550PCSMS', '6PK1555PCSMS', '6PK1560PCSMS', '6PK698PCSMS', 'N31058PCSMS', 'R31008PCSMS', 'R31058PCSMS') AND a.supplierId=358) OR ( a.articleSearch IN ('6PK1070', '6PK1075', '6PK1080', '6PK1560', 'MIP1012') AND a.supplierId=6270) OR ( a.articleSearch IN ('540537', '540553', '540822', '540830', '541404') AND a.supplierId=403) OR ( a.articleSearch IN ('MRB551450', 'MRB560700', 'MRB561070', 'MRB561075', 'MRB561080', 'MRB561087', 'MRB561555', 'MRB561560', 'MRP2B03', 'MTP4210', 'MTP4903', 'MTP4916') AND a.supplierId=4773) OR ( a.articleSearch IN ('05424', '49308') AND a.supplierId=4664) OR ( a.articleSearch IN ('1020K5', '5PK1025', '5PK1125', '5PK1220', '5PK1250', '5PK1450', '6PK1069', '6PK1076', '6PK1080', '6PK1085', '6PK1087', '6PK1545', '6PK1555', '6PK1558', '6PK1565', '6PK730') AND a.supplierId=94) OR ( a.articleSearch IN ('SMAMP02049', 'SMAMP02376', 'SMAMP03353', 'SMAMP04349', 'SMAMP04432', 'SMAMP06329', 'SMAMV4PK668', 'SMAMV5PK1020', 'SMAMV5PK1023', 'SMAMV5PK1025', 'SMAMV5PK1030', 'SMAMV5PK1100', 'SMAMV5PK1103', 'SMAMV5PK1219', 'SMAMV5PK1220', 'SMAMV5PK1250', 'SMAMV5PK1255', 'SMAMV5PK778', 'SMAMV6PK1070', 'SMAMV6PK1075', 'SMAMV6PK1078', 'SMAMV6PK1080', 'SMAMV6PK1084', 'SMAMV6PK1088', 'SMAMV6PK1138', 'SMAMV6PK1255', 'SMAMV6PK1538', 'SMAMV6PK1540', 'SMAMV6PK1548', 'SMAMV6PK1550', 'SMAMV6PK1555', 'SMAMV6PK1560', 'SMAMV6PK1564', 'SMAMV6PK1565', 'SMAMV6PK1600', 'SMAMV6PK1835', 'SMAMV6PK1840', 'SMAMV6PK1880', 'SMAMV6PK2245', 'SMAMV6PK2253', 'SMAMV6PK698', 'SMAMV6PK730') AND a.supplierId=6279) OR ( a.articleSearch IN ('501251123', '501251453', '501261070', '501261078', '501261088', '501261255', '501261548', '501261550', '501261555', '501261560', '5PK1123', '5PK1453', '6PK1070', '6PK1078', '6PK1088', '6PK1255', '6PK1548', '6PK1550', '6PK1555', '6PK1560') AND a.supplierId=6376) OR ( a.articleSearch IN ('VFB337', 'VFB362', 'VFB363', 'VFB371', 'VFB398', 'VFB470', 'VFB483', 'VFB528', 'VFB543', 'VFB556') AND a.supplierId=4564) OR ( a.articleSearch IN ('AST1849', 'AST1855', 'AST2045', 'AST2138', 'AST2190', 'AST2261', 'AST2687', 'AST2723', 'AST2731', 'AST2844', 'AST3214', 'AST3223', 'AST3735', 'ASTA0001', 'ASTA0008', 'ASTA0010', 'ASTA0013', 'ASTA0018', 'ASTA0020', 'ASTA0043', 'ASTA0044', 'ASTA0057', 'ASTA0058', 'ASTA0064') AND a.supplierId=6874) OR (a.articleSearch='005373532E' AND a.supplierId=4535) OR ( a.articleSearch IN ('J1061070', 'N1061555', 'N1061560') AND a.supplierId=248) OR ( a.articleSearch IN ('D111O05', 'D111O13', 'M111I15', 'T110A19') AND a.supplierId=440) OR ( a.articleSearch IN ('RNKAU008', 'RNKAU029', 'RNKCH011', 'RNKVV003', 'RNKVW001', 'RNKVW005', 'RNKVW014', 'RRKCH007') AND a.supplierId=6355) OR ( a.articleSearch IN ('2329762', '2329770', '2329830', '2329836', '2329881', '2329883', '2329915', '2329945', '2329993', '2330120', '2330190', '2330267', '2330287', '2330294', '2330322', '2330336') AND a.supplierId=4380) OR ( a.articleSearch IN ('ACT205200', 'ACT213000', 'ACT218100', 'PVB107006', 'PVB107606', 'PVB110005', 'PVB112505', 'PVB122005', 'PVB125506', 'PVB154506', 'PVB155806', 'PVB156506') AND a.supplierId=378) OR ( a.articleSearch IN ('3012UR', '3058SR', '3140SR', '3141SR', '5PK1025', '5PK1025SCC', '5PK1030', '5PK1030SCC', '5PK1125', '5PK1219', '5PK1219SCC', '5PK1255', '5PK1255SCC', '5PK1450', '6DPK1825KT1', '6DPK1841KT1', '6DPK1841KT2', '6PK1070', '6PK1070SCC', '6PK1078', '6PK1080TM', '6PK1090', '6PK1548', '6PK1555', '6PK1560', '6PK1560SCC', '6PK1565', '6PK1565SCC', '6PK698', '6PK730') AND a.supplierId=64) OR ( a.articleSearch IN ('05277', '07631', '09477', '10390', '10422', '10448', '10474', '15795', '23497', '25900', '28870') AND a.supplierId=4683) OR ( a.articleSearch IN ('PTA1000253', 'PTA1020144', 'PTA1020174', 'PTA1020207', 'PTA1020364') AND a.supplierId=6457) OR (a.articleSearch='08079200A' AND a.supplierId=63) OR ( a.articleSearch IN ('JAPDV5PK1023', 'JAPDV6PK1078', 'JAPDV6PK1563', 'JAPTS210', 'JAPTS916') AND a.supplierId=4652) OR ( a.articleSearch IN ('5PK1020', '5PK1030', '5PK1100', '5PK1125', '5PK1219', '5PK1225', '5PK1255', '6PK0698', '6PK0725', '6PK0730', '6PK1065', '6PK1070', '6PK1075', '6PK1080', '6PK1084', '6PK1090', '6PK1538', '6PK1548', '6PK1555', '6PK1560', '6PK1564', 'GA050', 'KGA2007', 'KGA2047', 'KGA2049', 'KGA3003', 'KGA3005', 'KGA3008', 'KGA3009', 'KGA3010', 'KGA3011', 'KGA3013', 'KGA5003') AND a.supplierId=4655) OR (a.articleSearch='10142376' AND a.supplierId=4686) OR ( a.articleSearch IN ('QF00100009', 'QF31P00050', 'QF31P00065', 'QF31P00083') AND a.supplierId=4339) OR ( a.articleSearch IN ('QBR61070', 'QBR61075', 'QBR61080', 'QBR61548', 'QBR61550', 'QBR61555', 'QBR61560', 'QBR61563', 'QTA1277', 'QTA1326', 'QTA1345', 'QTA1423', 'QTA1462', 'QTA1621', 'QTT1301', 'QBR61564', 'QTA1453') AND a.supplierId=57) OR ( a.articleSearch IN ('995PK1020', '995PK1025', '995PK1030', '995PK1100', '995PK1125', '995PK1220', '996PK1070', '996PK1075', '996PK1080', '996PK1090', '996PK1255', '996PK1256', '996PK1560', '996PK1564') AND a.supplierId=4869) OR ( a.articleSearch IN ('RKT1849', 'RKT1855', 'RKT2045', 'RKT2138', 'RKT2190', 'RKT2261', 'RKT2687', 'RKT2723', 'RKT2731', 'RKT2844', 'RKT3214', 'RKT3223', 'RKT3735', 'RKTA0001', 'RKTA0008', 'RKTA0010', 'RKTA0013', 'RKTA0018', 'RKTA0020', 'RKTA0043', 'RKTA0044', 'RKTA0057', 'RKTA0058', 'RKTA0064') AND a.supplierId=4330) OR ( a.articleSearch IN ('305P0032', '305P0033', '305P0034', '305P0038', '305P0056', '305P0057', '305P0072', '305P0073', '305P0195', '310T0129', '310T0191', '312D0013', '312D0037', '541V0005', '541V0010', '542R0036', '542R0047', '542R0049', '542R0057', '542R0086', '542R0133', '542R0134', '542R0142', '542R0326', '542R0388', '542R0413') AND a.supplierId=6358) OR ( a.articleSearch IN ('55093802', '5509384', '5509386', '55274', '5527480', '5547580', '5547581', '55545', '5554580', '55775', '55776', '5577680', '5577681', '5577682', '5598181', '5598980', '56533', '56544', '56987', '57205', '57346', '5734780', '58603', '5PK1125', '6PK0730', '6PK1070', '6PK1078', '6PK1538', '6PK1555', '6PK1564') AND a.supplierId=23) OR (a.articleSearch='203317' AND a.supplierId=4623) OR ( a.articleSearch IN ('V204681', 'V401641') AND a.supplierId=6377) OR ( a.articleSearch IN ('5R367', '5R385', '6R341', '6R370', '6R371', '6R409', '6R410', 'G016', 'V743') AND a.supplierId=225) OR ( a.articleSearch IN ('SK5PK1030', 'SK5PK1100', 'SK5PK1125', 'SK5PK1220', 'SK6PK1070', 'SK6PK1078', 'SK6PK1548', 'SK6PK1555', 'SK6PK1560', 'SKDG1080012', 'SKDG1080029', 'SKDG1080036', 'SKPB0090086', 'SKRBS1200035', 'SKRBS1200046', 'SKRBS1200048', 'SKRBS1200056', 'SKRBS1200085', 'SKRBS1200132', 'SKRBS1200133', 'SKRBS1200141', 'SKRBS1200248', 'SKRBS1200256', 'SKRBS1200279', 'SKRBS1200325', 'SKRBS1200387', 'SKRBS1200412', 'SKTP0600141', 'SKTP0600203', 'SKVB0590004', 'SKVB0590009') AND a.supplierId=6357) OR ( a.articleSearch IN ('T405424', 'T449308') AND a.supplierId=4667) OR ( a.articleSearch IN ('20928951', '20928952', '30102297', '30104258', '30928854', '30928918', '30928919', '30930621', '30937533', '30938451', '30940308', '30945147', '40938421', '50938182', '55030018', '55921628', '55931359', '60928852', '62939800', '64937531', '64937535', '70919871', '70939799', '81928953', '99928920') AND a.supplierId=151) OR ( a.articleSearch IN ('5KSY1020', '5KSY1030', '5KSY1100', '5KSY1125', '5KSY1219', '5KSY1255', '6DKSY1841K1', '6KSY1065', '6KSY1070', '6KSY1070K4', '6KSY1075', '6KSY1080', '6KSY1084', '6KSY1090', '6KSY1538', '6KSY1548', '6KSY1555', '6KSY1560', '6KSY1564', '6KSY698', '6KSY730', 'SY31076010', 'SY32046810', 'SY34016410', 'SY34030910') AND a.supplierId=6394) OR ( a.articleSearch IN ('100588', '100594', '109658', '109864', '110059', '110096', '206715', '300923', '304101', '722269', '723308', '723312') AND a.supplierId=301) OR ( a.articleSearch IN ('TA1425', 'TA1565', 'TA1566', 'TA1647', 'TA1755', 'TA1785', 'TA1875', 'TA2042', 'TA2129') AND a.supplierId=4732) OR ( a.articleSearch IN ('423999', '427163') AND a.supplierId=4970) OR ( a.articleSearch IN ('8640501023', '8640501030', '8640501103', '8640501123', '8640501220', '8640501255', '8640501453', '8640600700', '8640600730', '8640601070', '8640601078', '8640601088', '8640601255', '8640601548', '8640601555', '8640601560', '8640601565', '8641103010', '8641133010', '8641152020', '8641163016', '8641272005', '8641273004', '8641292015', '8641293021', '8641802004', '8641803001') AND a.supplierId=108) OR ( a.articleSearch IN ('038903315AE', '038903315AH', '06A903315E', '06F903315P', '11281427252', '11281748130', '11281748131', '11287549589', '30637141P') AND a.supplierId=4999) OR ( a.articleSearch IN ('V101815', 'V103418', 'V103705', 'V104614', 'V950164', 'V950286') AND a.supplierId=183) OR ( a.articleSearch IN ('WG1033873', 'WG1033877', 'WG1033885', 'WG1153015', 'WG1153016', 'WG1153017', 'WG1153044', 'WG1153079', 'WG1153080', 'WG1153081', 'WG1252584', 'WG1253007', 'WG1253097', 'WG1253349', 'WG1253382', 'WG1253403', 'WG1253483', 'WG1253491', 'WG1253499', 'WG1253538', 'WG1427958', 'WG1427959', 'WG1428712', 'WG1428713', 'WG1428799', 'WG1429080', 'WG1429113', 'WG1429143', 'WG1429296', 'WG1430420', 'WG1430525', 'WG1430617', 'WG1431990', 'WG1432787', 'WG1709993', 'WG1907027', 'WG1907028', 'WG1907029', 'WG1907066', 'WG1907067', 'WG1907068', 'WG1907069', 'WG1907505', 'WG1910453', 'WG1937874', 'WG1940792', 'WG1940794', 'WG1966504', 'WG1978442', 'WG1990876', 'WG2002456', 'WG2002458', 'WG2002463', 'WG2002464', 'WG2002466', 'WG2002467', 'WG2002468', 'WG2002469', 'WG2002601', 'WG2002603', 'WG2002604', 'WG2002605', 'WG2002606', 'WG2004464', 'WG2004538', 'WG2004559', 'WG2004652', 'WG2004672', 'WG2004678', 'WG2004722', 'WG2004846', 'WG2004925', 'WG2004960', 'WG2004986', 'WG2005067', 'WG2059033', 'WG2071381', 'WG2071382', 'WG2101376', 'WG2101377', 'WG2101380', 'WG2112146', 'WG2112147', 'WG2112295', 'WG2136842', 'WG2148686', 'WG2152011') AND a.supplierId=4832) OR ( a.articleSearch IN ('10513', '10780', '10812', '10814', '10816', '10818', '10819', '10823', '10829', '10854', '10855', '10865', '111149', '111293', '11565', '11750', '280971', '313181', '313595') AND a.supplierId=6347)An internal server error occurred.