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 ('13075700', '13121900', '13002000', '13002100', '13002700', '13121600', '75000400') AND a.supplierId=139) OR ( a.articleSearch IN ('915213', '815187', '006552', '006553', '030792', '030793', '036163', '036164', '049930', '216910', '216919', '527290', '527291', '610020', '625760') AND a.supplierId=10) OR ( a.articleSearch IN ('0256022', '0356001', '0356003', '0356049', '1952801') AND a.supplierId=237) OR ( a.articleSearch IN ('110933', '110833', '411001', '413018', '511031') AND a.supplierId=367) OR ( a.articleSearch IN ('X5163801', '703141410', 'B3276700', 'B3706300', 'S3276800', 'X0374701', 'X5194701', 'X5543101', 'X8140901') AND a.supplierId=88) OR ( a.articleSearch IN ('HR397', 'HR397T', 'JC152', 'JD600', 'JD170', 'JD606') AND a.supplierId=113) OR ( a.articleSearch IN ('703141410', '712878110', '712789820', '712818620', '713195700', '013115701', '083141401', '083753901', '702843700', '703141420', '712845100') AND a.supplierId=9) OR ( a.articleSearch IN ('51816', '59797') AND a.supplierId=6558) OR (a.articleSearch='DI1032' AND a.supplierId=4737) OR ( a.articleSearch IN ('190000710', '190003510', '190019810') AND a.supplierId=323) OR ( a.articleSearch IN ('KCA015', 'KCA016', 'KCA040') AND a.supplierId=4464) OR ( a.articleSearch IN ('BGSILC', 'CK1515', 'CK1519', 'CK1558', 'CK1591', 'CK4562', 'CK8399', 'HN4334', 'HN4338', 'HN4339', 'HN4359', 'MG4557', 'MG4558', 'MG6315', 'MG9304') AND a.supplierId=478) OR (a.articleSearch='037253039D' AND a.supplierId=6366) OR ( a.articleSearch IN ('KCC015', 'KCC016', 'KCC040') AND a.supplierId=4463) OR (a.articleSearch='011093' AND a.supplierId=405) OR ( a.articleSearch IN ('424830H', '428435P', '460067P', '460068P', '460448H') AND a.supplierId=140) OR (a.articleSearch='DRM0882' AND a.supplierId=6534) OR (a.articleSearch='116290' AND a.supplierId=355) OR ( a.articleSearch IN ('RS0069', 'TM0032') AND a.supplierId=4514) OR ( a.articleSearch IN ('EM240', 'IM534') AND a.supplierId=267) OR (a.articleSearch='2780' AND a.supplierId=4834) OR (a.articleSearch='102622' AND a.supplierId=101) OR ( a.articleSearch IN ('3102655500', '3102655610', '3102845400', '3102891800', '3400042000') AND a.supplierId=60) OR ( a.articleSearch IN ('1847455104', '2147168610', '2147566715', '2147635400') AND a.supplierId=4257) OR ( a.articleSearch IN ('83111222', '83111935') AND a.supplierId=118) OR ( a.articleSearch IN ('1119601300', '1119604500', '1119607500') AND a.supplierId=268) OR (a.articleSearch='9600480' AND a.supplierId=78) OR ( a.articleSearch IN ('KCD015', 'KCD016', 'KCD040') AND a.supplierId=4462) OR (a.articleSearch='0540020' AND a.supplierId=4546) OR ( a.articleSearch IN ('SG0385', 'SG0733') AND a.supplierId=4600) OR ( a.articleSearch IN ('MGW152', 'MGW170', 'MGW265', 'MGW600') AND a.supplierId=6420) OR ( a.articleSearch IN ('02313', '11551', '20260') AND a.supplierId=4683) OR ( a.articleSearch IN ('PG51114', 'PG52005', 'PG52006', 'PG52012') AND a.supplierId=4558) OR ( a.articleSearch IN ('1000001SX', '1126000SX', '1126005SX', '1126012SX', '1126041SX', '1129017SX') AND a.supplierId=4595) OR (a.articleSearch='30102622' AND a.supplierId=151) OR ( a.articleSearch IN ('100318', '100320', '100738', '108304') AND a.supplierId=301) OR (a.articleSearch='038103085' AND a.supplierId=4999) OR ( a.articleSearch IN ('V101846', 'V105091', 'V400892') AND a.supplierId=183) OR ( a.articleSearch IN ('11030366501', '11031354201', '11290159101', '11290373301', '11290373401', '12530157801', '52531394301') AND a.supplierId=4346) OR ( a.articleSearch IN ('WG1006795', 'WG1007706', 'WG1007893', '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='311493' AND a.supplierId=6347) OR ( a.articleSearch IN ('ZVBZ0048', 'ZVVY008') AND a.supplierId=6274)An internal server error occurred.