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 ('MG3729', 'MG4701', 'MG3768', 'MG7580', 'BGSILC', 'CK1515', 'CK1519', 'CK1558', 'CK1591', 'CK4562', 'CK8399') AND a.supplierId=478) OR ( a.articleSearch IN ('236320', '246150', '007870', '477640', '006552', '006553', '030792', '030793', '036163', '036164', '216910', '216919', '527290', '527291', '610020', '736650') AND a.supplierId=10) OR ( a.articleSearch IN ('0256032', '0256085', '0356017', '1952801') AND a.supplierId=237) OR ( a.articleSearch IN ('1119609900', '1119609100', '1119608700', '1119612800') AND a.supplierId=268) OR ( a.articleSearch IN ('PG52081', 'PG60173') AND a.supplierId=4558) OR ( a.articleSearch IN ('HR397', 'HR397T', 'JD5815', 'JD6067', 'JD6109') AND a.supplierId=113) OR ( a.articleSearch IN ('703141410', '711051000', '713892900', '714050700', '713742200', '713842800', '013115701', '083141401', '083753901', '702843700', '703141420', '713372400') AND a.supplierId=9) OR ( a.articleSearch IN ('11291780101', '22531397301', '11030366501', '11031354201', '22531567301') AND a.supplierId=4346) OR (a.articleSearch='59797' AND a.supplierId=6558) OR ( a.articleSearch IN ('13198500', '13225800', '13236900', '13237200', '75000400') AND a.supplierId=139) OR (a.articleSearch='DI1032' AND a.supplierId=4737) OR ( a.articleSearch IN ('MG969', 'MG978') AND a.supplierId=6362) OR ( a.articleSearch IN ('KCA015', 'KCA016', 'KCA040') AND a.supplierId=4464) OR ( a.articleSearch IN ('KCC015', 'KCC016', 'KCC040') AND a.supplierId=4463) OR (a.articleSearch='011093' AND a.supplierId=405) OR ( a.articleSearch IN ('026479P', '428435P', '49421976', '49422052') AND a.supplierId=140) OR ( a.articleSearch IN ('DRM076', 'DRM0846', 'DRM0883') AND a.supplierId=6534) OR (a.articleSearch='116290' AND a.supplierId=355) OR (a.articleSearch='RS0069' AND a.supplierId=4514) OR ( a.articleSearch IN ('411017', '411028', '511006') AND a.supplierId=367) OR ( a.articleSearch IN ('EM1360', 'EM1662', 'IM1745') AND a.supplierId=267) OR ( a.articleSearch IN ('45218', '45747') AND a.supplierId=101) OR ( a.articleSearch IN ('703141410', 'B3276700', 'B3706300', 'S3276800', 'X5947401', 'X5949601', 'X8168501', 'X8988401', 'X9006301') AND a.supplierId=88) OR ( a.articleSearch IN ('3103023500', '3400042000') AND a.supplierId=60) OR ( a.articleSearch IN ('1842208300', '2035675400', '2042208300') AND a.supplierId=4257) OR ( a.articleSearch IN ('83113930', '83113943') AND a.supplierId=118) OR (a.articleSearch='9600480' AND a.supplierId=78) OR ( a.articleSearch IN ('KCD015', 'KCD016', 'KCD040') AND a.supplierId=4462) OR ( a.articleSearch IN ('SG0092', 'SG0404') AND a.supplierId=4600) OR (a.articleSearch='MRP2B03' AND a.supplierId=4773) OR ( a.articleSearch IN ('18499', '27187') AND a.supplierId=4683) OR (a.articleSearch='27G0002' AND a.supplierId=6358) OR (a.articleSearch='SKGE0690001' AND a.supplierId=6357) OR ( a.articleSearch IN ('1000001SX', '1129017SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('30945218', '30945747') AND a.supplierId=151) OR ( a.articleSearch IN ('111927', '112960', '113887', '113937') AND a.supplierId=301) OR (a.articleSearch='038103085' AND a.supplierId=4999) OR (a.articleSearch='V400892' AND a.supplierId=183) OR ( a.articleSearch IN ('WG1007922', 'WG1103724', 'WG1103725', 'WG1140888', 'WG1142752', 'WG1181243', 'WG1230494', 'WG1245938', 'WG1343336', 'WG1343342', 'WG1497691', 'WG1737377', 'WG1988941', 'WG2046918', 'WG2047308', 'WG2047310', 'WG2047980', 'WG2059068', 'WG1343344') AND a.supplierId=4832) OR ( a.articleSearch IN ('ZVVK017', 'ZVVK019') AND a.supplierId=6274)An internal server error occurred.