SELECT DISTINCT 
    m.manufacturerName AS cross_brand, 
    ao.manufacturerId, 
    ao.oemSearch, 
    ao.oemnumber, 
    ps.id AS supplier_product_id,
    ps.supplier_id AS real_supplier_id
FROM article a 
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 
LEFT JOIN products.products_suppliers ps 
    ON ps.product_id = p.id 
   AND ps.supplier_id IN (224, 226, 223, 225, 227) 
WHERE (a.articleSearch='CCZ1126ABE' AND a.supplierId=4426) OR ( a.articleSearch IN ('200059', '200062', '200223', '200022', '200054') AND a.supplierId=206) OR (a.articleSearch='OPWHASTR' AND a.supplierId=4631) OR ( a.articleSearch IN ('150096510', '140023410', '110154010', '110154110', '110155910', '110185010', '110185110', '110186810', '140026410', '150033910', '150061510', '150082810', '150083010', '150087110', '150096610', '150097710', '150097810', '150101410', '150101510', '150108410', '150109110', '150114910') AND a.supplierId=323) OR ( a.articleSearch IN ('60001', '30001', '51585', '60176', '60182', '60183') AND a.supplierId=47) OR ( a.articleSearch IN ('BSG65551002', 'BSG65125013', 'BSG65325006', 'BSG65600001', 'BSG65600003', 'BSG65600004', 'BSG65600012', 'BSG65836005', 'BSG65837007', 'BSG65840019', 'BSG65840020', 'BSG65840023', 'BSG65840024', 'BSG65840029') AND a.supplierId=4455) OR ( a.articleSearch IN ('WS2519', 'WS2697', 'CS0245', 'CS0321', 'CS0341', 'CS0424', 'LS140028', 'LS140036', 'LS140100', 'LS140308', 'LS140524', 'LS140534', 'LS140597', 'TH651792J', 'TP0006', 'TP0026') AND a.supplierId=215) OR ( a.articleSearch IN ('SS10808', 'SS10884', 'TS10340', 'AF1023212B1', 'AF1023217B1', 'AS10195', 'BK1171', 'BK1173', 'BK1177', 'BK679', 'BK970', 'EG1028812B1', 'EG1028815B1', 'ES1073512B1', 'ES10880', 'ES1088012B1', 'ES10935', 'ES2002512B1', 'ES20221', 'ES2022112B1', 'ES2027712B1', 'ES2028012B1', 'ES20321', 'ES2052512B1', 'SS10798', 'SS10799', 'SS10800', 'SS1099212B1', 'SS1099312B1', 'SS11124', 'SS11313', 'TS10271', 'WC10096') AND a.supplierId=89) OR ( a.articleSearch IN ('550154', '550073', '550076', '550078', '550144', '550144A', '550059', '550060', '550710', '330085', '330509', '330126', '350383', '550059A', '550060A', '550073A', '550076A', '550078A', '550154A', '550511A', '550710A', '551191', '551191A', '555027', '555027A', '558002', '558002A', '570061', '570061A', '570111A', '570245A', '570270A') AND a.supplierId=234) OR ( a.articleSearch IN ('93074', '90236', '73264', '1830005', '1830264', '1953236', '1953314', '1953317', '1957050', '1995002', '1997565', '1997594', '1997611', '1998014', '1998055', '1998150', '105002', '107565', '107594', '107611', '108014', '108055', '108150', '73005', '90314', '90317', '93050') AND a.supplierId=4005) OR ( a.articleSearch IN ('33501', '79069', '33680', '32230', '60130', '77207', '77253', '77297', '77465', '77476', '79113', '79138', '79166', '79308') AND a.supplierId=240) OR (a.articleSearch='1882ASTR' AND a.supplierId=4674) OR ( a.articleSearch IN ('01840', '28377', '01651', '02843', '02895', '14611', '14615', '14623', '14696', '18163', '18169', '21383', '24164', '24865', '28128', '29606', '33698', '39544', '47207', '47208', '47209', '47703') AND a.supplierId=101) OR ( a.articleSearch IN ('TSN22850', 'WHB81109', 'WHB81263', 'WHB83260', 'WHB83261', 'WHB83262') AND a.supplierId=271) OR ( a.articleSearch IN ('20498015K', '20498009K', '20498012K', '20498017K', '20498033K') AND a.supplierId=4727) OR ( a.articleSearch IN ('9400058', '9333029', '9333029K', '9333033', '9333033K', '9333036', '9333036K', '9333102', '9333102K', '9400058K', '9400064', '9400064K') AND a.supplierId=373) OR ( a.articleSearch IN ('OOU04', 'EGR0400') AND a.supplierId=156) OR ( a.articleSearch IN ('1297400100', '1293101000', '1293900200', '1241400800', '1241400801', '1241401200', '1251400200', '1251400400', '1241400700', '1251400300', '1293100800', '1293700300', '1293701200', '1294201400', '1297000400', '1297100600') AND a.supplierId=268) OR ( a.articleSearch IN ('064848206010', '171916011750', '213719630019', '064836012010', '064847146010', '064847161010', '064847171010', '064848107010', '064848116010', '215810606500', '361111181574', '361111181575', '361111182936', '361111182937', '361111182938', '460000244010', '460000474010', '460000480010', '460001789010', '460001794010', '460002003010', '466016355029', '466016355182', '466016355191', '571822112056') AND a.supplierId=4723) OR ( a.articleSearch IN ('87207', '87262', '87065', '87065E', '94548', '87345', '82090', '82447', '81041', '81565E', '86016', '86016E', '01614', '25194', '81022', '81022E', '81029', '81029E', '81504', '81504E', '81516', '81516E', '81569', '81569E', '81572', '81573', '81583', '81614', '81620', '81657', '81657E', '81707', '81707E', '81708', '81756', '81779', '81951', '82452', '83002', '83043', '87047', '871013', '87219', '87262E', '87349', '88002B', '88002E', '88045', '88045E', '88502') AND a.supplierId=244) OR ( a.articleSearch IN ('2148210011', '6146520003', '6146520010', '37148130001', '6146520009', '6147520004', '6148100000', '6148110001', '6148990007', '6148990009', '6148990021') AND a.supplierId=144) OR ( a.articleSearch IN ('1938', '92668', '0056', '0244', '0480', '1343', '1789', '1794', '1952', '81322', '81420', '81437', '81488', '92107', '96028', '97007') AND a.supplierId=15) OR ( a.articleSearch IN ('EPDCPL001', 'EPPPL002', 'ECPAR013', 'ECPPL000', 'ECPPL001', 'ECPPL021', 'ECTPL000', 'ESLFR002', 'ESLFR006', 'ESLFT006', 'ESLUV001', 'HCAPL012', 'KLPPL005', 'KLPPL005Z', 'KLPPL007', 'KLPPL007Z', 'KLPPL009', 'KLTPL001', 'KLTPL001Z', 'KLTPL002') AND a.supplierId=6355) OR ( a.articleSearch IN ('11498', '06336', '08959', '12747', '13873', '02111', '11114', '01540', '01541', '01542', '02550', '03183', '13898', '00296', '03209', '04364', '05489', '08392', '08513', '09021', '10021', '10919', '12811', '13037', '13150', '13638', '16414', '21602', '25395', '34588', '35097', '38822', '41067') AND a.supplierId=4683) OR ( a.articleSearch IN ('PE12015', 'PE80000', 'PE40143', 'PE40037', 'PE25035', 'PE13008', 'PFA10081', 'PBK3409', 'PBK3409H', 'PBK3422', 'PBK3422H', 'PBK3510', 'PBK3510H', 'PBK3511', 'PBK3511H', 'PBK3513', 'PBK3513H', 'PE13024', 'PE13177', 'PE21025', 'PE21105', 'PE30006', 'PE40138', 'PE40140', 'PE40164', 'PE40168', 'PE50011') AND a.supplierId=4558) OR ( a.articleSearch IN ('0608004SX', '0600034SX', '0604029SX', '6106055SX', '0125024SX', '0125090SX', '0600006SX', '0600008SX', '0600039SX', '0600073SX', '0600099SX', '0604008SX', '0604132SX', '0609016SX', '0609504SX', '0665705SX', '1300010SX', '2000007SX', '2000022SX', '2000127SX', '2000237SX', '2340033SX', '4030045SX', '4030046SX', '4030096SX', '4328069SX', '4328484SX', '4328563SX', '4328640SX', '4328651SX', '4328777SX', '6106036SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('99901840', '40928377', '40230003', '40902843', '40902895', '40914611', '40918163', '40924164', '40928128', '40929606', '40933698', '40939544', '40947207', '40947208', '40947209', '40947703', '50921383', '99914615', '99914623') AND a.supplierId=151) OR ( a.articleSearch IN ('V40720488', 'V40720489', 'V400387', 'V400535', 'V407004', 'V407005', 'V10760042', 'V10760051', 'V22720033', 'V24760017', 'V25760007', 'V40630009', 'V406300091', 'V40720301', 'V40720305', 'V40720306', 'V407203061', 'V40720316', 'V407203161', 'V40720320', 'V40720321', 'V40720324', 'V40720331', 'V40720341', 'V40720342', 'V40720343', 'V40720360', 'V40720397', 'V40720479', 'V46760013', 'V52720112') AND a.supplierId=183) OR ( a.articleSearch IN ('RL1079', 'RL1406') AND a.supplierId=4894) OR ( a.articleSearch IN ('S105778001Z', '5WK9606Z', '5WK90541Z', '5WK90551Z', 'A2C59513231Z', 'A2C59513326Z', 'S103057001Z', 'S103857002Z', 'S103968001Z', 'S105578001Z') AND a.supplierId=83) OR ( a.articleSearch IN ('12004089', '12004092', '12004167', '12005059', '12005071', '12008081', '12101041') AND a.supplierId=4657) OR ( a.articleSearch IN ('AEGR617', 'AMMA706', 'APT050', 'APT068', 'ASC629', 'SLS0002', 'SLS13171', 'SLS13326') AND a.supplierId=374) OR ( a.articleSearch IN ('51440', '51460', '51497', '51702', '51813', '51814', '51901', '52514', '52680', '53375', '53423', '53908', '54687', '56277', '56476') AND a.supplierId=6558) OR (a.articleSearch='TER114' AND a.supplierId=317) OR ( a.articleSearch IN ('155027N', '751051N', '751056N') AND a.supplierId=80) OR ( a.articleSearch IN ('10342863', '10342945', '10342946', '10342947', '10342955') AND a.supplierId=479) OR ( a.articleSearch IN ('620093', '620166', '620177', '620838', '620840') AND a.supplierId=96) OR (a.articleSearch='XT6517' AND a.supplierId=4975) OR ( a.articleSearch IN ('70812', '70813', '71752', '73303', '74128', '74140', '74169', '74204', '74216', '98549') AND a.supplierId=4576) OR ( a.articleSearch IN ('150000400', '43U04') AND a.supplierId=257) OR ( a.articleSearch IN ('920048002', '920049724', 'PAL62025', 'PAL62032', 'PAL62044', 'PAL62049') AND a.supplierId=442) OR (a.articleSearch='700095' AND a.supplierId=298) OR ( a.articleSearch IN ('805409', '805411', '805412', '805460', '805461', '903114', '903117', '903119', '904052', '904055', '904059', '959014') AND a.supplierId=300) OR ( a.articleSearch IN ('AS2083', 'AS2088', 'AS2201', 'AS2212', 'AS3032', 'AS3449', 'AS4185', 'AS4187', 'AS4188', 'AS4190', 'AS4220', 'AS4227', 'AS4241', 'AS4701', 'AV6020', 'LM1026', 'RS1006', 'RS1007', 'RS1008', 'RS1009', 'RS1305') AND a.supplierId=4737) OR ( a.articleSearch IN ('01020', '01021', '01873', '0197179', '0197180', '0197181', '0197182') AND a.supplierId=4651) OR (a.articleSearch='17065' AND a.supplierId=4306) OR ( a.articleSearch IN ('PDN0008', 'PES0138', 'PES0193', 'PGR4038', 'PSE1152', 'PSE1153', 'PSE1154', 'PSE1198', 'PSE1297', 'PTH4119') AND a.supplierId=4337) OR ( a.articleSearch IN ('290RD00052', '290RD00061', '290RD00062', '290RD00130', '290RD00347') AND a.supplierId=6271) OR ( a.articleSearch IN ('RA4404', 'RA4406', 'RA4406H', 'RA4407', 'RA4407H', 'RA4455', 'RA4456') AND a.supplierId=4464) OR ( a.articleSearch IN ('0011017820', '0011021278', '0274014298') AND a.supplierId=4995) OR ( a.articleSearch IN ('AMS705', 'CSS701', 'CSS702', 'CSS710', 'CSS711') AND a.supplierId=194) OR ( a.articleSearch IN ('050009B', '050015B', '050071B', '050072B', '050105B') AND a.supplierId=49) OR ( a.articleSearch IN ('OZH176', 'OZH190', 'ST037', 'ST089', 'ST220', '710775D0') AND a.supplierId=6444) OR ( a.articleSearch IN ('3317', '3356', '3357', '3395', '80211', '8691', '90036') AND a.supplierId=208) OR (a.articleSearch='EGR0047' AND a.supplierId=6010) OR ( a.articleSearch IN ('ADC47038', 'ADG07031', 'ADG07070', 'ADM57067', 'ADT37204') AND a.supplierId=350) OR ( a.articleSearch IN ('BTS3024', 'BWK410', 'BWK411', 'BWK841', 'BWK842', 'BWK844') AND a.supplierId=475) OR ( a.articleSearch IN ('0258005718', '0258005730', '0258986507', '0258986602', '0280122001', '0280122003', '0280130107', 'F00HL00036', 'F00HL00129', 'F00HL00155', 'F00HL00221', 'F00HL00383', 'F00HL00415') AND a.supplierId=30) OR ( a.articleSearch IN ('KRT2292', 'KRT2293', 'KRT2295', 'KRT2580', 'KRT2587') AND a.supplierId=195) OR ( a.articleSearch IN ('H1X004BTA', 'H1X005BTA', 'H1X007BTA', 'H2X001BTA', 'H2X002BTA', 'SALEH1X005BTA') AND a.supplierId=4693) OR ( a.articleSearch IN ('520030', '520040', '520050', '520060', '520370') AND a.supplierId=6549) OR ( a.articleSearch IN ('54030', '54083') AND a.supplierId=157) OR ( a.articleSearch IN ('RC4404', 'RC4407', 'RC4407H', 'RC4455', 'RC4456') AND a.supplierId=4463) OR ( a.articleSearch IN ('65425', '6771') AND a.supplierId=4604) OR ( a.articleSearch IN ('481046', '482549', '482550', '757556', '764443') AND a.supplierId=405) OR ( a.articleSearch IN ('CHA042', 'CHA043', 'CHA058', 'CHA059') AND a.supplierId=421) OR ( a.articleSearch IN ('1194CRB33511ABS', '137CRB33513ABS') AND a.supplierId=4594) OR ( a.articleSearch IN ('CGR4643', 'CGR4643C', 'CGR4954C', 'CKJ1614', 'CPM9103', 'CPM9120', 'CPM9145', 'CSD9006', 'CSL2190', 'CSL2201', 'CSL2268', 'CSL2308', 'CSM6616', 'CSM6616C', 'CSR3318', 'CSR3322', 'CSR3403', 'CSR3403C', 'CSR9112', 'CSR9115', 'CSR9115C', 'CSR9117', 'CSR9220', 'CSR9220C', 'CSR9221', 'CSR9221C', 'CSR9358', 'CST1289', 'CST5417', 'CST9550', 'CSV9710', 'CTH2056', 'CTH2067', 'CTH2199', 'CTH2200', 'CTH2213', 'CTH2265', 'CTH2301', 'CTH2573', 'CTH2600') AND a.supplierId=4334) OR ( a.articleSearch IN ('DT1220H', 'KWD1062', 'KWD1141', 'KWD1142') AND a.supplierId=42) OR ( a.articleSearch IN ('W413345', 'W413353', 'W413362', 'W413364') AND a.supplierId=186) OR ( a.articleSearch IN ('DOX0113', 'DOX0119', 'DOX0121', 'DOX0259', 'DOX0351', 'DOX1371', 'DOX1566') AND a.supplierId=4760) OR ( a.articleSearch IN ('R3023', 'R3034', 'R3066', 'R3067') AND a.supplierId=4396) OR ( a.articleSearch IN ('1301002', '1301012') AND a.supplierId=253) OR ( a.articleSearch IN ('EGR042AN', 'EGR042N', 'EGR042R', 'FLOW088DPSN', 'FLOW088HLLN', 'INJCS020N', 'INJCS054N', 'INJCS074N', 'INJCS078N', 'INJCS097N', 'INJCS099AN', 'INJCS099VDON', 'INJLS058BSCN', 'INJS134N', 'INJSBM007N', 'TRM091N') AND a.supplierId=4882) OR (a.articleSearch='DS1015' AND a.supplierId=471) OR ( a.articleSearch IN ('1060200075', '1060200079', '1060200080', '1180030015') AND a.supplierId=4345) OR ( a.articleSearch IN ('DP2010100206', 'DP2010100211', 'DP2010100481', 'DP2010100577', 'DP2010100594') AND a.supplierId=4948) OR (a.articleSearch='681020' AND a.supplierId=355) OR ( a.articleSearch IN ('DMAF1009', 'DS065', 'DWH3409', 'DWH3510', 'DWH3511', 'DWH3513') AND a.supplierId=4881) OR ( a.articleSearch IN ('EBK1692A', 'EBK1705A', 'EBK1788A', 'EBK1789A', 'EBK1790A', 'EBK1791A') AND a.supplierId=6364) OR ( a.articleSearch IN ('295100', '295133', '303063', '303103', '303128', '303273', '305011') AND a.supplierId=211) OR ( a.articleSearch IN ('EA0067', 'EA0101', 'EA0116', 'EE0027', 'EE0101', 'EE0105', 'EE0169', 'EE0565', 'EE4004', 'EE8008', 'EE8016', 'EV0012', 'EV0037', 'EV0299', 'EX0002', 'EX0010', 'EX0177', 'EX0226', 'EX0392', 'XAM4002', 'XBS067', 'XBS101', 'XBS116', 'XCS6030', 'XCS6078', 'XCS6088', 'XCS6158', 'XCS6488', 'XLS1005', 'XLS1009', 'XLS1172', 'XLS1377', 'XLS1468', 'XSP7210', 'XSP7211', 'XTS7714', 'XTS7743', 'XTS7757') AND a.supplierId=4344) OR ( a.articleSearch IN ('ENT300006', 'ENT500043', 'ENT600010', 'ENT600060', 'ENT810001') AND a.supplierId=6889) OR ( a.articleSearch IN ('07SKV119', '09SKV005', '09SKV036', '09SKV048', '09SKV096', '09SKV104', '09SKV572', '09SKV594', '09SKV595', '09SKV705', '09SKV743', '09SKV904', '09SKV909', '09SKV993', '14SKV015', '17SKV005', '17SKV009', '17SKV209', '17SKV211', '17SKV218', '17SKV230', '17SKV233', '17SKV325', '17SKV529', '20SKV005', '20SKV012', '20SKV016', '20SKV036', '20SKV040', '29SKV003', '29SKV007', '29SKV008', '29SKV027', '29SKV056', '29SKV121') AND a.supplierId=4969) OR (a.articleSearch='93BBAA9F472' AND a.supplierId=6367) OR ( a.articleSearch IN ('1623949680', '1623949880', '1623952680', '1623953080', '1623954180', 'E144003', 'E144007') AND a.supplierId=4391) OR ( a.articleSearch IN ('713644040', '713644060', '713644070', '713644550', '713644560') AND a.supplierId=192) OR ( a.articleSearch IN ('FHBK1056', 'FHBK1064') AND a.supplierId=267) OR ( a.articleSearch IN ('14173', '14174', '6037') AND a.supplierId=4834) OR ( a.articleSearch IN ('XL782040040', 'XL785240045') AND a.supplierId=415) OR ( a.articleSearch IN ('FBK410', 'FBK411', 'FBK841', 'FBK842', 'FBK844', 'FTS3024') AND a.supplierId=407) OR ( a.articleSearch IN ('38616', '38616A2', '405194', '460114', '460119', '460121', '460243', '821289', '821289A2', '82355', '82550', '8301614', '83112', '83115', '83117', '83220', '83220A2', '83221', '83221A2', '833322', '834609', '834643', '83609AS', '83643', '83643AS', '83643R', '84006', '84103', '84120', '90054', '90054A2', '90054HQ', '90056', '90056A2', '90074', '90074A2', '90074HQ', '90135', '90135A2', '90135HQ', '90190', '90190A2', '90192', '90193', '90201', '90226', '90232', '90267', '90267A2', '90308', '90308A2', '90308HQ', '90309', '90356', '90380', '90951') AND a.supplierId=441) OR ( a.articleSearch IN ('GL4114S', 'GL4119S', 'GL4343S') AND a.supplierId=6317) OR ( a.articleSearch IN ('FR290922', 'FR290924', 'FR291031', 'FR291039', 'FR961286') AND a.supplierId=236) OR (a.articleSearch='EGR12131' AND a.supplierId=235) OR ( a.articleSearch IN ('FWB0051', 'FWB0052', 'FWB0053', 'FWB0408KT', 'FWB0409KT') AND a.supplierId=409) OR ( a.articleSearch IN ('GH5012', 'GS1603', 'GS7301', 'GS8228') AND a.supplierId=4933) OR ( a.articleSearch IN ('910021', '919911', '920011', '920041', '921341', '923101', '930061', '970201') AND a.supplierId=4379) OR (a.articleSearch='VE1022' AND a.supplierId=6456) OR (a.articleSearch='WH1351K' AND a.supplierId=316) OR ( a.articleSearch IN ('GH30410', 'GH30890A', 'GH30910A', 'GH31800') AND a.supplierId=6666) OR ( a.articleSearch IN ('150851', '150875', '150882', '180439', '181481', '181702', '181938', '182001') AND a.supplierId=4819) OR ( a.articleSearch IN ('6NU010171711', '6PA358066251', '6PA358103031', '6PA358103291', '6PA358103381', '6PA358103521', '6PG009108531', '6PT009104011', '6PT009104017', '6PT009107161', '6PT009309271', '6PU009110621', '6PU009121041', '6PU009121061', '6PU009121311', '6PU009163811', '6PU009163831', '6PU012681011', '6PX008476331', '8ET009142031') AND a.supplierId=4734) OR ( a.articleSearch IN ('70511041', '70511534', '70607400', '70610003', '70610004', '70610040', '70630016', '70630021', '70640102', '70671411', 'J1460330', 'J1462012', 'J1470904', 'J1473018', 'J5640304', 'J5640500') AND a.supplierId=72) OR ( a.articleSearch IN ('131626', '135099', '138137', '138972', '2508972') AND a.supplierId=449) OR (a.articleSearch='92096003' AND a.supplierId=118) OR ( a.articleSearch IN ('7472090', '7472447', '7472452', '7481022', '7481022E', '7481029', '7481029E', '7481504', '7481504E', '7481516', '7481516E', '7481569', '7481569E', '7481572', '7481573', '7481583', '7481614', '7481620', '7481657', '7481657E', '7481707', '7481707E', '7481708', '7481756', '7481779', '7481951', '7513002', '7513043', '7516016', '7516016E', '7517047', '7517065', '7517065E', '75171013', '7517207', '7517219', '7517262', '7517262E', '7517349', '7518002B', '7518002E', '7518045', '7518045E', '7518502', '8035194', '9101614') AND a.supplierId=341) OR ( a.articleSearch IN ('101137', '101137R', '101252', '101252R', '101253', '101253R', '101255', '101255R', '101256', '101256R', '101257', '101257R') AND a.supplierId=4862) OR ( a.articleSearch IN ('14922', '17161', '18907', '18960', '18961', '18962', '18995', '19046', '19522', '19655M', '19908', '19928', '52820', '53027', '55525', '55736', '60622', '60765', '64136', '64161', '64408', '64480', '64652', '64796', '64834') AND a.supplierId=269) OR ( a.articleSearch IN ('304404', '304406', '304407', '304455', '304456', '402109', '402112', '402114', '403047', '403050', '403054', '458009') AND a.supplierId=262) OR ( a.articleSearch IN ('1500400', '3U04') AND a.supplierId=481) OR (a.articleSearch='TH0200011' AND a.supplierId=296) OR ( a.articleSearch IN ('AGR5555034', 'LMM5515003') AND a.supplierId=138) OR ( a.articleSearch IN ('108019', '108021', '109002', '109028', '5500037', '5500059', '5500061', '5500062', '5500079', '5500080') AND a.supplierId=185) OR ( a.articleSearch IN ('ECT1001', 'EOS1037', 'ETP3001', 'WBK1013') AND a.supplierId=201) OR ( a.articleSearch IN ('818024101', '853024114', '853024115', '853024116', '853024212', '853024213', '862610039', '881224003', '881324102', '884512002', '884512034', '884516002', '884525002', '884529050', '885524104', '885524115', '885524125', '886521101', '886524101') AND a.supplierId=286) OR ( a.articleSearch IN ('KWB410', 'KWB411', 'KWB841', 'KWB842', 'KWB844') AND a.supplierId=4879) OR ( a.articleSearch IN ('163223Z', '22027Z', '22028Z', '22029Z', '22031Z', '22032Z', '22033Z', '49001Z', '49501Z', '49502Z', '50042Z') AND a.supplierId=387) OR ( a.articleSearch IN ('RK4404', 'RK4407', 'RK4407H', 'RK4455', 'RK4456') AND a.supplierId=4462) OR ( a.articleSearch IN ('1511640', '1841560', '4101630', '4101635', '4101660', '4101670', '4101680', '4101681', '8801510', '8801520', '8801528', '8801532', '8851525') AND a.supplierId=4546) OR ( a.articleSearch IN ('453236', '453314', '453317', '457050', '495002', '497565', '497594', '497611', '498014', '498055', '498150', '530005', '530264') AND a.supplierId=4006) OR ( a.articleSearch IN ('LAB057', 'LAB494', 'LAT138', 'LCS186', 'LCS228', 'LCS229', 'LCS230', 'LCS250', 'LCS294', 'LCS494', 'LEGR156', 'LKS020', 'LLB089', 'LLB113', 'LLB405', 'LLB597', 'LLB764', 'LLB815', 'LMF232', 'LTP001', 'LTP008', 'LWS032', 'LWS207', 'LWS238') AND a.supplierId=6518) OR ( a.articleSearch IN ('1602501', '1602701') AND a.supplierId=35) OR ( a.articleSearch IN ('AGR0058', 'L0027B450', 'L0032B400') AND a.supplierId=117) OR ( a.articleSearch IN ('FDM709', 'LEB4017', 'LEB441', 'LEB5128', 'LEB5227', 'LEB528', 'LEB532', 'LEB622', 'LKBA67008', 'LKBA67009', 'LKBA67010', 'LKBA67011', 'LKBA67022', 'LKBA67028', 'SEB1132', 'SEB1261', 'SEB1725', 'SEB210', 'SEB450', 'SEB490', 'SEB491', 'SEB851', 'SEB985', 'SEB998', 'SNB117', 'SNB1199', 'SNB224', 'SNB851') AND a.supplierId=4501) OR ( a.articleSearch IN ('WH1069', 'WH1146', 'WH1171', 'WH1185', 'WH1194') AND a.supplierId=4600) OR (a.articleSearch='OEV010014' AND a.supplierId=4658) OR (a.articleSearch='TI592' AND a.supplierId=287) OR ( a.articleSearch IN ('26806', '26807', '26810', '26812', '26813', '28717', '42704', '82705', '83708', '88704') AND a.supplierId=133) OR ( a.articleSearch IN ('3409SETMS', '3411SETMS', '3422SETMS', '3510SETMS', '3511SETMS', '3512SETMS', '3513SETMS', '8200052063PCSMS') AND a.supplierId=358) OR (a.articleSearch='MOE4003' AND a.supplierId=6270) OR ( a.articleSearch IN ('210123', '210255', '210340', '240008', '240010', '240018', '240021', '240064', '240117', '240169', '240217', '240225', '250011', '270163', '330255', '330256', '330257', '330276', '330277', '510039', '590013', '590014', '590110') AND a.supplierId=403) OR ( a.articleSearch IN ('EEGOP29', 'EPS1830005', 'EPS1830264', 'EPS1953236', 'EPS1953314', 'EPS1953317', 'EPS1957050', 'EPS1995002', 'EPS1997565', 'EPS1997594', 'EPS1997611', 'EPS1998014', 'EPS1998055', 'EPS1998150', 'MLS9U04', 'MRP2B03') AND a.supplierId=4773) OR ( a.articleSearch IN ('90205', '90206', '90333', '90524', '93006') AND a.supplierId=4664) OR ( a.articleSearch IN ('0891006', '0892012', '0893051', '0893061', '0893092', '0893128', '0895465', '0895503', '0901107', '0902010', '0902012', '0902054', '0902357', '0903006', '0903007', '0903035', '0903036', '0903207', '0903216', '0904002', '0904029', '0905007', '0905132', '0905417', '0907011', 'WM1113', 'WM1114', 'WM876', 'WM877') AND a.supplierId=94) OR ( a.articleSearch IN ('DB83057', 'DB83163') AND a.supplierId=6495) OR ( a.articleSearch IN ('CSE004', 'CSE005', 'CSE007', 'CSE069', 'CSE160', 'MAG007', 'OSB4183P', 'OSB454P', 'OSB466P', 'OSF424P', 'OSM413P', 'OSSU401P', 'OST481P', 'SP003', 'TPE003', 'TPE004') AND a.supplierId=4705) OR ( a.articleSearch IN ('OPWB11088', 'OPWB11089', 'OPWB11091', 'OPWB11117', 'OPWB11118') AND a.supplierId=134) OR ( a.articleSearch IN ('LVAT131', 'LVBW690', 'LVBW691', 'LVBW941', 'LVBW944', 'LVCP104', 'LVCP283', 'LVCT210', 'LVCT400', 'LVEP141', 'LVER161', 'LVKN124', 'LVMA159', 'LVOS1429', 'LVOS1546', 'LVOS1702', 'LVOS1727', 'LVOS1930', 'LVRC263', 'LVRC410', 'LVTP111', 'LVTP131', 'VBK690', 'VBK691', 'VBK941', 'VBK944', 'VCP105', 'VCT127', 'VRC129') AND a.supplierId=4564) OR ( a.articleSearch IN ('1CS528', '1CS533', '1KR520', '1KR590', '3MF570', '541192K') AND a.supplierId=388) OR ( a.articleSearch IN ('ASB0927', 'ASB0928', 'ASB1600', 'ASB1774', 'ASB1775', 'ASB1776', 'ASB1777') AND a.supplierId=6874) OR ( a.articleSearch IN ('3029', '4007', '5103', '7254', '781740045', '782040040', '783440035', '783845031', '787640077', '789643035', '792540037', '793340050', '793440035', '981440025', 'VT46192') AND a.supplierId=320) OR ( a.articleSearch IN ('70230035', '70230062', '70230063', '70230064', '70230065', '70230071') AND a.supplierId=4653) OR ( a.articleSearch IN ('NBK1008', 'NBK1014', 'NBK1032') AND a.supplierId=190) OR (a.articleSearch='N4710914' AND a.supplierId=248) OR (a.articleSearch='98227' AND a.supplierId=123) OR ( a.articleSearch IN ('753620', '753621', '753623', '763614', '763615') AND a.supplierId=127) OR ( a.articleSearch IN ('DOX0109', 'DOX0114', 'DOX0259', 'DOX1371') AND a.supplierId=440) OR ( a.articleSearch IN ('KH30054', 'KH30055', 'KH30057', 'KH30058', 'KH30059') AND a.supplierId=4728) OR ( a.articleSearch IN ('2376215', '2376221', '2458046') AND a.supplierId=4380) OR ( a.articleSearch IN ('HBK518203', 'HBK521103', 'TRM115200') AND a.supplierId=378) OR ( a.articleSearch IN ('07S058', '07S076', '08S011', '08S033', '08S036', '08S038', '201033', '201035', '201043', '202140', '202142') AND a.supplierId=129) OR (a.articleSearch='5311' AND a.supplierId=331) OR ( a.articleSearch IN ('PTA3210014', 'PTA3210017', 'PTA3210038', 'PTA3210211', 'PTA5100012') AND a.supplierId=6457) OR (a.articleSearch='JAPEGR0400' AND a.supplierId=4652) OR ( a.articleSearch IN ('402003240', '402003490', '702604470', '702604640', '702604830', '705271010', '705271540', '722414080') AND a.supplierId=5) OR ( a.articleSearch IN ('86110008', '86110015', '86110034', '86110272') AND a.supplierId=4543) OR ( a.articleSearch IN ('R3071', 'R3074', 'R3076') AND a.supplierId=4655) OR ( a.articleSearch IN ('25013409', '25013422', '25013510', '25013511', '25013513', '40050004') AND a.supplierId=4686) OR ( a.articleSearch IN ('QF04D00185', 'QF10D00063', 'QF15A00021', 'QF15A00040', 'QF15A00046', 'QF15A00069', 'QF25A00075', 'QF25A00081', 'QF31B00011', 'QF86A00052', 'QF91A00007', 'QF91A00055') AND a.supplierId=4339) OR ( a.articleSearch IN ('QM616', 'QWB1112', 'QWB1113', 'QWB1114', 'QWB876', 'QWB877', 'XEGR6', 'XEMS81', 'XKS35', 'XLOS1112', 'XLOS1390', 'XLOS1539', 'XLOS1676', 'XLOS1710', 'XPOT324', 'XPOT407', 'XREV200', 'XREV201', 'XREV262', 'XREV320', 'XREV351', 'XREV354', 'XREV676', 'XTT141', 'XTT20') AND a.supplierId=57) OR ( a.articleSearch IN ('RCAK1104', 'RCAK1200') AND a.supplierId=492) OR (a.articleSearch='50SZ024' AND a.supplierId=4869) OR ( a.articleSearch IN ('RKB0927', 'RKB0928', 'RKB1600', 'RKB1774', 'RKB1775', 'RKB1776', 'RKB1777') AND a.supplierId=4330) OR ( a.articleSearch IN ('1145E0035', '1186S0002', '1189S0003', '3921K0033', '3922L0010', '3922L0033', '3922L0067', '3922L0124', '3922L0132', '3922L0198', '3922L0202', '3922L0204', '3922L0216', '3922L0225', '3922L0228', '3922L0229', '3926A0007', '3940T0002', '3946S0004', '3946S0006', '3946S0099', '654W0023', '654W0025', '654W0063', '654W0075', '654W0513', '830C0013', '830C0028', '833C0019', '833C0043', '833C0064') AND a.supplierId=6358) OR ( a.articleSearch IN ('5322', '5323', '5331', '5332', '5333') AND a.supplierId=23) OR ( a.articleSearch IN ('3256011', '3256017') AND a.supplierId=260) OR ( a.articleSearch IN ('E302040', 'E534454', 'E614138', 'WB24103') AND a.supplierId=6377) OR ( a.articleSearch IN ('CC27', 'CP223', 'CP25', 'CP40') AND a.supplierId=263) OR ( a.articleSearch IN ('38616', '38616A2', '405194', '460114', '460119', '460121', '460243', '821289', '821289A2', '82355', '82550', '8301614', '83112', '83115', '83117', '83220', '83220A2', '83221', '83221A2', '833322', '834609', '834643', '83609AS', '83643', '83643AS', '83643R', '84006', '84103', '84120', '90054', '90054A2', '90054HQ', '90056', '90056A2', '90074', '90074A2', '90074HQ', '90135', '90135A2', '90135HQ', '90190', '90190A2', '90192', '90193', '90201', '90226', '90232', '90267', '90267A2', '90308', '90308A2', '90308HQ', '90309', '90356', '90380', '90951') AND a.supplierId=27) OR ( a.articleSearch IN ('VKBA3409', 'VKBA3422', 'VKBA3510', 'VKBA3511', 'VKBA3512', 'VKBA3513') AND a.supplierId=50) OR ( a.articleSearch IN ('R15322', 'R15323', 'R15331', 'R15332', 'R15333') AND a.supplierId=110) OR ( a.articleSearch IN ('SKAS0150006', 'SKCPS0360018', 'SKCPS0360042', 'SKCPS0360063', 'SKCTS0850012', 'SKCTS0850027', 'SKEGR0770034', 'SKKS0400033', 'SKLS0140009', 'SKLS0140032', 'SKLS0140066', 'SKLS0140082', 'SKLS0140169', 'SKLS0140188', 'SKLS0140210', 'SKLS0140232', 'SKLS0140318', 'SKLS0140374', 'SKLS0140376', 'SKLS0140388', 'SKSE1370001', 'SKSPS0370003', 'SKSPS0370005', 'SKSPS0370099', 'SKSSP1130002', 'SKTPS0380001', 'SKWB0180022', 'SKWB0180024', 'SKWB0180062', 'SKWB0180074', 'SKWB0180648') AND a.supplierId=6357) OR ( a.articleSearch IN ('VSMF0520', 'VSOS0521', 'VSTP0306') AND a.supplierId=4771) OR ( a.articleSearch IN ('T490205', 'T490206', 'T490333', 'T490524', 'T493006') AND a.supplierId=4667) OR ( a.articleSearch IN ('199014', '290924', '291031', '291039', '63066') AND a.supplierId=6691) OR ( a.articleSearch IN ('81OP0271', '81OP0273') AND a.supplierId=4758) OR (a.articleSearch='KR140' AND a.supplierId=6312) OR (a.articleSearch='KTT070004' AND a.supplierId=4466) OR ( a.articleSearch IN ('202126', '202366', '202440', '205208', '205631', '205680', '205766', '205767', '205893', '206206', '206617', '206694', '206729', '207446', '207520', '701076') AND a.supplierId=301) OR ( a.articleSearch IN ('WB1519', 'WB1530', 'WB1608', 'WB1609', 'WB1611') AND a.supplierId=4732) OR ( a.articleSearch IN ('MR0587', 'MR2131', 'MR2133') AND a.supplierId=4772) OR ( a.articleSearch IN ('347002', '488090', '908034', '908035', '908038', '908256') AND a.supplierId=4970) OR ( a.articleSearch IN ('818024101', '853024114', '853024115', '853024116', '853024212', '853024213', '862011792', '862015092', '862015492', '862027692', '862610039', '881224003', '881324102', '884512002', '884512034', '884516002', '884525002', '884529050', '885524104', '885524115', '885524125', '886521101', '886524101') AND a.supplierId=108) OR ( a.articleSearch IN ('TR00548', 'TR00570') AND a.supplierId=4949) OR ( a.articleSearch IN ('253701', '253811', '253832', '253834', '254088', '254112', '254144', '366132', '368070', '368090', '700005', '820502') AND a.supplierId=21) OR (a.articleSearch='D33047' AND a.supplierId=4836) OR ( a.articleSearch IN ('15801', '17828', '17878', '19746', '19748', 'VE80211', 'VE8691', 'VE90036') AND a.supplierId=4425) OR (a.articleSearch='MAF10232T' AND a.supplierId=4627) OR ( a.articleSearch IN ('2001332', '2141003', '2351913', '2351960', '2351963', '2451238', '25024001', '250241011', '250241022', '250241051', '25024452', '25024462', '25024568', '25024789', '25024862', '25054008') AND a.supplierId=303) OR ( a.articleSearch IN ('240660168', '290960021', '290960083', '290960149', '290960152', '290960153', '290960164', '290960191', '290960197', '290960237', '290960285', '290960286', '290960337', '290960362', '290960631', '290960633', '290960635', '290960652', '290960684', '290970007', '290970016', '290970025', '290970033', '290970038', '330690011', '330690017', '330690066', '330690545', '330690740', '330690748', '330870022', '330870480', '410570027', '410570034', '410570068', '410570176', '410570186', '410570229', '410570967', '410570982', '410580062', '410580218', '410580223', '410600004', '410600014', '411790003') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1013854', 'WG1013856', 'WG1013877', 'WG1013881', 'WG1013918', 'WG1013923', 'WG1013946', 'WG1013968', 'WG1013990', 'WG1014029', 'WG1014062', 'WG1014893', 'WG1014895', 'WG1014945', 'WG1014957', 'WG1015231', 'WG1025427', 'WG1025998', 'WG1026015', 'WG1026034', 'WG1026426', 'WG1026770', 'WG1028923', 'WG1028924', 'WG1028947', 'WG1029063', 'WG1029276', 'WG1029334', 'WG1029336', 'WG1031988', 'WG1032806', 'WG1032833', 'WG1032836', 'WG1032896', 'WG1032974', 'WG1099998', 'WG1153960', 'WG1217689', 'WG1407300', 'WG1407623', 'WG1407624', 'WG1407695', 'WG1408085', 'WG1408193', 'WG1408234', 'WG1408302', 'WG1409970', 'WG1429759', 'WG1429853', 'WG1429924', 'WG1429929', 'WG1429962', 'WG1430001', 'WG1430054', 'WG1430096', 'WG1430097', 'WG1430282', 'WG1445339', 'WG1445780', 'WG1461220', 'WG1461320', 'WG1461413', 'WG1492388', 'WG1492512', 'WG1493223', 'WG1493224', 'WG1493226', 'WG1493250', 'WG1493251', 'WG1493255', 'WG1493256', 'WG1493259', 'WG1493351', 'WG1493364', 'WG1493365', 'WG1493748', 'WG1493934', 'WG1494470', 'WG1495091', 'WG1496017', 'WG1496018', 'WG1497230', 'WG1497231', 'WG1498090', 'WG1498284', 'WG1498429', 'WG1499453', 'WG1499461', 'WG1499480', 'WG1499537', 'WG1499538', 'WG1499583', 'WG1499628') AND a.supplierId=4832)An internal server error occurred.