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 ('1987301026', '1987301033', '1987301052', '1987302204', '1987302206', '1987302211', '1987302281', '1987302284', '1987302286', '1987302810', '1987302815', '1987302819') AND a.supplierId=30) OR ( a.articleSearch IN ('171253000', '171254000', '171713000', '171773000', '171774000', '171893000', '173143000', '176353000', '681613000', '681633000') AND a.supplierId=485) OR ( a.articleSearch IN ('12036B2', '12036CP', '12036WVUB2', '12498B2', '12498CP', '12498LLECOB2', '12498LLECOCP', '12498VPB2', '12821B2', '12821CP', '12821LLECOB2', '12844B2', '12844CP', '12866B2', '12866CP', '12961B2', '12961CP', '12961LLECOB2', '12961LLECOCP', '12961WVUB2', '12961XVPB2', '12036BVCP', '12036WHVB2', '12396NAB2', '12396NACP', '12496LLECOCP', '12496NAB2', '12496NACP', '12496SVB2', '12496SVS2', '12499B2', '12499CP', '12499EDBW', '12499LLECOB2', '12499LLECOCP', '12499VPB2', '12594B2', '12594CP', '12821', '12821LLECOCP', '12822CP', '12844', '12854CP', '12961BVUB2', '12961EDCP', '12961NBVB2', '13844B2', '13844CP') AND a.supplierId=75) OR ( a.articleSearch IN ('032101', '032201', '032211') AND a.supplierId=21) OR ( a.articleSearch IN ('00305848', '03833890', '03833891', '042243150515', '4411403LUE', '4411403RUE', 'L044700002LED') AND a.supplierId=4657) OR ( a.articleSearch IN ('91347', '91348', '91356', '91360') AND a.supplierId=4495) OR ( a.articleSearch IN ('150106110', '150111310', '150111710', '150111910', '150112410') AND a.supplierId=323) OR ( a.articleSearch IN ('1321', '1341', '1401', '1621', '1711', '1712', '1715', '1896') AND a.supplierId=4995) OR (a.articleSearch='BSG25805028' AND a.supplierId=4455) OR ( a.articleSearch IN ('2205178', '9500080', '9500081', 'LID10046', 'LID10047', 'LID10048', 'LID10050', 'LID10057', 'LID10059') AND a.supplierId=253) OR ( a.articleSearch IN ('89410872502', '89410872602') AND a.supplierId=4353) OR ( a.articleSearch IN ('725379', '978120', '978125', '978129', '978130', '978131', '978139', '978165') AND a.supplierId=355) OR ( a.articleSearch IN ('EB0207SB', 'EB0207SC', 'EB0207TB', 'EB0207TC', 'EB0208TC', 'EB0239SB', 'EB0239SC', 'EB0239TB', 'EB0239TC', 'EB0240TC', 'EB0382SB', 'EB0382SC', 'EB0382TB', 'EB0382TC', 'EB0388TC') AND a.supplierId=4344) OR ( a.articleSearch IN ('1616430780', '1616431080', '1616431280', '1616431580') AND a.supplierId=4391) OR (a.articleSearch='22063' AND a.supplierId=101) OR ( a.articleSearch IN ('B1000', 'B1100', 'B1500') AND a.supplierId=271) OR ( a.articleSearch IN ('2BM003647021', '8GA002071121', '8GA002071123', '8GA002071371', '8GA002073121', '8GA002073123', '8GA002073137', '8GA002073271', '8GA002073281', '8GA006841121', '8GA006841123', '8GH007643121', '8GM002091131', '8GM002091181', '8GM002092121', '8GM002092123', '8GM002092137', '8GM002092171', '8GP003594121', '8GP003594123', '8GP003594125', '8GP003594261', '8GP003594541', '8GP003594543') AND a.supplierId=4734) OR (a.articleSearch='89901140' AND a.supplierId=72) OR (a.articleSearch='1195901400' AND a.supplierId=268) OR ( a.articleSearch IN ('20970910', '20970913') AND a.supplierId=78) OR ( a.articleSearch IN ('LLB207', 'LLB207LLPX2', 'LLB207PX2', 'LLB207T', 'LLB239', 'LLB239LLPX2', 'LLB239PX2', 'LLB239T', 'LLB382', 'LLB382LLPX2', 'LLB382PX2', 'LLB382T') AND a.supplierId=4501) OR ( a.articleSearch IN ('004007100000', '008506100000', '009418100000', '715102108120') AND a.supplierId=4723) OR ( a.articleSearch IN ('L510', 'L551', 'L710', 'L751') AND a.supplierId=6270) OR ( a.articleSearch IN ('780020SET', '780021SET', '780022', '780022SET', '780024SET', '780027', '780032SET', '780033', '780033SET', '780060') AND a.supplierId=403) OR ( a.articleSearch IN ('VBU207', 'VBU382', 'VBU501', 'VBU501B') AND a.supplierId=4564) OR (a.articleSearch='02918' AND a.supplierId=4683) OR ( a.articleSearch IN ('PL3501', 'PLG18125', 'PLS2521', 'PLT10125', 'PLT3502') AND a.supplierId=4558) 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', '0961847', '0961855', '0961859') AND a.supplierId=4623) OR ( a.articleSearch IN ('202068', '202075', '202099', '202112') AND a.supplierId=225) OR ( a.articleSearch IN ('1269', '2010', '2014', '2525', '2525L', '5221', '5221L', '5236', '751506') AND a.supplierId=45) OR ( a.articleSearch IN ('612000BLSX', '612000BSX', '612020SX', '9939029SX', '9939038SX', '9939039SX', '9939040SX', '9939045SX', '9939046SX', '9939047SX', '9939053SX', '9939057SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('10922063', '30926966', '99906912', '99906962', '99906974') AND a.supplierId=151) OR ( a.articleSearch IN ('B17101', 'B52101', 'B52201', 'B55101', 'B65201', 'B85301') AND a.supplierId=356) OR ( a.articleSearch IN ('104488', '104491', '104492', '104493') AND a.supplierId=301) OR ( a.articleSearch IN ('8858109', '8858114', '8858117', '8858118', '8858123', '8858124') 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', 'V99840003', 'V99840004', 'V99840008', 'V99840009') AND a.supplierId=183)An internal server error occurred.