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 ('1830278', '73278', '73355', '1830355') AND a.supplierId=4005) OR ( a.articleSearch IN ('PE12002', 'PE12013', 'PE13166') AND a.supplierId=4558) OR (a.articleSearch='81786' AND a.supplierId=4598) OR (a.articleSearch='12007004' AND a.supplierId=4657) OR ( a.articleSearch IN ('51169', '56481', '56491', '56568') AND a.supplierId=6558) OR ( a.articleSearch IN ('16013800', '16015400', '16075500') AND a.supplierId=139) OR (a.articleSearch='751013N' AND a.supplierId=80) OR (a.articleSearch='XS2607' AND a.supplierId=4975) OR (a.articleSearch='105557' AND a.supplierId=4495) OR ( a.articleSearch IN ('AS2004', 'AS3009', 'AS3031') AND a.supplierId=4737) OR ( a.articleSearch IN ('150011110', '190013310') AND a.supplierId=323) OR (a.articleSearch='PES0095' AND a.supplierId=4337) OR ( a.articleSearch IN ('0011021301', '0023001087') AND a.supplierId=4995) OR (a.articleSearch='ST114' AND a.supplierId=6444) OR (a.articleSearch='OR5303' AND a.supplierId=478) OR ( a.articleSearch IN ('BTS3028', 'BTS3080') AND a.supplierId=475) OR ( a.articleSearch IN ('B11960', 'B11978', 'B13146', 'B18252', 'B18284') AND a.supplierId=4815) OR ( a.articleSearch IN ('WS2607', 'WS3070') AND a.supplierId=215) OR ( a.articleSearch IN ('755123', '955245') AND a.supplierId=405) OR ( a.articleSearch IN ('CST9330', 'CST9527', 'CST9538', 'CST9979') AND a.supplierId=4334) OR ( a.articleSearch IN ('TS10266', 'TS10278') AND a.supplierId=89) OR (a.articleSearch='INJSWS002N' AND a.supplierId=4882) OR (a.articleSearch='DS1017' AND a.supplierId=471) OR (a.articleSearch='468269' AND a.supplierId=355) OR ( a.articleSearch IN ('295111', '295166', '295187') AND a.supplierId=211) OR (a.articleSearch='074290' AND a.supplierId=10) OR ( a.articleSearch IN ('EV0002', 'EV0302', 'XTS7702', 'XTS7793') AND a.supplierId=4344) OR ( a.articleSearch IN ('330546', '331006', '551343A') AND a.supplierId=234) OR ( a.articleSearch IN ('06A919501', '8Z0820535') AND a.supplierId=6367) OR ( a.articleSearch IN ('33517', '33784', '33891') AND a.supplierId=240) OR (a.articleSearch='15891' AND a.supplierId=4834) OR ( a.articleSearch IN ('106571', '12409', '174268', '29318', '33911') AND a.supplierId=101) OR (a.articleSearch='TSN22736' AND a.supplierId=271) OR ( a.articleSearch IN ('FTS3028', 'FTS3080') AND a.supplierId=407) OR ( a.articleSearch IN ('82330', '82527', '82979') AND a.supplierId=441) OR (a.articleSearch='FSE51169' AND a.supplierId=236) OR (a.articleSearch='2940053' AND a.supplierId=313) OR (a.articleSearch='CSS0001' AND a.supplierId=6443) OR (a.articleSearch='120000034' AND a.supplierId=4524) OR (a.articleSearch='6PT009309331' AND a.supplierId=4734) OR ( a.articleSearch IN ('70511539', '70511543') AND a.supplierId=72) OR ( a.articleSearch IN ('7472128', '7472422', '7472709') AND a.supplierId=341) OR ( a.articleSearch IN ('55106', '55591', '55756') AND a.supplierId=269) OR (a.articleSearch='SD12312' AND a.supplierId=6387) OR ( a.articleSearch IN ('1119606800', '1193101400', '1193102700', '1197400200') AND a.supplierId=268) OR (a.articleSearch='ECT5503' AND a.supplierId=201) OR (a.articleSearch='862610042' AND a.supplierId=286) OR ( a.articleSearch IN ('530278', '530355') AND a.supplierId=4006) OR ( a.articleSearch IN ('LETS001', 'LWS053', 'LWS135') AND a.supplierId=6518) OR ( a.articleSearch IN ('SNB1321', 'SNB1451', 'SNB964') AND a.supplierId=4501) OR ( a.articleSearch IN ('171916011110', '171916011920') AND a.supplierId=4723) OR (a.articleSearch='88800' AND a.supplierId=133) OR ( a.articleSearch IN ('210140', '210339') AND a.supplierId=403) OR ( a.articleSearch IN ('EPS1830278', 'EPS1830355') AND a.supplierId=4773) OR ( a.articleSearch IN ('82128', '82422', '82709') AND a.supplierId=244) OR ( a.articleSearch IN ('02110', '50288') AND a.supplierId=4664) OR ( a.articleSearch IN ('0905022', '0905451', '0905466') AND a.supplierId=94) OR ( a.articleSearch IN ('1001210095', '1009190032', '1148210001') AND a.supplierId=144) OR ( a.articleSearch IN ('LVAT140', 'LVCT380', 'VCT131') AND a.supplierId=4564) OR ( a.articleSearch IN ('4092', '4259') AND a.supplierId=320) OR (a.articleSearch='N5625008' AND a.supplierId=248) OR ( a.articleSearch IN ('ECTAU001', 'ECTVW000') AND a.supplierId=6355) OR ( a.articleSearch IN ('AQ22791', 'AQ23851') AND a.supplierId=129) OR ( a.articleSearch IN ('01308', '20724', '21686') AND a.supplierId=4683) OR (a.articleSearch='QF25A00019' AND a.supplierId=4339) OR (a.articleSearch='XTT159' AND a.supplierId=57) OR ( a.articleSearch IN ('1186S0004', '830C0019') AND a.supplierId=6358) OR (a.articleSearch='0963689' AND a.supplierId=4623) OR (a.articleSearch='3256001' AND a.supplierId=260) OR (a.articleSearch='E534406' AND a.supplierId=6377) OR ( a.articleSearch IN ('82330', '82527', '82979') AND a.supplierId=27) OR ( a.articleSearch IN ('SKCTS0850018', 'SKSE1370003') AND a.supplierId=6357) OR ( a.articleSearch IN ('T402110', 'T450288') AND a.supplierId=4667) OR ( a.articleSearch IN ('0604007SX', '0604134SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('30106571', '30220002', '30929318', '30933911', '33102105') AND a.supplierId=151) OR (a.articleSearch='KTT070001' AND a.supplierId=4466) OR ( a.articleSearch IN ('104529', '109896', '113346', '115879') AND a.supplierId=301) OR (a.articleSearch='463699' AND a.supplierId=4970) OR (a.articleSearch='862610042' AND a.supplierId=108) OR ( a.articleSearch IN ('0742077', '0742097') AND a.supplierId=209) OR ( a.articleSearch IN ('032121142', '037121132E', '06A919501A', '8Z0820535') AND a.supplierId=4999) OR (a.articleSearch='700105' AND a.supplierId=21) OR ( a.articleSearch IN ('V10721114', 'V10721361', 'V10990001', 'V15992114', 'V99990001') AND a.supplierId=183) OR ( a.articleSearch IN ('11211792101', '11211841801', '88201765301', '93160080701', '99190078301', '99190079801', '99191539701') AND a.supplierId=4346) OR (a.articleSearch='2111056' AND a.supplierId=303) OR ( a.articleSearch IN ('410580087', '410580194', '410580341') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1407325', 'WG1428761', 'WG1492521', 'WG1499623', 'WG1499634', 'WG1748994', 'WG2151461') AND a.supplierId=4832) OR ( a.articleSearch IN ('12021', '320489', '350401') AND a.supplierId=6347)An internal server error occurred.