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 ('202075', '202112') AND a.supplierId=225) OR ( a.articleSearch IN ('1987301026', '1987301033', '1987301052', '1987301059', '1987302203', '1987302204', '1987302206', '1987302211', '1987302281', '1987302284', '1987302286', '1987302810', '1987302815', '1987302816', '1987302819') AND a.supplierId=30) OR ( a.articleSearch IN ('1616431080', '1616431280', '1616431580') AND a.supplierId=4391) OR ( a.articleSearch IN ('171713000', '171773000', '171774000', '171893000', '173113000', '173114000', '173143000', '176353000') AND a.supplierId=485) OR ( a.articleSearch IN ('N207', 'N20702B', 'N245', 'N24502B', 'N264', 'N26402B', 'N382', 'N38202B', 'N501', 'N50102B') AND a.supplierId=4671) OR ( a.articleSearch IN ('2825', '282502B', '2825ULT', '2825ULT02B', '5007', '500702B', '5007ULT', '5007ULT02B', '5008', '500802B', '5008ULT', '5008ULT02B', '7506', '750602B', '7506ULT', '7506ULT02B') AND a.supplierId=67) OR ( a.articleSearch IN ('PL4402', 'PLG181210', 'PLG18125', 'PLS2521', 'PLT10125') AND a.supplierId=4558) OR ( a.articleSearch IN ('12498B2', '12498CP', '12498LLECOB2', '12498LLECOCP', '12498VPB2', '12814B2', '12814CP', '12821B2', '12821CP', '12821LLECOB2', '12866B2', '12866CP', '12961B2', '12961CP', '12961LLECOB2', '12961LLECOCP', '12961WVUB2', '12961XVPB2', '12594B2', '12594CP', '12821', '12821LLECOCP', '12822CP', '12961BVUB2', '12961EDCP', '12961NBVB2') AND a.supplierId=75) OR ( a.articleSearch IN ('032101', '032109', '032201', '032211', '032217', '032219', '032221', '032223') AND a.supplierId=21) OR (a.articleSearch='LP1064' AND a.supplierId=4894) OR ( a.articleSearch IN ('91348', '91360', '91363') AND a.supplierId=4495) OR ( a.articleSearch IN ('150106110', '150111310', '150111710') AND a.supplierId=323) OR ( a.articleSearch IN ('1321', '1401', '1621') AND a.supplierId=4995) OR ( a.articleSearch IN ('9500080', 'LID10046', 'LID10047', 'LID10048') AND a.supplierId=253) OR ( a.articleSearch IN ('89410872502', '89410872602') AND a.supplierId=4353) OR ( a.articleSearch IN ('725379', '978131', '978139') AND a.supplierId=355) OR ( a.articleSearch IN ('8GA002071121', '8GA002071123', '8GA002073121', '8GA002073123', '8GA002073137', '8GP003594121', '8GP003594123', '8GP003594125') AND a.supplierId=4734) OR (a.articleSearch='89901140' AND a.supplierId=72) OR (a.articleSearch='1195901400' AND a.supplierId=268) OR ( a.articleSearch IN ('VBU207', 'VBU382', 'VBU501') AND a.supplierId=4564) OR (a.articleSearch='02918' AND a.supplierId=4683) OR ( a.articleSearch IN ('AD0134139', 'AD0164039', 'AD0174139', 'VG0304303', 'VG0324039', 'VG0324103', 'VG0324104', 'VG0324140', 'VG0504139', 'VG9504054', 'VG9504154', 'AD0174039', 'AD0164139', 'SK0204139', 'SK3204139', 'VW0304303', 'VW0324039', 'VW0324103', 'VW0324104', 'VW0324140', 'VW0504139', 'VW9504054', 'VW9504154') AND a.supplierId=340) OR ( a.articleSearch IN ('0961847', '0961859', '0961862') AND a.supplierId=4623) OR ( a.articleSearch IN ('2010', '2525', '2525L', '5221', '5221L', '751506') AND a.supplierId=45) OR ( a.articleSearch IN ('9939038SX', '9939045SX', '9939046SX') AND a.supplierId=4595) OR (a.articleSearch='99906912' AND a.supplierId=151) OR ( a.articleSearch IN ('B52101', 'B55101', 'B65201') AND a.supplierId=356) OR ( a.articleSearch IN ('104488', '104493') AND a.supplierId=301) OR ( a.articleSearch IN ('8858109', '8858117', '8858118') AND a.supplierId=209) OR ( a.articleSearch IN ('V99840001', 'V99840003', 'V99840004', 'V99840009') AND a.supplierId=183)An internal server error occurred.