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 ('0258006986', '0258017270', '0258986602', '0258003148', '0258003165', '0258003247', '0258003253', '0258003259', '0258003267', '0258003269', '0258003271', '0258003275', '0258003291', '0258003292', '0258003307', '0258003314', '0258003339', '0258003344', '0258003383', '0258003396', '0258003423', '0258003477', '0258003478', '0258003544', '0258003548', '0258003556', '0258003571', '0258003584', '0258003588', '0258003597', '0258003613', '0258003630', '0258003640', '0258003642', '0258003644', '0258003673', '0258003713', '0258003714', '0258003716', '0258003719', '0258003736', '0258003759', '0258003779', '0258003782', '0258003798', '0258003829', '0258003842', '0258003862', '0258003868', '0258005007', '0258005030', '0258005055', '0258005070', '0258005075', '0258005081', '0258005088', '0258005090', '0258005096', '0258005110', '0258005113', '0258005115', '0258005134', '0258005136', '0258005160', '0258005184', '0258005225', '0258005234', '0258005235', '0258005240', '0258005247', '0258005249', '0258005251', '0258005253', '0258005254', '0258005255', '0258005256', '0258005263', '0258005283', '0258005291', '0258005293', '0258005295', '0258005297', '0258005322', '0258005658', '0258005659', '0258005660', '0258005703', '0258005704', '0258005705', '0258005708', '0258005710', '0258005712', '0258005716', '0258005717', '0258005718', '0258005726', '0258005728', '0258005729', '0258005730', '0258005732', '0258005736', '0258005737', '0258006001', '0258006033', '0258006039', '0258006046', '0258006063', '0258006064', '0258006125', '0258006146', '0258006159', '0258006165', '0258006174', '0258006175', '0258006181', '0258006196', '0258006205', '0258006206', '0258006213', '0258006237', '0258006239', '0258006245', '0258006249', '0258006255', '0258006257', '0258006259', '0258006268', '0258006274', '0258006276', '0258006281', '0258006283', '0258006287', '0258006296', '0258006300', '0258006302', '0258006305', '0258006324', '0258006330', '0258006334', '0258006353', '0258006359', '0258006373', '0258006378', '0258006379', '0258006384', '0258006391', '0258006392', '0258006398', '0258006400', '0258006412', '0258006416', '0258006418', '0258006424', '0258006425', '0258006433', '0258006435', '0258006438', '0258006452', '0258006456', '0258006462', '0258006473', '0258006475', '0258006495', '0258006498', '0258006506', '0258006511', '0258006513', '0258006515', '0258006517', '0258006534', '0258006537', '0258006539', '0258006540', '0258006541', '0258006547', '0258006553', '0258006555', '0258006557', '0258006559', '0258006569', '0258006575', '0258006576', '0258006586', '0258006587', '0258006588', '0258006589', '0258006591', '0258006593', '0258006596', '0258006611', '0258006613', '0258006615', '0258006617', '0258006623', '0258006658', '0258006659', '0258006661', '0258006663', '0258006665', '0258006667', '0258006669', '0258006671', '0258006682', '0258006683', '0258006695', '0258006697', '0258006698', '0258006700', '0258006702', '0258006704', '0258006717', '0258006720', '0258006721', '0258006722', '0258006726', '0258006727', '0258006729', '0258006732', '0258006738', '0258006741', '0258006744', '0258006746', '0258006747', '0258006749', '0258006755', '0258006757', '0258006785', '0258006792', '0258006793', '0258006794', '0258006795', '0258006796', '0258006808', '0258006809', '0258006810', '0258006811', '0258006816', '0258006823', '0258006825', '0258006829', '0258006833', '0258006835', '0258006837', '0258006839', '0258006844', '0258006849', '0258006851', '0258006861', '0258006862', '0258006869', '0258006875', '0258006887', '0258006889', '0258006891', '0258006895', '0258006897', '0258006898', '0258006904', '0258006908', '0258006909', '0258006911', '0258006915', '0258006919', '0258006925', '0258006929', '0258006947', '0258006953', '0258006958', '0258006966', '0258006970', '0258006971', '0258006975', '0258006978', '0258006980', '0258006982', '0258006984', '0258006988', '0258006994', '0258007351', '0258010002', '0258010007', '0258010011', '0258010013', '0258010022', '0258010024', '0258010032', '0258010034', '0258010036', '0258010038', '0258010049', '0258010055', '0258010062', '0258010073', '0258010075', '0258010081', '0258010091', '0258010110', '0258010115', '0258010117', '0258010121', '0258010155', '0258010190', '0258010235', '0258010244', '0258010246', '0258010282', '0258010298', '0258010313', '0258010333', '0258010340', '0258010351', '0258010387', '0258010413', '0258010414', '0258010420', '0258010421', '0258010428', '0258010435', '0258010450', '0258010459', '0258010516', '0258017044', '0258017185', '0258017274', '0258017305', '0258986502', '0258986503', '0258986504', '0258986505', '0258986506', '0258986507', '0258986601', '0258986603', '0258986604', '0258986605', '0258986606', '0258986607', '0258986608', '0258986609', '0258986611', '0258986612', '0258986613', '0258986615', '0258986617', '0258986618', '0258986619', '0258986621', '0258986622', '0258986623', '0258986625', '0258986627', '0258986628', '0258986629', '0258986630', '0258986631', '0258986633', '0258986634', '0258986635', '0258986636', '0258986637', '0258986638', '0258986641', '0258986642', '0258986643', '0258986644', '0258986645', '0258986646', '0258986647', '0258986648', '0258986649', '0258986650', '0258986651', '0258986652', '0258986653', '0258986654', '0258986655', '0258986657', '0258986659', '0258986660', '0258986662', '0258986663', '0258986664', '0258986665', '0258986667', '0258986668', '0258986669', '0258986670', '0258986672', '0258986673', '0258986674', '0258986675', '0258986676', '0258986678', '0258986681', '0258986682', '0258986683', '0258986684', '0258986685', '0258986687', '0258986690', '0258986694', '0258986696', '0258986697', '0258986698', '0258986699', '0258986701', '0258986702', '0258986703', '0258986705', '0258986709', '0258986710', '0258986711', '0258986712', '0258986713', '0258986716', '0258986717', '0258986719', '0258986722', '0258986723', '0258986724', '0258986726', '0258986727', '0258986738', '0258986745', '0258986749', '0258986750', '0258986751', '0258986752', '0258986754', '0258986755', '0258986767', '0258986770', '0258986772', '0258986774', '0258986782', '0986594582', '0986AG2201', '0986AG2202', '0986AG2203', '0986AG2204', '0986AG2205', '0986AG2206', '0986AG2207', '0986AG2208', '0986AG2212', '0986AG2216', '0986AG2217', '0986AG2219', '0986AG2221', '0986AG2222', '0986AG2224', '0986AG2225', '0986AG2228', '0986AG2229', 'F00E260762', 'F00E261080', 'F00E262938', 'F00E262948', 'F00E263084', 'F00E263194', 'F00E263195', 'F00E263198', 'F00E263207', 'F00E263208', 'F00E263228', 'F00E263229', 'F00E263231', 'F00E263232', 'F00E263238', 'F00E263247', 'F00E263273', 'F00E263287', 'F00E263289', 'F00E263292', 'F00E263294', 'F00E263295', 'F00E263299', 'F00E263304', 'F00HL00034', 'F00HL00046', 'F00HL00052', 'F00HL00061', 'F00HL00081', 'F00HL00090', 'F00HL00091', 'F00HL00093', 'F00HL00149', 'F00HL00150', 'F00HL00154', 'F00HL00155', 'F00HL00165', 'F00HL00184', 'F00HL00186', 'F00HL00192', 'F00HL00208', 'F00HL00217', 'F00HL00219', 'F00HL00220', 'F00HL00221', 'F00HL00235', 'F00HL00257', 'F00HL00260', 'F00HL00267', 'F00HL00292', 'F00HL00317', 'F00HL00318', 'F00HL00319', 'F00HL00320', 'F00HL00321', 'F00HL00323', 'F00HL00324', 'F00HL00325', 'F00HL00326', 'F00HL00328', 'F00HL00329', 'F00HL00330', 'F00HL00332', 'F00HL00333', 'F00HL00335', 'F00HL00336', 'F00HL00344', 'F00HL00346', 'F00HL00347', 'F00HL00348', 'F00HL00351', 'F00HL00353', 'F00HL00354', 'F00HL00355', 'F00HL00356', 'F00HL00360', 'F00HL00361', 'F00HL00365', 'F00HL00371', 'F00HL00373', 'F00HL00377', 'F00HL00379', 'F00HL00380', 'F00HL00381', 'F00HL00382', 'F00HL00385', 'F00HL00388', 'F00HL00389', 'F00HL00391', 'F00HL00394', 'F00HL00396', 'F00HL00398', 'F00HL00399', 'F00HL00400', 'F00HL00401', 'F00HL00402', 'F00HL00403', 'F00HL00405', 'F00HL00406', 'F00HL00416', 'F00HL00417', 'F00HL00419', 'F00HL00420', 'F00HL00428', 'F00HL00434', 'F00HL00439', 'F00HL00440', 'F00HL00441', 'F00HL00444', 'F00HL00445', 'F00HL00447', 'F00HL00449', 'F00HL00452', 'F00HL00454') AND a.supplierId=30) OR ( a.articleSearch IN ('ES1110412B1', 'ES1013512B1', 'ES10276', 'ES10289', 'ES1028912B1', 'ES1033312B1', 'ES10399', 'ES1039911B1', 'ES10403', 'ES1040611B1', 'ES10568', 'ES1056812B1', 'ES10574', 'ES10579', 'ES1057911B1', 'ES10580', 'ES1058012B1', 'ES1058112B1', 'ES10582', 'ES1058211B1', 'ES10596', 'ES1059611B1', 'ES10632', 'ES1063211B1', 'ES1063212B1', 'ES1073512B1', 'ES1076112B1', 'ES1076312B1', 'ES1078912B1', 'ES1079112B1', 'ES1079712B1', 'ES1079812B1', 'ES1082212B1', 'ES10856', 'ES10880', 'ES1088011B1', 'ES1088012B1', 'ES10882', 'ES1088211B1', 'ES10883', 'ES1088311B1', 'ES1088312B1', 'ES10895', 'ES10897', 'ES10899', 'ES1090912B1', 'ES1091612B1', 'ES1092112B1', 'ES10941', 'ES1096712B1', 'ES1096812B1', 'ES10972', 'ES1097712B1', 'ES1098012B1', 'ES1098112B1', 'ES1098212B1', 'ES1098312B1', 'ES1098612B1', 'ES1098712B1', 'ES1099312B1', 'ES1100012B1', 'ES11003', 'ES1100311B1', 'ES1100312B1', 'ES1101012B1', 'ES1101412B1', 'ES11073', 'ES1107312B1', 'ES11077', 'ES1109212B1', 'ES1110612B1', 'ES1110712B1', 'ES1110812B1', 'ES1110912B1', 'ES1111312B1', 'ES1111512B1', 'ES1111712B1', 'ES1111812B1', 'ES1111912B1', 'ES1112212B1', 'ES2000512B1', 'ES20014', 'ES2001512B1', 'ES20016', 'ES2001611B1', 'ES2001712B1', 'ES20020', 'ES2002012B1', 'ES20025', 'ES2002512B1', 'ES20026', 'ES20029', 'ES2002912B1', 'ES20030', 'ES2003312B1', 'ES2003712B1', 'ES2003812B1', 'ES2004012B1', 'ES2004411B1', 'ES2004412B1', 'ES20045', 'ES2004511B1', 'ES2004512B1', 'ES2004612B1', 'ES20050', 'ES20052', 'ES20053', 'ES2005312B1', 'ES20054', 'ES20059', 'ES2005911B1', 'ES2005912B1', 'ES20061', 'ES20063', 'ES2006311B1', 'ES20064', 'ES2006612B1', 'ES20067', 'ES20068', 'ES2006811B1', 'ES2006812B1', 'ES2007012B1', 'ES2007312B1', 'ES20076', 'ES2007611B1', 'ES2007612B1', 'ES20077', 'ES2007812B1', 'ES2007912B1', 'ES20081', 'ES20082', 'ES20083', 'ES2008412B1', 'ES2008512B1', 'ES20091', 'ES2009412B1', 'ES2009512B1', 'ES2009612B1', 'ES2010012B1', 'ES2010312B1', 'ES20104', 'ES20105', 'ES2011112B1', 'ES20113', 'ES20115', 'ES2011511B1', 'ES2011512B1', 'ES20117', 'ES2011712B1', 'ES20118', 'ES2011811B1', 'ES2011812B1', 'ES2012012B1', 'ES20122', 'ES2012312B1', 'ES20124', 'ES2012412B1', 'ES2013012B1', 'ES20135', 'ES2013512B1', 'ES20141', 'ES2014212B1', 'ES2014512B1', 'ES20151', 'ES2015112B1', 'ES2015212B1', 'ES20154', 'ES20156', 'ES2015611B1', 'ES2015612B1', 'ES2015711B1', 'ES2015712B1', 'ES20158', 'ES2015811B1', 'ES20160', 'ES2016012B1', 'ES20161', 'ES2016111B1', 'ES2016212B1', 'ES20164', 'ES20165', 'ES2016612B1', 'ES20167', 'ES20168', 'ES2016812B1', 'ES2016911B1', 'ES20170', 'ES2017011B1', 'ES2017012B1', 'ES20171', 'ES20172', 'ES2017211B1', 'ES2017212B1', 'ES2017311B1', 'ES2017312B1', 'ES20174', 'ES2017412B1', 'ES20175', 'ES2017512B1', 'ES20177', 'ES2017811B1', 'ES2017912B1', 'ES20180', 'ES20181', 'ES2019411B1', 'ES2019412B1', 'ES20195', 'ES20196', 'ES20198', 'ES20199', 'ES20200', 'ES2020112B1', 'ES2020412B1', 'ES20209', 'ES2020912B1', 'ES20211', 'ES2021111B1', 'ES20213', 'ES20214', 'ES2021411B1', 'ES2021412B1', 'ES20220', 'ES2022012B1', 'ES20221', 'ES2022112B1', 'ES20222', 'ES2022212B1', 'ES20223', 'ES2022312B1', 'ES20224', 'ES2022411B1', 'ES2022412B1', 'ES20226', 'ES2022612B1', 'ES20227', 'ES2022711B1', 'ES2022712B1', 'ES2022811B1', 'ES2022812B1', 'ES2023012B1', 'ES2023612B1', 'ES2025212B1', 'ES20253', 'ES2025312B1', 'ES2025512B1', 'ES2025612B1', 'ES2025812B1', 'ES2026212B1', 'ES2026312B1', 'ES2026412B1', 'ES20265', 'ES2026512B1', 'ES2026712B1', 'ES2026812B1', 'ES2026912B1', 'ES2027012B1', 'ES2027112B1', 'ES2027212B1', 'ES2027312B1', 'ES20276', 'ES2027612B1', 'ES2027712B1', 'ES2027812B1', 'ES2028012B1', 'ES2028112B1', 'ES2028312B1', 'ES2028412B1', 'ES2028512B1', 'ES2028612B1', 'ES2028912B1', 'ES2029012B1', 'ES2029112B1', 'ES2029212B1', 'ES2029312B1', 'ES2029912B1', 'ES2030112B1', 'ES2030212B1', 'ES2030312B1', 'ES2030812B1', 'ES2030912B1', 'ES2031112B1', 'ES2031212B1', 'ES2031312B1', 'ES2031412B1', 'ES2031512B1', 'ES20317', 'ES2031712B1', 'ES20318', 'ES2031811B1', 'ES2031812B1', 'ES20321', 'ES2032111B1', 'ES2032112B1', 'ES20322', 'ES2032211B1', 'ES2032212B1', 'ES2032312B1', 'ES20324', 'ES2032411B1', 'ES20325', 'ES2032511B1', 'ES20326', 'ES2032611B1', 'ES2032612B1', 'ES20327', 'ES2032812B1', 'ES20330', 'ES20331', 'ES2033312B1', 'ES2033412B1', 'ES2033512B1', 'ES2033812B1', 'ES2033912B1', 'ES2034112B1', 'ES2034412B1', 'ES2034612B1', 'ES2034712B1', 'ES2034812B1', 'ES2034912B1', 'ES20352', 'ES2035212B1', 'ES20354', 'ES20355', 'ES2035512B1', 'ES20360', 'ES20361', 'ES2036112B1', 'ES2036212B1', 'ES20363', 'ES20365', 'ES2036512B1', 'ES20367', 'ES2036711B1', 'ES20371', 'ES20372', 'ES2037211B1', 'ES20373', 'ES20374', 'ES20376', 'ES20380', 'ES2038712B1', 'ES2038912B1', 'ES20390', 'ES2039112B1', 'ES20392', 'ES2039312B1', 'ES2041112B1', 'ES2041312B1', 'ES2041412B1', 'ES2042012B1', 'ES2044212B1', 'ES2044612B1', 'ES2045012B1', 'ES2045212B1', 'ES2049112B1', 'ES2050712B1', 'ES2050812B1', 'ES2050912B1', 'ES2051012B1', 'ES2051312B1', 'ES2051812B1', 'ES2051912B1', 'ES2052012B1', 'ES2052112B1', 'ES2052212B1', 'ES2052312B1', 'ES2052412B1', 'ES2052512B1', 'ES2052712B1') AND a.supplierId=89) OR a.articleSearch='DOX0150' AND a.supplierId=4760) OR ( a.articleSearch IN ('570101A', '570208') AND a.supplierId=234) OR a.articleSearch='E144007' AND a.supplierId=4391) OR ( a.articleSearch IN ('108245', '108410') AND a.supplierId=4005) OR a.articleSearch='466016355072' AND a.supplierId=4723) OR ( a.articleSearch IN ('81624', '81656') AND a.supplierId=244) OR a.articleSearch='OS15P' AND a.supplierId=4705) OR ( a.articleSearch IN ('1952', '90357') AND a.supplierId=15) OR ( a.articleSearch IN ('ESLAU002', 'ESLAU005', 'ESLAU008', 'ESLCH003') AND a.supplierId=6355) OR ( a.articleSearch IN ('01759', '05478', '05907', '05908', '07859', '08878') AND a.supplierId=4683) OR a.articleSearch='2000022SX' AND a.supplierId=4595) OR a.articleSearch='99981599201' AND a.supplierId=4346) OR a.articleSearch='30400' AND a.supplierId=206) OR ( a.articleSearch IN ('19347507', '19350870') AND a.supplierId=6307) OR ( a.articleSearch IN ('AMMA820', 'SLS0001', 'SLS0002', 'SLS11077', 'SLS13168', 'SLS13169', 'SLS13171', 'SLS13172', 'SLS13173', 'SLS13174', 'SLS13175', 'SLS13176', 'SLS13185', 'SLS13186', 'SLS13189', 'SLS13190', 'SLS13215', 'SLS13216', 'SLS13217', 'SLS13223', 'SLS13224', 'SLS13228', 'SLS13229', 'SLS13230', 'SLS13231', 'SLS13235', 'SLS13236', 'SLS13238', 'SLS13240', 'SLS13241', 'SLS13298', 'SLS13311', 'SLS13313', 'SLS13314', 'SLS13315', 'SLS13316', 'SLS13317', 'SLS13318', 'SLS13319', 'SLS13320', 'SLS13321', 'SLS13322', 'SLS13323', 'SLS13325', 'SLS13326', 'SLS13327', 'SLS13328', 'SLS13331', 'SLS13333', 'SLS13334', 'SLS13338', 'SLS13345', 'SLS13869', 'SLS13871', 'SLS13875', 'SLS13888', 'SLS13892', 'SLS27003', 'SLS27030', 'SLS27070', 'SLS27112', 'SLS27120', 'SLS27123', 'SLS27126', 'SLS27147', 'SLS42', 'SLS45', 'SLS45610', 'SLS46', 'SLS4B2', 'SLS4B5', 'SLS4B6', 'SLS60404', 'SLS60475', 'SLS60477', 'SLS60479', 'SLS60482', 'SLS60496', 'SLS90001', 'SLS90004', 'SLS90199', 'SLS90200', 'SLU51', 'SLU5B1') AND a.supplierId=374) OR ( a.articleSearch IN ('A51760002', 'A52760004', 'A52760012', 'A52760016', 'A52760019', 'A52760020', 'A52760023', 'A53760007', 'A53760010', 'A53760012') AND a.supplierId=4364) OR ( a.articleSearch IN ('54513', '54515', '54516', '54517', '54518', '54519', '54522', '54522SET', '54524', '54524SET', '54525', '54525SET') AND a.supplierId=6558) OR ( a.articleSearch IN ('74121', '74124', '74137', '74140', '74166', '74169', '74183', '74204', '74209', '74210', '74226') AND a.supplierId=4576) OR ( a.articleSearch IN ('151000201', '43H01', '43H05', '43H08', '43M06', '43MI07', '43T05', '43U03', '43U04', '43Y14', '43Y15', '43Y16', '43Y17', 'DOX1456') AND a.supplierId=257) OR ( a.articleSearch IN ('920044152', '920046316', '920048002', '920048098', '920048136', '920048186', '920048198', '9200482112', '920048212', '920048274', '920048324', '920048338', '920048352', '920048450', '920048466', '920048582', '920048596', '920048610', '920048670', '920048676', '920048698', '920048720', '920048876', '920048896', '920048900', '920048906', '920048946', '920048974', '920048980', '920049034', '920049352', '920049378', '920049380', '920049420', '920049542', '920049554', '920049558', '920049560', '920049698', '920049724', '920049802', '920049804', '920049808', '920049812', '920049814', '920050070', 'B40401', 'B42414', 'B43022') AND a.supplierId=442) OR a.articleSearch='24071152203' AND a.supplierId=3) OR ( a.articleSearch IN ('AS2200', 'AS2201', 'AS2202', 'AS2203', 'AS2207', 'AS2208', 'AS2210', 'AS2212', 'AS4551') AND a.supplierId=4737) OR ( a.articleSearch IN ('140000210', '150015310', '150015610', '150019110', '150033010', '150033110', '150033210', '150033410', '150033910', '150034010', '150072410', '150072510', '150073210', '150073410', '150073510', '150073610', '150073810', '150077610', '150078110', '150078310', '150078810', '150079010', '150087810', '150088110', '150088210', '150090210', '150090310', '150090510', '150090610', '150090810', '150091010') AND a.supplierId=323) OR a.articleSearch='0011019294' AND a.supplierId=4995) OR ( a.articleSearch IN ('OXY321071', 'OXY405030', 'OXY410040', 'OXY413040', 'OXY415087', 'OXY415100', 'OXY415150', 'OXY420180', 'OXY427150', 'OXY442035', 'OXY451070', 'OXY452082', 'OXY453042', 'OXY460022', 'OXY461050', 'OXY462023', 'OXY462033', 'OXY465059', 'OXY466050', 'OXY469037', 'OXY472072', 'OXY473057') AND a.supplierId=194) OR a.articleSearch='058685B' AND a.supplierId=49) OR ( a.articleSearch IN ('OPH002', 'OPH011', 'OPH012', 'OPH013', 'OPH014', 'OPH016', 'OPH031', 'OPH033', 'OPH036', 'OPH037', 'OPH038', 'OPH039', 'OPH044', 'OPH052', 'OPH076', 'OPH077', 'OPH087', 'OPH089', 'OPH090', 'OPH094', 'OZH006', 'OZH009', 'OZH010', 'OZH012', 'OZH014', 'OZH016', 'OZH017', 'OZH022', 'OZH023', 'OZH024', 'OZH028', 'OZH030', 'OZH031', 'OZH035', 'OZH045', 'OZH050', 'OZH054', 'OZH059', 'OZH069', 'OZH071', 'OZH073', 'OZH076', 'OZH084', 'OZH086', 'OZH088', 'OZH092', 'OZH101', 'OZH113', 'OZH120', 'OZH121', 'OZH124', 'OZH132', 'OZH143', 'OZH148', 'OZH150', 'OZH151', 'OZH159', 'OZH163', 'OZH177', 'OZH180', 'OZH182', 'OZH184', 'OZH200', 'OZH208', 'OZH211', 'OZH216', 'OZH219', 'OZH228', 'OZH229', 'OZH233', 'OZH234', 'OZH235', 'OZH237', 'OZH238') AND a.supplierId=6444) OR a.articleSearch='54423' AND a.supplierId=208) OR ( a.articleSearch IN ('ADA107001', 'ADA107002', 'ADA107005C', 'ADA107007C', 'ADA107011', 'ADA107012', 'ADA107013', 'ADA107021', 'ADA107023', 'ADA107024', 'ADA107025', 'ADA107027', 'ADA107033', 'ADA107037', 'ADA107038', 'ADA107039', 'ADA107041', 'ADA107043', 'ADA107049', 'ADA107050', 'ADB117001', 'ADB117003', 'ADB117004', 'ADC47006', 'ADC47009', 'ADC47011', 'ADC47012', 'ADC47013', 'ADC47014', 'ADC47015', 'ADC47017', 'ADC47021', 'ADC47023', 'ADC47024', 'ADC47026', 'ADC47028', 'ADC47029', 'ADC47030', 'ADC47032', 'ADC47035', 'ADC47038', 'ADC47044', 'ADC47045', 'ADC47046', 'ADC47049', 'ADC47054', 'ADC47059', 'ADC47060', 'ADC47061', 'ADC47064', 'ADC47065', 'ADD67001', 'ADD67004', 'ADD67007', 'ADD67008', 'ADD67009', 'ADD67010', 'ADF127004C', 'ADF127005C', 'ADG07001', 'ADG07002', 'ADG07004', 'ADG07005', 'ADG07008', 'ADG07009', 'ADG070101', 'ADG070103', 'ADG070104', 'ADG070105', 'ADG07011', 'ADG070111', 'ADG070112', 'ADG07012', 'ADG070120', 'ADG070126', 'ADG07013', 'ADG07020', 'ADG07021', 'ADG07027', 'ADG07028', 'ADG07029', 'ADG07031', 'ADG07033', 'ADG07037', 'ADG07039', 'ADG07040', 'ADG07041', 'ADG07042', 'ADG07043', 'ADG07044', 'ADG07045C', 'ADG07046C', 'ADG07050', 'ADG07051', 'ADG07052', 'ADG07053', 'ADG07058', 'ADG07064', 'ADG07065', 'ADG07068', 'ADG07071', 'ADG07074', 'ADG07075', 'ADG07076', 'ADG07078', 'ADG07079', 'ADG07082', 'ADG07083', 'ADG07085', 'ADG07092', 'ADG07093', 'ADG07096', 'ADH27002', 'ADH27003', 'ADH27004', 'ADH27005', 'ADH27006', 'ADH27007C', 'ADH27009', 'ADH27015', 'ADH27016', 'ADH27017', 'ADH27018', 'ADH27022', 'ADH27023', 'ADH27024', 'ADH27025', 'ADH27027', 'ADH27028', 'ADH27031', 'ADH27032', 'ADH27033', 'ADH27038', 'ADH27040', 'ADH27051', 'ADH27055', 'ADH27056', 'ADH27058', 'ADH27066', 'ADJ137001C', 'ADJ137015', 'ADJ137026', 'ADK87006', 'ADK87008', 'ADK87008C', 'ADK87009', 'ADK87010', 'ADK87011C', 'ADK87013', 'ADK87014', 'ADK87015', 'ADK87016C', 'ADK87018', 'ADK87019', 'ADK87020', 'ADK87021', 'ADK87022', 'ADK87023', 'ADK87025C', 'ADK87026', 'ADK87027', 'ADK87031', 'ADK87035', 'ADK87038', 'ADK87050', 'ADK87051', 'ADK87053', 'ADM57001', 'ADM57003', 'ADM57003C', 'ADM57005', 'ADM57005C', 'ADM57006', 'ADM57006C', 'ADM57011', 'ADM57014', 'ADM57015', 'ADM57016', 'ADM57017', 'ADM57020', 'ADM57025', 'ADM57026C', 'ADM57027', 'ADM57028', 'ADM57029', 'ADM57030', 'ADM57033C', 'ADM57036', 'ADM57040C', 'ADM57042', 'ADM57043', 'ADM57044', 'ADM57046', 'ADM57048', 'ADM57049', 'ADM57050', 'ADM57052', 'ADM57053', 'ADM57054', 'ADM57055', 'ADM57056', 'ADM57057', 'ADM57058', 'ADM57061', 'ADM57063', 'ADM57067', 'ADM57068', 'ADM57069', 'ADM57071', 'ADM57072', 'ADM57076', 'ADM57078', 'ADN17011', 'ADN17013', 'ADN17014', 'ADN17015', 'ADN17016', 'ADN17017', 'ADN17023', 'ADN17024', 'ADN17028', 'ADN17029', 'ADN17031', 'ADN17032C', 'ADN17034', 'ADN17038', 'ADN17043', 'ADN17053', 'ADN17056', 'ADN17061', 'ADP157001', 'ADP157002C', 'ADP157005C', 'ADR167001', 'ADS77003', 'ADS77003C', 'ADS77006', 'ADS77010', 'ADS77016', 'ADS77019', 'ADS77024', 'ADT37004', 'ADT370100', 'ADT370101', 'ADT370103C', 'ADT370105', 'ADT370106', 'ADT370108', 'ADT370109', 'ADT370113', 'ADT370118', 'ADT37012', 'ADT370122', 'ADT370127', 'ADT370128', 'ADT37013', 'ADT37014', 'ADT370140', 'ADT370141', 'ADT370142', 'ADT370143', 'ADT370144', 'ADT370145', 'ADT370146', 'ADT370147', 'ADT370148', 'ADT37016', 'ADT37018', 'ADT37020', 'ADT37021', 'ADT37024', 'ADT37025', 'ADT37027', 'ADT37028C', 'ADT37029C', 'ADT37037', 'ADT37042', 'ADT37047', 'ADT37050', 'ADT37051', 'ADT37052', 'ADT37054', 'ADT37055', 'ADT37056', 'ADT37057', 'ADT37058', 'ADT37059', 'ADT37060', 'ADT37061', 'ADT37065', 'ADT37076', 'ADT37078', 'ADT37080', 'ADT37081', 'ADT37085', 'ADT37092', 'ADT37093', 'ADT37094', 'ADT37095C', 'ADT37097', 'ADT37099', 'ADV187002', 'ADV187003C', 'ADV187005C', 'ADV187006C', 'ADZ97003') AND a.supplierId=350) OR ( a.articleSearch IN ('B16926', 'B16928', 'B16929', 'B18920', 'B18922', 'B18925', 'B18928', 'B18930') AND a.supplierId=4815) OR a.articleSearch='51518' AND a.supplierId=47) OR ( a.articleSearch IN ('54029', '54030', '54031', '54032', '54035', '54038', '54047', '54054', '54061', '54076', '54081', '54082', '54083', '54088') AND a.supplierId=157) OR ( a.articleSearch IN ('LS130007', 'LS130016', 'LS140002', 'LS140006', 'LS140007', 'LS140008', 'LS140010', 'LS140012', 'LS140014', 'LS140015', 'LS140016', 'LS140018', 'LS140019', 'LS140020', 'LS140021', 'LS140023', 'LS140025', 'LS140027', 'LS140028', 'LS140035', 'LS140036', 'LS140038', 'LS140039', 'LS140044', 'LS140048', 'LS140054', 'LS140058', 'LS140061', 'LS140062', 'LS140065', 'LS140067', 'LS140069', 'LS140073', 'LS140078', 'LS140082', 'LS140098', 'LS140100', 'LS140101', 'LS140103', 'LS140104', 'LS140106', 'LS140107', 'LS140108', 'LS140116', 'LS140118', 'LS140119', 'LS140122', 'LS140124', 'LS140126', 'LS140127', 'LS140132', 'LS140136', 'LS140137', 'LS140155', 'LS140156', 'LS140162', 'LS140173', 'LS140177', 'LS140178', 'LS140184', 'LS140194', 'LS140207', 'LS140220', 'LS140229', 'LS140235', 'LS140237', 'LS140243', 'LS140252', 'LS140262', 'LS140272', 'LS140274', 'LS140275', 'LS140276', 'LS140278', 'LS140282', 'LS140294', 'LS140295', 'LS140300', 'LS140301', 'LS140308', 'LS140313', 'LS140326', 'LS140327', 'LS140328', 'LS140333', 'LS140336', 'LS140337', 'LS140338', 'LS140340', 'LS140349', 'LS140352', 'LS140356', 'LS140359', 'LS140369', 'LS140370', 'LS140371', 'LS140372', 'LS140377', 'LS140380', 'LS140381', 'LS140388', 'LS140389', 'LS140392', 'LS140394', 'LS140413', 'LS140420', 'LS140428', 'LS140430', 'LS140443', 'LS140445', 'LS140446', 'LS140449', 'LS140451', 'LS140467', 'LS140468', 'LS140470', 'LS140473', 'LS140478', 'LS140483', 'LS140486', 'LS140497', 'LS140498', 'LS140500', 'LS140502', 'LS140506', 'LS140510', 'LS140511', 'LS140515', 'LS140522', 'LS140523', 'LS140524', 'LS140526', 'LS140530', 'LS140531', 'LS140532', 'LS140534', 'LS140543', 'LS140544', 'LS140546', 'LS140547', 'LS140548', 'LS140552', 'LS140560', 'LS140561', 'LS140565', 'LS140567', 'LS140568', 'LS140584', 'LS140597', 'LS140599', 'LS140616', 'LS140624', 'LS140628', 'LS140630', 'LS140634', 'LS140639', 'LS140642', 'LS140654', 'LS140656', 'LS140663', 'LS140665', 'LS140668', 'LS140669', 'LS140676', 'LS140681', 'LS140682', 'LS140683', 'LS140691', 'LS140696', 'LS140700', 'LS140707', 'LS140708', 'LS140710', 'LS140711', 'LS140713', 'LS140720', 'LS140721', 'LS140722', 'LS140723', 'LS140726', 'LS140727', 'LS140729', 'LS140731', 'LS140733', 'LS140734', 'LS140736', 'LS140737', 'LS140738', 'LS140739', 'LS140740', 'LS140741', 'LS140742', 'LS140743', 'LS140744', 'LS140745', 'LS140746', 'LS140747', 'LS150001', 'LS150016', 'LS150059', 'LS150067') AND a.supplierId=215) OR ( a.articleSearch IN ('65767', '6771') AND a.supplierId=4604) OR ( a.articleSearch IN ('755121', '755256') AND a.supplierId=405) OR ( a.articleSearch IN ('700103504', '71628TH', '782052063', '782551743', '782632270') AND a.supplierId=6411) OR ( a.articleSearch IN ('A2C59513168Z', 'A2C59513169Z', 'A2C59513171Z', 'A2C59513172Z', 'A2C59513173Z', 'A2C59513174Z', 'A2C59513175Z', 'A2C59513176Z', 'A2C59513185Z', 'A2C59513186Z', 'A2C59513189Z', 'A2C59513190Z', 'A2C59513215Z', 'A2C59513216Z', 'A2C59513217Z', 'A2C59513223Z', 'A2C59513224Z', 'A2C59513228Z', 'A2C59513229Z', 'A2C59513230Z', 'A2C59513231Z', 'A2C59513235Z', 'A2C59513236Z', 'A2C59513238Z', 'A2C59513240Z', 'A2C59513241Z', 'A2C59513298Z', 'A2C59513311Z', 'A2C59513313Z', 'A2C59513314Z', 'A2C59513315Z', 'A2C59513316Z', 'A2C59513317Z', 'A2C59513318Z', 'A2C59513319Z', 'A2C59513320Z', 'A2C59513321Z', 'A2C59513322Z', 'A2C59513323Z', 'A2C59513325Z', 'A2C59513326Z', 'A2C59513327Z', 'A2C59513328Z', 'A2C59513329Z', 'A2C59513331Z', 'A2C59513333Z', 'A2C59513334Z', 'A2C59513338Z', 'A2C59513345Z', 'A2C59513347Z', 'A2C59513869Z', 'A2C59513870Z', 'A2C59513871Z', 'A2C59513872Z', 'A2C59513875Z', 'A2C59513876Z', 'A2C59513878Z', 'A2C59513886Z', 'A2C59513887Z', 'A2C59513888Z', 'A2C59513889Z', 'A2C59513890Z', 'A2C59513891Z', 'A2C59513892Z', 'A2C59513893Z', 'A2C59513895Z') AND a.supplierId=83) OR ( a.articleSearch IN ('CSG9598', 'CSL2013', 'CSL2052', 'CSL2056', 'CSL2059', 'CSL2064', 'CSL2065', 'CSL2066', 'CSL2085', 'CSL2101', 'CSL2103', 'CSL2116', 'CSL2117', 'CSL2118', 'CSL2126', 'CSL2131', 'CSL2133', 'CSL2140', 'CSL2147', 'CSL2149', 'CSL2159', 'CSL2161', 'CSL2165', 'CSL2168', 'CSL2172', 'CSL2179', 'CSL2186', 'CSL2187', 'CSL2188', 'CSL2190', 'CSL2192', 'CSL2194', 'CSL2197', 'CSL2199', 'CSL2202', 'CSL2203', 'CSL2209', 'CSL2215', 'CSL2218', 'CSL2224', 'CSL2227', 'CSL2229', 'CSL2232', 'CSL2233', 'CSL2235', 'CSL2236', 'CSL2239', 'CSL2240', 'CSL2249', 'CSL2250', 'CSL2254', 'CSL2258', 'CSL2266', 'CSL2267', 'CSL2272', 'CSL2277', 'CSL2278', 'CSL2281', 'CSL2282', 'CSL2286', 'CSL2287', 'CSL2297', 'CSL2298', 'CSL2299', 'CSL2307', 'CSL2310', 'CSL2311', 'CSL2314', 'CSL2316', 'CSL2321', 'CSL2331', 'CSL2338', 'CSL2342', 'CSL2344', 'CSL2346', 'CSL2354', 'CSL2356', 'CSL2358', 'CSL2359', 'CSL2384', 'CSL2388', 'CSL2389', 'CSL2390', 'CSL2392', 'CSL2393', 'CSL2394', 'CSL2395', 'CSL2396', 'CSL2397', 'CSL2398', 'CSL2399', 'CSL2400', 'CSL2405', 'CSL2408', 'CSL2410', 'CSL2415', 'CSL2416', 'CSL2419', 'CSL2425', 'CSL2426', 'CSL2427', 'CSL2430', 'CSL2451', 'CSL2453', 'CSL2457', 'CSL2458', 'CSL2459', 'CSL2469', 'CSL2547', 'CSL2731', 'CSL2908') AND a.supplierId=4334)An internal server error occurred.