SELECT DISTINCT m.manufacturerName AS cross_brand, ao.oemSearch, ao.oemnumber, ps.id FROM ( VALUES ('750402201', 6484), ('70412', 4576), ('70439', 4576), ('19167985', 16), ('22214751', 16), ('22214768', 16), ('30R840', 14), ('36A29B', 14), ('BSG60300001', 4455), ('BSG60300002', 4455), ('BSG60300003', 4455), ('BSG60300004', 4455), ('BSG90300014', 4455), ('FT11521', 4938), ('A22037', 271), ('A22127', 271), ('A51047', 271), ('A51104', 271), ('MM00306', 156), ('MM00307', 156), ('MM00308', 156), ('1142702300', 268), ('335809', 85), ('335810', 85), ('344409', 85), ('444161', 85), ('444262', 85), ('940001', 85), ('G121000LR', 4600), ('G32526LR', 4600), ('G32527LR', 4600), ('O12583LR', 4600), ('352726080000', 4723), ('357333070000', 4723), ('MSS017344', 4570), ('MSS017345', 4570), ('0266230001', 144), ('0266230008', 144), ('0267150002', 144), ('0267150005', 144), ('V1116', 4752), ('V4503', 4752), ('60332108', 127), ('65333091', 127), ('A16347H', 129), ('115904', 32), ('115906', 32), ('318326', 32), ('900085', 32), ('11120031SX', 4595), ('11130049SX', 4595), ('12130054SX', 4595), ('41140134SX', 4595), ('42140167SX', 4595), ('42140168SX', 4595), ('AG15051', 4772), ('AG15052', 4772), ('AG15501', 4772), ('AH15502', 4772), ('0230056', 209), ('0230064', 209), ('0230077', 209), ('0230086', 209), ('JGM1004T', 4501), ('JGM1006T', 4501), ('JHT238T', 4501), ('SG4483', 4894), ('MLS686970', 4400), ('52013', 6558), ('52604', 6558), ('52613', 6558), ('101570', 96), ('200100', 96), ('200110', 96), ('200113', 96), ('200813', 96), ('201080', 96), ('201530', 96), ('203193', 96), ('209110', 96), ('300910', 96), ('302140', 96), ('610040', 96), ('X045349', 4975), ('X484343', 4975), ('70454', 4576), ('70869', 4576), ('MA00288', 257), ('MA00304', 257), ('MA00305', 257), ('MA00306', 257), ('MA00307', 257), ('MA00308', 257), ('MA00526', 257), ('MA00527', 257), ('MA00549', 257), ('MA00727', 257), ('MA00749', 257), ('20217', 4495), ('20257', 4495), ('20258', 4495), ('20259', 4495), ('20404', 4495), ('20443', 4495), ('20444', 4495), ('20930', 4495), ('20931', 4495), ('20943', 4495), ('98640', 4495), ('D5021', 351), ('110070410', 323), ('110070510', 323), ('110096210', 323), ('110096310', 323), ('110097510', 323), ('PSG2335', 4337), ('PSG2370', 4337), ('PSG3029', 4337), ('PSG3219', 4337), ('PSG4046', 4337), ('PSG4348', 4337), ('PSG8376', 4337), ('PSG8432', 4337), ('PSG9044', 4337), ('PSH2370', 4337), ('PSH3029', 4337), ('PSH4046', 4337), ('047062B', 49), ('060250GB', 49), ('060350HB', 49), ('060749GB', 49), ('060749HB', 49), ('062394GB', 49), ('062394HB', 49), ('062481GB', 49), ('062620B', 49), ('19028521', 16), ('19064529', 16), ('19100180', 16), ('19169279', 16), ('24214230', 16), ('277950', 14), ('277960', 14), ('30D240', 14), ('30K49A', 14), ('31009A', 14), ('32B710', 14), ('32B780', 14), ('32B800', 14), ('32H600', 14), ('32H610', 14), ('32H61A', 14), ('32H620', 14), ('32H630', 14), ('32K500', 14), ('36A27A', 14), ('36A27B', 14), ('36A27C', 14), ('36A29C', 14), ('36C280', 14), ('BSG60300008', 4455), ('BSG60300021', 4455), ('BSG90300010', 4455), ('BSG90300011', 4455), ('BSG90700122', 4455), ('99205', 4604), ('99206', 4604), ('99207', 4604), ('423303', 6479), ('423304', 6479), ('434710', 6479), ('453302', 6479), ('453303', 6479), ('533357', 6479), ('534711', 6479), ('563315', 6479), ('563316', 6479), ('563317', 6479), ('563318', 6479), ('564203', 6479), ('564204', 6479), ('564711', 6479), ('PK2301', 6479), ('PK2305', 6479), ('D22510080', 89), ('D2253733', 89), ('D2259006', 89), ('D2259060', 89), ('DG9025', 89), ('V20334723', 89), ('DSB003G', 186), ('DSF011O', 186), ('DSF012G', 186), ('DSF014O', 186), ('DSF021O', 186), ('DSF024G', 186), ('DSF079G', 186), ('9970016', 253), ('9970040', 253), ('9970069', 253), ('9970160', 253), ('1060140106', 4345), ('1060140107', 4345), ('1060170074', 4345), ('465174', 355), ('466585', 355), ('466586', 355), ('466587', 355), ('466588', 355), ('466589', 355), ('467876', 355), ('468334', 355), ('468744', 355), ('DSA333709', 4881), ('DSA333716', 4881), ('DSA333718', 4881), ('DSA334812', 4881), ('DSA335809', 4881), ('DSA335810', 4881), ('DSA341846', 4881), ('DSA341951', 4881), ('DSA343271', 4881), ('DSA344261', 4881), ('DSA345900', 4881), ('DSA441081', 4881), ('DSA444119', 4881), ('DSA444161', 4881), ('DSA444262', 4881), ('520020', 4512), ('32SKV062', 4969), ('32SKV063', 4969), ('32SKV092', 4969), ('32SKV158', 4969), ('1623312980', 4391), ('1623331680', 4391), ('1635548580', 4391), ('1675670280', 4391), ('FT11070', 4938), ('FT11071', 4938), ('FT11515', 4938), ('FT11535', 4938), ('1607G013F', 4674), ('2307G002R', 4674), ('109507', 101), ('20446', 101), ('A21111', 271), ('A22170', 271), ('A22171', 271), ('FZ91913', 4467), ('750401901', 6484), ('750402101', 6484), ('750403101', 6484), ('750702301', 6484), ('42388', 4639), ('42864', 4639), ('83367', 4639), ('83450', 4639), ('G54045', 4639), ('G54046', 4639), ('G71108', 4639), ('8130037', 4395), ('8130057', 4395), ('8130769', 4395), ('8150075', 4395), ('8150085', 4395), ('8150086', 4395), ('8150314', 4395), ('8150542', 4395), ('8150708', 4395), ('8270003', 4395), ('8270043', 4395), ('9130037', 4395), ('9130057', 4395), ('9130106', 4395), ('9130769', 4395), ('9150075', 4395), ('9150085', 4395), ('9150086', 4395), ('9150314', 4395), ('9150542', 4395), ('9150708', 4395), ('9150725', 4395), ('9160016', 4395), ('9270003', 4395), ('9270043', 4395), ('9270659', 4395), ('9430703', 4395), ('540578', 373), ('5405780PK', 373), ('GSA341846', 6529), ('GSA344261', 6529), ('GSA444119', 6529), ('MM00288', 156), ('MM00304', 156), ('MM00305', 156), ('MM00526', 156), ('MM00527', 156), ('MM00549', 156), ('MM00727', 156), ('MM00749', 156), ('MJ00288', 481), ('MJ00304', 481), ('MJ00305', 481), ('MJ00306', 481), ('MJ00307', 481), ('MJ00308', 481), ('MJ00526', 481), ('MJ00527', 481), ('MJ00549', 481), ('MJ00727', 481), ('MJ00749', 481), ('1142108000', 268), ('1152103000', 268), ('1152109200', 268), ('1152109500', 268), ('1152109900', 268), ('1342101900', 268), ('1352102100', 268), ('2000034', 185), ('2000475', 185), ('2000476', 185), ('2000805', 185), ('2000890', 185), ('2000931', 185), ('2000967', 185), ('2019044', 185), ('20300036', 185), ('20300046', 185), ('20335061', 185), ('20335062', 185), ('20344002', 185), ('20345032', 185), ('20349037', 185), ('20441195', 185), ('20553003', 185), ('SSA10154', 201), ('SSA10155', 201), ('SSA10160', 201), ('SSA10162', 201), ('SSA10163', 201), ('SSA10164', 201), ('SSA10263', 201), ('SSA10264', 201), ('SSA10268', 201), ('46200Z', 387), ('46230Z', 387), ('46281Z', 387), ('802482', 18), ('822380', 18), ('822434', 18), ('822440', 18), ('822585', 18), ('872604', 18), ('872638', 18), ('88051055', 18), ('4000241', 4546), ('4000245', 4546), ('4001350', 4546), ('4001410', 4546), ('4010690', 4546), ('4010710', 4546), ('4011200', 4546), ('4011210', 4546), ('4011220', 4546), ('4011222', 4546), ('4011265', 4546), ('4011270', 4546), ('4011275', 4546), ('4080095', 4546), ('341339', 85), ('341846', 85), ('343484', 85), ('344261', 85), ('349044', 85), ('349045', 85), ('441081', 85), ('443190', 85), ('443342', 85), ('444119', 85), ('553119', 85), ('553287', 85), ('C02335', 4731), ('C03151', 4731), ('C03219', 4731), ('C04055', 4731), ('C14049', 4731), ('C22370', 4731), ('C24046', 4731), ('C28376', 4731), ('C28432', 4731), ('D02335', 4731), ('D03151', 4731), ('D03219', 4731), ('D04055', 4731), ('D14049', 4731), ('D22370', 4731), ('D24046', 4731), ('D28376', 4731), ('D28432', 4731), ('G11152LR', 4600), ('G12734LR', 4600), ('G12872LR', 4600), ('O12184LR', 4600), ('O12469LR', 4600), ('O12581LR', 4600), ('PR5003', 4600), ('351489080000', 4723), ('352714080000', 4723), ('352746070000', 4723), ('352747070000', 4723), ('354315080000', 4723), ('357213070000', 4723), ('357276070000', 4723), ('357323070000', 4723), ('357404080000', 4723), ('380002480203', 4723), ('380012130943', 4723), ('380012131053', 4723), ('A9M003MT', 4427), ('AGM023MT', 4427), ('AGM024MT', 4427), ('AGW039MT', 4427), ('AHM018MT', 4427), ('AHW039MT', 4427), ('MSS015031', 4570), ('MSS015266', 4570), ('MSS015366', 4570), ('MSS016956', 4570), ('MSS016957', 4570), ('MSS017072', 4570), ('MSS020971', 4570), ('MSS020975', 4570), ('MSS020976', 4570), ('MSS020977', 4570), ('MSS021245', 4570), ('20809', 133), ('208092', 133), ('20850', 133), ('208502', 133), ('20851', 133), ('208512', 133), ('40840', 133), ('408402', 133), ('40842', 133), ('408422', 133), ('40845', 133), ('408452', 133), ('40849', 133), ('408492', 133), ('101497PCSMS', 358), ('101498PCSMS', 358), ('115904PCSMS', 358), ('115906PCSMS', 358), ('124654PCSMS', 358), ('170786PCSMS', 358), ('290377PCSMS', 358), ('314608PCSMS', 358), ('110047', 403), ('110048', 403), ('110050', 403), ('110205', 403), ('110411', 403), ('110647', 403), ('MCD0016', 4764), ('MCD0040', 4764), ('MCD0069', 4764), ('MCD0160', 4764), ('MCD0253', 4764), ('PN6531502', 4570), ('PN7331102', 4570), ('PN7331146', 4570), ('PS9831155', 4570), ('PS9831157', 4570), ('MSH700288', 4773), ('MSH700304', 4773), ('MSH700305', 4773), ('MSH700306', 4773), ('MSH700307', 4773), ('MSH700308', 4773), ('MSH700526', 4773), ('MSH700527', 4773), ('MSH700549', 4773), ('MSH700727', 4773), ('MSH700749', 4773), ('2340015', 94), ('2340039', 94), ('2340066', 94), ('2340110', 94), ('2340310', 94), ('0146400002', 144), ('0266230007', 144), ('0267150004', 144), ('0267150006', 144), ('0267250035', 144), ('0267250036', 144), ('1267250001', 144), ('DG01061', 6495), ('DG0106101', 6495), ('DG01373', 6495), ('DG02176', 6495), ('DG0217601', 6495), ('DG02375', 6495), ('DG02376', 6495), ('DM02382', 6495), ('DM02425', 6495), ('PK123', 4752), ('V1066', 4752), ('V1087', 4752), ('V1166', 4752), ('V1177', 4752), ('V1205', 4752), ('V2077', 4752), ('V4507', 4752), ('60331157', 127), ('60332153', 127), ('60333214', 127), ('60472011', 127), ('62333091', 127), ('62335624', 127), ('63332319', 127), ('63472011', 127), ('693302', 127), ('120178', 6361), ('120179', 6361), ('130110', 6361), ('130154', 6361), ('I490U17', 440), ('82223FU', 198), ('82278FU', 198), ('82341RU', 198), ('82390FU', 198), ('82629RU', 198), ('2165730', 4380), ('2165738', 4380), ('2166206', 4380), ('2166237', 4380), ('2166276', 4380), ('DCK511302', 378), ('SAB821931', 378), ('SAB822512', 378), ('SAB824031', 378), ('SAB827331', 378), ('SAB830432', 378), ('A1431G', 129), ('A2108G', 129), ('A2108H', 129), ('A3091G', 129), ('A3091H', 129), ('A3715G', 129), ('A5134G', 129), ('AK735418', 129), ('F87160', 129), ('32138', 331), ('50326', 331), ('04165', 4683), ('04663', 4683), ('12707', 4683), ('18419', 4683), ('PPK10207', 4558), ('PPK10307', 4558), ('PPK10402', 4558), ('PSA335809', 4558), ('PSA335810', 4558), ('PSA341339', 4558), ('PSA344409', 4558), ('PSA345900', 4558), ('PSA349044', 4558), ('PSA441081', 4558), ('PSA444119', 4558), ('PSA444161', 4558), ('01340600A', 63), ('01340610A', 63), ('01347810A', 63), ('01352010A', 63), ('01352910A', 63), ('01353010A', 63), ('76311410A', 63), ('JAPMM00727', 4652), ('JAPMM00749', 4652), ('20010073', 4686), ('20010528', 4686), ('20010606', 4686), ('20020275', 4686), ('20020768', 4686), ('20020917', 4686), ('20041163', 4686), ('20041176', 4686), ('171205', 6865), ('173414', 6865), ('173821', 6865), ('173914', 6865), ('173915', 6865), ('182014', 6865), ('182195', 6865), ('182236', 6865), ('183387', 6865), ('183396', 6865), ('183414', 6865), ('183670', 6865), ('192020', 6865), ('475061', 6865), ('475083', 6865), ('475085', 6865), ('475087', 6865), ('475331', 6865), ('476007', 6865), ('QAG181180', 57), ('QAG181185', 57), ('QAG181186', 57), ('QAG181187', 57), ('QAG181241', 57), ('QAG181305', 57), ('QAG181358', 57), ('QAG181376', 57), ('QAG181379', 57), ('R52532', 4303), ('854S0055', 6358), ('854S0105', 6358), ('854S0343', 6358), ('854S0516', 6358), ('854S0560', 6358), ('854S0689', 6358), ('854S0883', 6358), ('854S1074', 6358), ('854S1861', 6358), ('854S2089', 6358), ('854S2234', 6358), ('854S2284', 6358), ('101497', 32), ('101498', 32), ('101516', 32), ('106163', 32), ('115899', 32), ('115901', 32), ('115905', 32), ('115907', 32), ('124654', 32), ('170585', 32), ('170786', 32), ('280665', 32), ('290377', 32), ('290378', 32), ('290379', 32), ('290403', 32), ('310014', 32), ('314608', 32), ('318323', 32), ('318327', 32), ('318328', 32), ('318329', 32), ('100145', 4623), ('201281', 4623), ('201282', 4623), ('201283', 4623), ('203227', 4623), ('203454', 4623), ('203455', 4623), ('209356', 4623), ('209464', 4623), ('209465', 4623), ('209477', 4623), ('10046F', 6377), ('21144F', 6377), ('21670R', 6377), ('21686R', 6377), ('21887F', 6377), ('21888F', 6377), ('22051R', 6377), ('22058R', 6377), ('22074R', 6377), ('22075R', 6377), ('32772R', 6377), ('32877F', 6377), ('33011F', 6377), ('33351R', 6377), ('33375R', 6377), ('33395F', 6377), ('Z2011', 225), ('11477', 4614), ('215238G', 6322), ('215894G', 6322), ('215895G', 6322), ('545540', 6322), ('545540G', 6322), ('545610G', 6322), ('735459G', 6322), ('745458G', 6322), ('SKSA0130054', 6357), ('SKSA0130104', 6357), ('SKSA0130880', 6357), ('SKSA0131157', 6357), ('SKSA0131221', 6357), ('SKSA0131565', 6357), ('SKSA0131951', 6357), ('SKSA0132175', 6357), ('SKSA0132973', 6357), ('SKSA0133202', 6357), ('SKSA0133345', 6357), ('SKSA0133395', 6357), ('1117178SX', 4595), ('12120037SX', 4595), ('12140011SX', 4595), ('8704886SX', 4595), ('810998', 6691), ('8115002', 6691), ('8119602', 6691), ('814510', 6691), ('041707950072', 336), ('041707950075', 336), ('041707950095', 336), ('041707950100', 336), ('041707950111', 336), ('041707950250', 336), ('041707950264', 336), ('041707950295', 336), ('041707950301', 336), ('041707950302', 336), ('33100485', 151), ('SYNC1065', 6394), ('SYNC1137', 6394), ('SYNC1138', 6394), ('SYNC2608', 6394), ('SYNC2609', 6394), ('SYNC2613', 6394), ('SYNC2614', 6394), ('SYNC2620', 6394), ('SYNC2646', 6394), ('SYNC2648', 6394), ('SYNC2701', 6394), ('SYNC2702', 6394), ('00412928', 4593), ('00720177', 4593), ('00727894', 4593), ('108365', 301), ('112868', 301), ('401985', 301), ('401988', 301), ('5000335810', 6022), ('5000341339', 6022), ('AG15503', 4772), ('AG18509', 4772), ('870523201', 108), ('870523202', 108), ('870529206', 108), ('0230081', 209), ('0230106', 209), ('0230178', 209), ('JGM1004S', 4501), ('JGM1006S', 4501), ('JGT1132S', 4501), ('JGT1132T', 4501), ('JHE245S', 4501), ('JHE245T', 4501), ('JHE264S', 4501), ('JHE264T', 4501), ('JHT129S', 4501), ('JHT129T', 4501), ('JHT238S', 4501), ('V104982', 183), ('V301710', 183), ('V301760', 183), ('V304141', 183), ('V304148', 183), ('VE56132', 4425), ('44131063701', 4346), ('44131099001', 4346), ('55130887601', 4346), ('55131045201', 4346), ('55131063801', 4346), ('55131616901', 4346), ('1015490', 6003), ('1015650', 6003), ('1015660', 6003), ('1015670', 6003), ('1019090', 6003), ('1019120', 6003), ('1104970', 6003), ('1104980', 6003), ('1114890', 6003), ('1114900', 6003), ('1115650', 6003), ('1115690', 6003), ('1115840', 6003), ('1115860', 6003), ('201549', 6003), ('201565', 6003), ('201566', 6003), ('201567', 6003), ('201909', 6003), ('201912', 6003), ('210497', 6003), ('210498', 6003), ('211489', 6003), ('211490', 6003), ('211565', 6003), ('211569', 6003), ('211584', 6003), ('211586', 6003), ('160479', 6347), ('160495', 6347), ('160871', 6347), ('160873', 6347), ('161195', 6347), ('161205', 6347), ('161431', 6347), ('180849', 6347), ('360965', 6347), ('360967', 6347), ('360981', 6347), ('361631', 6347), ('361647', 6347), ('SG2097', 4894), ('SG2098', 4894), ('SG2420', 4894), ('SG2459', 4894), ('SG2460', 4894), ('SG2560', 4894), ('SG2810', 4894), ('SG4686', 4894), ('SO2039', 4894), ('SO2081', 4894), ('SO6193', 4894), ('MJ00309', 481), ('MJ00555', 481), ('MJ00556', 481), ('MJ00529', 481), ('325650', 14), ('36A29A', 14), ('115900', 32), ('105811', 32), ('310770', 32), ('335914', 85), ('335915', 85), ('345900', 85), ('209113', 96), ('MM00309', 156), ('MM00555', 156), ('MM00556', 156), ('MM00529', 156), ('0230228', 209), ('MA00309', 257), ('MA00555', 257), ('MA00556', 257), ('MA00529', 257) ) AS search_list(search_art, search_sup) INNER JOIN article a ON a.articleSearch = search_list.search_art AND a.supplierId = search_list.search_sup 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 p.id = ps.product_id AND ps.supplier_id IN (223) An internal server error occurred.