SELECT DISTINCT m.manufacturerName AS cross_brand, ao.oemSearch, ao.oemnumber, ps_sub.id AS id FROM ( VALUES ('1987946051',30), ('E2W0065BTA',4693), ('APV3208',42), ('6PK1026S',42), ('6PK1033',42), ('2387CFNA',4674), ('43677',101), ('T39292',6665), ('K016PK1025',6665), ('K026PK1028',6665), ('6PK1025',6665), ('6PK1028',6665), ('6PK799SF',6665), ('AG00323',6495), ('6PK1033',4558), ('6PK1025',260), ('6PK1033',6513), ('5PK725',4924), ('6PK1018',4924), ('6PK1020EMD',4924), ('6PK1028',4924), ('6PK1038',4924), ('6PK1043',4924), ('6PK1138',4924), ('6PK1218',4924), ('6PK1880',4924), ('6PK2245',4924), ('YD855292',4924), ('YS006524',4924), ('1570416',317), ('1570586',317), ('55592',4576), ('55605',4576), ('1126PK1025',257), ('1126PK1030',257), ('1126PK1035',257), ('80017',4495), ('654727',300), ('655120',300), ('6PK1015',300), ('6PK1020',300), ('6PK1025',300), ('6PK1033',300), ('6PK1035',300), ('RT1012',4737), ('RT1946',4737), ('RT1960',4737), ('0380418',4651), ('0381084',4651), ('0381984',4651), ('060002',4651), ('160025810',323), ('210155910',323), ('210156310',323), ('210156610',323), ('A05888',4464), ('A09960',4464), ('6PK1025',454), ('6PK1030',454), ('6PK1035',454), ('0011026141',4995), ('0011026142',4995), ('0011026145',4995), ('0011028050',4995), ('0011028141',4995), ('0011028142',4995), ('0011028199',4995), ('0011028223',4995), ('6PK1026',478), ('6PK1033',478), ('DC0116',478), ('AD06R1025',350), ('AD06R1030',350), ('AD06R1036',350), ('ADT39636',350), ('BMS364',6888), ('BMS404',6888), ('1987946000',30), ('1987946054',30), ('1987947817',30), ('1987947940',30), ('TOA3671',195), ('TOA3713',195), ('TOA4408',195), ('TOA5577',195), ('BSG90615021',4455), ('BSG90615053',4455), ('E2F0014BTA',4693), ('E2G0011BTA',4693), ('E2W0068BTA',4693), ('E3C0002BTA',4693), ('E3W0006BTA',4693), ('29800',4679), ('500202',4679), ('500376',4679), ('20968',4463), ('89114',4463), ('759782',405), ('6PK1025',6513), ('6PK1026',6513), ('6PK1030',6513), ('V85726',6513), ('6PK1013',42), ('6PK1030',42), ('6PK1035',42), ('6PK1035S',42), ('6PK1040',42), ('APV2677',42), ('MR61015',89), ('MR61030',89), ('MR61033',89), ('MR61035',89), ('6PK1025',186), ('P224005',186), ('031653',4738), ('A3016',4396), ('A3050',4396), ('A3062',4396), ('1343569',355), ('334303',355), ('DT31042',4881), ('DT31047',4881), ('DT34700',4881), ('1606349980',4391), ('1606350180',4391), ('1612063380',4391), ('1612063580',4391), ('1612065280',4391), ('1612160080',4391), ('1635043380',4391), ('13703',4834), ('14316',4834), ('FT44567',4938), ('FT44597',4938), ('881286L1018',4674), ('28913',101), ('37254',101), ('38423',101), ('39786',101), ('6PK1018',236), ('6PK1025',236), ('6PK1028',236), ('6PK1029EMD',236), ('6PK1033',236), ('6PK1038',236), ('6PK1018',6665), ('6PK1029EMD',6665), ('6PK1030HD',6665), ('6PK1033',6665), ('6PK1038',6665), ('T39107',6665), ('654099',181), ('654727',181), ('153722',178), ('296PK1020',178), ('296PK1035',178), ('J1061020',72), ('J1061033',72), ('1015K6',239), ('1025K6',239), ('1030K6',239), ('1036K6',239), ('T0079',239), ('T0681',239), ('931079',4862), ('931274',4862), ('529016710',204), ('529030110',204), ('529030130',204), ('529032210',204), ('529036710',204), ('529041810',204), ('534030810',204), ('534055210',204), ('537000710',204), ('537000910',204), ('FB6PK1025',204), ('FB6PK1033',204), ('153722',262), ('154115',262), ('296PK1015',262), ('296PK1020',262), ('296PK1025',262), ('296PK1033',262), ('296PK1035',262), ('DV6PK1025',156), ('DV6PK1030',156), ('DV6PK1035',156), ('6PK1025',481), ('6PK1030',481), ('6PK1035',481), ('1118113000',268), ('1118204300',268), ('1118204400',268), ('1118306400',268), ('1318102200',268), ('1318104600',268), ('4818102400',268), ('R0078',185), ('R0226',185), ('R0228',185), ('R0377',185), ('R0380',185), ('DMV3507',201), ('DMV6510',201), ('DMV9056',201), ('DMV9078',201), ('DMV9123',201), ('6PK1013',387), ('6PK1020',387), ('6PK1025',387), ('6PK1035',387), ('6PK1038',387), ('6PK1040',387), ('RX34700',387), ('RX39292',387), ('FI14720',4462), ('FI24900',4462), ('1225755',4546), ('95207313',4712), ('1412201',35), ('1716901',35), ('1717001',35), ('1874601',35), ('6PK1013L',4501), ('6PK1020L',4501), ('6PK1026L',4501), ('6PK1029SL',4501), ('6PK1030L',4501), ('6PK1033L',4501), ('6PK1037L',4501), ('LA0524',4501), ('LA0679',4501), ('6PK1018',4600), ('6PK1028',4600), ('6PK1033',4600), ('PB5202',4600), ('PB5248',4600), ('PB5265',4600), ('PB5291',4600), ('PT3054',4600), ('PT3099',4600), ('PT3105',4600), ('PT3203',4600), ('PT3316',4600), ('PT3332',4600), ('331316170344',4723), ('331316170674',4723), ('331316171175',4723), ('340611001025',4723), ('340611001030',4723), ('340611001033',4723), ('261015',133), ('261025',133), ('261030',133), ('6PK1025PCSMS',358), ('6PK1030PCSMS',358), ('6PK1038PCSMS',358), ('6PK1040PCSMS',358), ('6PK1045PCSMS',358), ('N34700PCSMS',358), ('N39292PCSMS',358), ('6PK1020',6270), ('6PK1035',6270), ('541610',403), ('MRB561025',4773), ('MRB561030',4773), ('MRB561035',4773), ('58576',4664), ('6PK1013',94), ('6PK1025',94), ('6PK1033',94), ('6PK1035',94), ('6PK1040',94), ('0500061025',144), ('0500061035',144), ('0500061038',144), ('1009031125',144), ('7140200006',144), ('SMAMP02445',6279), ('SMAMP03426',6279), ('SMAMV5PK725',6279), ('SMAMV6PK1018',6279), ('SMAMV6PK1020',6279), ('SMAMV6PK1020EXTRA',6279), ('SMAMV6PK1025',6279), ('SMAMV6PK1026',6279), ('SMAMV6PK1028',6279), ('SMAMV6PK1029',6279), ('SMAMV6PK1033',6279), ('SMAMV6PK1035',6279), ('SMAMV6PK1038',6279), ('SMAMV6PK1043',6279), ('SMAMV6PK1138',6279), ('SMAMV6PK1880',6279), ('SMAMV6PK2245',6279), ('6PK1020',6495), ('6PK1033',6495), ('6PK1038',6495), ('AD15083',6495), ('AD15130',6495), ('AD15228',6495), ('AD15340',6495), ('AG00027',6495), ('AG00073',6495), ('AG00307',6495), ('AG03020',6495), ('AG03050',6495), ('AG03099',6495), ('5PK720',4994), ('6PK1015',4994), ('6PK1025',4994), ('6PK1030',4994), ('6PK1036',4994), ('6PK1042',4994), ('6PK1045',4994), ('6PK1140',4994), ('6PK1220',4994), ('501261025',6376), ('501261028',6376), ('501261033',6376), ('501261038',6376), ('6PK1025',6376), ('6PK1028',6376), ('6PK1033',6376), ('6PK1038',6376), ('VFB312',4564), ('M06423',6533), ('AST2134',6874), ('AST2800',6874), ('AST3700',6874), ('ASTA0002',6874), ('530673E',4535), ('J1061020',248), ('J1061035',248), ('N1061028',248), ('M111A16',440), ('N111N57',440), ('T111A51',440), ('RNKFR025',6355), ('2329793',4380), ('2330250',4380), ('2330446',4380), ('ACT220200',378), ('3150SR',64), ('6PK1015',64), ('6PK1025',64), ('6PK1025SCC',64), ('6PK1029OLYMPIA',64), ('6PK1035',64), ('6PK1038',64), ('0N1733',129), ('0N1733S',129), ('0N1832',129), ('0N2014',129), ('0N2014S',129), ('0N2288',129), ('0N2288S',129), ('0N2461',129), ('0N2461S',129), ('0N2488',129), ('0N2488S',129), ('10415',4683), ('40422',4683), ('47285',4683), ('47936',4683), ('PTA1020049',6457), ('PTA1020322',6457), ('6PK1013',4558), ('6PK1025',4558), ('6PK1030',4558), ('6PK1035',4558), ('PT34700B',4558), ('PT52335B',4558), ('6PK1025',4655), ('6PK1026',4655), ('6PK1030',4655), ('6PK1033',4655), ('KGA2052',4655), ('QF31P00029',4339), ('QBR61020',57), ('QTA1464',57), ('QTA1482',57), ('QTA1567',57), ('QTA1577',57), ('QTA1625',57), ('996PK1025',4869), ('996PK1033',4869), ('996PK1035',4869), ('RKT2134',4330), ('RKT2800',4330), ('RKT3700',4330), ('RKTA0002',4330), ('305P0053',6358), ('305P0122',6358), ('55292',23), ('56370',23), ('6PK1013',23), ('6PK1035',23), ('6PK1205',23), ('023130',4623), ('1620055',260), ('1626199',260), ('6PK1030',260), ('6PK1035',260), ('4R351',225), ('6R367',225), ('6R368',225), ('VKM34700',50), ('VKMA31053',50), ('VKMA31213',50), ('VKMA32022',50), ('VKMA33309',50), ('VKMA34700',50), ('VKMA34708',50), ('VKMA38703',50), ('VKMC31028',50), ('VKMC34700',50), ('VKMV6PK1025',50), ('VKMV6PK1026',50), ('VKMV6PK1030',50), ('VKMV6PK1032',50), ('VKMV6PK1033',50), ('VKMV6PK1035',50), ('VKMV6PK1045',50), ('CA6PK1025',110), ('CA6PK1030',110), ('CA6PK1036',110), ('GA35812',110), ('SK6PK1033',6357), ('SKPB0090013',6357), ('T458576',4667), ('0340570SX',4595), ('0340606SX',4595), ('0340747SX',4595), ('0340820SX',4595), ('0340915SX',4595), ('0601013SX',4595), ('0601025SX',4595), ('0601030SX',4595), ('0601035SX',4595), ('30928913',151), ('30943677',151), ('50937254',151), ('70939786',151), ('74938423',151), ('6KSY1026',6394), ('6KSY1033',6394), ('SY34030810',6394), ('SY34055210',6394), ('TP20452',330), ('100742',301), ('111858',301), ('117053',301), ('118001',301), ('304104',301), ('TA1934',4732), ('TA2301',4732), ('8640601018',108), ('8640601025',108), ('8640601028',108), ('8640601033',108), ('8640601038',108), ('8641163017',108), ('8641293048',108), ('037121010C',4999), ('V101814',183), ('V103419',183), ('V103703',183), ('V103707',183), ('V103762',183), ('V104963',183), ('V226666',183), ('99031768801',4346), ('WG1153008',4832), ('WG1253296',4832), ('WG1253312',4832), ('WG1253482',4832), ('WG1428663',4832), ('WG1428664',4832), ('WG1428708',4832), ('WG1428883',4832), ('WG1429010',4832), ('WG1429226',4832), ('WG1430415',4832), ('WG1431699',4832), ('WG1431801',4832), ('WG1709988',4832), ('WG1710163',4832), ('WG1710172',4832), ('WG1710189',4832), ('WG1907022',4832), ('WG1978441',4832), ('WG1992048',4832), ('WG1992049',4832), ('WG2002424',4832), ('WG2002434',4832), ('WG2002436',4832), ('WG2002438',4832), ('WG2002439',4832), ('WG2002440',4832), ('WG2004637',4832), ('WG2004685',4832), ('WG2004757',4832), ('WG2004902',4832), ('WG2005076',4832), ('WG2005112',4832), ('WG2136837',4832), ('WG2148688',4832), ('WG2148690',4832), ('10514',6347), ('10850',6347), ('110785',6347), ('110823',6347), ('110847',6347), ('110873',6347), ('111421',6347), ('310943',6347), ('311413',6347), ('KR6PK1018',4894), ('KR6PK1030',4894), ('SR1019',4894), ('SR1021',4894), ('SR1373',4894), ('SR1448',4894), ('SR1948',4894), ('PB5158',4600), ('14122',35), ('17169',35), ('17170',35), ('18746',35), ('6PK1030',64), ('DMV6518',201) ) 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 LATERAL ( SELECT ps_sub.id FROM products.products_suppliers ps_sub WHERE ps_sub.product_id = p.id AND ps_sub.supplier_id IN (223) ) ps_sub ON true; An internal server error occurred.