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 IN ('1616430780', '1616431580') AND a.supplierId=4391) OR ( a.articleSearch IN ('171253000', '171254000', '171773000', '171774000', '171893000') AND a.supplierId=485) OR ( a.articleSearch IN ('N239', 'N23902B', 'N264', 'N26402B', 'N501', 'N50102B', 'N504', 'NT1061CW02B') AND a.supplierId=4671) OR ( a.articleSearch IN ('2821', '282102B', '2825', '282502B', '2825DRP02B', '2825DWP02B', '2825ULT', '2825ULT02B', '6411', '641102B', '6413', '6413DWP01B', '6418', '641802B', '6418ULT', '6418ULT02B') AND a.supplierId=67) OR ( a.articleSearch IN ('PLT10125', 'PL3501') AND a.supplierId=4558) OR ( a.articleSearch IN ('11961ULWX2', '127998000KX2', '12844B2', '12844CP', '12961B2', '12961CP', '12961LLECOB2', '12961LLECOCP', '12961WVUB2', '12961XVPB2', '12396NAB2', '12396NACP', '12844', '12854CP', '12961BVUB2', '12961EDCP', '12961NBVB2', '13844B2', '13844CP') AND a.supplierId=75) OR ( a.articleSearch IN ('032209', '032211', '032217') AND a.supplierId=21) OR ( a.articleSearch IN ('00305848', '03833890', '03833891', '042243150515', '4411403LUE', '4411403RUE', 'L044700002LED') AND a.supplierId=4657) OR ( a.articleSearch IN ('91347', '91360') AND a.supplierId=4495) OR ( a.articleSearch IN ('150111710', '150111910') AND a.supplierId=323) OR ( a.articleSearch IN ('1621', '1711', '1712', '1715') AND a.supplierId=4995) OR (a.articleSearch='BSG25805028' AND a.supplierId=4455) OR (a.articleSearch='2205178' AND a.supplierId=253) OR ( a.articleSearch IN ('89410872502', '89410872602') AND a.supplierId=4353) OR ( a.articleSearch IN ('978129', '978139', '978165') AND a.supplierId=355) OR ( a.articleSearch IN ('EB0239SB', 'EB0239SC', 'EB0239TB', 'EB0239TC', 'EB0240TC') AND a.supplierId=4344) OR (a.articleSearch='B1000' AND a.supplierId=271) OR ( a.articleSearch IN ('2BM003647021', '8GM002092121', '8GM002092123', '8GM002092137', '8GM002092171', '8GP003594121', '8GP003594123', '8GP003594125', '8GP003594261', '8GP003594541', '8GP003594543') AND a.supplierId=4734) OR ( a.articleSearch IN ('20970910', '20970913') AND a.supplierId=78) OR ( a.articleSearch IN ('LLB239', 'LLB239LLPX2', 'LLB239PX2', 'LLB239T') AND a.supplierId=4501) OR ( a.articleSearch IN ('009418100000', '715102108120') AND a.supplierId=4723) OR ( a.articleSearch IN ('L510', 'L710') AND a.supplierId=6270) OR ( a.articleSearch IN ('780032SET', '780033', '780033SET', '780060') AND a.supplierId=403) OR ( a.articleSearch IN ('VBU501', 'VBU501B') AND a.supplierId=4564) OR ( a.articleSearch IN ('AD0134139', 'AD0164039', 'AD0174139', 'VG0284039', 'VG0324039', 'VG0324140', 'VG0504139', 'AD0174039', 'AD0164139', 'SK0204139', 'SK3204139', 'VW0284039', 'VW0324039', 'VW0324140', 'VW0504139') AND a.supplierId=340) OR ( a.articleSearch IN ('0961846', '0961859') AND a.supplierId=4623) OR ( a.articleSearch IN ('202099', '202112') AND a.supplierId=225) OR ( a.articleSearch IN ('5221', '5221L', '5236', '751506') AND a.supplierId=45) OR ( a.articleSearch IN ('9939029SX', '9939035SX', '9939045SX', '9939047SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('30926966', '99906962', '99906974') AND a.supplierId=151) OR ( a.articleSearch IN ('B65201', 'B85301') AND a.supplierId=356) OR (a.articleSearch='104492' AND a.supplierId=301) OR ( a.articleSearch IN ('8858118', '8858123') AND a.supplierId=209) OR ( a.articleSearch IN ('1811007019', '1811007119', '185327052') AND a.supplierId=61) OR (a.articleSearch='5812914' AND a.supplierId=36) OR ( a.articleSearch IN ('V99840001', 'V99840008') AND a.supplierId=183)An internal server error occurred.