SELECT DISTINCT 
    m.manufacturerName AS cross_brand, 
    ao.manufacturerId, 
    ao.oemSearch, 
    ao.oemnumber, 
    ps.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='BSG65525007' AND a.supplierId=4455) OR ( a.articleSearch IN ('TSP0225532', 'TSP0225667') AND a.supplierId=89) OR ( a.articleSearch IN ('DCN20009', 'DCN20011') AND a.supplierId=4760) OR ( a.articleSearch IN ('393400', '350650') AND a.supplierId=6207) OR ( a.articleSearch IN ('LRAC21165', 'LRAC2129') AND a.supplierId=4707) OR (a.articleSearch='ACCB008' AND a.supplierId=6495) OR ( a.articleSearch IN ('94767', '94807') AND a.supplierId=123) OR ( a.articleSearch IN ('35555', '35554') AND a.supplierId=205) OR ( a.articleSearch IN ('PRS1197', 'PRS1197KOR', 'PRS1338') AND a.supplierId=4558) OR ( a.articleSearch IN ('1045003SX', '1045019SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('0370160023', '0370160024') AND a.supplierId=4657) OR (a.articleSearch='19347487' AND a.supplierId=6307) OR ( a.articleSearch IN ('300617', '300618') AND a.supplierId=4654) OR ( a.articleSearch IN ('43134', '43145') AND a.supplierId=422) OR ( a.articleSearch IN ('152015N', '152016N') AND a.supplierId=80) OR (a.articleSearch='32169' AND a.supplierId=4576) OR (a.articleSearch='PAL120003' AND a.supplierId=442) OR (a.articleSearch='30311505CP' AND a.supplierId=4656) OR ( a.articleSearch IN ('103828', '103829') AND a.supplierId=4688) OR (a.articleSearch='160091410' AND a.supplierId=323) OR ( a.articleSearch IN ('OL5366D', 'OL5367D', 'OL5366', 'OL5367') AND a.supplierId=247) OR ( a.articleSearch IN ('1223490', '1223490X', '1223508', '1223508X') AND a.supplierId=4553) OR ( a.articleSearch IN ('DCC1724', 'DCC1725', '8180600', '8180601') AND a.supplierId=253) OR (a.articleSearch='667056' AND a.supplierId=234) OR (a.articleSearch='1610159580' AND a.supplierId=4391) OR ( a.articleSearch IN ('08072020', '08072021') AND a.supplierId=313) OR ( a.articleSearch IN ('260452', '261026') AND a.supplierId=4819) OR ( a.articleSearch IN ('8FC351301761', '8FC351301764', '8FC351301771', '8FC351301774') AND a.supplierId=4734) OR ( a.articleSearch IN ('720M58', '720M60', 'M7200970') AND a.supplierId=296) OR (a.articleSearch='5052305367' AND a.supplierId=78) OR ( a.articleSearch IN ('0221595', '0221624') AND a.supplierId=4546) OR ( a.articleSearch IN ('350203255000', '350203257000', '350203759000') AND a.supplierId=4723) OR ( a.articleSearch IN ('AC377000P', 'AC377001S', 'AC378000P', 'AC378000S') AND a.supplierId=287) OR ( a.articleSearch IN ('AC830013', 'AC898200') AND a.supplierId=403) OR ( a.articleSearch IN ('DCN20009', 'DCN20011') AND a.supplierId=440) OR ( a.articleSearch IN ('CCSPL016', 'CCSPL017') AND a.supplierId=6355) OR ( a.articleSearch IN ('PL5211', 'PL5644') AND a.supplierId=6542) OR ( a.articleSearch IN ('7110378', '7110584') AND a.supplierId=4543) OR ( a.articleSearch IN ('OL5366D', 'OL5367D', 'OP410C001', 'OP410C002', 'OL5366', 'OL5367') AND a.supplierId=340) OR (a.articleSearch='PR5052C1' AND a.supplierId=4686) OR ( a.articleSearch IN ('448C0008', '448C0141') AND a.supplierId=6358) OR ( a.articleSearch IN ('SKCD0110007', 'SKCD0110070') AND a.supplierId=6357) OR ( a.articleSearch IN ('KTT110058', 'KTT110145') AND a.supplierId=4466) OR ( a.articleSearch IN ('817839', '817846') AND a.supplierId=21) OR ( a.articleSearch IN ('37005366', '37005367') AND a.supplierId=36) OR ( a.articleSearch IN ('V40620014', 'V40620015') AND a.supplierId=183) OR ( a.articleSearch IN ('8880400363', '8880400482') AND a.supplierId=97) OR ( a.articleSearch IN ('WG1917308', 'WG1917310', 'WG2016666', 'WG2041719', 'WG2041795', 'WG2160979', 'WG2160980') AND a.supplierId=4832) OR (a.articleSearch='580107' AND a.supplierId=6347) OR ( a.articleSearch IN ('MK3016', 'MK3037') AND a.supplierId=4894)An internal server error occurred.