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 ('RN1227DSET', 'RN1377DSET', 'RN1227', 'RN1377') AND a.supplierId=4682) OR ( a.articleSearch IN ('C3W039ABE', 'C4W015ABE') AND a.supplierId=4426) OR ( a.articleSearch IN ('17558', '17628') AND a.supplierId=206) OR ( a.articleSearch IN ('54878', '54879') AND a.supplierId=6558) OR ( a.articleSearch IN ('60000902', '60000902C', '61000927', '61000927C') AND a.supplierId=257) OR ( a.articleSearch IN ('24011201691', '24012501581', '24031201691', '24032501581') AND a.supplierId=3) OR ( a.articleSearch IN ('120015810', '120017510') AND a.supplierId=323) OR ( a.articleSearch IN ('BAR12169', 'BAR25158') AND a.supplierId=394) OR ( a.articleSearch IN ('BBD4383', 'BBD4546', 'BBD5167') AND a.supplierId=475) OR ( a.articleSearch IN ('CD7305V', 'CD7306S') AND a.supplierId=4872) OR ( a.articleSearch IN ('BSG90210020', 'BSG90210026') AND a.supplierId=4455) OR ( a.articleSearch IN ('562258CH', '562387CH') AND a.supplierId=43) OR ( a.articleSearch IN ('ADC1449V', 'AND6030') AND a.supplierId=421) OR (a.articleSearch='C210R0049' AND a.supplierId=6476) OR ( a.articleSearch IN ('1070100036', '1070110021') AND a.supplierId=4345) OR ( a.articleSearch IN ('DBD1305', 'DBD1306', 'DBD1306C') AND a.supplierId=4881) OR ( a.articleSearch IN ('DDF1305', 'DDF1305C', 'DDF1306', 'DDF1306C') AND a.supplierId=62) OR ( a.articleSearch IN ('FR0339', 'FR0487V') AND a.supplierId=4937) OR ( a.articleSearch IN ('BD5618', 'BD5619') AND a.supplierId=409) OR ( a.articleSearch IN ('B1G21201691', 'B1G22501581') AND a.supplierId=500) OR (a.articleSearch='GDB125158' AND a.supplierId=6529) OR ( a.articleSearch IN ('J3300810', 'J3310810') AND a.supplierId=72) OR ( a.articleSearch IN ('DI0902', 'DI0902C', 'DP0927', 'DP0927C') AND a.supplierId=156) OR ( a.articleSearch IN ('600902', '600902C', '610927', '610927C') AND a.supplierId=481) OR ( a.articleSearch IN ('1163109500', '1163205900') AND a.supplierId=268) OR ( a.articleSearch IN ('VAG178', 'VAG189', 'VAG322') AND a.supplierId=4935) OR ( a.articleSearch IN ('562258J', '562258JC', '562277J', '562387J', '562387JC', '562387JC1') AND a.supplierId=49) OR ( a.articleSearch IN ('1031005', '1032610') AND a.supplierId=185) OR ( a.articleSearch IN ('KBD4383', 'KBD5167') AND a.supplierId=4879) OR ( a.articleSearch IN ('25052Z', '25053Z') AND a.supplierId=387) OR ( a.articleSearch IN ('6040520', '6050270') AND a.supplierId=4546) OR ( a.articleSearch IN ('BN1198', 'BN1202') AND a.supplierId=4600) OR (a.articleSearch='360406050600' AND a.supplierId=4723) OR ( a.articleSearch IN ('25833', '25833C', '25841') AND a.supplierId=133) OR ( a.articleSearch IN ('201201690', '201201691', '202501580', '202501581', '202501582', '24011201691PCSMS', '24011201691PRPCSMS', '24011201691SESETMS', '24011201691SETMS', '24012501581PCSMS', '24012501581PRPCSMS', '24012501581SESETMS', '24012501581SETMS') AND a.supplierId=358) OR (a.articleSearch='191044' AND a.supplierId=403) OR ( a.articleSearch IN ('8710900000', '8710900060', '8710900080', '8710906060', '8710906880', '8710906980', '8710910000', '8710910060', '8710910080', '8710916060', '8710916880', '8710916980') AND a.supplierId=4899) OR ( a.articleSearch IN ('6110046', '6110072') AND a.supplierId=94) OR (a.articleSearch='K000387' AND a.supplierId=6495) OR ( a.articleSearch IN ('416101091', '416201120') AND a.supplierId=6376) OR ( a.articleSearch IN ('NBD1353', 'NBD1354', 'PBD1353', 'PBD1354') AND a.supplierId=190) OR (a.articleSearch='50101305' AND a.supplierId=4686) OR ( a.articleSearch IN ('82B0031', '82B0137', '82B2474') AND a.supplierId=6358) OR ( a.articleSearch IN ('RT1640', 'RT1640GL', 'RT1640GLT3', 'RT1640GLT5', 'RT1640GLT6', 'RT20312', 'RT20312GL', 'RT20312GLT3', 'RT20312GLT5', 'RT20312GLT6', 'RT20312HP', 'RT20312HPGL', 'RT20312HPGLT3', 'RT20312HPGLT5', 'RT20312HPGLT6') AND a.supplierId=4676) OR ( a.articleSearch IN ('DBB305V', 'DBB306S') AND a.supplierId=6331) OR ( a.articleSearch IN ('SKAD2030', 'SKBD0020141', 'SKBD0024616', 'SKBK1090008', 'SKBK1090019', 'SKBK1090045', 'SKBK1090281') AND a.supplierId=6357) OR ( a.articleSearch IN ('602047115VKSX', '602047115VSX', '602047116KSX', '602047116SX', '60204787VKSX') AND a.supplierId=4595) OR (a.articleSearch='755418' AND a.supplierId=6312) OR ( a.articleSearch IN ('DF180112', 'DF180121') AND a.supplierId=4772) OR ( a.articleSearch IN ('0735209', '0735216') AND a.supplierId=209) OR ( a.articleSearch IN ('V1040082', 'V1080085') AND a.supplierId=183) OR ( a.articleSearch IN ('WGR13051', 'WGR13061') AND a.supplierId=4498) OR ( a.articleSearch IN ('BS5016', 'BS5398') AND a.supplierId=4894) OR ( a.articleSearch IN ('100330020', '100330052', '100330053', '100331520', '100331552', '100331553') AND a.supplierId=86)An internal server error occurred.