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='16054000' AND a.supplierId=139) OR ( a.articleSearch IN ('CT5446K', 'CP2278', 'CP2698', 'CT5145', 'CT5294', 'CT5361', 'CT5379', 'CT5385', 'CT5442K', 'CT5450', 'CT5454K', 'CT5455K', 'CT5464K', 'CT5476K', 'CT5480K', 'CT5488K', 'CT5504', 'CT5507', 'CT5509', 'CT5510', 'CT5517', 'CT5524', 'CT5528', 'CT5533', 'CT5571', 'CT5497K', 'CT5316K', 'CT5563') AND a.supplierId=478) OR ( a.articleSearch IN ('B13141', 'B18281', 'B18244', 'B18245', 'B18246', 'B18256', 'B18258', 'B18259', 'B18260', 'B18262', 'B18265', 'B18268') AND a.supplierId=4815) OR ( a.articleSearch IN ('BSG90125003', 'BSG16125008', 'BSG30125004', 'BSG30125013', 'BSG30125014', 'BSG30125015', 'BSG30125016', 'BSG40126002', 'BSG40126006', 'BSG40126009', 'BSG60125011') AND a.supplierId=4455) OR ( a.articleSearch IN ('TH143987J', 'TH133580J', 'TH133587J', 'TH141087J', 'TH141982J', 'TH141988J', 'TH143980J', 'TH143984J', 'TH151481J', 'TH151488J', 'TH152989J', 'TH456192J', 'TH597380J', 'TH598189J', 'TH600788J', 'TH624887J', 'TH627387J', 'TH629482J', 'TH631482', 'TH631985J', 'TH631988J', 'TH643482J', 'TH652688J', 'TH134387J', 'TH333489J', 'TH334984J', 'TH334987J') AND a.supplierId=215) OR ( a.articleSearch IN ('DT1006V', 'DT1005V', 'DT1076F', 'DT1139V', 'DT1235V', 'DT1249V', 'DT1250V') AND a.supplierId=42) OR (a.articleSearch='761109' AND a.supplierId=10) OR (a.articleSearch='6123028' AND a.supplierId=237) OR ( a.articleSearch IN ('17888', '01349', '12403', '14772', '17884', '17892', '17908', '17912', '17914', '17932', '17966', '17976', '17978', '18282', '18980', '23981', '26194', '36462') AND a.supplierId=101) OR ( a.articleSearch IN ('TS087', 'HB1202', 'HB1211', 'HB1212', 'TS016') AND a.supplierId=271) OR ( a.articleSearch IN ('TH11287G1', 'TH00682G1', 'TH02491G1', 'TH04282G1', 'TH09180G1', 'TH11088G1', 'TH12588G1', 'TH12988G1', 'TH13684G1', 'TH26187G1', 'TH29882G1', 'TH31987G1', 'TH47685G1') AND a.supplierId=6665) OR ( a.articleSearch IN ('1114650400', '1114601210', '1114600610', '1514501100', '1514600210', '1514600310') AND a.supplierId=268) OR ( a.articleSearch IN ('TX1387D', 'TX1587D', 'TI2187', 'TI8787D', 'TX1088D', 'TX10987D', 'TX1187D', 'TX1288D', 'TX1371D', 'TX1380D', 'TX1392D', 'TX1584D', 'TX187D', 'TX19888D', 'TX20388D', 'TX3080D', 'TX7282', 'TX7285D', 'TX7883', 'TX883D', 'TX888D', 'TX9683D') AND a.supplierId=287) OR ( a.articleSearch IN ('352317101260', '350982001000', '352022888000', '352023382100', '352023385100', '352023388000', '352023388100', '352023482000', '352024188000', '352026588000', '352026589000', '352027088000', '352027291000', '352030482000', '352035188000', '352037382000', '352052787000', '352316171164', '352317000330', '352317000540', '352317001180', '352317001260', '352317001300', '352317001370', '352317001740', '352317002290', '352317002310', '352317003900', '352317100330', '352317100540', '352317101180', '352317101300', '352317101370', '352317101740') AND a.supplierId=4723) OR ( a.articleSearch IN ('92125', '92352', '92091', '92120', '92121', '92173', '92193', '92217', '92294', '92308', '92321', '92322', '92353', '92365', '92404', '92505', '92709', '92739', '92795', '92796', '92806', '92354') AND a.supplierId=244) OR ( a.articleSearch IN ('0282870010', '0282710002', '0282750005', '0282800010', '0282920001', '1001210048', '1130120028', '36282280006', '37282280005', '37282280006', '7282880000') AND a.supplierId=144) OR ( a.articleSearch IN ('52787K', '23382JK', '23385JK', '23388JK', '23388K', '23471', '23480K', '23482K', '23487K', '23488K', '24188K', '27088K', '27291K', '30482K', '35188K', '37382K', '42489K', '52782K', '59188K', '62182K', 'MG22') AND a.supplierId=388) OR ( a.articleSearch IN ('PE21008', 'PE21005', 'PE21006', 'PE21016', 'PE21054', 'PE21069', 'PE21112', 'PE21185') AND a.supplierId=4558) OR ( a.articleSearch IN ('QTH481K', 'QTH104K', 'QTH117K', 'QTH135K', 'QTH313K', 'QTH316K', 'QTH327', 'QTH329K', 'QTH354K', 'QTH393K', 'QTH468K', 'QTH501', 'QTH623K', 'QTH109K', 'QTH215', 'QTH357', 'QTH113K', 'QTH472K', 'QTH437K') AND a.supplierId=57) OR ( a.articleSearch IN ('9000161', '3306029', '3306030', '3306038', '3306041', '3371971', '3381031', '9000074', '9000087', '9000092', '9000163', '9000334', '9000383', '9000387', '9000719') AND a.supplierId=260) OR ( a.articleSearch IN ('2340002SX', '2340003SX', '1125428SX', '2340000SX', '2340006SX', '2340019SX', '2340021SX', '2340025SX', '2340042SX', '2340043SX', '2340050SX', '2340066SX', '2340093SX', '2340118SX', '2340148SX', '2340168SX', '2340186SX', '2340190SX', '2340207SX', '2340229SX', '2340257SX', '2340273SX', '45000371SX', '8224025SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('32917888', '10936462', '30917976', '30917978', '30918282', '32150009', '32917884', '32917908', '32917932', '32917966', '50918980', '50923981', '55914772', '90926194', '99912403') AND a.supplierId=151) OR ( a.articleSearch IN ('0719039', '0719030', '0719051', '0719214') AND a.supplierId=209) OR ( a.articleSearch IN ('819868', '820168', '819847', '819853', '819864', '819865', '819867', '819882', '819883', '819889', '819896', '819926', '820040', '820064', '820074', '820137', '820148', '820150', '820176', '820178', '820184', '820193', '820245', '820475', '820525', '820555', '819910', '820493') AND a.supplierId=21) OR ( a.articleSearch IN ('11210090501', '11210091001', '11210090301', '11210090901', '11211285701', '11211425601') AND a.supplierId=4346) OR (a.articleSearch='81722' AND a.supplierId=4598) OR ( a.articleSearch IN ('0170250017', '0520250001', '0530250003', '0530250016', '0530250017', '0530250032') AND a.supplierId=4657) OR ( a.articleSearch IN ('A52990003', 'A52990004') AND a.supplierId=4364) OR ( a.articleSearch IN ('51177', '52896', '52897', '52900', '52907', '55638', '58254', '58322') AND a.supplierId=6558) OR (a.articleSearch='1349' AND a.supplierId=220) OR ( a.articleSearch IN ('TER002', 'TER006', 'TER030', 'TER037', 'TER057', 'TER104', 'TER115', 'TER139', 'TER149', 'TER158', 'TER173', 'TER183', 'TER208', 'TER211', 'TER231', 'TER233', 'TER271', 'TER295', 'TER299', 'TER328') AND a.supplierId=317) OR ( a.articleSearch IN ('750375N', '750932N', '781010N') AND a.supplierId=80) OR ( a.articleSearch IN ('XT141087', 'XT1439', 'XT143980', 'XT143987', 'XT1514', 'XT515187', 'XT6273', 'XT6526') AND a.supplierId=4975) OR ( a.articleSearch IN ('73314', '73357', '73397', '73401', '77114') AND a.supplierId=4576) OR ( a.articleSearch IN ('22019', '22045', '22049', '3801102', '3801120', '3802207', '3805599', '3807700', '380HH06', '3803304', '380KK08', '3801100') AND a.supplierId=257) OR ( a.articleSearch IN ('101440', '99181') AND a.supplierId=4495) OR ( a.articleSearch IN ('160028210', '160032610', '160046910', '160047210', '160047510') AND a.supplierId=323) OR ( a.articleSearch IN ('OTH5083', 'PTH0482', 'PTH1010', 'PTH1014', 'PTH1029', 'PTH1033', 'PTH1037', 'PTH1072', 'PTH1093', 'PTH2009', 'PTH2182', 'PTH2489', 'PTH2782', 'PTH2787', 'PTH3093', 'PTH3482', 'PTH3487', 'PTH4188', 'PTH5083', 'PTH7088', 'PTH7291', 'PTH8052', 'PTH9188') AND a.supplierId=4337) OR ( a.articleSearch IN ('0011016626', '0011017859', '0026000164', '0026000166') AND a.supplierId=4995) OR ( a.articleSearch IN ('300003', '300013', '300037', '300039', '300052', '300104', '300121', '300127', '300168', '300181', '300196', '300270', '300320', '300327', '300381', '300442') AND a.supplierId=128) OR (a.articleSearch='80195' AND a.supplierId=208) OR ( a.articleSearch IN ('ADG09205', 'ADG09220', 'ADG09243', 'ADJ139201', 'ADN19202', 'ADN19207') AND a.supplierId=350) OR ( a.articleSearch IN ('BBT010', 'BBT027', 'BBT040', 'BBT198', 'BTS15382', 'BTS15388', 'BTS19380', 'BTS19387', 'BTS19392', 'BTS20782', 'BTS21682', 'BTS24082', 'BWP1106', 'BTS39188') AND a.supplierId=475) OR ( a.articleSearch IN ('002138', '315982D', '400682D', '402288D', '41013188D', '41034882D', '412380D', '415488D', '425387D', '425582D', '425587D', '425671', '425680D', '425680D60', '425683D60', '425687D50', '426484D', '426487D', '427290D', '427587D', '482087D') AND a.supplierId=6444) OR (a.articleSearch='PA0320C' AND a.supplierId=109) OR ( a.articleSearch IN ('330548', '332467') AND a.supplierId=243) OR ( a.articleSearch IN ('756839', '756866', '756888', '756896', '756908', '952050') AND a.supplierId=405) OR (a.articleSearch='713VW03' AND a.supplierId=6411) OR (a.articleSearch='504328' AND a.supplierId=6263) OR ( a.articleSearch IN ('CBR3102', 'CBR3108', 'CBR3109', 'CTH2091', 'CTH2093', 'CTH2120', 'CTH2121', 'CTH2125', 'CTH2141', 'CTH2154', 'CTH2173', 'CTH2193', 'CTH2194', 'CTH2217', 'CTH2243', 'CTH2266', 'CTH2294', 'CTH2308', 'CTH2321', 'CTH2322', 'CTH2327', 'CTH2339', 'CTH2352', 'CTH2353', 'CTH2365', 'CTH2388', 'CTH2437', 'CTH2505', 'CTH2525', 'CTH2587', 'CTH2629', 'CTH2635', 'CTH2739', 'CTH2790', 'CTH2794', 'CTH2795', 'CTH2796', 'CTH2806') AND a.supplierId=4334) OR (a.articleSearch='A310194' AND a.supplierId=186) OR ( a.articleSearch IN ('TRM010N', 'TRM015N', 'TRM019N', 'TRM036N', 'TRM061N', 'TRM064N', 'TRM089N', 'TRM092N', 'TRM097N', 'TRM112N', 'TRM131N', 'TRM167N') AND a.supplierId=4882) OR ( a.articleSearch IN ('1040230013', '1040230070') AND a.supplierId=4345) OR ( a.articleSearch IN ('A150', 'A160') AND a.supplierId=154) OR ( a.articleSearch IN ('1122001', '1122015', '1342075', '468172', '468174') AND a.supplierId=355) OR ( a.articleSearch IN ('161005', '161017', '161027', '161029', '161039', '161044', '161084', '161096') AND a.supplierId=211) OR ( a.articleSearch IN ('1880160', '1880216S', '1880218', '1880218S', '1880220', '1880221', '1880221S', '1880223S', '1880259', '1880259S', '1880273S', '1880278', '1880307', '1880307S', '1880371', '1880371S', '1880372', '1880380', '1880380S', '1880394', '1880394S', '1880432', '1880434', '1880435', '1880449', '1880453', '1880483', '1880535', '1880536', '1880536S', '1880637', '1880657', '1880657S', '1880658', '1880726', '1880807', '1880837', '1880837S', '1880838', '1880845', '1880869', '1890590', '78160', '78216S', '78218', '78218S', '78220', '78221', '78221S', '78223S', '78259', '78259S', '78273S', '78278', '78307', '78307S', '78371', '78371S', '78372', '78380', '78380S', '78394', '78394S', '78432', '78434', '78435', '78449', '78453', '78483', '78535', '78536', '78536S', '78637', '78657', '78657S', '78658', '78726', '78807', '78837', '78837S', '78838', '78845', '78869', '79590') AND a.supplierId=4005) OR ( a.articleSearch IN ('350012', '350012A', '350027', '350027A', '350029', '350029A', '350033', '350033A', '350076', '350076A', '350129', '350129A', '350139', '350139A', '350153', '350163', '350171', '350171A', '350217', '350229', '350241', '350241A', '350264', '350306', '350373', '350374', '350374A', '350410', '350413', '350413A', '350442', '350446', '350482', '350585A') AND a.supplierId=234) OR ( a.articleSearch IN ('20SKV003', '20SKV018', '20SKV049') AND a.supplierId=4969) OR (a.articleSearch='056121113A' AND a.supplierId=6367) OR ( a.articleSearch IN ('5202785', '5300882', '5301583', '5301884', '5302483', '5302487', '5303885', '5303888', '5303980', '5303987', '5304388', '5304391', '5304988', '5305788', '5306688', '5307087', '5307280', '5309592', '5339088', '5345187') AND a.supplierId=240) OR ( a.articleSearch IN ('T003', 'T006') AND a.supplierId=4834) OR ( a.articleSearch IN ('FTK010', 'FTK027', 'FTK040', 'FTK198', 'FTS15382', 'FTS15388', 'FTS19380', 'FTS19387', 'FTS19392', 'FTS20782', 'FTS21682', 'FTS24082', 'FWP1106', 'FTS39188') AND a.supplierId=407) OR ( a.articleSearch IN ('94091', '94120', '94121', '94125', '94173', '94193', '94217', '94294', '94308', '94321', '94322', '94352', '94353', '94365', '94404', '94505', '94709', '94739', '94795', '94796', '94806', '94354') AND a.supplierId=441) OR (a.articleSearch='HP10209' AND a.supplierId=313) OR (a.articleSearch='30801' AND a.supplierId=6305) OR ( a.articleSearch IN ('PA10142', 'PA10640') AND a.supplierId=368) OR (a.articleSearch='980150' AND a.supplierId=181) OR (a.articleSearch='GWVW09A' AND a.supplierId=6666) OR ( a.articleSearch IN ('YHAU105', 'YHV102H') AND a.supplierId=6323) OR (a.articleSearch='PA546' AND a.supplierId=310) OR ( a.articleSearch IN ('315000005', '322500005') AND a.supplierId=4524) OR ( a.articleSearch IN ('8MT354773471', '8MT354773811', '8MT354773821', '8MT354773831', '8MT354773841', '8MT354773861', '8MT354774101', '8MT354774191', '8MT354774211', '8MT354774411', '8MT354774881', '8MT354774891', '8MT354774951', '8MT354775021', '8MT354775311', '8MT354775321', '8MT354775331', '8MT354775391', '8MT354775511', '8MT354775811', '8MT354775821', '8MT354776351', '8MT354776471', '8MT354777601', '8MT354777711', '8MT354777721', '8MT354777781', '8MT354777831', '8MT354778311', '9GD354771641') AND a.supplierId=4734) OR (a.articleSearch='P516' AND a.supplierId=178) OR ( a.articleSearch IN ('J1530314', 'J1530501', 'J1530520', 'J1531000', 'J1535000', 'J1535002') AND a.supplierId=72) OR ( a.articleSearch IN ('8192091', '8192120', '8192121', '8192125', '8192173', '8192193', '8192217', '8192294', '8192308', '8192321', '8192322', '8192352', '8192353', '8192365', '8192404', '8192505', '8192709', '8192739', '8192795', '8192796', '8192806', '8192354') AND a.supplierId=341) OR ( a.articleSearch IN ('15507030', '15507052', '15507085', '15511090', '15513044', '15513100', '15514052', '15518021', '15550041') AND a.supplierId=6359) OR (a.articleSearch='538033010' AND a.supplierId=204) OR ( a.articleSearch IN ('75010', '75018', '75057', '75058', '75067', '75096', '75130', '75140', '75153', '75166', '75205', '75210', '75240', '75606', '75608', '75624', '75634', '75645') AND a.supplierId=269) OR ( a.articleSearch IN ('VA019', 'VA045', 'VA049', 'VT102', 'VT120', 'VT207', 'VT599', 'VT700', 'VTH06', 'VT304', 'VTK08', 'VT100') AND a.supplierId=156) OR ( a.articleSearch IN ('2219', '2245', '2249', '38102', '38120', '38207', '38599', '38700', '38H06', '38304', '38K08', '38100') AND a.supplierId=481) OR ( a.articleSearch IN ('TH0120007', 'TH0170006', 'TH0190004', 'TH0190007', 'TH0200001', 'TH0300002', 'TH0300006', 'TH0300007', 'TH0540002') AND a.supplierId=296) OR ( a.articleSearch IN ('TH3001', 'TH3007', 'TH6515', 'TH6527', 'TH6530') AND a.supplierId=201) OR (a.articleSearch='15627387Z' AND a.supplierId=387) OR (a.articleSearch='50005150' AND a.supplierId=432) OR (a.articleSearch='1512030' AND a.supplierId=4546) OR ( a.articleSearch IN ('580160', '580216S', '580218', '580218S', '580220', '580221', '580221S', '580223S', '580259', '580259S', '580273S', '580278', '580307', '580307S', '580371', '580371S', '580372', '580380', '580380S', '580394', '580394S', '580432', '580434', '580435', '580449', '580453', '580483', '580535', '580536', '580536S', '580637', '580657', '580657S', '580658', '580726', '580807', '580837', '580837S', '580838', '580845', '580869', '590590') AND a.supplierId=4006) OR (a.articleSearch='10546' AND a.supplierId=312) OR ( a.articleSearch IN ('20201512', '75201500', '75201503', '95201503', '95201504') AND a.supplierId=4712) OR (a.articleSearch='WP0548' AND a.supplierId=283) OR (a.articleSearch='LT0810' AND a.supplierId=4707) OR ( a.articleSearch IN ('21708', '21709', '28504', '28530', '28561', '28602', '28603', '28605', '28617', '28801', '28803', '28858') AND a.supplierId=133) OR ( a.articleSearch IN ('044121113PCSMS', '2550025001PCSMS') AND a.supplierId=358) OR ( a.articleSearch IN ('WV5488', 'WV54B88') AND a.supplierId=6270) OR ( a.articleSearch IN ('670007', '670010', '670020', '670044', '670070', '670089') AND a.supplierId=403) OR ( a.articleSearch IN ('EPS1880160', 'EPS1880216', 'EPS1880218', 'EPS1880218S', 'EPS1880220', 'EPS1880221', 'EPS1880221S', 'EPS1880223', 'EPS1880259', 'EPS1880259S', 'EPS1880273', 'EPS1880278', 'EPS1880307', 'EPS1880307S', 'EPS1880371', 'EPS1880371S', 'EPS1880372', 'EPS1880380', 'EPS1880380S', 'EPS1880394', 'EPS1880394S', 'EPS1880432', 'EPS1880434', 'EPS1880435', 'EPS1880453', 'EPS1880483', 'EPS1880535', 'EPS1880536', 'EPS1880536S', 'EPS1880658', 'EPS1880726', 'EPS1880807', 'EPS1880837', 'EPS1880837S', 'EPS1880838', 'EPS1880845', 'EPS1880869', 'EPS1890590', 'MRP2B03', 'MTH4019', 'MTH4045', 'MTH4049', 'MTH4102', 'MTH4120', 'MTH4207', 'MTH4599', 'MTH4H06') AND a.supplierId=4773) OR ( a.articleSearch IN ('03092', '30273', '30289', '30310', '35825') AND a.supplierId=4664) OR (a.articleSearch='240546' AND a.supplierId=121) OR ( a.articleSearch IN ('4006052', '4006053', '4006068', '4006109', '4006112', '4006154', '4006270', '4006273', '4006284', '4006389') AND a.supplierId=94) OR ( a.articleSearch IN ('VGT125', 'VTK11', 'VTK177', 'VTK24', 'VTK25', 'VTK54', 'VTK60', 'VTK65', 'VTK8', 'VTS101', 'VTS140', 'VTS148', 'VTS200', 'VTS203', 'VTS212', 'VTS281') AND a.supplierId=4564) OR ( a.articleSearch IN ('VT21983', 'VT22082', 'VT22490', 'VT22580', 'VT23382', 'VT23388', 'VT25888', 'VT26088', 'VT28087', 'VT28485', 'VT28682', 'VT28880', 'VT28882', 'VT28884', 'VT28887', 'VT29287', 'VT31088', 'VT31883', 'VT43382', 'VT43582') AND a.supplierId=320) OR ( a.articleSearch IN ('J1530520', 'J1530521', 'J1533001', 'J1535000', 'J1535002') AND a.supplierId=248) OR ( a.articleSearch IN ('H153I02', 'H153I11', 'M153A14', 'M153I00', 'N153N02', 'N153N10', 'N153N14') AND a.supplierId=440) OR ( a.articleSearch IN ('CTMHY000', 'CTMME004', 'CTMVW040') AND a.supplierId=6355) OR (a.articleSearch='MB0320C' AND a.supplierId=6345) OR ( a.articleSearch IN ('2457637', '2457705', '2457707', '2457711', '2457717', '2457753', '2457793', '2457811', '2457940') AND a.supplierId=4380) OR ( a.articleSearch IN ('TRM100100', 'TRM100400', 'TRM108300', 'TRM108600', 'TRM115100') AND a.supplierId=378) OR ( a.articleSearch IN ('00010', '00492', '01284', '01319', '01654', '04077', '04484', '04883', '06802', '08113', '10638', '11008', '11018', '11677', '13518', '13814', '14184', '21582', '24012', '24013', '24518', '27089', '33205', '44088') AND a.supplierId=4683) OR ( a.articleSearch IN ('00482', 'JAPVA045') AND a.supplierId=4652) OR (a.articleSearch='P107001' AND a.supplierId=6339) OR (a.articleSearch='PRW0040' AND a.supplierId=4520) OR ( a.articleSearch IN ('55HY001', '55HY003', '55NI000') AND a.supplierId=4869) OR ( a.articleSearch IN ('316T0002', '316T0016', '316T0017', '316T0026', '316T0034', '316T0039', '316T0063', '316T0082', '316T0146', '316T0214') AND a.supplierId=6358) OR (a.articleSearch='65410G' AND a.supplierId=23) OR (a.articleSearch='PA519' AND a.supplierId=245) OR (a.articleSearch='WP0548' AND a.supplierId=343) OR ( a.articleSearch IN ('037388', '210465') AND a.supplierId=4623) OR ( a.articleSearch IN ('94091', '94120', '94121', '94125', '94173', '94193', '94217', '94294', '94308', '94321', '94322', '94352', '94353', '94365', '94404', '94505', '94709', '94739', '94795', '94796', '94806', '94354') AND a.supplierId=27) OR (a.articleSearch='VKPA81400' AND a.supplierId=50) OR ( a.articleSearch IN ('SMTSH009', 'SMTSH011', 'SMTSH017') AND a.supplierId=4348) OR ( a.articleSearch IN ('SKTC0560001', 'SKTC0560015', 'SKTC0560016', 'SKTC0560025', 'SKTC0560033', 'SKTC0560038', 'SKTC0560145') AND a.supplierId=6357) OR ( a.articleSearch IN ('T403092', 'T430273', 'T430289', 'T430310', 'T435825') AND a.supplierId=4667) OR ( a.articleSearch IN ('199036', '199041', '199044', '199069', '199086', '733181') AND a.supplierId=6691) OR (a.articleSearch='SYNC40339' AND a.supplierId=6394) OR (a.articleSearch='T02109' AND a.supplierId=6001) OR ( a.articleSearch IN ('D2A001TT', 'D2G001TT', 'D2M001TT', 'D2M003TT', 'D2T003TT') AND a.supplierId=4466) OR ( a.articleSearch IN ('101092', '101117', '101455', '109892', '111166', '300405', '820304', '820305') AND a.supplierId=301) OR ( a.articleSearch IN ('860029002', '862010691', '862013289', '862019082', '86202182', '86202188', '862023287', '86202382', '86202387', '86202391', '86202988', '86202992', '86203282', '86203787', '86205188', '86205688', '86205788', '86206282', '86206288', '86206788', '86206888', '86208988', '86209488', '86209688', '86209691') AND a.supplierId=108) OR (a.articleSearch='037121010C' AND a.supplierId=4999) OR ( a.articleSearch IN ('V1050039', 'V15991894', 'V159919831', 'V159919871', 'V159919872', 'V15992086', 'V25991710', 'V25991721', 'V25991724', 'V25991742', 'V30990109', 'V38990003', 'V40990028', 'V50990002', 'V52990003', 'V52990004', 'V95990006', 'V309901091') AND a.supplierId=183) OR ( a.articleSearch IN ('D3721983', 'D3728087', 'D3728887') AND a.supplierId=4836) OR (a.articleSearch='VE80195' AND a.supplierId=4425) OR (a.articleSearch='407636700' AND a.supplierId=9) OR ( a.articleSearch IN ('421150056', '421150060', '421150061', '421150063', '421150075', '421150091', '421150118', '421150129', '421150130', '421150157', '421150158', '421150160', '421150168', '421150216', '421150348', '421150374', '421150431', '421150432', '421150442', '421150488', '421150490', '421150491') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1091544', 'WG1091587', 'WG1091620', 'WG1091625', 'WG1091659', 'WG1091671', 'WG1091703', 'WG1091704', 'WG1091705', 'WG1091707', 'WG1091708', 'WG1091709', 'WG1091710', 'WG1091713', 'WG1091716', 'WG1091767', 'WG1091798', 'WG1163666', 'WG1194886', 'WG1217729', 'WG1217862', 'WG1217865', 'WG1217989', 'WG1217990', 'WG1218020', 'WG1243626', 'WG1261785', 'WG1261806', 'WG1261807', 'WG1261812', 'WG1261821', 'WG1261822', 'WG1261824', 'WG1261825', 'WG1261826', 'WG1261830', 'WG1262735', 'WG1264901', 'WG1278885', 'WG1379834', 'WG1409175', 'WG1409180', 'WG1409181', 'WG1409183', 'WG1409195', 'WG1409211', 'WG1409238', 'WG1409251', 'WG1409252', 'WG1409283', 'WG1409286', 'WG1409294', 'WG1409340', 'WG1409535', 'WG1409536', 'WG1409546', 'WG1426552', 'WG1428415', 'WG1428416', 'WG1428426', 'WG1429459', 'WG1429472', 'WG1430240', 'WG1430302', 'WG1430539', 'WG1432292', 'WG1445535', 'WG1445536', 'WG1445538', 'WG1445550', 'WG1445556', 'WG1445560', 'WG1445617', 'WG1445644', 'WG1445662', 'WG1445664', 'WG1445679', 'WG1445686', 'WG1445695', 'WG1445700', 'WG1445816', 'WG1492712', 'WG1492713', 'WG1492731', 'WG1492732', 'WG1492735', 'WG1492736', 'WG1492796', 'WG1492886', 'WG1492887', 'WG1493022', 'WG1493049', 'WG1700029', 'WG2013886', 'WG2013907', 'WG2013975', 'WG2113050', 'WG2113051', 'WG2113178', 'WG2113251', 'WG2113263', 'WG2113264') AND a.supplierId=4832) OR ( a.articleSearch IN ('10985', '10990', '10991', '10993', '120825', '120827', '220047', '220049', '220053', '320193', '320205', '320619', '320655', '320661', '320663', '320669', '320683', '320727', '320757', '320759', '320899', '320985', '321063', '321429', '321439', '351855', '351859', '510275', '580175', '580177', '620077', '620099') AND a.supplierId=6347) OR ( a.articleSearch IN ('TX19888D', 'TX888D', 'TX9683D') AND a.supplierId=382)An internal server error occurred.