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 ('AD20CH500', 'AD20HC500') AND a.supplierId=350) OR ( a.articleSearch IN ('3397007088', '3397007089', '3397008045', '3397016466', '3397007100', '3397007187', '3397007215', '3397007256', '3397007290', '3397007295', '3397007424', '3397007462', '3397007501', '3397007555', '3397007579', '3397007637', '3397007638', '3397007862', '3397007863', '3397009821', '3397009825', '3397009826', '3397010280', '3397013743', '3397014010', '3397014077', '3397014095', '3397014173', '3397014244', '3397014248', '3397014535', '3397118929', '3397118953', '3397118979', '3397007311', '3397007580') AND a.supplierId=30) OR ( a.articleSearch IN ('EF50B01', 'A53B01', 'AF28XB01', 'AFL35B01', 'AFL40B01', 'AFL4850BC02', 'AFL48AB01', 'AFL5035GC02', 'AFL5050BC02', 'AFL50B01', 'AFL5348AC02', 'AFL53B01', 'AFL5553BC02', 'AFL55B01', 'AFL5845EC02', 'AFL5853GC02', 'AFL6035AC02', 'AFL6040AC02', 'AFL6040EC02', 'AFL6040FC02', 'AFL6040GC02', 'AFL6045AC02', 'AFL6045BC02', 'AFL6045GC02', 'AFL6048AC02', 'AFL6048BC02', 'AFL6048EC02', 'AFL6048FC02', 'AFL6050FC02', 'AFL6053AC02', 'AFL6060EC02', 'AFL60B01', 'AFL6540GC02', 'AFL6545FC02', 'AFL6548EC02', 'AFL6550AC02', 'AFL6553FC02', 'AFL6560BC02', 'AFL65B01', 'AFL7055BC02', 'AFL70B01', 'AFL8070AC02', 'AFL80B01', 'AFR60B01', 'AFR70B01', 'AFU6040AC02', 'AFU7060BC02', 'AFU7065BC02', 'AFU7070EC02', 'AS60B01', 'ASC6055B02', 'E53BE1', 'EF35B01', 'EF40B01', 'EF45B01', 'EF48B01', 'EF53B01', 'EF55B01', 'EF60B01', 'EF65B01', 'EF70B01', 'ER35B01', 'ER60B01', 'ER70B01', 'RD53B01', 'RDF50B01', 'RDF53B01', 'RDF60B01', 'RDF70B01', 'AS53B01') AND a.supplierId=43) OR (a.articleSearch='2800011012280' AND a.supplierId=6513) OR ( a.articleSearch IN ('1635454080', '1635454680', '1635454980', '1635455180', '1623232580', '1623232680', '1623232780', '1623232880', '1623232980', '1623233080', '1623233180', '1623233280', '1623233380', '1623233480', '1623233580', '1623235180', '1623235580', '1623236280', '1623237280', '1635454780', '1635455080') AND a.supplierId=4391) OR ( a.articleSearch IN ('WB50220', 'WB50200', 'WB53200', 'WB60010', 'WB60210', 'WB65210') AND a.supplierId=271) OR ( a.articleSearch IN ('030000', '036000', '090000', '096000', '280000', '286000') AND a.supplierId=4840) OR ( a.articleSearch IN ('119497', '119523', '262206', '262211', '116134', '116520', '116540', '119252', '119257', '119260', '119261', '119268', '119269', '119272', '119275', '119276', '119277', '119282', '119283', '119284', '119285', '119287', '119288', '119290', '119292', '119294', '119296', '119297', '119298', '119299', '119305', '119312', '119313', '119314', '119318', '119330', '119332', '119340', '119348', '119355', '119356', '119374', '119378', '119382', '119389', '119391', '119392', '119396', '119401', '119414', '119422', '119426', '119430', '119439', '119452', '119457', '119458', '119460', '119461', '119463', '119466', '119468', '119515', '119764', '119855', '119860', '119865', '262200', '262202', '262207', '262208', '262212', '262213', '262215', '262216', '262231', '262250', '262259', '262263', '116114', '119427', '119425') AND a.supplierId=19) OR ( a.articleSearch IN ('35200', '35240', 'EX304', 'TF500L', 'TF600L') AND a.supplierId=227) OR ( a.articleSearch IN ('574614', '578500', '578506', '578511', '574112', '574117', '574118', '574125', '574129', '574136', '574141', '574151', '574158', '574164', '574275', '574298', '574317', '574321', '574322', '574329', '574337', '574342', '574343', '574346', '574359', '574363', '574365', '574373', '574377', '574382', '574385', '574387', '574394', '574462', '574463', '574466', '574469', '574470', '574472', '574474', '574476', '574478', '574491', '574591', '574634', '574641', '574642', '574643', '574645', '574647', '574653', '574654', '574660', '574668', '574687', '574688', '574703', '574707', '574710', '574747', '575005', '575006', '575008', '575010', '575553', '575785', '575786', '575788', '575790', '575830', '575831', '575832', '575903', '577804', '577808', '577810', '577824', '577826', '577828', '577841', '577857', '577865', '577866', '577871', '577884', '577890', '577894', '577896', '577904', '577912', '577970', '578501', '578502', '578503', '578504', '578505', '578507', '578508', '578512', '578513', '578515', '578516', '578517', '578561', '578564', '578570', '578572', '578576', '578579', '578582', '574168', '574187', '574172', '574173', '574190', '574174', '574176', '574178', '574185', '574313', '574661', '574492', '574349', '574344', '574494', '574603', '574672', '577822', '574670', '574378', '567941', '567945', '567946', '567947', '567948', '567951') AND a.supplierId=21) OR ( a.articleSearch IN ('10300049', '10300049C', '10300122', '10300122C', '10307350') AND a.supplierId=4657) OR ( a.articleSearch IN ('56844', '56865', '57595') AND a.supplierId=6558) OR (a.articleSearch='8001124' AND a.supplierId=257) OR ( a.articleSearch IN ('ASH71026', 'ASH71045', 'ASH71049', 'ASH71051', 'ASH71052', 'ASH71053', 'ASH71054', 'ASH71056', 'ASH71057', 'ASH71060', 'ASH71062', 'ASH71064', 'ASH71069', 'ASH71072', 'ASH71073', 'ASH71074', 'ASH71078', 'ASH71079', 'ASH71080', 'ASH71081', 'ASH71083', 'ASH71085', 'ASH71099', 'ASH71100', 'ASH71101', 'ASH71107', 'ASH71116', 'ASH71117', 'ASH71120', 'ASH71122', 'ASH71123', 'ASH71125', 'ASH71135', 'ASH71136', 'ASH71137', 'ASH71142', 'ASH71143', 'ASH71144', 'ASH71145', 'ASH71146', 'ASH71147', 'ASH71148', 'ASH72430', 'ASH72500', 'ASH72530', 'ASH72600', 'ASH72700', 'ASHR8275', 'PAL72430', 'PAL72500', 'PAL72530', 'PAL72580', 'PAL72600', 'PAL72700', 'WAF20') AND a.supplierId=442) OR (a.articleSearch='PWB1500' AND a.supplierId=4337) OR ( a.articleSearch IN ('BW11RF', 'BW11RF10', 'BW15F', 'BW15F10', 'BW15RF', 'BW15RF10', 'BW16F', 'BW16F10', 'BW16R', 'BW16R10', 'BW18C', 'BW18C10', 'BW18F', 'BW19F', 'BW19F10', 'BW20F', 'BW20F10', 'BW21F', 'BW22F', 'BW24C', 'BW24F', 'BW24F10', 'BW26F', 'BW28F', 'BW28F10') AND a.supplierId=475) OR ( a.articleSearch IN ('BSG15992007', 'BSG15992008', 'BSG15992011', 'BSG15992015', 'BSG15992016', 'BSG15992017', 'BSG15992018', 'BSG15992020', 'BSG15992021', 'BSG15992023', 'BSG15992025', 'BSG30992006', 'BSG30992013', 'BSG30992014', 'BSG30992015', 'BSG30992017', 'BSG30995062', 'BSG40992007', 'BSG40992008', 'BSG40992012', 'BSG60992006', 'BSG65992010', 'BSG70992004', 'BSG70992005', 'BSG70992006', 'BSG70992007', 'BSG70992008', 'BSG90992008', 'BSG90992009', 'BSG90992010', 'BSG90992013', 'BSG90992014', 'BSG90992015') AND a.supplierId=4455) OR ( a.articleSearch IN ('BMC19356', 'BMC19428', 'BMC19429', 'BMC19432', 'BSP21941') AND a.supplierId=157) OR ( a.articleSearch IN ('752538', '752581', '752603', '759913', '760019', '760035') AND a.supplierId=405) OR ( a.articleSearch IN ('D200R0016', 'D200R0019', 'D200R0020', 'D200R0024', 'D200R0026') AND a.supplierId=6476) OR ( a.articleSearch IN ('VD10002', 'VD10026', 'VD10032', 'VD10036', 'VD10038', 'VD10062', 'VD10065', 'VD10123', 'VD10124', 'VD10128', 'VD10133') AND a.supplierId=186) OR ( a.articleSearch IN ('DF005', 'DF007', 'DF011', 'DF013', 'DF015', 'DF016', 'DF017', 'DF018', 'DF029', 'DF033', 'DF034', 'DF037', 'DF040', 'DF047', 'DF050', 'DF052', 'DF061', 'DF063', 'DF067', 'DF069', 'DF072', 'DF078', 'DF085', 'DF096', 'DF100', 'DF109', 'DF112', 'DF114', 'DF121', 'DF124', 'DF128', 'DF151', 'DF240', 'DF245', 'DF260', 'DF308', 'DF311') AND a.supplierId=4760) OR ( a.articleSearch IN ('8574700', '8574701', '8574703') AND a.supplierId=253) OR ( a.articleSearch IN ('1100180002', '1100180012', '1100180017', '1100180027') AND a.supplierId=4345) OR ( a.articleSearch IN ('89550597202', '89550623102', '89550624202', '89550624402', '89980623602', '99551457502', '99551697202', '99981762902', '99981763302', '99981765902', '99981766002') AND a.supplierId=4353) OR ( a.articleSearch IN ('1398002', '466189') AND a.supplierId=355) OR ( a.articleSearch IN ('350DC', '350DF', '350DH', '400DF', '475DF', '500DF', '500DH', '600DC', '600DF', '600DH', '650DF', '650DH') AND a.supplierId=4881) OR ( a.articleSearch IN ('EW7097', 'EW7179', 'EW7185') AND a.supplierId=4344) OR ( a.articleSearch IN ('FT93218', 'FT93224', 'FT93247', 'FT93248', 'FT93250', 'FT93252') AND a.supplierId=4938) OR ( a.articleSearch IN ('792707601', '792707701', '792707801', '792709001', '792709201', '792709501', '792752501', '892702601', '892703101', '892703401', '892704301', '892709401', '892711201', '892733601') AND a.supplierId=6484) OR ( a.articleSearch IN ('AWBC14', 'AWBC22', 'AWBC24') AND a.supplierId=4663) OR ( a.articleSearch IN ('WI0009', 'WI0069', 'WI0088') AND a.supplierId=6443) OR ( a.articleSearch IN ('HB14', 'HB24', 'HF24', 'HF24A', 'HQ14', 'HQ16', 'HQ18', 'HQ19', 'HQ20', 'HQ21', 'HQ24') AND a.supplierId=4756) OR (a.articleSearch='DF124' AND a.supplierId=156) OR (a.articleSearch='80124' AND a.supplierId=481) OR ( a.articleSearch IN ('2110309', '2110327', '27A01', '27A22', '27B06', '27D05', '27D09', '29008', '29009') AND a.supplierId=185) OR ( a.articleSearch IN ('33103Z', '33106Z', '33300Z', '33301Z', '33303Z', '33304Z', '33305Z', '33306Z', '33307Z', '33309Z', '33310Z', '33311Z', '33312Z', '33313Z', '33314Z', '33650X', '33650Z', '33652X', '33652Z', '33656X', '33656Z', '33671X', '33671Z', '33673X', '33738X', '33952Z', '33955Z', '33957Z', '33963Z', '33966Z', '33970Z', '33971Z', '33973Z', '33974Z', '33975Z', '33976Z', '33977Z', '33978Z', '33980Z', '33981Z', '33986Z', '33990Z', '33992Z', '33993Z', '33995Z', '33999Z', '33200Z', '33201Z', '33203Z', '33205Z', '33206Z', '33207Z', '33209Z', '33210Z', '33211Z', '33212Z', '33709X') AND a.supplierId=387) OR ( a.articleSearch IN ('LWCR097', 'LWCR179', 'LWCR185') AND a.supplierId=4501) OR ( a.articleSearch IN ('350L', '5535LR', '600L', '600LS', '6040LR', 'LR38V', 'LW360', 'LW480', 'LW600', 'LX350', 'LX600', 'XF350', 'XF400', 'XF480', 'XF500', 'XF600', 'XF650', 'XF6535R', 'XF6550P') AND a.supplierId=4600) OR ( a.articleSearch IN ('000723114302', '000723114303', '000723114305', '000723114306', '000723114307', '000723114308', '000723114313', '000723114316', '000723114317', '000723114318', '000723114319', '000723114320', '000723114322', '000723114329', '000723114330', '000723114331', '000723114332', '000723114333', '000723114334', '000723114850', '000723115050', '000723115853', '000723116048', '000723116053', '000723116553', '000723118070', '000723126540', '000723126545', '000723126560', '000723140525', '000723143500', '000723144000', '000723144500', '000723144800', '000723145000', '000723145300', '000723145500', '000723146000', '000723146500', '000723147000', '000734000000', '000734500000', '000734800000', '000735000000', '000735300000', '000735500000', '000736000000', '000736500000', '000737000000') AND a.supplierId=4723) OR ( a.articleSearch IN ('104020HPS', '104120HPS', '104575HPS', '104650HPS', '1047002HPS', '104726HPS') AND a.supplierId=133) OR (a.articleSearch='21BPCSMS' AND a.supplierId=358) OR ( a.articleSearch IN ('MU018U', 'MU018WS', 'MU019U', 'MU019WS', 'MU020U', 'MU020WS', 'MU024U', 'MU024WS', 'MU028U', 'MU028WS', 'MU28R') AND a.supplierId=6270) OR ( a.articleSearch IN ('390068', '390074', '390083', '390089', '390091', '390115', '390124', '390144', '390323', '390614', '390639', '390647', '390652', '390655', '390658', '390659', '390662', '390685') AND a.supplierId=403) OR ( a.articleSearch IN ('MCD1124', 'MRP2B03') AND a.supplierId=4773) OR ( a.articleSearch IN ('68026', '68075', '68100', '68141', '68311', '68444', '68463') AND a.supplierId=4664) OR ( a.articleSearch IN ('2190098', '2190329', '2190409') AND a.supplierId=94) OR ( a.articleSearch IN ('CWC18AC', 'CWR15XA', 'CWW22AC') AND a.supplierId=6495) OR (a.articleSearch='M24566' AND a.supplierId=6533) OR ( a.articleSearch IN ('2125733', '2125735', '2125742', '2125753', '2262798', '2262803', '2262815') AND a.supplierId=4380) OR ( a.articleSearch IN ('WBF001300', 'WBF001311', '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', 'WBF003200', 'WBF003211', 'WBH001800', 'WBH001900', 'WBH002100', 'WBH002300', 'WBH002400', 'WBR700200', 'WBR702200') AND a.supplierId=378) OR ( a.articleSearch IN ('18257', '25861', '25863', '25867', '25869', '25870', '27135', '27140', '27142', '27145', '28076') AND a.supplierId=4683) OR ( a.articleSearch IN ('WA400400', 'WA400500', 'WB400525', 'WC400600', 'WC4006001', 'WCP350350', 'WE450450', 'WF450450') AND a.supplierId=6267) OR ( a.articleSearch IN ('041701', '041703', '041705', '041707', '041708', '041710', '041712', '041713', '041714', '041716') AND a.supplierId=314) OR ( a.articleSearch IN ('QAW020', 'QAW024', 'QAW028', 'QTW018') AND a.supplierId=57) OR ( a.articleSearch IN ('298W0008', '298W0019', '298W0030', '298W0036', '298W0047', '298W0048', '298W0049', '298W0055', '298W0056', '298W0059', '298W0060', '298W0063', '298W0074', '298W0082', '298W0086', '298W0092', '298W0096', '298W0105', '298W0107', '298W0110', '298W0112', '298W0118', '298W0120', '298W0122', '298W0134', '298W0135', '298W0141', '298W0145', '298W0151', '298W0155', '298W0158', '298W0159', '298W0161', '298W0176', '298W0197', '298W0204', '298W0234', '298W0260', '298W0266', '298W0279') AND a.supplierId=6358) OR ( a.articleSearch IN ('SKWIB0940007', 'SKWIB0940011', 'SKWIB0940018', 'SKWIB0940029', 'SKWIB0940035', 'SKWIB0940046', 'SKWIB0940047', 'SKWIB0940048', 'SKWIB0940054', 'SKWIB0940055', 'SKWIB0940058', 'SKWIB0940059', 'SKWIB0940062', 'SKWIB0940073', 'SKWIB0940081', 'SKWIB0940085', 'SKWIB0940091', 'SKWIB0940095', 'SKWIB0940104', 'SKWIB0940106', 'SKWIB0940109', 'SKWIB0940111', 'SKWIB0940117', 'SKWIB0940121', 'SKWIB0940133', 'SKWIB0940134', 'SKWIB0940140', 'SKWIB0940144', 'SKWIB0940150', 'SKWIB0940154', 'SKWIB0940158', 'SKWIB0940160', 'SKWIB0940175', 'SKWIB0940203', 'SKWIB0940233', 'SKWIB0940259', 'SKWIB0940265', 'SKWIB0940278') AND a.supplierId=6357) OR ( a.articleSearch IN ('T468026', 'T468075', 'T468100', 'T468141', 'T468311', 'T468444', 'T468463') AND a.supplierId=4667) OR ( a.articleSearch IN ('101450SX', '101530SX', '115380SX', '201603SX', '201609SX', '201632SX', '201633SX', '201637SX', '201644SX', '201677SX', '201697SX', '201699SX', '201701SX', '201703SX', '201706SX', '201724SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('1000351', '1000501', '1000531', '1000551', '1000601', '1000701') AND a.supplierId=6691) OR ( a.articleSearch IN ('BE53', 'BE61', 'FBT460', 'FBT480', 'FBT540', 'FBT610', 'FBT660', 'FBT710') AND a.supplierId=6312) OR ( a.articleSearch IN ('112471', '114279', '114292', '115952', '409096', '409097', '501642', '501643') AND a.supplierId=301) OR ( a.articleSearch IN ('0258414', '0258418', '0258424', '0258430', '0258441', '0758019', '0758022', '0758024', '0858258', '0858260', '0858268', '0858275', '0858277', '0858278') AND a.supplierId=209) OR ( a.articleSearch IN ('V103463', 'V251464', 'V950412', 'V950441', 'V990112') AND a.supplierId=183) OR ( a.articleSearch IN ('1001014', '1001024', '1001028', '1002024', '1003014', '1003024', '1004014', '1004016', '1004018', '1004019', '1004021', '1004022', '1004024', '1005014', '1005024', '1006014', '1006024', '1007014', '1007018', '1007020', '1007021', '1007022', '1007024', '1007026', '1007028') AND a.supplierId=482) OR ( a.articleSearch IN ('171117', '371801', '371803', '371805', '371809', '371813', '371815', '371817', '371819', '371821', '371823') AND a.supplierId=6347) OR ( a.articleSearch IN ('ZV214RM', 'ZV21T', 'ZV299CC', 'ZV29AQ', 'ZV31BW', 'ZV35VL', 'ZV43VL', 'ZV45AL', 'ZV47BW', 'ZV48VL', 'ZV55K', 'ZV8PT', 'ZV98AV', 'ZV9981A', 'ZV99AV', 'ZVL8R', 'ZVL9189', 'ZVLC16', 'ZVLD16', 'ZVMW267', 'ZVMW318') AND a.supplierId=6274)An internal server error occurred.