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 ('17462', '16291', '16292', '17461', '17740', '17741', '17767', '17768', '17769', '18554', '37578', '17772', '17775', '17784') AND a.supplierId=206) OR ( a.articleSearch IN ('24011601231', '24012401271', '24012802131', '24013201311', '13046049782', '24011601241', '24011601251', '24012202981', '24012401381', '24012803071', '24013201881', '24011601151', '24011601141', '24012402081', '24012402091') AND a.supplierId=3) OR ( a.articleSearch IN ('ADP154342', 'ADBP430041', 'ADL144328', 'ADP154324', 'ADP154325', 'ADP154326', 'ADP154327', 'ADP154328', 'ADP154341') AND a.supplierId=350) OR ( a.articleSearch IN ('0986479066', '0986479297', '0986479313', '0986479315', '0986479316', '0986479399', '0986479S70', '0986478434', '0986478842', '0986479065', '0986479314', '0986479317', '0986479R86', '0986479R98', '0986479S73', '0986479S86', '0986494110', '0986495254', 'F026A06815', 'F026A06816', 'F026A06817') AND a.supplierId=30) OR ( a.articleSearch IN ('08809430', '08809440', '09893120', '09893121', '09C66311', '09D01811', '08809450', '08809460', '08A45910', '09590414', '09590614', '09893110', '09893210', '09961414', '09961514', '09A23520', '09A45810', '09D01711') AND a.supplierId=65) OR ( a.articleSearch IN ('5815201944', '5815201958', '5815201959', '5815203732', '5815311941', '5815311944', '5815311959', '5815311960', '5815201931', '5815201932', '5815201935', '5815201937', '5815201941', '5815201943', '5815201946', '5815201960', '5815203731', '5815209945', '5815209946', '5815311943', '5815311946', '5815311958', '5815311963', '5815313731', '5815313732', '5815319945', '5815319946', '5815201950', '5815201945', '5815311950', '5815311945') AND a.supplierId=4770) OR ( a.articleSearch IN ('1618863480', '1667858880', '1616060280', '1618862980', '1618863880', '1618864580', '1618865280', '1618865380', '1618878280', '1642766680', '1642766780', '1676014480') AND a.supplierId=4391) OR ( a.articleSearch IN ('43933', '43974', '10564', '10565', '171496', '43902', '43937', '43988', '44037', '44909') AND a.supplierId=101) OR ( a.articleSearch IN ('8DD355108981', '8DD355109021', '8DD355132141', '8DD355104431', '8DD355108961', '8DD355113711', '8DD355113731', '8DD355122691', '8DD355122701', '8DD355125261', '8DD355125291', '8DD355125421', '8EG008498651') AND a.supplierId=4734) OR ( a.articleSearch IN ('C1006P', '14807', '14808', '14922', '14932', '14967', '24534E', '24535E', '24813', '24814', '24863E', '24864E', '25160', '25227', '25255', '25255V', '25607V', '25633V', '25634V', '05P966', 'C1003P', 'C1003PR', 'C1006PR', 'C1012V', 'C1039P', 'C1039PR', 'F2006V', 'F2007V', 'F2014P', 'F2014PR', 'F2015P', 'F2015PR', 'F2024V', 'F2171V', 'F2171VR', 'F2181V', 'P1009V', 'P1022V') AND a.supplierId=283) OR ( a.articleSearch IN ('230340', '230885C', '2207100', '230341', '230731', '230732', '230884C', '230911C', '230912C', '230952C') AND a.supplierId=121) OR ( a.articleSearch IN ('2155210018', '2155210021', '2155230027', '2148600003', '2155210003', '2155210004', '2155210019', '2155210029', '2155230004', '2155230006', '2155230006PD', '2155230012', '2155230028', '2835210003PD', '2835210004PD', '2835210021PD') AND a.supplierId=144) OR ( a.articleSearch IN ('201944', '201958', '201959', '203732', '311941', '311944', '311958', '311959', '313732', '201941', '201943', '201946', '203731', '209945', '209946', '311943', '311946', '311960', '311963', '313731', '319945', '319946', '201950', '201945', '311950', '311945') AND a.supplierId=127) OR ( a.articleSearch IN ('92116703', '92157303', '92157403', '92116103', '92116203', '92157600', '92275003', '92275103', '92275105', '92284303', '92286103', '92305203', '92073903', '92157203', '92116603') AND a.supplierId=39) OR ( a.articleSearch IN ('DF4481S', 'DF4751S', 'DF4752', 'DF4770', 'DF2721', 'DF2722', 'DF4245', 'DF4481', 'DF4750', 'DF4753S', 'DF4769S', 'DF4771S', 'DF6918S', 'DF6925S') AND a.supplierId=4501) OR ( a.articleSearch IN ('C3C032ABE', 'C3C036ABE', 'C3F024ABE', 'C3F036ABE', 'C3P017ABE', 'C4C012ABE', 'C4F003ABE', 'C4F004ABE', 'C4F005ABE') AND a.supplierId=4426) OR ( a.articleSearch IN ('VBD4962', 'VBD4966') AND a.supplierId=4400) OR (a.articleSearch='BPFI2001' AND a.supplierId=4951) OR ( a.articleSearch IN ('BN0125', 'BN0125E', 'BN0168', 'BN0168E', 'BN0169', 'BN0169E', 'BN0172', 'BN0172E', 'BN0181', 'BN0181E', 'BN0205', 'BN0205E', 'BN0206', 'BN0206E', 'BN0207', 'BN0207E', 'BN0278', 'BN0278E', 'BN0282', 'BN0282E', 'BN0335', 'BN0335E', 'BN0415', 'BN0415E') AND a.supplierId=4024) OR ( a.articleSearch IN ('1110037', '1110047', '1110056', '1110122', '1110123', '1110126', '1110183', '1110193', '1110257', '1110352', '1110496', '1110543') AND a.supplierId=317) OR ( a.articleSearch IN ('DSK2247', 'DSK2259', 'DSK2479', 'DSK2480', 'DSK2481', 'DSK2482', 'DSK2483', 'DSK2484', 'DSK2625', 'DSK3258', 'DSK3260', 'DSK3331', 'DSK644', 'DSK925', 'SDK6072', 'SDK6181', 'SDK6185', 'SDK6192', 'SDK6209', 'SDK6389', 'SDK6489', 'SDK6490', 'SDK6491', 'SDK6566', 'SDK6857', 'SDK6934', 'SDK7006') AND a.supplierId=4537) OR ( a.articleSearch IN ('X601013', 'X601165', 'X601166', 'X602016', 'X602017') AND a.supplierId=4975) OR ( a.articleSearch IN ('71252', '71253', '71254', '71255', '71712', '71714', '71732', '73641', '74853') AND a.supplierId=4576) OR ( a.articleSearch IN ('30000200', '30ECO016', '50000018', '50000222', '50000655', '51000610', '60000237', '60000237C', '60000239', '60000239C', '60000240', '60000240C', '60000241', '60000241C', '60000618', '60000618C', '60000619', '60000619C', '60000620', '60000620C', '60000621', '60000621C', '61000216', '61000216C', '61000217', '61000217C', '61000230', '61000230C', '61000609', '61000609C', '61000611', '61000611C', 'MA00135', 'MA00680', 'MA00691', 'PM403') AND a.supplierId=257) OR ( a.articleSearch IN ('P11050', 'P11066', 'P330011', 'P330023', 'P330071', 'P330080', 'P331009', 'P331024', 'P331041') AND a.supplierId=442) OR (a.articleSearch='830165' AND a.supplierId=300) OR ( a.articleSearch IN ('PDC0486', 'PDC0575', 'PDC0578', 'PDC0582', 'PDC0614', 'PDC2466', 'PDC3174', 'PDC3178', 'PDC5306') AND a.supplierId=4337) OR ( a.articleSearch IN ('290BK00411', '290BK00412', '290BK00443', '290BK00444', '290BK00482', '290BK00496', '290BK00587', '290BK00588', '290BK02309') AND a.supplierId=6271) OR ( a.articleSearch IN ('BA2241', 'BAR16114', 'BAR16124', 'BAR24127', 'BAR24138') AND a.supplierId=394) OR ( a.articleSearch IN ('521714', '521963', '521964', '522115', '522134', '522135', '522141', '522142', '522160', '522180', '522261', '561969J', '561969JC', '561984J', '561984JC', '562215J', '562215JC', '562468J', '562468JC', '562526JC', '562629JC', '562630JC', '562630JC1', '562644JC', '562753JC', '562757JC', '562835JC', '563018J', '563021J', '563026J', '563144JC', '563223J') AND a.supplierId=49) OR ( a.articleSearch IN ('BBD4404', 'BBD4405', 'BBD4608', 'BBD4609', 'BBD4621', 'BBD4668', 'BBD4801', 'BBD4802', 'BBD5094', 'BBD5112', 'BBD5805S', 'BBD6125S', 'BBD6154S', 'BBD6156S', 'BBP2035') AND a.supplierId=475) OR (a.articleSearch='GN037' AND a.supplierId=6444) OR ( a.articleSearch IN ('AD0002', 'AD0267', 'AD0348', 'AD0405', 'AD0791', 'AD0985', 'AE0085', 'AE0145', 'AE0176', 'AE0718', 'AE0728') AND a.supplierId=4993) OR ( a.articleSearch IN ('239170070310', '244650070300', 'BR070SA100', 'BR075SA100', 'BR323VA100', 'BR334VA100', 'BR348VA100') AND a.supplierId=281) OR ( a.articleSearch IN ('BS7606', 'BS7607', 'BS7712', 'BS7722', 'BS7758', 'BS8165', 'BS8166', 'BS8439', 'BS8440', 'BS8529', 'BS8530', 'BS8770', 'BS8837', 'BS8865', 'BV8865', 'BV9217', 'BV9243', 'BV9244') AND a.supplierId=289) OR ( a.articleSearch IN ('CD6767S', 'CD6768V', 'CD6786S', 'CD7144S', 'CD7145S', 'CD7170V', 'CD7171V', 'CD7321V', 'CD7574S', 'CD7653S', 'CD7718V', 'CD7800V', 'CD7809V', 'CD7823S', 'CD8659V') AND a.supplierId=4872) OR ( a.articleSearch IN ('BSG25210009', 'BSG70210003', 'BSG70210005', 'BSG70210016', 'BSG70210017') AND a.supplierId=4455) OR ( a.articleSearch IN ('1421409', '1421413', '1421414', '1421417', '1421418', '1421491', '1421504', '142169', '142173', '1421749', '1421750', '1422009', '142212', '142213', 'HPD1409', 'HPD1413', 'HPD1414', 'HPD1491', 'HPD1504', 'HPD169', 'HPD173', 'HPD1749', 'HPD2009', 'HPD212', 'HPD213') AND a.supplierId=243) OR ( a.articleSearch IN ('55406', '55407', '55408', '55409', '55562', '55563', '55578', '55579', '55580') AND a.supplierId=4604) OR ( a.articleSearch IN ('561969CH', '561984CH', '562350CH', '562468CH', '562526CH', '562629CH1', '562630CH1', '562753CH', '562757CH', '563018CH', '563021CH', '563026CH', '573113CH', '573274CH') AND a.supplierId=43) OR ( a.articleSearch IN ('800340', '800341', '800731', '800732', '800884C', '800885C', '800911C', '800912C', '800952C', '8227100') AND a.supplierId=311) OR ( a.articleSearch IN ('ADC1532V', 'ADC1535V', 'ADC1536V', 'ADC1564', 'ADC1570V', 'ADC1571V', 'ADC1572V', 'ADC1577', 'ADC1578', 'ADC1822', 'ADC2833V', 'ADC2834V', 'ADC2835', 'ADC2867V', 'ADC4002V', 'ADC9143', 'ADC9144', 'AND6182', 'AND6222', 'AND6265', 'AND6313', 'AND6499', 'AND6564', 'AND6566', 'AND6814', 'AND7020', 'AND7021', 'AND7022', 'AND7054', 'AND7184') AND a.supplierId=421) OR ( a.articleSearch IN ('600342', '600605', '600615', '600620', '602285', '602290', '602301', '602622', '602705', '602706', '603720', '609980', '609981', '609982') AND a.supplierId=6479) OR ( a.articleSearch IN ('BG2846', 'BG2847', 'BG3841', 'BG3842', 'BG3853', 'BG3923', 'BG4059', 'BG4060', 'BG4061', 'BG4062', 'BG4099', 'BG4796C', 'BG4823C', 'BG9180C') AND a.supplierId=89) OR ( a.articleSearch IN ('B110938', 'B130031', 'B130070', 'B130292', 'B130293', 'B130296', 'B130372', 'B130438', 'B130442') AND a.supplierId=186) OR ( a.articleSearch IN ('N08034', 'N08042', 'N08068', 'N08068P', 'N08069', 'N08395', 'N08399', 'N08399P', 'N0842P', 'N08464', 'N08465', 'N08469', 'N08469P', 'N08470', 'N08470P', 'N08712', 'N7044') AND a.supplierId=4396) OR ( a.articleSearch IN ('DFD1017', 'DFD1029') AND a.supplierId=471) OR ( a.articleSearch IN ('1070100095', '1070100101', '1070100130', '1070100142', '1070110036', '1070110039') AND a.supplierId=4345) OR ( a.articleSearch IN ('PCD18192', 'PCD19442', 'PCD19452', 'PCD19491', 'PCD19502', 'PCD19512', 'PCD19622', 'PCD19692') AND a.supplierId=278) OR ( a.articleSearch IN ('DP1010110196', 'DP1010110234', 'DP1010110285', 'DP1010110293', 'DP1010110543', 'DP1010110548', 'DP1010110777', 'DP1010110792', 'DP1010111371', 'DP1010111384', 'DP1010111438', 'DP1010111458') AND a.supplierId=4948) OR ( a.articleSearch IN ('1241000', '1241001', '1241002', '1241003', '1241005', '1241006', '1293102') AND a.supplierId=355) OR ( a.articleSearch IN ('D832', 'D833') AND a.supplierId=6368) OR ( a.articleSearch IN ('28251039', '28251049') AND a.supplierId=6374) OR ( a.articleSearch IN ('RAD1079C', 'RAD1154C', 'RAD1188C', 'RAD1189C', 'RAD1212C', 'RAD1316C', 'RAD1320C', 'RAD1346C', 'RAD1451C', 'RAD1462C', 'RAD1463C', 'RAD1489C', 'RAD1500C', 'RAD1625C', 'RAD1679C', 'RAD1717C', 'RAD1725C', 'RAD1727C', 'RAD1878C', 'RAD1886C', 'RAP1081') AND a.supplierId=457) OR ( a.articleSearch IN ('190150', '190357', '190358', '194032', '194681', '194682', '197412', '197413', '197414') AND a.supplierId=309) OR (a.articleSearch='0911101191' AND a.supplierId=246) OR ( a.articleSearch IN ('FT31007', 'FT31034', 'FT31069', 'FT31070', 'FT31095', 'FT31096', 'FT31108', 'FT31109', 'FT31110', 'FT82736') AND a.supplierId=4938) OR (a.articleSearch='FD12043A' AND a.supplierId=6543) OR ( a.articleSearch IN ('TB215372', 'TB217039', 'TB218029', 'TB218201', 'TB219061') AND a.supplierId=271) OR ( a.articleSearch IN ('DDF1144', 'DDF1144C', 'DDF1145', 'DDF1170', 'DDF1170C', 'DDF1171', 'DDF1171C', 'DDF1574', 'DDF1574C', 'DDF1653', 'DDF1653C', 'DDF1718', 'DDF17181', 'DDF1800', 'DDF1800C', 'DDF1809', 'DDF1809C', 'DDF1823', 'DDF18231', 'DDF1880C', 'DDF2659', 'DDF767', 'DDF767C', 'DDF768', 'DDF768C', 'DDF1566') AND a.supplierId=62) OR ( a.articleSearch IN ('FBD202', 'FBP4233') AND a.supplierId=4838) OR ( a.articleSearch IN ('FO2178', 'FO2179', 'FO2674', 'FO2698', 'FO2711', 'FO2791', 'FO2831', 'FO2835', 'FO4122') AND a.supplierId=4887) OR ( a.articleSearch IN ('BD3806', 'BD4622', 'BD4681', 'BD4682', 'BD4696', 'BD5622', 'BD5626', 'BD7076', 'FBP1479') AND a.supplierId=409) OR ( a.articleSearch IN ('7260', 'BD0114', 'BD0547', 'BD0834', 'BD0869', 'BD1165', 'BD1182', 'BD1224', 'BD1240', 'BD1403') AND a.supplierId=295) OR ( a.articleSearch IN ('BS4361', 'BS4361B', 'BS4362', 'BS4362B', 'BS5364', 'BS5364B', 'BS5365', 'BS5365B', 'BS7166', 'BS7166B', 'BS7167', 'BS7167B', 'BS7169', 'BS7170', 'BS7170B', 'BS7357', 'BS7357B', 'BS7772', 'BS7772B') AND a.supplierId=54) OR ( a.articleSearch IN ('B1G10205162', 'B1G21601231', 'B1G21601241', 'B1G22401271', 'B1G22401381') AND a.supplierId=500) OR ( a.articleSearch IN ('6027211', '6027221', '6042454', '6044814', '6044815', '6047504', '6047515', '6047524', '6047535', '6047695', '6047704', '6047715', '6069185', '6069255') AND a.supplierId=279) OR (a.articleSearch='210186' AND a.supplierId=373) OR (a.articleSearch='J3300814' AND a.supplierId=72) OR ( a.articleSearch IN ('SD5506', 'SD5507') AND a.supplierId=6265) OR ( a.articleSearch IN ('78BD38061', '78BD46221', '78BD46812', '78BD46822', '78BD46961', '78BD56222', '78BD56231', '78BD56251') AND a.supplierId=158) OR ( a.articleSearch IN ('801068', '801069', '801113', '801114', '801115', '801188', '801226', '801276', '801425', '801688', '801726', '801806', '802016', '802038', '802260') AND a.supplierId=4862) OR ( a.articleSearch IN ('DI0237', 'DI0237C', 'DI0239', 'DI0239C', 'DI0240', 'DI0240C', 'DI0241', 'DI0241C', 'DI0618', 'DI0618C', 'DI0619', 'DI0619C', 'DI0620', 'DI0620C', 'DI0621', 'DI0621C', 'DP0216', 'DP0216C', 'DP0217', 'DP0217C', 'DP0230', 'DP0230C', 'DP0609', 'DP0609C', 'DP0611', 'DP0611C', 'FC0200S', 'FCECO016', 'MM00135', 'MM00680', 'MM00691', 'PA0018AF', 'PA0222AF', 'PA0655AF', 'PM403', 'PP0610AF') AND a.supplierId=156) OR ( a.articleSearch IN ('300200', '3ECO016', '500018', '500222', '500655', '510610', '600237', '600237C', '600239', '600239C', '600240', '600240C', '600241', '600241C', '600618', '600618C', '600619', '600619C', '600620', '600620C', '600621', '600621C', '610216', '610216C', '610217', '610217C', '610230', '610230C', '610609', '610609C', '610611', '610611C', 'MJ00135', 'MJ00680', 'MJ00691', 'PM403') AND a.supplierId=481) OR ( a.articleSearch IN ('4163100900', '4163101900', '4163102000', '4163102500', '4163200400', '4163200500', '4163200900', '4163201000') AND a.supplierId=268) OR ( a.articleSearch IN ('CIT104', 'CIT106', 'CIT107', 'CIT112', 'CIT113', 'CIT114', 'CIT116', 'CIT117', 'CIT160', 'JCP023', 'CIT118', 'CIT115', 'CIT158', 'CIT159') AND a.supplierId=4935) OR ( a.articleSearch IN ('103131', '103139', '1031534', '1031536', '103314', '1033148', '1033646') AND a.supplierId=185) OR ( a.articleSearch IN ('6101510', '6101610', '6105500', '6105600', '6105700', '6112000', '6115510', '6120410', '6135110', '6160010', '6163710', '6210910', '647610', '650410', '674100') AND a.supplierId=286) OR ( a.articleSearch IN ('KBD4404', 'KBD4608', 'KBD4609', 'KBD4621', 'KBD4668', 'KBD4801', 'KBD5094', 'KBD6154S') AND a.supplierId=4879) OR ( a.articleSearch IN ('25039Z', '25136Z', '25180Z', '25243Z', '25288Z', '25377Z', '25444Z', '25627Z', '25647Z', '25720Z', '25731Z', '25734Z') AND a.supplierId=387) OR ( a.articleSearch IN ('6045810', '6045820', '6045905', '6045909', '6045913', '6053110', '6053120', '6055907') AND a.supplierId=4546) OR ( a.articleSearch IN ('3087301', '3087801', '3088001', '30873', '30878', '30880') AND a.supplierId=35) OR ( a.articleSearch IN ('062900060304', '353611525240', '353611526240', '353611533540', '353611533550', '353611535240', '353611536240', '360406022600', '360406022700', '360406023500', '360406023600', '360406023800', '360406023900', '360406065100', '360406072800', '360406159101', '361302040133', '361302040135', '361302040137', '361302040166', '361302040168', '361302040228', '361302040230', '361302040271', '361302040331', '361302040512', '361302040538', '431602040290', '431602040490') AND a.supplierId=4723) OR ( a.articleSearch IN ('MBC035270', 'MBC035275', 'MBC035276', 'MBC035277', 'MBC035280', 'MBC035281', 'MBC035283') AND a.supplierId=4570) OR ( a.articleSearch IN ('15037', '15038', '15332', '15334', '15336', '15416', '25038', '25040') AND a.supplierId=133) OR ( a.articleSearch IN ('13046049782NSETMS', '13046049782SETMS', '201601150', '201601151', '201601230', '202401270', '202401380', '202802130', '203201310', '24011601141PCSMS', '24011601141SETMS', '24011601151PCSMS', '24011601151SETMS', '24011601231PCSMS', '24011601231PRPCSMS', '24011601241PCSMS', '24011601241SETMS', '24011601251PCSMS', '24011601251SETMS', '24012401271PCSMS', '24012401271SETMS', '24012401381PCSMS', '24012401381SETMS', '24012802131PCSMS', '24012802131SETMS', '24013201311PCSMS', '24013201311SETMS', '24112527861PCSMS', '24112528011PCSMS', '24112528011PRPCSMS', '24112528011SETMS') AND a.supplierId=358) OR ( a.articleSearch IN ('190798', '190798MAX', '190798SPORT', '190799', '190799MAX', '190799SPORT', '190993', '190993MAX', '190993SPORT', '191066', '191066SPORT', '191207', '191334', '191334MAX', '191334SPORT', '191876', '191876MAX', '191876SPORT', '191944', '191944MAX', '192001', '192001MAX', '192006', '192007', '192007MAX', '192007SPORT', '192008', '192008SPORT', '193532', '193532SPORT') AND a.supplierId=403) OR ( a.articleSearch IN ('8756310000', '8756310060', '8756310080', '8756316060', '8756316880', '8756316980', '8756410000', '8756410060', '8756410080', '8756416060', '8756416880', '8756416980', '8756420000', '8756420060', '8756420080', '8756426060', '8756426880', '8756426980', '8756500000', '8756500060', '8756500080', '8756506060', '8756506880', '8756506980', '8756510000', '8756510060', '8756510080', '8756516060', '8756516880', '8756516980', '8772130000', '8772130060', '8772130080', '8772136060', '8772136880', '8772136980', '8772200000', '8772200060', '8772200080', '8772206060', '8772206880', '8772206980', '8772440000', '8772440060', '8772440080', '8772446060', '8772446880', '8772446980', '8772470000', '8772470060', '8772470080', '8772476060', '8772476880', '8772476980', '8772480000', '8772480060', '8772480080', '8772486060', '8772486880', '8772486980') AND a.supplierId=4899) OR (a.articleSearch='MBR6021' AND a.supplierId=349) OR ( a.articleSearch IN ('6110104', '6110163', '6110252', '6110338', '6110354', '6110438', '6110497', '6110647', '6110651', '6110851') AND a.supplierId=94) OR ( a.articleSearch IN ('K000487', 'K000488', 'K000514', 'K000566', 'K000670', 'K001550', 'K010636', 'K010676', 'K011497') AND a.supplierId=6495) OR ( a.articleSearch IN ('MDC1650', 'MDC1686', 'MDC1816', 'MDC1978', 'MDC2006', 'MDC2058', 'MDC2685', 'MDC2686', 'MDC2686C', 'MDC2752C', 'MDC2755', 'MDC2878C', 'MVK0079', 'MVK0081', 'MVK0082', 'MDC1817', 'MDC840', 'MDC1849', 'MDC2154') AND a.supplierId=73) OR ( a.articleSearch IN ('LVBD1172', 'LVBD1200', 'LVBD1282', 'LVBD1283', 'LVBD1284', 'LVBD1285', 'LVBD1286', 'LVBD1287', 'LVBD1313', 'LVBD1842', 'LVBD1908', 'LVBD1928', 'LVBD800', 'LVBD801') AND a.supplierId=4564) OR (a.articleSearch='M18253' AND a.supplierId=6533) OR (a.articleSearch='18162081' AND a.supplierId=4653) OR ( a.articleSearch IN ('NBD1257', 'NBD1311', 'NBD1441', 'NBD1442', 'NBD1443', 'NBD1532', 'NBD1533', 'NBD1926', 'NBD1951', 'NBD1989', 'NBD747') AND a.supplierId=190) OR ( a.articleSearch IN ('NB015870V05F', 'NB021660S05R') AND a.supplierId=6280) OR ( a.articleSearch IN ('2133992', '2134042', '2134045', '2134604', '2134606', '2134608', '2134618', '2134620', '2135666', '2143285', '2143290', '2143332', '2143343') AND a.supplierId=4380) OR ( a.articleSearch IN ('BDA115120', 'BDA115220', 'BDA203310', 'BDA217610', 'BDA236620', 'BDA238410', 'BDA238510', 'BDA238610', 'BDA243820', 'BDA243920', 'BDA278620', 'BDA280120', 'BDA281820') AND a.supplierId=378) OR ( a.articleSearch IN ('BS4760', 'BS4760HC', 'BS5040', 'BS5040HC', 'BS6750', 'BS6760', 'BS6760C', 'BS8372', 'BS8372C', 'BS8374', 'BS8374C', 'BS8376', 'BS8376C', 'BS8378', 'BS8378HC', 'BS8380', 'BS8380HC', 'BS8382', 'BS8382HC', 'BS8384', 'BS8384HC', 'BS9434HC') AND a.supplierId=129) OR (a.articleSearch='09380' AND a.supplierId=4683) OR ( a.articleSearch IN ('PBD1810', 'PBD1917', 'PBD2721', 'PBD2722', 'PBD4245', 'PBD4752', 'PBD4770') AND a.supplierId=4558) OR ( a.articleSearch IN ('5042', '5046', '5048', '5388', '5680', 'V021', 'V022', 'V023', 'V038', 'V039', 'V059', 'V096', 'V1555', 'V1556', 'V1557', 'V485', 'V756') AND a.supplierId=291) OR ( a.articleSearch IN ('50100768', '50101170', '50101574', '50101653') AND a.supplierId=4686) OR ( a.articleSearch IN ('PRD2121', 'PRD2124', 'PRD2338', 'PRD2339', 'PRD2342', 'PRD2503', 'PRD2541', 'PRD3081', 'PRD5203', 'PRD5222', 'PRD5282', 'PRD5354', 'PRD5387', 'PRD6313') AND a.supplierId=4520) OR ( a.articleSearch IN ('QD0865', 'QD3217', 'QD3229', 'QD3403', 'QD6469', 'QD8444', 'QD8699', 'QD9523') AND a.supplierId=4821) OR ( a.articleSearch IN ('BDC4361', 'BDC4362', 'BDC4399', 'BDC4400', 'BDC5364', 'BDC5365', 'BDC5579', 'BDC5580', 'BDC5592', 'BDC5594', 'BDC5610', 'BDC5661', 'BDC5662') AND a.supplierId=57) OR ( a.articleSearch IN ('RD00123', 'RD00125', 'RD00126', 'RD00128', 'RD00645', 'RD00646', 'RD00683', 'RD01068', 'RD01069', 'RD01399', 'RD01448', 'RD01541') AND a.supplierId=400) OR ( a.articleSearch IN ('78RBD13806', '78RBD14696', '78RBD24622', '78RBD24681', '78RBD24682', '78RBD25622', '78RBD15623', '78RBD15625') AND a.supplierId=4955) OR ( a.articleSearch IN ('6101510', '6101610', '6105500', '6105600', '6105700', '6112000', '6115510', '6120410', '6135110', '6160010', '6163710', '6210910', '647610', '650410', '674100', '848601', '848700') AND a.supplierId=153) OR ( a.articleSearch IN ('RAD1079C', 'RAD1154C', 'RAD1188C', 'RAD1189C', 'RAD1212C', 'RAD1316C', 'RAD1320C', 'RAD1346C', 'RAD1451C', 'RAD1462C', 'RAD1463C', 'RAD1489C', 'RAD1500C', 'RAD1625C', 'RAD1679C', 'RAD1717C', 'RAD1725C', 'RAD1727C', 'RAD1878C', 'RAD1886C', 'RAP1081', 'RAD1494C', 'RAD1683C', 'RAD1741C', 'RAD1439C', 'RAD1734C', 'RAD1785C', 'RAD1624C', 'RAD1651C', 'RAD2030C', 'RAD1921C', 'RAD1879C', 'RAD2042C', 'RAP1233', 'RAP1260', 'RAP1433') AND a.supplierId=214) OR ( a.articleSearch IN ('402B0192', '82B0120', '82B0134', '82B0173', '82B0325', '82B0498', '82B0561', '82B0600', '82B0964') AND a.supplierId=6358) OR ( a.articleSearch IN ('6101510', '6101610', '6105500', '6105600', '6105700', '6112000', '6115510', '6120410', '6135110', '6160010', '6163710', '6210910', '647610', '650410', '674100', '848601', '848700') AND a.supplierId=152) OR ( a.articleSearch IN ('RT1497', 'RT1497GL', 'RT1497GLT3', 'RT1497GLT5', 'RT1497GLT6', 'RT1602', 'RT1602GL', 'RT1602GLT3', 'RT1602GLT5', 'RT1602GLT6', 'RT1743', 'RT1743GL', 'RT1743GLT3', 'RT1743GLT5', 'RT1743GLT6', 'RT1744', 'RT1744GL', 'RT1744GLT3', 'RT1744GLT5', 'RT1744GLT6', 'RT1763', 'RT1763GL', 'RT1763GLT3', 'RT1763GLT5', 'RT1763GLT6', 'RT20657', 'RT20657GL', 'RT20657GLT3', 'RT20657GLT5', 'RT20657GLT6', 'RT20732', 'RT20732GL', 'RT20732GLT3', 'RT20732GLT5', 'RT20732GLT6', 'RT21728', 'RT21728GL', 'RT21728GLT3', 'RT21728GLT5', 'RT21728GLT6', 'RT2763', 'RT2763GL', 'RT2763GLT3', 'RT2763GLT5', 'RT2763GLT6', 'RT2823', 'RT2823GL', 'RT2823GLT3', 'RT2823GLT5', 'RT2823GLT6') AND a.supplierId=4676) OR ( a.articleSearch IN ('5SP966', 'C1003P', 'C1003PR', 'C1006P', 'C1006PR', 'C1012V', 'C1039P', 'C1039PR', 'F2006V', 'F2007V', 'F2014P', 'F2014PR', 'F2015P', 'F2015PR', 'F2024V', 'F2171V', 'F2171VR', 'F2181V', 'P1009V', 'P1022V') AND a.supplierId=343) OR ( a.articleSearch IN ('2464L24J', '2464Y34J', '2464Y94J', '2464Z34J', '6100017', '6100018', '6100019', '6100021', '6100022', '6100023', '6210025') AND a.supplierId=260) OR ( a.articleSearch IN ('1815201931', '1815201932', '1815201935', '1815201937', '1815201941', '1815201943', '1815201944', '1815201946', '1815201958', '1815201959', '1815201960', '1815203731', '1815203732', '1815209945', '1815209946', '1815311943', '1815311944', '1815311946', '1815311958', '1815311959', '1815311960', '1815311963', '1815313731', '1815313732', '1815319945', '1815319946', '1815201950', '1815201945', '1815311942', '1815311950', '1815311941', '1815311945') AND a.supplierId=297) OR ( a.articleSearch IN ('DBA767S', 'DBA768V', 'DBA786S', 'DBB144S', 'DBB145S', 'DBB170V', 'DBB171V', 'DBB321V', 'DBB574S', 'DBB653S', 'DBB718V', 'DBB800V', 'DBB809V', 'DBB823S', 'DBC659V') AND a.supplierId=6331) OR ( a.articleSearch IN ('SKBD0020122', 'SKBD0020138', 'SKBD0020177', 'SKBD0020330', 'SKBD0022218', 'SKBD0022341', 'SKBD0022412', 'SKBD0023114', 'SKBK1090195', 'SKBP0010192') AND a.supplierId=6357) OR ( a.articleSearch IN ('001090LSX', '001090SX', '60201088KSX', '60201088SX', '60201136VSX', '60201477KSX', '60201477SX', '60203732KSX', '60203732SX', '60209945VKSX', '60209945VSX', '60209946VKSX', '60209946VSX', '60209956KSX', '60209956SX', '60209966KSX', '60209966SX', '60209967KSX', '60209967SX') AND a.supplierId=4595) OR (a.articleSearch='576003' AND a.supplierId=6691) OR ( a.articleSearch IN ('031102600020', '031102600030', '031102600040', '031102600050', '031102600060', '031102600070', '031102600080', '031102600090', '031102600100') AND a.supplierId=336) OR ( a.articleSearch IN ('33100926', '62943933', '62943937', '62943974', '62944909', '70910564', '70910565', '70943902', '70943988', '70944037') AND a.supplierId=151) OR ( a.articleSearch IN ('755195', '755210', '755255', '755374', '755375', '755400', '756031', '756032', '756033') AND a.supplierId=6312) OR ( a.articleSearch IN ('TX7019', 'TX7060', 'TX7061', 'TX7095', 'TX7138', 'TX7235', 'TX7257') AND a.supplierId=4377) OR ( a.articleSearch IN ('721169', '721183', '721184', '722454', '722458', '722596', '722597', '723311') AND a.supplierId=301) OR ( a.articleSearch IN ('BD1039', 'BD1040', 'BD1041', 'BD1042', 'BD1077', 'BD1157', 'BD1158', 'BD1196', 'BD1216') AND a.supplierId=4732) OR ( a.articleSearch IN ('DF165101', 'DF165102', 'DF165103', 'DF165104', 'DF165105', 'DF165106', 'DF165107') AND a.supplierId=4772) OR ( a.articleSearch IN ('811010563', '8120101003C', '8120101004C', '8120101005C', '8120101006C', '8120101088C', '812010140C', '812010141C', '812010154C', '812010176', '812010177', '812010199C', '8120101003', '8120101004', '8120101005', '812028148C', '8120101006', '812010140', '812010141', '812010199') AND a.supplierId=108) OR (a.articleSearch='TF28271008' AND a.supplierId=4022) OR ( a.articleSearch IN ('7260', 'DF114', 'DF1165', 'DF1182', 'DF1224', 'DF1240', 'DF1403', 'DF547', 'DF834', 'DF869') AND a.supplierId=199) OR ( a.articleSearch IN ('V2240002', 'V2240005', 'V2240007', 'V2480008', 'V4240006', 'V4240008', 'V4280006', 'V4280013', 'V4280017', 'V4280018') AND a.supplierId=183) OR ( a.articleSearch IN ('186418', '197023', '197043', '197097', '197105', '197131', '197228', '197248', '197329', '197565', '197821', '297043', '297329') AND a.supplierId=21) OR ( a.articleSearch IN ('WGR07671', 'WGR07681', 'WGR11441', 'WGR11701', 'WGR11711', 'WGR16531', 'WGR18001') AND a.supplierId=4498) OR (a.articleSearch='WG1486137' AND a.supplierId=4832) OR ( a.articleSearch IN ('8586301', '8587300', 'D6101510', 'D6101610', 'D6105500', 'D6105600', 'D6105700', 'D6112000', 'D6115510', 'D6120410', 'D6135110', 'D6160010', 'D6163710', 'D6210910', 'D647610', 'D650410', 'D674100') AND a.supplierId=366) OR ( a.articleSearch IN ('BS5108', 'BS5109', 'BS5111', 'BS5152', 'BS5153', 'BS5166', 'BS5866', 'BS6290', 'BS5151') AND a.supplierId=4894) OR ( a.articleSearch IN ('180301120', '180301320', '180301352', '180301920', '180302020', '180303020', '180303120', '180303220', '230237220', '230237320', '230237420', '230237520', '230237620') AND a.supplierId=86)An internal server error occurred.