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 ('AD24FL600', 'ADG09748') AND a.supplierId=350) OR ( a.articleSearch IN ('3397007620', '3397007860', '3397001342', '3397001417', '3397001543', '3397007187', '3397007290', '3397007292', '3397007295', '3397007462', '3397007555', '3397007579', '3397007637', '3397007638', '3397007862', '3397007863', '3397009821', '3397009825', '3397009826', '3397010280', '3397014010', '3397014116', '3397014244', '3397014248', '3397014825', '3397018612', '3397118301', '3397118402', '3397118405', '3397118505', '3397118506', '3397118563', '3397118566', '3397118929', '3397118967', '3397118979', '3397012366', '3397012429', '3397007580', '3397012015', '3397012089', '3397005024', '3397018303', '3397110875', '3397118510', '3397001250', '3397018506') AND a.supplierId=30) OR ( a.articleSearch IN ('BSG90992011', 'BSG90992012', 'BSG15992007', 'BSG15992008', 'BSG15992015', 'BSG15992016', 'BSG15992017', 'BSG15992018', 'BSG15992020', 'BSG15992023', 'BSG30992006', 'BSG30992007', 'BSG30992013', 'BSG30992014', 'BSG30992015', 'BSG30992016', 'BSG30992017', 'BSG40992001', 'BSG40992002', 'BSG40992003', 'BSG40992004', 'BSG40992007', 'BSG40992008', 'BSG40992009', 'BSG40992011', 'BSG40992012', 'BSG40992014', 'BSG40992017', 'BSG40992019', 'BSG40992025', 'BSG60992006', 'BSG60992007', 'BSG65992010', 'BSG70992004', 'BSG70992005', 'BSG70992007', 'BSG70992008', 'BSG90992008', 'BSG90992009', 'BSG90992010', 'BSG90992013', 'BSG90992015') AND a.supplierId=4455) OR ( a.articleSearch IN ('DF015', 'DF005', 'DF007', 'DF011', 'DF013', 'DF016', 'DF017', 'DF018', 'DF020', 'DF033', 'DF039', 'DF050', 'DF052', 'DF063', 'DF069', 'DF072', 'DF077', 'DF085', 'DF096', 'DF103', 'DF109', 'DF112', 'DF121', 'DF124', 'DF128', 'DF151', 'DF240', 'DF245', 'DF250', 'DF260', 'DF308', 'DM045', 'DM048', 'DMS548', 'DUR060L') AND a.supplierId=4760) OR ( a.articleSearch IN ('DVF48', 'DV45') AND a.supplierId=4585) OR ( a.articleSearch IN ('99551078502', '89550597202', '89550623102', '89550623402', '89550624202', '89550624402', '89980623602', '99551457502', '99981762202', '99981762902', '99981763302', '99981765902', '99981766002') AND a.supplierId=4353) OR ( a.articleSearch IN ('1635454580', '1635454980', '1623232580', '1623232680', '1623232780', '1623232880', '1623232980', '1623233080', '1623233180', '1623233280', '1623233380', '1623234680', '1623235580', '1623237280', '1635454880', '1635455080') AND a.supplierId=4391) OR ( a.articleSearch IN ('WB45200', 'WB48010', 'WB48200', 'WB48210', 'WB60010', 'WB60200', 'WB60210', 'WB45010', 'WB45210', 'WB55010', 'WB55200', 'WB55210') AND a.supplierId=271) OR ( a.articleSearch IN ('029000', '034000', '089000', '094000', '279000', '284000') AND a.supplierId=4840) OR ( a.articleSearch IN ('000723116048', '000723110600', '000723111219', '000723114302', '000723114303', '000723114305', '000723114306', '000723114307', '000723114308', '000723114311', '000723114313', '000723114317', '000723114318', '000723114319', '000723114320', '000723114322', '000723114330', '000723114331', '000723114334', '000723114850', '000723116548', '000723116553', '000723126540', '000723126545', '000723140450', '000723140500', '000723140525', '000723140600', '000723144000', '000723144300', '000723144500', '000723144800', '000723145000', '000723145300', '000723145500', '000723146000', '000723146500', '000734000000', '000734500000', '000734800000', '000735000000', '000735500000', '000736000000') AND a.supplierId=4723) OR (a.articleSearch='0294751900' AND a.supplierId=144) OR ( a.articleSearch IN ('119261', '262205', '262211', '116136', '116148', '116540', '119257', '119260', '119264', '119268', '119272', '119273', '119275', '119276', '119277', '119283', '119284', '119287', '119288', '119290', '119292', '119297', '119298', '119299', '119300', '119301', '119305', '119312', '119314', '119330', '119332', '119340', '119348', '119355', '119356', '119374', '119378', '119382', '119388', '119391', '119396', '119418', '119430', '119439', '119452', '119461', '119468', '119764', '119860', '132400', '262202', '262203', '262204', '262208', '262212', '262213', '262253', '262254', '262259', '116190', '116349', '116142', '116317', '119427', '130400') AND a.supplierId=19) OR ( a.articleSearch IN ('35240', 'FX450', 'NF459', 'TF600L') AND a.supplierId=227) OR ( a.articleSearch IN ('574476', '575004', '575008', '578505', '578511', '574110', '574112', '574118', '574125', '574129', '574136', '574141', '574143', '574158', '574164', '574191', '574193', '574251', '574275', '574316', '574321', '574322', '574337', '574346', '574363', '574365', '574373', '574382', '574383', '574385', '574386', '574387', '574388', '574394', '574462', '574463', '574468', '574470', '574472', '574474', '574478', '574481', '574491', '574591', '574641', '574642', '574643', '574645', '574647', '574651', '574652', '574653', '574660', '574668', '574707', '574710', '574724', '574732', '574747', '575007', '575555', '575784', '575787', '575788', '575831', '575832', '575903', '577804', '577818', '577819', '577824', '577826', '577828', '577841', '577849', '577857', '577865', '577866', '577867', '577871', '577884', '577912', '577926', '578500', '578501', '578502', '578503', '578504', '578506', '578507', '578508', '578512', '578513', '578564', '578572', '578573', '578574', '578576', '578579', '574166', '574186', '574168', '574187', '574173', '574190', '574174', '574176', '574178', '574185', '574313', '574492', '574349', '574354', '574344', '574494', '574603', '574672', '577822', '574670', '567941', '567942', '567997', '567943', '567945', '567946', '567947', '567948') AND a.supplierId=21) OR ( a.articleSearch IN ('FW4501', 'FW6001', 'HW6001', 'FW450', 'FW600', 'HW600') AND a.supplierId=4894) OR ( a.articleSearch IN ('10300122', '10300122C') AND a.supplierId=4657) OR ( a.articleSearch IN ('56844', '56865') AND a.supplierId=6558) OR (a.articleSearch='8001124' AND a.supplierId=257) OR ( a.articleSearch IN ('ASH71004', 'ASH71026', 'ASH71045', 'ASH71047', 'ASH71049', 'ASH71050', 'ASH71051', 'ASH71052', 'ASH71053', 'ASH71054', 'ASH71056', 'ASH71060', 'ASH71061', 'ASH71064', 'ASH71078', 'ASH71079', 'ASH71080', 'ASH71081', 'ASH71083', 'ASH71085', 'ASH71086', 'ASH71097', 'ASH71099', 'ASH71100', 'ASH71101', 'ASH71116', 'ASH71120', 'ASH71122', 'ASH71123', 'ASH71125', 'ASH71136', 'ASH71137', 'ASH71144', 'ASH71145', 'ASH71148', 'ASH72430', 'ASH72480', 'ASH72550', 'ASH72600', 'PAL72430', 'PAL72480', 'PAL72550', 'PAL72580', 'PAL72600', 'WAF20') AND a.supplierId=442) OR ( a.articleSearch IN ('PWB1500', 'PWB1550') AND a.supplierId=4337) OR ( a.articleSearch IN ('BW15F', 'BW15F10', 'BW15RF', 'BW15RF10', 'BW16F', 'BW16F10', 'BW16R', 'BW16R10', 'BW18C', 'BW18C10', 'BW18F', 'BW18F10', 'BW19F', 'BW19F10', 'BW20F', 'BW22F', 'BW24C', 'BW24F', 'BW24F10', 'BW26F', 'BW26F10', 'BW28F', 'BW28F10', 'HK9082') AND a.supplierId=475) OR ( a.articleSearch IN ('BMC19429', 'BMC19432', 'BSP21941') AND a.supplierId=157) OR ( a.articleSearch IN ('752603', '760035') AND a.supplierId=405) OR ( a.articleSearch IN ('A45B01', 'A51B01', 'A53B01', 'A60B01', 'AFL40B01', 'AFL43B01', 'AFL45B01', 'AFL4850BC02', 'AFL48AB01', 'AFL48B01', 'AFL5348AC02', 'AFL5553BC02', 'AFL55B01', 'AFL5845EC02', 'AFL6035AC02', 'AFL6038AC02', 'AFL6040AC02', 'AFL6040EC02', 'AFL6040FC02', 'AFL6040GC02', 'AFL6045AC02', 'AFL6045BC02', 'AFL6045GC02', 'AFL6048AC02', 'AFL6048BC02', 'AFL6048EC02', 'AFL6048FC02', 'AFL6050FC02', 'AFL6060EC02', 'AFL60B01', 'AFL6540GC02', 'AFL6545FC02', 'AFL6548AC02', 'AFL6548FC02', 'AFL6553FC02', 'AFL65B01', 'AFR60B01', 'AFU6040AC02', 'AFU6558BC02', 'AFU7060BC02', 'AFU7065BC02', 'AHL40B01', 'AHL60B01', 'AS4545B02', 'AS5148B02', 'AS5348B02', 'AS60B01', 'ASC6055B02', 'E55BE1', 'EF40B01', 'EF43B01', 'EF45B01', 'EF48B01', 'EF50B01', 'EF53B01', 'EF55B01', 'EF60B01', 'EF65B01', 'ER48B01', 'ER50B01', 'ER60B01', 'RD55B01', 'RDF48B01', 'RDF55B01', 'RDF60B01', 'AS53B01') AND a.supplierId=43) OR ( a.articleSearch IN ('D200R0016', 'D200R0018', 'D200R0019', 'D200R0020', 'D200R0022', 'D200R0024') AND a.supplierId=6476) OR ( a.articleSearch IN ('VD10002', 'VD10032', 'VD10036', 'VD10038', 'VD10041', 'VD10049', 'VD10062', 'VD10065', 'VD10123', 'VD10124', 'VD10128') AND a.supplierId=186) OR ( a.articleSearch IN ('8574700', '8574701', '8574800') AND a.supplierId=253) OR ( a.articleSearch IN ('1100180006', '1100180007', '1100180012', '1100180021', '1100180022', '1100180027') AND a.supplierId=4345) OR ( a.articleSearch IN ('400DF', '450DC', '450DF', '450DH', '475DC', '475DF', '480DH', '500DF', '500DH', '550DF', '600DC', '600DF', '600DH') AND a.supplierId=4881) OR (a.articleSearch='EW7185' AND a.supplierId=4344) OR ( a.articleSearch IN ('FT93206', 'FT93218', 'FT93224', 'FT93246', 'FT93249', 'FT93250') AND a.supplierId=4938) OR ( a.articleSearch IN ('792707601', '792707701', '792707801', '792708201', '792709001', '792709201', '792709301', '792709501', '792752501', '892703101', '892703401', '892704301', '892709401', '892733601') AND a.supplierId=6484) OR ( a.articleSearch IN ('AWBC24', 'HWBC17', 'HWBC24', 'WBC18', 'WBC24') AND a.supplierId=4663) OR (a.articleSearch='WI0069' AND a.supplierId=6443) OR ( a.articleSearch IN ('HB18', 'HB19', 'HB24', 'HF18', 'HF19', 'HF24', 'HF24A', 'HQ16', 'HQ18', 'HQ19', 'HQ24', 'HQ26') AND a.supplierId=4756) OR (a.articleSearch='DF124' AND a.supplierId=156) OR (a.articleSearch='80124' AND a.supplierId=481) OR ( a.articleSearch IN ('2110327', '2110338', '27A01', '27A13', '27D05', '27F03', '29008') AND a.supplierId=185) OR ( a.articleSearch IN ('27018', 'NU024L', 'NU026L', 'EU018') AND a.supplierId=201) OR ( a.articleSearch IN ('33106Z', '33300Z', '33301Z', '33303Z', '33304Z', '33305Z', '33306Z', '33307Z', '33309Z', '33310Z', '33313Z', '33314Z', '33650X', '33650Z', '33652X', '33652Z', '33665X', '33665Z', '33671X', '33671Z', '33673X', '33705Z', '33708Z', '33725X', '33736X', '33738X', '33952Z', '33954Z', '33955Z', '33957Z', '33959Z', '33963Z', '33971Z', '33973Z', '33974Z', '33975Z', '33976Z', '33977Z', '33978Z', '33981Z', '33983Z', '33986Z', '33988Z', '33993Z', '33995Z', '33999Z', '33200Z', '33201Z', '33203Z', '33205Z', '33206Z', '33207Z', '33209Z', '33210Z', '33709X') AND a.supplierId=387) OR ( a.articleSearch IN ('K4545', 'K60HYB') AND a.supplierId=4546) OR (a.articleSearch='LWCR185' AND a.supplierId=4501) OR ( a.articleSearch IN ('450L', '450LS', '480L', '480LS', '550L', '550LS', '5535LR', '5548LR', '600L', '600LS', '6040LR', '6045LR', 'LR38V', 'LW450', 'LW480', 'LW550', 'LW600', 'LX450', 'LX480', 'LX550', 'LX600', 'XF400', 'XF450', 'XF480', 'XF500', 'XF550', 'XF5545S', 'XF600', 'XF6038T', 'XF6040B', 'XF6045P', 'XF6048B', 'XF6048S') AND a.supplierId=4600) OR ( a.articleSearch IN ('104020HPS', '1044002HPS', '1044502HPS', '1045002HPS', '104575HPS', '1046002HPS', '104726HPS') AND a.supplierId=133) OR (a.articleSearch='24BPCSMS' AND a.supplierId=358) OR ( a.articleSearch IN ('MU017', 'MU017S', 'MU017U', 'MU017W', 'MU017WS', 'MU018', 'MU018S', 'MU018U', 'MU018W', 'MU018WS', 'MU019U', 'MU019WS', 'MU020', 'MU020S', 'MU020U', 'MU020W', 'MU020WS', 'MU021', 'MU021S', 'MU021U', 'MU021W', 'MU021WS', 'MU024', 'MU024S', 'MU024U', 'MU024W', 'MU024WS', 'MU026U', 'MU026WS', 'MU17G', 'MU18G', 'MU20G', 'MU21G', 'MU24G') AND a.supplierId=6270) OR ( a.articleSearch IN ('390083', '390089', '390091', '390109', '390144', '390149', '390157', '390614', '390638', '390639', '390647', '390652', '390655', '390658', '390659', '390662', '390674', '397375', '397400', '397600') AND a.supplierId=403) OR ( a.articleSearch IN ('MCD1124', 'MRP2B03') AND a.supplierId=4773) OR ( a.articleSearch IN ('68100', '68463') AND a.supplierId=4664) OR ( a.articleSearch IN ('2190329', '2190487') AND a.supplierId=94) OR ( a.articleSearch IN ('CWC21AC', 'CWF24M', 'CWH24AC', 'CWR15XA', 'CWW22AC') AND a.supplierId=6495) OR (a.articleSearch='M24566' AND a.supplierId=6533) OR ( a.articleSearch IN ('27018', 'NU024L', 'NU026L', 'EU018') AND a.supplierId=145) OR ( a.articleSearch IN ('2125731', '2125737', '2125742', '2262803') AND a.supplierId=4380) OR ( a.articleSearch IN ('WBC001800', 'WBC001900', 'WBC002200', 'WBC002300', 'WBF001400', 'WBF001411', 'WBF001500', 'WBF001511', 'WBF001600', 'WBF001611', 'WBF001800', 'WBF001811', 'WBF001900', 'WBF001911', 'WBF002000', 'WBF002011', 'WBF002100', 'WBF002111', 'WBF002200', 'WBF002211', 'WBF002300', 'WBF002311', 'WBF002400', 'WBF002411', 'WBF002500', 'WBF002511', 'WBF002600', 'WBF002611', 'WBF002800', 'WBF002811', 'WBH001800', 'WBH001900', 'WBH002000', 'WBH002100', 'WBH002300', 'WBH002400') AND a.supplierId=378) OR ( a.articleSearch IN ('18257', '24813', '25863', '25867', '25869', '25870', '27140', '27142', '27144', '27145', '28076') AND a.supplierId=4683) OR ( a.articleSearch IN ('WA400400', 'WAP200250', 'WB400525', 'WC4005251', 'WC400600', 'WC4006001', 'WCP350350', 'WDP200250', 'WE450450') AND a.supplierId=6267) OR ( a.articleSearch IN ('041701', '041703', '041705', '041707', '041708', '041710', '041712', '041713') AND a.supplierId=314) OR ( a.articleSearch IN ('QAW021', 'QAW024', 'QTW018', 'QTW024') AND a.supplierId=57) OR ( a.articleSearch IN ('298W0007', '298W0008', '298W0019', '298W0030', '298W0036', '298W0046', '298W0049', '298W0055', '298W0056', '298W0058', '298W0059', '298W0060', '298W0063', '298W0072', '298W0073', '298W0074', '298W0086', '298W0092', '298W0096', '298W0105', '298W0107', '298W0110', '298W0112', '298W0134', '298W0135', '298W0141', '298W0142', '298W0145', '298W0151', '298W0152', '298W0158', '298W0161', '298W0179', '298W0186', '298W0190', '298W0227', '298W0234', '298W0266', '298W0269', '298W0273', '298W0279') AND a.supplierId=6358) OR ( a.articleSearch IN ('SKWIB0940007', 'SKWIB0940018', 'SKWIB0940029', 'SKWIB0940035', 'SKWIB0940045', 'SKWIB0940048', 'SKWIB0940054', 'SKWIB0940055', 'SKWIB0940057', 'SKWIB0940058', 'SKWIB0940059', 'SKWIB0940062', 'SKWIB0940071', 'SKWIB0940072', 'SKWIB0940073', 'SKWIB0940085', 'SKWIB0940091', 'SKWIB0940095', 'SKWIB0940100', 'SKWIB0940104', 'SKWIB0940106', 'SKWIB0940109', 'SKWIB0940111', 'SKWIB0940133', 'SKWIB0940134', 'SKWIB0940140', 'SKWIB0940141', 'SKWIB0940144', 'SKWIB0940150', 'SKWIB0940151', 'SKWIB0940160', 'SKWIB0940178', 'SKWIB0940185', 'SKWIB0940226', 'SKWIB0940233', 'SKWIB0940265', 'SKWIB0940268', 'SKWIB0940272', 'SKWIB0940278') AND a.supplierId=6357) OR ( a.articleSearch IN ('T468100', 'T468463') AND a.supplierId=4667) OR ( a.articleSearch IN ('101450SX', '103450SX', '103600SX', '104400SX', '104600SX', '115380SX', '121525SX', '201307SX', '201310SX', '201475SX', '201600SX', '201603SX', '201607SX', '201609SX', '201616SX', '201620SX', '201631SX', '201632SX', '201636SX', '201644SX', '201650SX', '201659SX', '201660SX', '201664SX', '201665SX', '201669SX', '201677SX', '201679SX', '201683SX', '201685SX', '201690SX', '201699SX', '201701SX', '201703SX', '202335SX', '202340SX', '202450SX', '202475SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('1000531', '1000551', '1000600', '1000601', '1000651') AND a.supplierId=6691) OR ( a.articleSearch IN ('BE45', 'BE51', 'BE53', 'BE61', 'FBT460', 'FBT480', 'FBT505', 'FBT540', 'FBT610', 'FBT660') AND a.supplierId=6312) OR ( a.articleSearch IN ('108963', '112380', '112471', '114279', '114292', '115952', '202225', '409096', '409097', '501643') AND a.supplierId=301) OR ( a.articleSearch IN ('0258407', '0258409', '0258418', '0258424', '0258432', '0258441', '0258444', '0758019', '0758022', '0758024', '0858258', '0858268', '0858275', '0858277', '0858278', '0258410') AND a.supplierId=209) OR ( a.articleSearch IN ('V207389', 'V950412', 'V950441') AND a.supplierId=183) OR ( a.articleSearch IN ('1001018', '1001019', '1001024', '1001028', '1002024', '1003017', '1003018', '1003019', '1003024', '1004016', '1004018', '1004019', '1004022', '1004024', '1004026', '1005017', '1005018', '1005019', '1005024', '1006017', '1006018', '1006019', '1006024', '1007018', '1007019', '1007022', '1007024', '1007026') AND a.supplierId=482) OR ( a.articleSearch IN ('171117', '371801', '371803', '371809', '371813', '371815', '371817', '371819', '371821', '371823') AND a.supplierId=6347) OR ( a.articleSearch IN ('ZV214RM', 'ZV21T', 'ZV299CC', 'ZV29AQ', 'ZV31BW', 'ZV42TY', 'ZV437FM', 'ZV43VL', 'ZV45AL', 'ZV47BW', 'ZV48VL', 'ZV55K', 'ZV899AB', 'ZV98AV', 'ZV9981A', 'ZV99AV', 'ZVDJ90L', 'ZVDJ91R', 'ZVL8R', 'ZVL9189', 'ZVLC16', 'ZVLD16', 'ZVLR32', 'ZVMW267') AND a.supplierId=6274)An internal server error occurred.