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 ('94570', '94596', '94618') AND a.supplierId=244) OR ( a.articleSearch IN ('17745', '21303', '21305', '34767', '34769', '34770') AND a.supplierId=4683) OR ( a.articleSearch IN ('890010', '890019', '632200', '632201', '632000', '632003', '632002', '632015') AND a.supplierId=21) OR ( a.articleSearch IN ('12001005', '12001029', '12001050') AND a.supplierId=4657) OR ( a.articleSearch IN ('ASP015', 'ASP023', 'ASP040') AND a.supplierId=374) OR ( a.articleSearch IN ('55843', '56571', '56572') AND a.supplierId=6558) OR ( a.articleSearch IN ('210053710', '210059810') AND a.supplierId=323) OR ( a.articleSearch IN ('5902010020', '5902010037') AND a.supplierId=4555) OR ( a.articleSearch IN ('CSA5570', 'CSA5596', 'CSA5611', 'CSA5618', 'CSA5642') AND a.supplierId=4334) OR ( a.articleSearch IN ('566035A', '566079A', '566080A') AND a.supplierId=234) OR ( a.articleSearch IN ('28SKV015', '28SKV023', '28SKV040', '28SKV096', '28SKV902') AND a.supplierId=4969) OR ( a.articleSearch IN ('970044', '970048', '970098') AND a.supplierId=441) OR (a.articleSearch='925001' AND a.supplierId=4379) OR ( a.articleSearch IN ('SP041', 'SP048', 'SP049', 'SP058', 'SP059', 'SP076', 'SP077') AND a.supplierId=6456) OR (a.articleSearch='6PX358141261' AND a.supplierId=4734) OR (a.articleSearch='70699137' AND a.supplierId=72) OR ( a.articleSearch IN ('8294570', '8294596', '8294618') AND a.supplierId=341) OR (a.articleSearch='1197501400' AND a.supplierId=268) OR ( a.articleSearch IN ('881510101', '881523110', '881511105', '881529121') AND a.supplierId=286) OR ( a.articleSearch IN ('96009024', '96009024A1', '96009082', '96009082A1') AND a.supplierId=78) OR ( a.articleSearch IN ('8990115', '8991029') AND a.supplierId=4546) OR ( a.articleSearch IN ('88630', '88759', '88845') AND a.supplierId=133) OR (a.articleSearch='MRP2B03' AND a.supplierId=4773) OR ( a.articleSearch IN ('0901120', '0901128', '0901130', '0901214', '0901239', '0901335') AND a.supplierId=94) OR (a.articleSearch='PDEU001' AND a.supplierId=4705) OR ( a.articleSearch IN ('EPDCAU016', 'EPDCBM004', 'EPDCME009') AND a.supplierId=6355) OR ( a.articleSearch IN ('PE25001', 'PE25013', 'PE25027', 'PE25032') AND a.supplierId=4558) OR ( a.articleSearch IN ('P203125', 'P203131', 'P303014', 'P303038') AND a.supplierId=6339) OR (a.articleSearch='QF10H00059' AND a.supplierId=4339) OR ( a.articleSearch IN ('XPAR137', 'XPAR150') AND a.supplierId=57) OR (a.articleSearch='2412P0061' AND a.supplierId=6358) OR ( a.articleSearch IN ('970044', '970048', '970098') AND a.supplierId=27) OR (a.articleSearch='SKPDS1420060' AND a.supplierId=6357) OR (a.articleSearch='0004926SX' AND a.supplierId=4595) OR ( a.articleSearch IN ('115957', '117442', '409618') AND a.supplierId=301) OR ( a.articleSearch IN ('881510101', '881523110', '881511105', '881529121') AND a.supplierId=108) OR ( a.articleSearch IN ('0684880V', '7624880V') AND a.supplierId=36) OR ( a.articleSearch IN ('V10720828', 'V10720829', 'V20720563', 'V20725193', 'V30720217', 'V30720784', 'V95720344', 'V99720020', 'V99720021', 'V99720050') AND a.supplierId=183) OR (a.articleSearch='99191781201' AND a.supplierId=4346) OR ( a.articleSearch IN ('411570066', '411570090', '411570107') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1749879', 'WG1749903', 'WG1794334', 'WG1794339', 'WG1804799', 'WG1822477', 'WG2151529', 'WG2151530') AND a.supplierId=4832) OR ( a.articleSearch IN ('WEKR0156', 'ZVPT005', 'ZVPT048') AND a.supplierId=6274)An internal server error occurred.