SELECT DISTINCT m.manufacturerName cross_brand, ao.oemSearch, ao.oemnumber, ps.id FROM article a
              /*LEFT JOIN supplier s ON s.supplierId=a.supplierId*/
              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 p.id=ps.product_id AND ps.supplier_id IN (223)
              WHERE ( a.articleSearch IN ('VAG96073B', 'VAG96073') AND a.supplierId=141) OR ( a.articleSearch IN ('12021100', '12010200', '12020000', '12025200', '57003900') AND a.supplierId=139) OR ( a.articleSearch IN ('VK2315', 'VK4377', 'VG3552', 'HK0537H', 'HK0594', 'HK0777', 'HK0783', 'HK1740', 'HK1793', 'HK2704', 'HK2709', 'HK2727', 'HK2756', 'HK2973', 'HK3520', 'HK3560', 'HK3561', 'HK3563', 'HK3564', 'HK3723', 'HK3787', 'HK4727', 'HK4747', 'HK4783', 'HK4785', 'HK4787', 'HK5521', 'HK5521B', 'HK5715', 'HK5728', 'HK5758', 'HK5761', 'HK6763', 'HK7539', 'HK8766', 'HK9506', 'HK9582', 'HK9731', 'HK9755', 'HK9791', 'HK9797', 'HN3309', 'HN3334', 'HN3352', 'HN3356', 'HN3365', 'HN3395', 'HN4302', 'HN4304', 'HN4305', 'HN4327', 'HN4332', 'HN4333', 'HN4337', 'HN4349', 'HN4353', 'HN4356', 'HN4385', 'HN5362', 'HN6383', 'OS5306', 'VK2312', 'VK2332', 'VK2335', 'VK2349', 'VK2358', 'VK2379', 'VK2394', 'VK3345', 'VK4300', 'VK4307', 'VK4373', 'VK4393', 'VK6378', 'VK9634') AND a.supplierId=478) OR ( a.articleSearch IN ('19036019', '12051545', '12014670', '12016386', '12016586', '12016756', '12020107', '12030209', '12036111', '12051748', '19020621', '19025687', '19026848', '19026849', '19029646', '19031076', '19031077', '19034071', '19034072', '19036018', '19036118', '19036121', '19036522', '19036735', '19036741', '19036872', '49380757') AND a.supplierId=140) OR ( a.articleSearch IN ('235610', '724590', '007030', '069630', '112593', '403730', '445100') AND a.supplierId=10) OR ( a.articleSearch IN ('1656050', '1642657', '1649082') AND a.supplierId=237) OR ( a.articleSearch IN ('1111352900', '1211350400') AND a.supplierId=268) OR ( a.articleSearch IN ('012488', '012489', '012948') AND a.supplierId=121) OR ( a.articleSearch IN ('00398', '04772', '06244', '13951', '16185') AND a.supplierId=4683) OR ( a.articleSearch IN ('PA5041', 'HL5002', 'HR291', 'HR5088', 'HR5127', 'HR791', 'HR814', 'NB884', 'PA6097', 'PA619') AND a.supplierId=113) OR ( a.articleSearch IN ('0212172', '0210195', '0210210', '0212169') AND a.supplierId=209) OR ( a.articleSearch IN ('8133111', '8133121', '8133122') AND a.supplierId=347) OR ( a.articleSearch IN ('123130612', '703130600', '022677504', '022727009', '023198501', '023199501', '023199502', '023199503', '023300001', '023300502', '023349501', '023351501', '123130601', '703130610', '703351200', '703426400', '703631200') AND a.supplierId=9) OR ( a.articleSearch IN ('11091792801', '11090159801') AND a.supplierId=4346) OR ( a.articleSearch IN ('80141') AND a.supplierId=4598) OR ( a.articleSearch IN ('70523') AND a.supplierId=317) OR ( a.articleSearch IN ('190037210') AND a.supplierId=323) OR ( a.articleSearch IN ('0015002708', '0033002778') AND a.supplierId=4995) OR ( a.articleSearch IN ('11091782105') AND a.supplierId=4815) OR ( a.articleSearch IN ('036109675') AND a.supplierId=6366) OR ( a.articleSearch IN ('N30003BTA') AND a.supplierId=4693) OR ( a.articleSearch IN ('7095640') AND a.supplierId=6411) OR ( a.articleSearch IN ('420753') AND a.supplierId=355) OR ( a.articleSearch IN ('VG0002') AND a.supplierId=4514) OR ( a.articleSearch IN ('VS739', 'VS750', 'VSK1006', 'VSK1036', 'VSK1160', 'VSK1196', 'VSK1496', 'VSK169', 'VSK1776', 'VSK1780', 'VSK1796', 'VSK1902', 'VSK1937', 'VSK1938', 'VSK2327', 'VSK2329', 'VSK739', 'VSK898', 'VSK1772') AND a.supplierId=267) OR ( a.articleSearch IN ('01592', '02741', '24202', '26169', '28391', '15508') AND a.supplierId=101) OR ( a.articleSearch IN ('G3552') AND a.supplierId=235) OR ( a.articleSearch IN ('D3165100', 'D3222800', 'D3228300', 'D3270300', 'D3299100', 'D3299900', 'D3696100', 'D3696300', 'D3696900', 'N9299000', 'N9602400', 'P7666200', 'P7677100', 'P7680900', 'P93934') AND a.supplierId=88) OR ( a.articleSearch IN ('2430614760', '5002420900', '5030614750', '5030656050', '5031937400') AND a.supplierId=60) OR ( a.articleSearch IN ('1410818483', '1435548300', '1435548483', '1435788500') AND a.supplierId=4257) OR ( a.articleSearch IN ('8004601') AND a.supplierId=4336) OR ( a.articleSearch IN ('VG059100') AND a.supplierId=238) OR ( a.articleSearch IN ('1130275', '1131510', '1151570') AND a.supplierId=4546) OR ( a.articleSearch IN ('1317701', '13177') AND a.supplierId=35) OR ( a.articleSearch IN ('SO0452') AND a.supplierId=4600) OR ( a.articleSearch IN ('029FX31174000') AND a.supplierId=287) OR ( a.articleSearch IN ('8200496321SET8MS') AND a.supplierId=358) OR ( a.articleSearch IN ('G3322') AND a.supplierId=6420) OR ( a.articleSearch IN ('F71005') AND a.supplierId=129) OR ( a.articleSearch IN ('25705', '27032V', '31360', '35006', '35663') AND a.supplierId=331) OR ( a.articleSearch IN ('9560380', '9560380S') AND a.supplierId=260) OR ( a.articleSearch IN ('4S025V', '4S045V') AND a.supplierId=4936) OR ( a.articleSearch IN ('10924202', '20340006', '40902741', '62926169', '70928391') AND a.supplierId=151) OR ( a.articleSearch IN ('107502', '201256', '206541') AND a.supplierId=301) OR ( a.articleSearch IN ('WG1004306', 'WG1004649', 'WG1004669', 'WG1004691', 'WG1084956', 'WG1145991') AND a.supplierId=4832) OR ( a.articleSearch IN ('111741', '210393', '310281', '310283', '311521', '312969', '312987', '560869', '560871', '560873') AND a.supplierId=6347)An internal server error occurred.