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 IN ('1970169', '96069', '1970135', '1970364', '1970532', '96035', '96264', '96432') AND a.supplierId=4005) OR ( a.articleSearch IN ('48340', '48001', '48044') AND a.supplierId=15) OR (a.articleSearch='00992' AND a.supplierId=4683) OR ( a.articleSearch IN ('PCI1138', 'PCI1004', 'PCI1004KOR', 'PCI1371') AND a.supplierId=4558) OR (a.articleSearch='12201006' AND a.supplierId=4657) OR ( a.articleSearch IN ('51309', '54902') AND a.supplierId=6558) OR (a.articleSearch='10610093' AND a.supplierId=479) OR (a.articleSearch='XE8048A' AND a.supplierId=4975) OR (a.articleSearch='74195' AND a.supplierId=4576) OR (a.articleSearch='7803300' AND a.supplierId=257) OR (a.articleSearch='M98012' AND a.supplierId=442) OR (a.articleSearch='ZS2000' AND a.supplierId=4737) OR ( a.articleSearch IN ('150009310', '150009410') AND a.supplierId=323) OR ( a.articleSearch IN ('IC18101', 'IC18109', 'ZK1869') AND a.supplierId=194) OR ( a.articleSearch IN ('ZEF1212', 'ZS126', 'ZS350', 'ZS350BO', 'ZS365', 'ZS422', 'ZS566') AND a.supplierId=6444) OR (a.articleSearch='ADM51497' AND a.supplierId=350) OR ( a.articleSearch IN ('0221122367', '0221122450', '0221503490', '0221122031', '0221122362', '1227020017') AND a.supplierId=30) OR ( a.articleSearch IN ('215001', '215001E', '215007', '215007E', '215009', '215009E') AND a.supplierId=452) OR ( a.articleSearch IN ('20155', '20177', '20457') AND a.supplierId=47) OR ( a.articleSearch IN ('BSG30835001', 'BSG30835004') AND a.supplierId=4455) OR ( a.articleSearch IN ('BAEA350', 'BAEA365', 'BAEA422') AND a.supplierId=43) OR (a.articleSearch='A2C59514956' AND a.supplierId=6513) OR ( a.articleSearch IN ('CBE5091', 'CBE5105', 'CBE5106', 'CBE5134', 'CBE5204', 'CBE5433', 'CBE5447') AND a.supplierId=4334) OR ( a.articleSearch IN ('CE2004212B1', 'CE2004412B1', 'CE20119') AND a.supplierId=89) OR (a.articleSearch='E100020' AND a.supplierId=186) OR ( a.articleSearch IN ('DG2031', 'DG2038') AND a.supplierId=4396) OR ( a.articleSearch IN ('BBA033DLPN', 'BBA033T1DLPN') AND a.supplierId=4882) OR ( a.articleSearch IN ('DIC072', 'DIC106') AND a.supplierId=4881) OR ( a.articleSearch IN ('155008', '155010', '155011', '155341') AND a.supplierId=211) OR ( a.articleSearch IN ('EE5003', 'EE5036', 'EE5092', 'EE5492', 'QL1003', 'QL1052', 'XIG5004', 'XIG5018', 'XIG5808', 'XIG5827') AND a.supplierId=4344) OR ( a.articleSearch IN ('880022', '880022A', '880048', '880048A', '880049', '880049A', '880193', '880193A') AND a.supplierId=234) OR (a.articleSearch='03SKV015' AND a.supplierId=4969) OR ( a.articleSearch IN ('DC1019', 'DC1025', 'DC1028', 'DC1247') AND a.supplierId=411) OR (a.articleSearch='988F12029AB' AND a.supplierId=6367) OR ( a.articleSearch IN ('80214', '80285') AND a.supplierId=240) OR ( a.articleSearch IN ('21569', '26869', '36999') AND a.supplierId=101) OR (a.articleSearch='IC16025' AND a.supplierId=271) OR ( a.articleSearch IN ('8530069', '8530134', '8530136', '8530138', '8530139', '8530302A2', '8530302AS', '8530447') AND a.supplierId=441) OR ( a.articleSearch IN ('GC4019', 'GC4029', 'GC4030', 'GC4490') AND a.supplierId=4933) OR ( a.articleSearch IN ('945311', '945651') AND a.supplierId=4379) OR (a.articleSearch='150416' AND a.supplierId=4819) OR (a.articleSearch='5DA193175411' AND a.supplierId=4734) OR (a.articleSearch='19020059' AND a.supplierId=72) OR ( a.articleSearch IN ('138803', '138809', '138811', '2508803', '2508809', '2508811') AND a.supplierId=449) OR ( a.articleSearch IN ('8010318', '8010318E', '8010628') AND a.supplierId=341) OR ( a.articleSearch IN ('81611052', '81611080') AND a.supplierId=6359) OR ( a.articleSearch IN ('11330', '11350', '11410', '12467', '12714', '12715', '12781') AND a.supplierId=269) OR (a.articleSearch='BOFD497' AND a.supplierId=6387) OR ( a.articleSearch IN ('JM5090', 'JM5091', 'JM5153', 'JM5209', 'JM5365') AND a.supplierId=397) OR (a.articleSearch='BO300' AND a.supplierId=156) OR (a.articleSearch='78300' AND a.supplierId=481) OR (a.articleSearch='1591600100' AND a.supplierId=268) OR ( a.articleSearch IN ('ICC4524', 'ICC4512', 'ICC4520', 'ICC4521', 'ICC4522', 'ICC4525') AND a.supplierId=201) OR ( a.articleSearch IN ('45006Z', '45015Z') AND a.supplierId=387) OR (a.articleSearch='9042050' AND a.supplierId=4546) OR ( a.articleSearch IN ('470135', '470169', '470364', '470532') AND a.supplierId=4006) OR ( a.articleSearch IN ('CP475', 'CP476', 'CP480', 'CP491') AND a.supplierId=6518) OR ( a.articleSearch IN ('DLB125', 'DLB198', 'DLB405', 'DMB1805', 'DMB805') AND a.supplierId=4501) OR ( a.articleSearch IN ('SPL1016', 'SPL1052') AND a.supplierId=4600) OR ( a.articleSearch IN ('060717036012', '060717038012', '060717178012', '060801005010', '060810220010') AND a.supplierId=4723) OR ( a.articleSearch IN ('MMI030080', 'MMI030081', 'MMI030090') AND a.supplierId=4570) OR ( a.articleSearch IN ('80752', '80753') AND a.supplierId=133) OR ( a.articleSearch IN ('130016', '130151') AND a.supplierId=403) OR ( a.articleSearch IN ('EPS1970135', 'EPS1970169', 'EPS1970364', 'EPS1970532', 'MCI9300') AND a.supplierId=4773) OR ( a.articleSearch IN ('10318', '10318E', '10628') AND a.supplierId=244) OR ( a.articleSearch IN ('0880026', '0880027', '0880172') AND a.supplierId=94) OR ( a.articleSearch IN ('7148850010', '7148850011') AND a.supplierId=144) OR (a.articleSearch='AL08072' AND a.supplierId=6495) OR ( a.articleSearch IN ('CE166', 'CF01', 'CF46', 'CF69') AND a.supplierId=4705) OR ( a.articleSearch IN ('LVCL400', 'LVCL402', 'LVCL424', 'LVCL838') AND a.supplierId=4564) OR ( a.articleSearch IN ('2IC106', '2IC552', '2IC617') AND a.supplierId=388) OR (a.articleSearch='ECZFR000' AND a.supplierId=6355) OR (a.articleSearch='18108007' AND a.supplierId=4686) OR (a.articleSearch='QF09A00093' AND a.supplierId=4339) OR ( a.articleSearch IN ('XIC8044', 'XIC8048', 'XIC8062', 'XIC8169', 'XIC8049', 'XIC8053', 'XIC8061', 'XIC8078') AND a.supplierId=57) OR (a.articleSearch='689C0007' AND a.supplierId=6358) OR ( a.articleSearch IN ('8530069', '8530134', '8530136', '8530138', '8530139', '8530302A2', '8530302AS', '8530447') AND a.supplierId=27) OR (a.articleSearch='SKCO0070006' AND a.supplierId=6357) OR ( a.articleSearch IN ('SC1076', 'SC1083') AND a.supplierId=4771) OR ( a.articleSearch IN ('6100007SX', '6100233SX') AND a.supplierId=4595) OR (a.articleSearch='880049' AND a.supplierId=6691) OR ( a.articleSearch IN ('50921569', '50926869', '50936999') AND a.supplierId=151) OR ( a.articleSearch IN ('CL401', 'CL409') AND a.supplierId=356) OR ( a.articleSearch IN ('300065', '302104') AND a.supplierId=301) OR ( a.articleSearch IN ('886010006', '886016023') AND a.supplierId=108) OR ( a.articleSearch IN ('078905101C', '30713416', '6N0905104') AND a.supplierId=4999) OR ( a.articleSearch IN ('245025', '245139', '245193', '245781', '245120', '245161') AND a.supplierId=21) OR (a.articleSearch='D46020' AND a.supplierId=4836) OR ( a.articleSearch IN ('V10700010', 'V25700001', 'V257000011', 'V25700008', 'V25700010', 'V10700009') AND a.supplierId=183) OR ( a.articleSearch IN ('CFD478', 'CFD497', 'CFD501', 'CUF714OE') AND a.supplierId=4627) OR ( a.articleSearch IN ('9201013', '9201015') AND a.supplierId=303) OR ( a.articleSearch IN ('220830029', '220830373', '220830660') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1012150', 'WG1012437', 'WG1032312', 'WG1054732', 'WG1430410', 'WG1443908', 'WG1487408', 'WG1487419', 'WG1487459', 'WG1496491', 'WG1496529', 'WG1496530', 'WG1496532', 'WG1496720', 'WG1496721', 'WG1498177', 'WG1498179', 'WG1778908', 'WG1794341', 'WG1940713', 'WG1965345') AND a.supplierId=4832) OR ( a.articleSearch IN ('30313', '350393', '350469', '350635') AND a.supplierId=6347)An internal server error occurred.