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 ('60500', '60449') AND a.supplierId=47) OR ( a.articleSearch IN ('104006', '1953793', '90793') AND a.supplierId=4005) OR ( a.articleSearch IN ('1197302700', '1197501400') AND a.supplierId=268) OR ( a.articleSearch IN ('TXP002', 'TXS005R', 'CSE202', 'CSE357', 'PDEU001', 'PDEU003', 'TXS005L') AND a.supplierId=4705) OR (a.articleSearch='81469' AND a.supplierId=15) OR ( a.articleSearch IN ('890007', '890010', '890019', '255007') AND a.supplierId=21) OR ( a.articleSearch IN ('12001005', '12001006', '12001029', '12001050') AND a.supplierId=4657) OR ( a.articleSearch IN ('ASP014', 'ASP015', 'ASP023', 'ASP071') AND a.supplierId=374) OR ( a.articleSearch IN ('55843', '56570', '56571', '56572', '56978', '57812') AND a.supplierId=6558) OR (a.articleSearch='AS5053' AND a.supplierId=4737) OR ( a.articleSearch IN ('210053710', '210053810', '210059810') AND a.supplierId=323) OR (a.articleSearch='TPS0903' AND a.supplierId=194) OR ( a.articleSearch IN ('100055', '100056', '43048000', '43050000', '43573000', '43577000', '45142000', '73900017', '73900018', '73901017', '73901018', '73901030', '73903440', '73903441', '73903442', '73903443', '73907047', '100361', '73903410', '73903420', '100363', '73903411', '73903421') AND a.supplierId=4662) OR ( a.articleSearch IN ('5902010020', '5902010037', '5902010449P') AND a.supplierId=4555) OR ( a.articleSearch IN ('0986280608', '0986280610') AND a.supplierId=30) OR ( a.articleSearch IN ('BSP25077', 'BSP25119') AND a.supplierId=157) OR (a.articleSearch='755266' AND a.supplierId=405) OR ( a.articleSearch IN ('CPR9081', 'CPR9082', 'CSA5570', 'CSA5596', 'CSA5603', 'CSA5611', 'CSA5618', 'CSA5642', 'CSR3244') AND a.supplierId=4334) OR ( a.articleSearch IN ('147230', '147231') AND a.supplierId=211) OR ( a.articleSearch IN ('EE0546', 'XCS6531') AND a.supplierId=4344) OR ( a.articleSearch IN ('551477A', '565010', '565032', '566035A', '566078A', '566079A', '566080A', '566120A') AND a.supplierId=234) OR ( a.articleSearch IN ('28SKV014', '28SKV015', '28SKV023', '28SKV071', '28SKV096', '28SKV902') AND a.supplierId=4969) OR (a.articleSearch='79523' AND a.supplierId=240) OR ( a.articleSearch IN ('780048', '780079', '780082', '780083', '780092', '833244', '970044', '970048', '970074', '970098') AND a.supplierId=441) OR ( a.articleSearch IN ('920861', '925001') AND a.supplierId=4379) OR ( a.articleSearch IN ('SP041', 'SP047', 'SP048', 'SP049', 'SP058', 'SP059', 'SP075', 'SP076', 'SP077') AND a.supplierId=6456) OR ( a.articleSearch IN ('TMP0048', 'TMP0079', 'TMP0092') AND a.supplierId=6443) OR ( a.articleSearch IN ('6PP358139031', '6PP358139041', '6PX358141261') AND a.supplierId=4734) OR ( a.articleSearch IN ('70699137', '70699434', '70699443', '70699433') AND a.supplierId=72) OR ( a.articleSearch IN ('7480081', '7480082', '7480083', '7480084', '7517940', '8294570', '8294596', '8294603', '8294618', '7480080') AND a.supplierId=341) OR (a.articleSearch='17211' AND a.supplierId=269) OR ( a.articleSearch IN ('881510101', '881511103', '881511106', '881523110', '885529130', '885529161', '881511105', '881529121') AND a.supplierId=286) OR ( a.articleSearch IN ('96009006', '96009006A1', '96009024', '96009024A1', '96009082', '96009082A1') AND a.supplierId=78) OR ( a.articleSearch IN ('8990114', '8990115', '8991029') AND a.supplierId=4546) OR (a.articleSearch='453793' AND a.supplierId=4006) OR (a.articleSearch='LCS551' AND a.supplierId=6518) OR (a.articleSearch='SEB2087' AND a.supplierId=4501) OR (a.articleSearch='064847220010' AND a.supplierId=4723) OR ( a.articleSearch IN ('88630', '88633', '88759', '88845') AND a.supplierId=133) OR ( a.articleSearch IN ('EPS1953793', 'MRP2B03') AND a.supplierId=4773) OR ( a.articleSearch IN ('80081', '80082', '80083', '80084', '87940', '94570', '94596', '94603', '94618', '80080') AND a.supplierId=244) OR (a.articleSearch='50231' AND a.supplierId=4664) OR ( a.articleSearch IN ('0901120', '0901128', '0901129', '0901130', '0901214', '0901239', '0901335', '0903266') AND a.supplierId=94) OR (a.articleSearch='1148000039' AND a.supplierId=144) OR (a.articleSearch='LVCP161' AND a.supplierId=4564) OR (a.articleSearch='1CS539' AND a.supplierId=388) OR ( a.articleSearch IN ('ECPAU029', 'EPDCAU016', 'EPDCBM004', 'EPDCBM005', 'EPDCME009') AND a.supplierId=6355) OR ( a.articleSearch IN ('2380100', '2380102', '2380104', '2409771') AND a.supplierId=4380) OR ( a.articleSearch IN ('07S243', '08S145') AND a.supplierId=129) OR ( a.articleSearch IN ('17745', '21303', '21304', '21305', '31247', '34767', '34769', '34770', '41303', '41313') AND a.supplierId=4683) OR ( a.articleSearch IN ('PE25013', 'PE25014', 'PE25027', 'PE25032') AND a.supplierId=4558) OR ( a.articleSearch IN ('P203030', 'P203125', 'P203131', 'P303014', 'P303038') AND a.supplierId=6339) OR ( a.articleSearch IN ('QF05C00022', 'QF10H00059') AND a.supplierId=4339) OR ( a.articleSearch IN ('XPAR137', 'XPAR145', 'XPAR150') AND a.supplierId=57) OR ( a.articleSearch IN ('2232W0005', '2232W0054', '2412P0061') AND a.supplierId=6358) OR ( a.articleSearch IN ('1210', '2200', '2200BGO1', '2200GO1', '2200TGO1', '2210', '2210B', '4084') AND a.supplierId=4946) OR ( a.articleSearch IN ('780048', '780079', '780082', '780083', '780092', '833244', '970044', '970048', '970074', '970098') AND a.supplierId=27) OR ( a.articleSearch IN ('SKPDS1420060', 'SKWS1400004', 'SKWS1400053') AND a.supplierId=6357) OR (a.articleSearch='T450231' AND a.supplierId=4667) OR (a.articleSearch='0004926SX' AND a.supplierId=4595) OR ( a.articleSearch IN ('115957', '117005', '117176', '117442', '409618', '503012') AND a.supplierId=301) OR ( a.articleSearch IN ('881510101', '881511103', '881511106', '881523110', '885529130', '885529161', '881511105', '881529121') AND a.supplierId=108) OR ( a.articleSearch IN ('0684880V', '4946880V', '7624880V') AND a.supplierId=36) OR ( a.articleSearch IN ('750008', '750012') AND a.supplierId=4425) OR ( a.articleSearch IN ('V10720828', 'V10720829', 'V10720831', 'V10720835', 'V10721319', 'V20720562', 'V20720563', 'V20725193', 'V30720217', 'V30720784', 'V95720344', 'V95720345', 'V99720020', 'V99720021', 'V99720050') AND a.supplierId=183) OR ( a.articleSearch IN ('99061809901', '99071548201', '99191781201') AND a.supplierId=4346) OR (a.articleSearch='2352067' AND a.supplierId=303) OR ( a.articleSearch IN ('410570752', '411510001', '411510003', '411510004', '411510010', '411570066', '411570090', '411570093', '411570107', '411510002') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1408615', 'WG1495932', 'WG1749879', 'WG1749903', 'WG1749906', 'WG1794332', 'WG1794334', 'WG1794339', 'WG1804799', 'WG2099485', 'WG2151528', 'WG2151529', 'WG2151530') AND a.supplierId=4832) OR ( a.articleSearch IN ('WEKR0156', 'ZVPT005', 'ZVPT042') AND a.supplierId=6274)An internal server error occurred.