SELECT DISTINCT 
    m.manufacturerName AS cross_brand, 
    ao.manufacturerId, 
    ao.oemSearch, 
    ao.oemnumber, 
    ps.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 ('430361', '430362', '420931', '420932', '421162', '421352', '421481', '421482', '421491', '421492', '421701', '421702', '422001', '422471', '422472', '422712', '423601', '423602', '429581', '429582', '43026', '430261', '430262', '430281', '430282', '430291', '430292', '430301', '430302', '43036', '430401', '430402', '430461', '430462', '430571', '430572', '430581', '430582', '430701', '430702', '430731', '430732', '430921', '430922', '430961', '430962', '431071', '431072', '431141', '431142', '431241', '431242', '431351', '431352', '431441', '431442', '431591', '431592', '431651', '431652', '522551', '522552', '53114', '55006', '721091', '721092', '721321', '721322', '728721', '728722', '730321', '730322', '73265') AND a.supplierId=206) OR ( a.articleSearch IN ('MZBCBKRL', 'MZBCBKRR', 'MZBCBLFL', 'MZBCBLFR', 'ADBC8KBFL', 'ADBC8KBFR', 'BMBCE83RL', 'FDBCCA2FR', 'FDBCDAWFL', 'FDBCDAWFR', 'HNBCCL7FL', 'HNBCCL7FR', 'HNBCKA7RL', 'HNBCKA7RR', 'MZBCBLRR', 'NSBCP12ERL', 'NSBCP12ERR', 'OPBCVCBRL', 'OPBCVCBRR', 'VWBC5NFL', 'VWBC5NFR') AND a.supplierId=4631) OR ( a.articleSearch IN ('24357198135', '11010154072', '11023007361', '11817100081', '11938770062', '11938770212', '11957197752', '11957197852', '11957198212', '11957198222', '11960197122', '24338117075', '24338117077', '24338117087', '24338770015', '24338770025', '24338770035', '24338770045', '24338770055', '24338770065', '24338770155', '24338770165', '24338770215', '24338770225', '24338770275', '24338770285', '24338770875', '24338770885', '24338770995', '24338771005', '24354181055', '24354181065', '24357117335', '24357197535', '24357197545', '24357197555', '24357197565', '24357197575', '24357197585', '24357197595', '24357197605', '24357197655', '24357197665', '24357197755', '24357197765', '24357198145', '24357198415', '24357198425', '24357198635', '24357198645', '24357198715', '24357198725', '24357699965', '24360197125', '24957197855', '24957197865') AND a.supplierId=3) OR ( a.articleSearch IN ('D41151C', 'D41614C', 'D41614K', 'D41765C', 'D4365', 'D4448', 'D4592', 'D4612', 'D4935', 'D41039C', 'D41082C', 'D41189C', 'D42009C', 'D42111C', 'D42223C', 'D42223K', 'D7003', 'D7003C') AND a.supplierId=351) OR ( a.articleSearch IN ('FKT003', 'FKT004', 'F06114', 'F06200', 'F06201', 'F23186', 'F23187', 'F23198', 'F23199', 'F24090', 'F24091', 'F24112', 'F24113', 'F24114', 'F24115', 'F24133', 'F28046', 'F28047', 'F28080', 'F28081', 'F28088', 'F28089', 'F28096', 'F28097', 'F28124', 'F28125', 'F49096', 'F49097', 'F49104', 'F49105', 'F49111', 'F49118', 'F49119', 'F52044', 'F52045', 'F56116', 'F56117', 'F59128', 'F59129', 'F59130', 'F59131', 'F61210', 'F61211', 'F61244', 'F61245', 'F61258', 'F61259', 'F68080', 'F68081', 'F68082', 'F68083', 'F68084', 'F68085', 'F68132', 'F68133', 'F68134', 'F68135', 'F68136', 'F68137', 'F83180', 'F83181', 'F85270', 'F85271', 'F85272', 'F85273', 'F86078', 'F86079') AND a.supplierId=65) OR ( a.articleSearch IN ('BSG30245009', 'BSG30245010', 'BSG30245011', 'BSG30245012', 'BSG30251012', 'BSG30251014', 'BSG65245025', 'BSG65245026') AND a.supplierId=4455) OR ( a.articleSearch IN ('400203', '400464', '400683', '400706', '401029', '401402', '401695', '401695K', '401881', '401241', '401349', '401425', '401997', '402016', '402179', '402179K', '410007', '410031') AND a.supplierId=4512) OR ( a.articleSearch IN ('FT32465', 'FT32467') AND a.supplierId=4938) OR ( a.articleSearch IN ('0577CMZ3F', '0375RD7R', '0575MZ3F', '0575MZ3R', '0576MZ3F', '0576MZ3RKIT', '0577MZ3RL', '0577MZ3RR', '2173FOC', '2176CDHRKIT', '2475DUSTF', '2776S60F') AND a.supplierId=4674) OR ( a.articleSearch IN ('238041', '238913', '238979', '257047', '257911', '238044', '254046', '812001', '824002') AND a.supplierId=380) OR ( a.articleSearch IN ('8836033', '2125155', '2125156', '2125157', '2125158', '2110133', '2110134', '2115231', '2115232', '211553', '2119153', '2119154', '2119171', '2119172', '2122155', '2122156', '2125180', '2125191') AND a.supplierId=127) OR ( a.articleSearch IN ('HZPFR014A', 'HZPFR014', 'HZPFR015') AND a.supplierId=6355) OR ( a.articleSearch IN ('17289', '17290', '17400', '17401') AND a.supplierId=4683) OR ( a.articleSearch IN ('PRK187', 'PRK239', 'PRK245', 'PRK282', 'PBRC043', 'PBRC044', 'PBRC128', 'PBRC129') AND a.supplierId=4558) OR ( a.articleSearch IN ('0590438SX', '0590446SX', '0590468SX', '0590475SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('BHN709E', 'BHN710E', 'BHX394E', 'BHX395E') AND a.supplierId=4501) OR (a.articleSearch='PDF47199' AND a.supplierId=6372) OR (a.articleSearch='C2X013ABE' AND a.supplierId=4426) OR (a.articleSearch='55282' AND a.supplierId=6558) OR ( a.articleSearch IN ('9048', '9081') AND a.supplierId=317) OR ( a.articleSearch IN ('BCA1011', 'BCA1012', 'BCA1023', 'BCA1024', 'BCA1045', 'BCA1046', 'BCA1049', 'BCA1050', 'BCA1122', 'BCA1147', 'BCA1148', 'BCA1159', 'BCA1160', 'BCA1163', 'BCA1268', 'LCA104', 'LCA136', 'LCA163', 'LCA165', 'LCA199', 'LCA207', 'LCA231', 'LCA233', 'LCA237', 'LCA243', 'LCA332', 'LCA371', 'LCA449', 'LCA453', 'LCA631', 'LCA691', 'LCA697', 'LCA702', 'LCA745', 'LCA748', 'LCA760', 'LCA836', 'LCA884', 'RCA104', 'RCA136', 'RCA165', 'RCA173', 'RCA199', 'RCA207', 'RCA231', 'RCA233', 'RCA237', 'RCA332', 'RCA371', 'RCA449', 'RCA453', 'RCA631', 'RCA691', 'RCA697', 'RCA702', 'RCA745', 'RCA748', 'RCA749', 'RCA760', 'RCA836', 'RCA884') AND a.supplierId=4537) OR (a.articleSearch='X40821' AND a.supplierId=4975) OR ( a.articleSearch IN ('98905', '99364', '99367', '99374', '99376', '99847') AND a.supplierId=4576) OR (a.articleSearch='5100005' AND a.supplierId=257) OR ( a.articleSearch IN ('H30927NEW', 'H30928NEW', 'H30981NEW', 'H30983NEW', 'H30984NEW', 'H30993NEW', 'M45370', 'M45370NEW', 'M45375', 'M45375NEW', 'M45380NEW', 'M45385NEW', 'M45387NEW', 'M45388NEW', 'M45443NEW', 'M45754NEW', 'N01473NEW', 'N01474NEW', 'PAL41101', 'PAL41120', 'PAL41121', 'PAL41130', 'PAL41147', 'PAL41172', 'PAL41325', 'PAL41326', 'PAL41369', 'PAL41399', 'PAL41400', 'PAL41401', 'PAL41402', 'PAL41403', 'PAL41459', 'PAL41503', 'PAL41504', 'PAL41554', 'PAL41555', 'PAL41731', 'PAL41732', 'PAL41747', 'PAL41755', 'PAL41756', 'PAL41773', 'PAL41774', 'PAL41775', 'PAL41776', 'PAL41790', 'PAL41791', 'PAL41797', 'PAL41830', 'PAL41831', 'PAL41848', 'PAL41849', 'PAL41860', 'PAL41861', 'PAL42730', 'PAL42731', 'PAL42782', 'PAL42783', 'PAL42784', 'PAL42785', 'PAL42887', 'PAL42888', 'T45611NEW', 'T45612NEW') AND a.supplierId=442) OR ( a.articleSearch IN ('KD1016', 'KD6508', 'KD6508W', 'KD7348') AND a.supplierId=4854) OR (a.articleSearch='PBP2014' AND a.supplierId=4337) OR ( a.articleSearch IN ('290CA00017', '290CA00018', '290CA00091', '290CA00092', '290CA00103', '290CA00104', '290CA00113', '290CA00215', '290CA00216', '290CA00227', '290CA00228', '290CA00235', '290CA00236', '290CA00243', '290CA00244', '290CA00337', '290CA00578', '290CA00579', '290CA00644', '290CA00645', '290CA00801', '290CA00802', '290CA00973', '290CA00974', '290CA00977', '290CA00978', '290CA00979', '290CA00980', '290CA00993', '290CA00994', '290CA00997', '290CA00998', '290CA01031', '290CA01032', '290CA01067', '290CA01068', '290CA01087', '290CA01088', '290CA01133', '290CA01134', '290CA01145', '290CA01146', '290CA01171', '290CA01172', '290CA01175', '290CA01176', '290CA01466', '290CA01467', '290CA02173', '290CA02174', '290CA02211', '290CA02212', '290CA02558', '290CA02559', '290CA02733', '290CA02734') AND a.supplierId=6271) OR ( a.articleSearch IN ('590732', '590733', '591170', '591232', '591233', '591242', '591243', '591244', '591245', '591308', '591309', '591310', '591311', '591312', '591313', '591352', '591353', '591360', '591361', '591436', '591437', '591438', '591439', '591494', '591495', '591882', '591883', '592584', '592585', '592748', '592749', '592803', '593209', '593334', '593335', '593450', '593451', '593638', '593639', '593714', '593715', '593754', '593755', '593820', '593821', '593902', '593903', '593904', '593905', '593946', '593947', '594286', '594287', '594730', '594731', '594746', '594747', '594770', '594771', '594806', '594807', '594828', '594829', '594932', '594933') AND a.supplierId=49) OR ( a.articleSearch IN ('ADH24525N', 'ADH24526N') AND a.supplierId=350) OR ( a.articleSearch IN ('BBP1931', 'BBP1943') AND a.supplierId=475) OR (a.articleSearch='1987470006' AND a.supplierId=30) OR ( a.articleSearch IN ('AG0327', 'AG0328', 'AG0508', 'AG0544', 'AG0545', 'AG0574', 'AG0575', 'AG0576', 'AG0577', 'AG0578', 'AG0579', 'AG0605', 'AG0606', 'AG0609', 'AG0610', 'AG0671', 'AG0672', 'AG0673', 'AG0674', 'AG0712', 'AG0713', 'AG0887', 'AG0888', 'AG1170', 'AG1388', 'AG1389', 'AG1509', 'AG1510', 'AG1581', 'AG1582', 'AG1648', 'AG1669', 'AG1670', 'AG1671', 'AG1672', 'AG1718', 'AG1719', 'AG1934', 'AG1935', 'AG1938', 'AG1939') AND a.supplierId=4993) OR ( a.articleSearch IN ('342098', '342099', '342856', '342857', '342938', '342939', '343008', '343096', '343097', '343098', '343099', '343114', '343115', '343178', '343179', '343242', '343243', '343250', '343251', '343306', '343307', '343394', '343395', '343396', '343397', '343500', '343501', '343502', '343503', '343656', '343657', '343719', '343844', '343845', '343960', '343961', '343972', '343973', '344156', '344157', '344178', '344179', '344186', '344187', '344300', '344301', '344302', '344303', '344386', '344387', '344415', '344624', '344625', '344626', '344627', '344692', '344693', '344710', '344711', '344794', '344795', '344796', '344797', '344798', '344799', '345341', '345436') AND a.supplierId=114) OR ( a.articleSearch IN ('759572', '760419', '769515') AND a.supplierId=405) OR ( a.articleSearch IN ('CBC005L', 'CBC005R', 'CBC010L', 'CBC010R', 'CBC014L', 'CBC014R', 'CBC016L', 'CBC016R', 'CBC021L', 'CBC021R', 'CBC036R', 'CBC052L', 'CBC052R', 'CBC113L', 'CBC113R', 'CBC134L', 'CBC134R', 'CBC139L', 'CBC166L', 'CBC166R', 'CBC267L', 'CBC267R', 'CBC275L', 'CBC275R', 'CBC296L', 'CBC296R', 'CBC365L', 'CBC365R', 'CBC378L', 'CBC378R', 'CBC458L', 'CBC458R', 'CBC493L', 'CBC493R', 'CBC501L', 'CBC501R') AND a.supplierId=421) OR ( a.articleSearch IN ('323629', 'BA2707', 'BA2708', 'BA3001', 'BA3002') AND a.supplierId=6479) OR ( a.articleSearch IN ('LC7082', 'LC7083', 'LC7188', 'LC7189', 'LC7433', 'LC7605', 'LC7606', 'LC7719', 'LC7720', 'LC7733', 'LC7734', 'LP1958') AND a.supplierId=89) OR ( a.articleSearch IN ('B190014L', 'B190014R', 'B190067L', 'B190067R', 'B190085L', 'B190085R', 'B190108L', 'B190108R', 'B190111L', 'B190111R', 'B190241L', 'B190241R', 'B190255L', 'B190255R', 'B190257L', 'B190257R') AND a.supplierId=186) OR ( a.articleSearch IN ('1070170001', '1070170002', '1070170003') AND a.supplierId=4345) OR ( a.articleSearch IN ('3109920', '3113610', '3118030', '3118520', '3125620', '3134520', '3138720', '3140120', '3141100', '3147720', '3152410', '3159020', '3166210', '3169600', '3171100', '3172500', '3173500', '3181600', '3194310', '3204030', '3209920', '3213610', '3218520', '3225620', '3234520', '3238720', '3240120', '3241100', '3247720', '3252410', '3259020', '3263510', '3266210', '3271100', '3272500', '3273500', '3281600', '3294310', '4112920', '4124620', '4124920', '4136620', '4138920', '4171500', '4171800', '4172100', '4173000', '4175700', '4187200', '4188200', '4212920', '4224620', '4224920', '4236620', '4238920', '4271500', '4271800', '4272100', '4273000', '4275700', '4287200', '4288200') AND a.supplierId=460) OR (a.articleSearch='DP1010100394' AND a.supplierId=4948) OR ( a.articleSearch IN ('2224495', '2224496', '2224547', '2224548', '2224555', '2224591', '2224592', '2224601', '2224602', '2224617', '2224618', '2224653', '2224654', '2224655', '2224656', '2224664', '2224689', '2224690', '2224701', '2224702', '2224726', '2224753', '2224754', '2224759', '2224760', '2224763', '2224764', '2224785', '2224786', '2224797', '2224798', '2224819', '2224820', '2224821', '2224822', '2224837', '2224838', '2224851', '2224852', '2224853', '2224854', '2224915', '2224916', '2225245', '2225246', '2225277', '2225278', '2225281', '2225282', '2225285', '2225286', '2225303', '2225304', '2225349', '2225350', '2225373', '2225374', '2225427', '2225428', '2225441', '2225442', '2225445', '2225446', '2585015', '2585016', '2585027', '2585039', '2585040') AND a.supplierId=391) OR ( a.articleSearch IN ('DC72098', 'DC72099', 'DC722946', 'DC722947', 'DC73096', 'DC73097', 'DC73098', 'DC73099', 'DC73242', 'DC73243', 'DC73250', 'DC73251', 'DC73306', 'DC73307', 'DC73396', 'DC73397', 'DC73972', 'DC73973', 'DC74156', 'DC74157', 'DC74414', 'DC74415', 'DC74624', 'DC74625', 'DC82856', 'DC82857', 'DC82938', 'DC82939', 'DC83008', 'DC83114', 'DC83115', 'DC83178', 'DC83179', 'DC83394', 'DC83395', 'DC83500', 'DC83501', 'DC83502', 'DC83503', 'DC83656', 'DC83657', 'DC83719', 'DC83844', 'DC83845', 'DC83960', 'DC83961', 'DC84178', 'DC84179', 'DC84186', 'DC84187', 'DC84300', 'DC84301', 'DC84302', 'DC84303', 'DC84386', 'DC84387', 'DC84626', 'DC84627', 'DC84710', 'DC84711', 'DC84796', 'DC84797', 'DC85341', 'DC886232', 'DC886233', 'DC89454', 'DC89455', 'RAB83100', 'RAB83109', 'RAB833057', 'RAB833058', 'RAB84100', 'RAB84107', 'RAB84108', 'RAB84109', 'RAB84353', 'RAB84354', 'RAB84361', 'RAB84362', 'RAB84407', 'RAB84408', 'RAB84417', 'RAB84418', 'RAB85525', 'RAB85526', 'RAB93967', 'RAB93968', 'RAB94119', 'RAB94405', 'RAB94406', 'RAB94820', 'RAB94955', 'RAB94956', 'RAB95411', 'RAB95412', 'RAB95413', 'RAB95414') AND a.supplierId=457) OR ( a.articleSearch IN ('820411', '820669', '820711', '820752', '820753', '820861', '821163', '821542', '821626', '821934', '822099', '822158', '822265', '822354', '822378', '822410', '822477', '822509', '823108', '830411', '830711', '830752', '830753', '830861', '831163', '831542', '831626', '831653', '831934', '832099', '832158', '832265', '832354', '832378', '832410', '832477', '832509', '833004', '860703', '860712', '860751', '860775', '860781', '860827', '860828', '862192', '862264', '862294', '862366', '862398', '870703', '870712', '870751', '870775', '870781', '870827', '870828', '872192', '872264', '872294', '872366', '872398') AND a.supplierId=226) OR ( a.articleSearch IN ('BC52098', 'BC52099', 'BC53096', 'BC53097', 'BC53098', 'BC53099', 'BC53250', 'BC53251', 'BC53306', 'BC53307', 'BC53396', 'BC53397', 'BC53972', 'BC53973', 'BC54415', 'BC54624', 'BC54625', 'BC54798', 'BC54799', 'BC56010', 'BC56011', 'BC62856', 'BC62857', 'BC63008', 'BC63114', 'BC63115', 'BC63178', 'BC63179', 'BC63394', 'BC63395', 'BC63500', 'BC63501', 'BC63502', 'BC63503', 'BC63719', 'BC63844', 'BC63845', 'BC63887', 'BC63960', 'BC63961', 'BC64186', 'BC64187', 'BC64300', 'BC64301', 'BC64302', 'BC64303', 'BC64386', 'BC64387', 'BC64626', 'BC64627', 'BC64692', 'BC64693', 'BC64710', 'BC64711', 'BC64794', 'BC64795', 'BC64796', 'BC64797') AND a.supplierId=224) OR ( a.articleSearch IN ('23SKV041', '23SKV041BLACK', '23SKV041RED', '23SKV041YELLOW', '23SKV042', '23SKV042BLACK', '23SKV042RED', '23SKV042YELLOW', '23SKV043', '23SKV043BLACK', '23SKV043RED', '23SKV043YELLOW', '23SKV044', '23SKV044BLACK', '23SKV044RED', '23SKV044YELLOW', '23SKV073', '23SKV073BLACK', '23SKV073RED', '23SKV073YELLOW', '23SKV074', '23SKV074BLACK', '23SKV074RED', '23SKV074YELLOW', '23SKV077', '23SKV078', '23SKV171', '23SKV172', '23SKV223', '23SKV223BLACK', '23SKV223RED', '23SKV223YELLOW', '23SKV224', '23SKV224BLACK', '23SKV224RED', '23SKV224YELLOW', '23SKV743', '23SKV744', '23SKV803', '23SKV804', '34SKV041', '34SKV611', '34SKV612', '34SKV654', '34SKV951', '34SKV952', '42SKV051', '42SKV052', '42SKV243', '42SKV244', '42SKV543', '42SKV544', '44SKV081', '44SKV082', '44SKV173', '44SKV174', '44SKV351', '44SKV352', '46SKV931', '46SKV932') AND a.supplierId=4969) OR ( a.articleSearch IN ('53012110133', '53012110134', '53012115231', '53012115232', '5301211553', '53012119153', '53012119154', '53012119171', '53012119172', '53012122155', '53012122156', '53012125155', '53012125156', '53012125157', '53012125158', '53012125180', '53012125191', '5301212565', '5301212566', '53012126123', '53012126124', '53012126133', '53012126134', '53012126145', '53012126146', '53012126161', '53012126162', '5301212641', '5301212642', '53012132139', '53012132140', '53012132143', '53012132144', '53012136143', '53012136144', '5301213697', '5301213698', '53012137141', '53012137142', '53012139115', '53012139116', '53012139123', '53012139124', '53012139139', '53012139140', '5301213919', '5301213920', '5301213923', '5301213924', '5301213989', '5301213990', '5301214075', '5301214076', '53012145197', '53012145198', '53012147345', '53012147346', '5301214741', '5301214742', '53012148111', '53012148112') AND a.supplierId=4770) OR (a.articleSearch='05620' AND a.supplierId=101) OR ( a.articleSearch IN ('CTC5751', 'CTC5752', 'CTC5778') AND a.supplierId=271) OR ( a.articleSearch IN ('FCL694079', 'FCL694080', 'FCL694189', 'FCL694303', 'FCL694304', 'FCL694345', 'FCL694346', 'FCL694349', 'FCL694350', 'FCL694357', 'FCL694358', 'FCL694394', 'FCL694395', 'FCL694459', 'FCL694460', 'FCL694467', 'FCL694468', 'FCL694597', 'FCL694598', 'FCL694599', 'FCL694600', 'FCL694791', 'FCL694792', 'FCL694947', 'FCL694948', 'FCL694956', 'FCL695121', 'FCL695122', 'FCL695159', 'FCL695160', 'FCL695171', 'FCL695172', 'FCL695175', 'FCL695176', 'FCL695253', 'FCL695254', 'FCL695324', 'FCL695325') AND a.supplierId=62) OR (a.articleSearch='FO926381' AND a.supplierId=4887) OR ( a.articleSearch IN ('701297', '701687', '701688', '701701', '701702', '701863', '701864', '703027', '703028', '703235', '703236', '703271', '703272', '703489', '703490') AND a.supplierId=87) OR ( a.articleSearch IN ('RS381303A0', 'RS381307A0', 'RS381403A0', 'RS381407A0', 'RS571315A0', 'RS571322A0', 'RS571415A0', 'RS571422A0', 'RX381303A0', 'RX381304A0', 'RX381306A0', 'RX381307A0', 'RX381308A0', 'RX381403A0', 'RX381404A0', 'RX381406A0', 'RX381407A0', 'RX381408A0', 'RX3898123A0', 'RX3898124A0', 'RX3898125A0', 'RX3898126A0', 'RX3898213A0', 'RX3898214A0', 'RX3898223A0', 'RX3898224A0', 'RX3898243A0', 'RX3898244A0', 'RX3898265A0', 'RX3898266A0', 'RX3898313A0', 'RX3898314A0', 'RX541319A0', 'RX541419A0', 'RX571314A0', 'RX571315A0', 'RX571316A0', 'RX571414A0', 'RX571415A0', 'RX571416A0', 'RX5798129A0', 'RX5798130A0', 'RX5798169A0', 'RX5798170A0', 'RX5798175A0', 'RX5798176A0', 'RX5798213A0', 'RX5798214A0', 'RX5798217A0', 'RX5798218A0', 'RX5798219A0', 'RX5798220A0', 'RX5798221A0', 'RX5798222A0', 'RX5798225A0', 'RX5798226A0', 'RX5798257A0', 'RX5798258A0', 'RX5798263A0', 'RX5798264A0', 'RX5798287A0', 'RX5798288A0', 'RX579863A0', 'RX579887A0', 'RX579888A0', 'RX579897A0', 'RX579898A0', 'RX609884A0') AND a.supplierId=54) OR ( a.articleSearch IN ('BW6143', 'BW6177', 'BW6178', 'CI6205', 'CI6206', 'FO6073', 'FO6074', 'FO6173', 'FO6174', 'FO6183', 'FO6184', 'HO6087', 'HO6088', 'HO6119', 'HO6120', 'HO6121', 'HO6122', 'HO6129', 'HO6130', 'MZ6145', 'MZ6146', 'ND6219', 'ND6220', 'OP6193', 'OP6194', 'OP6217', 'OP6218', 'RE6127', 'RE6128', 'RE6133', 'RE6134', 'RE6151', 'RE6152', 'RE6197', 'RE6198', 'RV6049', 'RV6050', 'RV6085', 'RV6086', 'TY6261', 'TY6262', 'VO6106', 'VO6113', 'VO6114') AND a.supplierId=316) OR (a.articleSearch='6116212' AND a.supplierId=279) OR (a.articleSearch='2009R' AND a.supplierId=4663) OR ( a.articleSearch IN ('8AC355382651', '8AC355382661', '8AC355382671', '8AC355382681', '8AC355382691', '8AC355382701', '8AC355382711', '8AC355382721', '8AC355382731', '8AC355382741', '8AC355383071', '8AC355383081', '8AC355383091', '8AC355383101', '8AC355389091', '8AC355389101', '8AC355391451', '8AC355391461', '8AC355391471', '8AC355391481', '8AC355391491', '8AC355391501', '8AC355391911', '8AC355391921', '8AC355392491', '8AC355392731', '8AC355392741', '8AC355392831', '8AC355392841', '8AC355394341', '8AC355395471', '8AC355395481', '8AC355396071', '8AC355396081', '8AC355397651', '8AC355397661', '8AC355398671', '8AC355398681', '8AC355398891', '8AC355398911', '8AC355399231', '8AC355399241', '8AN355782671', '8AN355782681', '8AN355791491', '8AN355791501', '8AN355792491') AND a.supplierId=4734) OR ( a.articleSearch IN ('J3211049', 'J3212102', 'J3213039', 'J3213042', 'J3213055', 'J3214017', 'J3214029', 'J3214039', 'J3214044', 'J3214046', 'J3221049', 'J3222102', 'J3223039', 'J3223042', 'J3223055', 'J3224017', 'J3224029', 'J3224039', 'J3224044', 'J3224046', 'J3270304', 'J3283031', 'J3283039', 'J3284017', 'J3285021') AND a.supplierId=72) OR (a.articleSearch='HP8225' AND a.supplierId=4998) OR ( a.articleSearch IN ('70606063', '70611060', '70617003') AND a.supplierId=6359) OR (a.articleSearch='PP005AF' AND a.supplierId=156) OR (a.articleSearch='51005' AND a.supplierId=481) OR ( a.articleSearch IN ('1262000170', '1262000180') AND a.supplierId=268) OR ( a.articleSearch IN ('JCA1002L', 'JCA1002R', 'JCA1007L', 'JCA1007R', 'JCA1023L', 'JCA1023R', 'JCA1025L', 'JCA1025R', 'JCA1033L', 'JCA1037L', 'JCA1037R', 'JCA1041L', 'JCA1041R', 'JCA1046L', 'JCA1046R', 'JCA1063R', 'JCA1080L', 'JCA1080R', 'JCA1126L', 'JCA1126R', 'JCA1169L', 'JCA1169R') AND a.supplierId=4935) OR ( a.articleSearch IN ('JBC0015', 'JBC0016', 'JBC0048', 'JBC0068', 'JBC0069', 'JBC0070', 'JBC0071', 'JBC0072', 'JBC0087', 'JBC0088', 'JBC0105', 'JBC0151', 'JBC0152', 'JBC0163', 'JBC0164', 'JBC0183', 'JBC0184', 'JBC0185', 'JBC0186', 'JBC0187', 'JBC0188', 'JBC0191', 'JBC0192', 'JBC0203', 'JBC0204', 'JBC0517', 'JBC0518', 'JBC0613', 'JBC0614') AND a.supplierId=185) OR ( a.articleSearch IN ('342098', '342099', '342856', '342857', '342938', '342939', '343008', '343096', '343097', '343098', '343099', '343114', '343115', '343178', '343179', '343242', '343243', '343250', '343251', '343306', '343307', '343394', '343395', '343396', '343397', '343500', '343501', '343502', '343503', '343656', '343657', '343719', '343844', '343845', '343960', '343961', '343972', '343973', '344156', '344157', '344178', '344179', '344186', '344187', '344300', '344301', '344302', '344303', '344386', '344387', '344415', '344624', '344625', '344626', '344627', '344692', '344693', '344710', '344711', '344794', '344795', '344796', '344797', '344798', '344799', '345341') AND a.supplierId=286) OR ( a.articleSearch IN ('KBP1931', 'KBP1943') AND a.supplierId=4879) OR ( a.articleSearch IN ('9912425', '9912426', '9913259', '9913260', '9913309', '9913310', '9913405', '9913406', '9914082', '9914209', '9914210', '9914215', '9914216', '9914243', '9914437', '9914438', '9918025', '9918026', '9918057', '9918058', '9918090', '9918109', '9918110', '9918139', '9918140', '9918169', '9918170', '9918171', '9918172', '9918186') AND a.supplierId=78) OR ( a.articleSearch IN ('6030420', '6032057', '6032174', '6032318', '6036669', '6036891', '6210055') AND a.supplierId=4546) OR ( a.articleSearch IN ('751448', '751449', '752486', '752487', '752798', '752799', '753897', '753937', '753938', '755078', '755079', '770144', '770478', '770479', '770582', '770583', '770626', '770627', '771448', '771449', '771450', '771451', '771744', '771745', '772104', '772105', '772480', '772481', '772486', '772487', '772638', '772639', '772654', '772655', '772760', '772798', '772799', '772940', '772941', '773174', '773175', '773230', '773231', '773590', '773591', '773688', '773689', '773802', '773803', '773897', '773937', '773938', '774748', '774749', '774848', '774849', '774856', '774857', '774958', '774959', '774970', '774971', '775078', '775079', '775238', '775239', '775240', '775241', '775292', '775293', '775306', '775307', '775376', '775377', '775378', '775379') AND a.supplierId=4496) OR ( a.articleSearch IN ('BC0115', 'BC0118', 'BC0194', 'BC0265', 'BC0420', 'BC0447', 'BC0458', 'BC0488', 'BC0530', 'BC2036', 'BC2078', 'BC2089', 'BC2098', 'BC2137', 'BC4090', 'BC4100', 'BC4346', 'BC4375', 'BC4376', 'BC6097', 'BC6127', 'BC6135', 'BC6183', 'BC6366', 'BC6389', 'BC6396', 'BC6444', 'BC6448') AND a.supplierId=4600) OR ( a.articleSearch IN ('4114', '4115', '4154', '4155', '4508', '4509', '4636', '4637', '4670', '4671', '4674', '4675', '4770', '4771', '4772', '4773', '4776', '4777') AND a.supplierId=133) OR ( a.articleSearch IN ('270425', '270478', '270482', '270502', '270570', '271542', '271611', '491363', '491949', '491966', '820023', '820024', '820031', '820032', '820047', '820048', '820095', '820096', '820161', '820162', '820169', '820170', '820193', '820273', '820274', '820334', '820339', '820340', '820349', '820350', '820405', '820406', '820445', '820446', '820449', '820450', '820575', '820576', '820593', '820594', '820691', '820692', '820723', '820724', '820909', '820910', '821063', '821064', '821077', '821078', '821079', '821080') AND a.supplierId=403) OR ( a.articleSearch IN ('6227002', '6227003', '6228002', '6228003', '6252002', '6252003', '6273004', '6427002', '6427003', '6427007', '6428002', '6428003', '6452002', '6452003', '6452044', '6452045', '6453054', '6453055', '6454018', '6454019', '6454022', '6454023', '6471020', '6471021', '6471024', '6471025', '6471037', '6473004', '6473026', '6473027', '6475318', '6475319', '6475602', '6475603', '6483414', '6483415', '6628002', '6628003', '6652002', '6652003', '6652044', '6652045', '6654019', '6654022', '6654023', '6671020', '6671021', '6671024', '6671025', '6673026', '6673027') AND a.supplierId=4899) OR ( a.articleSearch IN ('MRP2B03', 'MSE9212', 'MSE9404', 'MSE9406') AND a.supplierId=4773) OR ( a.articleSearch IN ('43038', '43044', '58166') AND a.supplierId=4664) OR ( a.articleSearch IN ('6250017', '6250018', '6250045', '6250046', '6250111', '6250112', '6250273', '6250361', '6250362', '6250363', '6250364', '6250373', '6250374', '6250497', '6250498', '6250503', '6250504', '6250573', '6250574', '6250675', '6250676', '6250711', '6250712', '6250741', '6250742', '6250833', '6250834', '6250893', '6250894', '6251060', '6251069', '6251070', '6251073', '6251074', '6251129', '6251130', '6251159', '6251160', '6260017', '6260018', '6260045', '6260046', '6260111', '6260112', '6260273', '6260361', '6260362', '6260363', '6260364', '6260373', '6260374', '6260503', '6260504', '6261060', '6261069', '6261070', '6261073', '6261074', '6261129', '6261130', '6261262') AND a.supplierId=94) OR ( a.articleSearch IN ('VBC104L', 'VBC104R', 'VBC109L', 'VBC109R', 'VBC113L', 'VBC113R', 'VBC115L', 'VBC115R', 'VBC120L', 'VBC120R', 'VBC135R', 'VBC151L', 'VBC151R', 'VBC212L', 'VBC212R', 'VBC233L', 'VBC233R', 'VBC238L', 'VBC265L', 'VBC265R', 'VBC366L', 'VBC366R', 'VBC374L', 'VBC374R', 'VBC395L', 'VBC395R', 'VBC464L', 'VBC464R', 'VBC477L', 'VBC477R', 'VBC557L', 'VBC557R', 'VBC592L', 'VBC592R', 'VBC600L', 'VBC600R') AND a.supplierId=4564) OR ( a.articleSearch IN ('J3211045', 'J3214017', 'J3221045', 'J3224017', 'N3212099', 'N3213032', 'N3214034', 'N3214037', 'N3222099', 'N3223032', 'N3224034', 'N3224037', 'N3253001', 'N3254001', 'N3263001', 'N3264001') AND a.supplierId=248)An internal server error occurred.