SELECT DISTINCT m.manufacturerName AS cross_brand, ao.oemSearch, ao.oemnumber, ps_sub.id AS id FROM ( VALUES ('0265006813',30), ('60320',47), ('60023',47), ('50394',47), ('BSG30840025',4455), ('BSG25840008',4455), ('CS0364',215), ('PS10122',89), ('AS10200',89), ('SS11076',89), ('SS10916',89), ('SS20109',89), ('1953037',4005), ('1830128',4005), ('550159',234), ('550295',234), ('550037',234), ('550122',234), ('550151',234), ('330116',234), ('331010',234), ('558052',234), ('93105',4005), ('90037',4005), ('73128',4005), ('73331',4005), ('60232',240), ('79300',240), ('FT75573',4938), ('2182GTRF',4674), ('174735',101), ('TSN22444',271), ('WHB73264',271), ('WHB83176',271), ('1540055K',4727), ('9245009',373), ('MSC6',287), ('064847183010',4723), ('82164',244), ('87494',244), ('87173',244), ('87121',244), ('87383',244), ('87436',244), ('86173',244), ('86173E',244), ('82033',244), ('0900029',94), ('7148000025',144), ('ABUS039',4705), ('81016',15), ('81076',15), ('81077',15), ('81019',15), ('10846',4683), ('12463',4683), ('PE40097',4558), ('PE13158',4558), ('ABS52010',4558), ('ABS52100',4558), ('ABS52152',4558), ('722184240',5), ('722184260',5), ('0600010SX',4595), ('0604010SX',4595), ('0665500SX',4595), ('6106512SX',4595), ('254004',21), ('12002082',4657), ('12004048',4657), ('12004049',4657), ('12005037',4657), ('12005040',4657), ('200014',206), ('30132',206), ('30440',206), ('30442',206), ('30445',206), ('AMMA775',374), ('ASM029',374), ('ASTR104',374), ('51908',6558), ('52090',6558), ('54078',6558), ('54604',6558), ('54913',6558), ('57240',6558), ('751015N',80), ('10342905',479), ('621009',96), ('ABS1069',4537), ('ABS1082',4537), ('XS2587',4975), ('70824',4576), ('73624',4576), ('74150',4576), ('99919',4576), ('PAL62012',442), ('FDWHFDF',4631), ('105578',4495), ('808870',300), ('901042',300), ('901511',300), ('901514',300), ('901515',300), ('903069',300), ('903128',300), ('903129',300), ('904040',300), ('AS2078',4737), ('AS2181',4737), ('AS4097',4737), ('AS4152',4737), ('AS4218',4737), ('AS4265',4737), ('AS4298',4737), ('AS4365',4737), ('AS4384',4737), ('AS4398',4737), ('AS4946',4737), ('AS5171',4737), ('LM1164',4737), ('RS1072',4737), ('0197382',4651), ('110010010',323), ('140006610',323), ('150003110',323), ('150008110',323), ('150008610',323), ('150013410',323), ('150015410',323), ('150039510',323), ('PDN0118',4337), ('PES0083',4337), ('PSE1346',4337), ('PSE1350',4337), ('PSE1352',4337), ('290RD00048',6271), ('290SS00138',6271), ('290SS00435',6271), ('290SS00437',6271), ('RA7865',4464), ('RA7865H',4464), ('0034012759',4995), ('AMS1511',194), ('050505B',49), ('058084B',49), ('058174B',49), ('058251B',49), ('058422B',49), ('ST028',6444), ('ST116',6444), ('SR8552',478), ('52211',208), ('ADJ137203',350), ('ADJ137213',350), ('ADJ137214',350), ('ADJ137218',350), ('ADJ137402',350), ('ADJ137403',350), ('ADM57225',350), ('BTS3000',475), ('BWK862',475), ('0265006458',30), ('0265006812',30), ('0265006818',30), ('0280122005',30), ('0280130026',30), ('0280130055',30), ('0280130107',30), ('0986280439',30), ('0986280475',30), ('0986280480',30), ('0986280703',30), ('KRT2336',195), ('30081',47), ('50396',47), ('50401',47), ('50416',47), ('60051',47), ('60207',47), ('60583',47), ('94BF6C315AA',6366), ('BSG30600005',4455), ('BSG30605020',4455), ('BSG30840010',4455), ('BSG65840028',4455), ('H1G032BTA',4693), ('H5G001BTA',4693), ('SALEH1G032BTA',4693), ('550450',6549), ('RC7865',4463), ('RC7865H',4463), ('CS0282',215), ('CS0291',215), ('CS0385',215), ('MS0102',215), ('RS5613',215), ('WS2587',215), ('WS3002',215), ('WS3130',215), ('081405',405), ('081412',405), ('71920LV',6411), ('CHA071',421), ('2910000438400',83), ('323805009001D',83), ('45CRT3588',4594), ('CSD9042',4334), ('CSG9687',4334), ('CSG9691',4334), ('CSG9693',4334), ('CSG9694',4334), ('CSM6813',4334), ('CSM6847',4334), ('CSP9240',4334), ('CSR9012',4334), ('CSR9022',4334), ('CSR9051',4334), ('CSR9209',4334), ('CSR9229',4334), ('CSR9445',4334), ('CST9394',4334), ('CST9544',4334), ('CST9557',4334), ('CST9577',4334), ('CST9581',4334), ('CST9582',4334), ('CST9586',4334), ('CST9587',4334), ('CST9592',4334), ('CVR3058',4334), ('KWD1194',42), ('AF1025412B1',89), ('AF1025512B1',89), ('BK1307',89), ('SS10057',89), ('SS10188',89), ('SS1018812B1',89), ('SS11038',89), ('SS20180',89), ('SS20261',89), ('TS1023912B1',89), ('TS10250',89), ('W413012',186), ('WK413111',186), ('DMA0220',4760), ('FLOWS009AN',4882), ('FLOWS009DPSN',4882), ('FLOWS009HLLN',4882), ('FLOWS009N',4882), ('DS1005',471), ('1040300019',4345), ('1040300023',4345), ('1180050075',4345), ('DP2010100042',4948), ('DP2010100139',4948), ('1336005',355), ('1336006',355), ('1336008',355), ('1340020',355), ('1340803',355), ('1391100',355), ('760503',355), ('DMAF2008',4881), ('DWH3588',4881), ('EBK1855',6364), ('145511',211), ('145519',211), ('145535',211), ('291066',211), ('295001',211), ('295076',211), ('302326',211), ('303231',211), ('303265',211), ('305131',211), ('EA0026',4344), ('EA0216',4344), ('EA0245',4344), ('EA0370',4344), ('EA0453',4344), ('EE0004',4344), ('EE0010',4344), ('EE0013',4344), ('EE0049',4344), ('EE2007',4344), ('EE2323',4344), ('EE2711',4344), ('EE4002',4344), ('EE4084',4344), ('EV0006',4344), ('EV0162',4344), ('EV0212',4344), ('EV0288',4344), ('EV3003',4344), ('XAM4004',4344), ('XAM4090',4344), ('XBL7413',4344), ('XBS026',4344), ('XBS216',4344), ('XBS245',4344), ('XCS6005',4344), ('XCS6008',4344), ('XCS6014',4344), ('XCS6044',4344), ('XKS6725',4344), ('XMS7014',4344), ('XSP7241',4344), ('XTS7705',4344), ('XTS7876',4344), ('XTS8159',4344), ('XTS8191',4344), ('ENT300001',6889), ('SALEENT300001',6889), ('1830211',4005), ('1830331',4005), ('1860242',4005), ('1953189',4005), ('1953307',4005), ('1953745',4005), ('1957105',4005), ('1993076',4005), ('330135',234), ('330593',234), ('330611',234), ('550037A',234), ('550038',234), ('550042',234), ('550042A',234), ('550122A',234), ('550151A',234), ('550159A',234), ('550295A',234), ('550314',234), ('558052A',234), ('560058',234), ('560059',234), ('560059A',234), ('560062',234), ('560062A',234), ('560064',234), ('06SKV108',4969), ('06SKV241',4969), ('08SKV206',4969), ('17SKV259',4969), ('17SKV260',4969), ('17SKV546',4969), ('29SKV047',4969), ('1623952280',4391), ('103076',4005), ('73211',4005), ('76242',4005), ('90189',4005), ('90307',4005), ('90745',4005), ('15069',240), ('32428',240), ('33010',240), ('33360',240), ('40595',240), ('78345',240), ('78475',240), ('79092',240), ('79094',240), ('79180',240), ('79247',240), ('713678650',192), ('FHBK1035',267), ('13771',4834), ('14180',4834), ('FT24059',4938), ('FT75515',4938), ('FT75522',4938), ('FT75524',4938), ('FT75575',4938), ('FT76110',4938), ('FT76117',4938), ('FT80864',4938), ('101635',101), ('103399',101), ('106026',101), ('106812',101), ('17695',101), ('22805',101), ('24841',101), ('24866',101), ('24880',101), ('FBK862',407), ('FTS3000',407), ('3234237',441), ('38813',441), ('38813A2',441), ('38847',441), ('460163',441), ('82333',441), ('82557',441), ('82582',441), ('83022',441), ('83051',441), ('83209',441), ('83209A2',441), ('83229',441), ('83445',441), ('84042',441), ('84240',441), ('84240A2',441), ('84687',441), ('84691',441), ('84693',441), ('84694',441), ('FR390074',236), ('1540024S',4727), ('FWB0139',409), ('880205701',6484), ('880205803',6484), ('GS8305',4933), ('913011',4379), ('913131',4379), ('913231',4379), ('913311',4379), ('919471',4379), ('919511',4379), ('920981',4379), ('920991',4379), ('WH1452K',316), ('GH21140',6666), ('WBH0053',6443), ('9245009K',373), ('120000041',4524), ('150442',4819), ('150701',4819), ('150711',4819), ('150833',4819), ('150880',4819), ('181941',4819), ('182435',4819), ('182437',4819), ('182439',4819), ('182873',4819), ('6PG009108741',4734), ('6PP009400381',4734), ('6PT009107361',4734), ('6PU009121471',4734), ('6PU009121681',4734), ('6PU009163511',4734), ('6ZF008621571',4734), ('8ET009142581',4734), ('70511110',72), ('70610023',72), ('70630004',72), ('70630300',72), ('70640307',72), ('70660329',72), ('J5633020',72), ('135087',449), ('137391',449), ('138127',449), ('138130',449), ('2505087',449), ('92095070',118), ('3600047',341), ('7472033',341), ('7472079',341), ('7472164',341), ('7472164E',341), ('7472425',341), ('7516173',341), ('7516173E',341), ('7516196',341), ('7517121',341), ('7517173',341), ('7517173E',341), ('7517383',341), ('7517436',341), ('7517494',341), ('7517542',341), ('8290098',341), ('8290111',341), ('8290113',341), ('8290116',341), ('84213080',6359), ('84217050',6359), ('101145',4862), ('101145R',4862), ('14773',269), ('16839',269), ('18876',269), ('18941',269), ('19071',269), ('19074',269), ('19095',269), ('19198',269), ('19553',269), ('19642',269), ('19755',269), ('54787',269), ('55121',269), ('55450',269), ('55585',269), ('60007',269), ('60029',269), ('60032',269), ('60048',269), ('307865',262), ('400037',262), ('400506',262), ('400509',262), ('400510',262), ('402064',262), ('402123',262), ('402124',262), ('403035',262), ('1193102200',268), ('1541400400',268), ('1593700200',268), ('1593901400',268), ('1060196',185), ('1060202',185), ('1060203',185), ('1060208',185), ('108011',185), ('108029',185), ('109015',185), ('109020',185), ('5500129',185), ('ECA4502',201), ('ECR4507',201), ('ECT2002',201), ('ECT4507',201), ('818016145',286), ('818016223',286), ('818016237',286), ('818016246',286), ('853016132',286), ('862610014',286), ('881216101',286), ('881228101',286), ('882416010',286), ('885516101',286), ('885516102',286), ('885516105',286), ('885516107',286), ('886516102',286), ('KWB862',4879), ('163301Z',387), ('22059Z',387), ('51033Z',387), ('RK7865',4462), ('RK7865H',4462), ('4102435',4546), ('8802003',4546), ('8802040',4546), ('8802045',4546), ('8802095',4546), ('9412115',4546), ('453037',4006), ('453189',4006), ('453307',4006), ('453745',4006), ('457105',4006), ('493076',4006), ('530128',4006), ('530211',4006), ('530331',4006), ('560242',4006), ('LAB120',6518), ('LAB121',6518), ('LAB124',6518), ('LAB344',6518), ('LAV001',6518), ('LCS160',6518), ('LCS212',6518), ('LCS311',6518), ('LCS314',6518), ('LCS336',6518), ('LCS430',6518), ('LKS048',6518), ('LMF129',6518), ('LMS035',6518), ('LRL055',6518), ('LWS010',6518), ('LWS026',6518), ('LWS116',6518), ('FDB968',4501), ('FDM689',4501), ('LKBA64036',4501), ('SEB1128',4501), ('SEB1150',4501), ('SEB1462',4501), ('SEB1951',4501), ('SEB412',4501), ('SEB464',4501), ('SEB5122',4501), ('SEB940',4501), ('SMB660',4501), ('SNB1448',4501), ('SNB809',4501), ('SNB844',4501), ('WB1006',4600), ('064836036010',4723), ('064847103010',4723), ('064847197010',4723), ('064848002010',4723), ('064848006010',4723), ('064848172010',4723), ('171916011040',4723), ('171916011370',4723), ('213719656010',4723), ('213719798019',4723), ('215810003000',4723), ('361111183108',4723), ('TSE12',287), ('26633',133), ('88000',133), ('88582',133), ('0280140516PCSMS',358), ('3588SETMS',358), ('200172',403), ('210124',403), ('210204',403), ('240098',403), ('240176',403), ('240204',403), ('330164',403), ('500142',403), ('510133',403), ('EPS1830128',4773), ('EPS1830211',4773), ('EPS1830331',4773), ('EPS1860242',4773), ('EPS1953037',4773), ('EPS1953189',4773), ('EPS1953307',4773), ('EPS1953745',4773), ('EPS1957105',4773), ('EPS1993076',4773), ('MRP2B03',4773), ('36047',244), ('82079',244), ('82164E',244), ('82425',244), ('86196',244), ('87173E',244), ('87542',244), ('90098',244), ('90111',244), ('90113',244), ('90116',244), ('90156',4664), ('90213',4664), ('0891029',94), ('09001041',94), ('0900302',94), ('0900333',94), ('0900338',94), ('0900360',94), ('0902079',94), ('0902104',94), ('0902161',94), ('0902367',94), ('0903040',94), ('0903072',94), ('0903235',94), ('0905003',94), ('0905025',94), ('0905175',94), ('0906041',94), ('0906352',94), ('0907017',94), ('0912024',94), ('WM2025',94), ('3141362102',144), ('7145000006',144), ('7148000016',144), ('7148000030',144), ('7148100000',144), ('7148120007',144), ('7148210003',144), ('ABEU037',4705), ('ABUS034',4705), ('ABUS042',4705), ('CSE105',4705), ('CSE107',4705), ('CSU001',4705), ('CSU005',4705), ('CSU089',4705), ('IACV003',4705), ('MAF008S',4705), ('MSU004',4705), ('FDWB11187',134), ('LVAB196',4564), ('LVAB376',4564), ('LVAB486',4564), ('LVAB683',4564), ('LVBW1020',4564), ('LVCP103',4564), ('LVCP144',4564), ('LVCP249',4564), ('LVCT401',4564), ('LVCT438',4564), ('LVEP153',4564), ('LVIS118',4564), ('LVKN221',4564), ('LVMA156',4564), ('LVPA249',4564), ('LVRC229',4564), ('LVRL104',4564), ('VBK1020',4564), ('VCT138',4564), ('VRC130',4564), ('1CS146',388), ('1CS503',388), ('1KR179',388), ('1KR569',388), ('1MF737',388), ('ASB1977',6874), ('4001',320), ('4051',320), ('4065',320), ('4152',320), ('7050',320), ('70512',320), ('70010014',4653), ('97990132',4653), ('97990440',4653), ('97990442',4653), ('97990445',4653), ('NBK1001',190), ('81075',15), ('94153',15), ('95860',15), ('J5653016',248), ('N5620503',248), ('N5623016',248), ('292531',127), ('292532',127), ('292543',127), ('292544',127), ('752532',127), ('DMA0220',440), ('KH20039',4728), ('ECMFR002',6355), ('ECPFR000',6355), ('ECPFR001',6355), ('ECPFR003',6355), ('ECPFR005',6355), ('EPPFR001',6355), ('HCAFR025',6355), ('HCAFR029',6355), ('HCAFR034',6355), ('HCAFR035',6355), ('KLPFR032',6355), ('KLPFR032Z',6355), ('HBK504202',378), ('04P302',129), ('06S086',129), ('06S176',129), ('06S253',129), ('06S425',129), ('07S051',129), ('07S054',129), ('08S008',129), ('08S024',129), ('301185',129), ('00295',4683), ('02057',4683), ('03377',4683), ('10851',4683), ('11172',4683), ('13865',4683), ('16812',4683), ('16902',4683), ('19169',4683), ('24744',4683), ('28278',4683), ('30931',4683), ('31501',4683), ('32300',4683), ('37275',4683), ('37311',4683), ('PTA3210133',6457), ('PTA5600233',6457), ('PTA5600296',6457), ('PTA5600300',6457), ('PTA5600304',6457), ('PTA5600309',6457), ('ABS52098',4558), ('ABS52153',4558), ('PBK3588',4558), ('PBK3588H',4558), ('PE13050',4558), ('PE40026',4558), ('PFA20018',4558), ('PFA20019',4558), ('86110090',4543), ('25013588',4686), ('QF10D00064',4339), ('QF25A00031',4339), ('QF25A00078',4339), ('QF60F00072',4339), ('QF86A00093',4339), ('QF86A00107',4339), ('QF91A00003',4339), ('QF91A00059',4339), ('QF93A00017',4339), ('QM809',57), ('QM875',57), ('QWB1258',57), ('XABS228',57), ('XABS341',57), ('XABS506',57), ('XABS508',57), ('XABS514',57), ('XEMS3',57), ('XEMS62',57), ('XICV29',57), ('XKS51',57), ('XMAP529',57), ('XREV203',57), ('XREV260',57), ('XREV288',57), ('XREV315',57), ('XREV438',57), ('XREV544',57), ('XRLS216',57), ('RKB1977',4330), ('3921K0044',6358), ('3926A0043',6358), ('3946S0033',6358), ('3946S0047',6358), ('3946S0087',6358), ('412W0394',6358), ('412W0504',6358), ('412W0509',6358), ('654W0150',6358), ('830C0018',6358), ('830C0051',6358), ('833C0013',6358), ('833C0206',6358), ('5260',23), ('0963710',4623), ('3250015',260), ('E614131',6377), ('WB35106',6377), ('CC52',263), ('CP101',263), ('CP165',263), ('CP33',263), ('MAP46',263), ('3234237',27), ('38813',27), ('38813A2',27), ('38847',27), ('460163',27), ('82333',27), ('82557',27), ('82582',27), ('83022',27), ('83051',27), ('83209',27), ('83209A2',27), ('83229',27), ('83445',27), ('84042',27), ('84240',27), ('84240A2',27), ('84687',27), ('84691',27), ('84693',27), ('84694',27), ('VKBA3588',50), ('ASB15219',110), ('R15260',110), ('SKAS0150042',6357), ('SKCPS0360012',6357), ('SKCPS0360207',6357), ('SKCTS0850017',6357), ('SKCTS0850050',6357), ('SKKS0400044',6357), ('SKSPS0370033',6357), ('SKSPS0370087',6357), ('SKWB0180155',6357), ('SKWSS0350394',6357), ('SKWSS0350504',6357), ('SKWSS0350509',6357), ('T490156',4667), ('T490213',4667), ('0600020SX',4595), ('0600153SX',4595), ('0600193SX',4595), ('0603038SX',4595), ('0604071SX',4595), ('0604133SX',4595), ('0612539SX',4595), ('4030044SX',4595), ('4328050SX',4595), ('4328350SX',4595), ('390074',6691), ('33102373',151), ('37933770',151), ('40917695',151), ('50101635',151), ('50103399',151), ('50106026',151), ('50106812',151), ('50922805',151), ('50924841',151), ('50924866',151), ('50924880',151), ('81FD0206',4758), ('KR296',6312), ('202328',301), ('302394',301), ('302647',301), ('302648',301), ('302651',301), ('302653',301), ('302657',301), ('302724',301), ('302802',301), ('304069',301), ('304833',301), ('304860',301), ('304879',301), ('304990',301), ('304991',301), ('WB1677',4732), ('430303',4970), ('908501',4970), ('908945',4970), ('818016145',108), ('818016223',108), ('818016237',108), ('818016246',108), ('853016132',108), ('862610014',108), ('881216101',108), ('881228101',108), ('882416010',108), ('885516101',108), ('885516102',108), ('885516105',108), ('885516107',108), ('886516102',108), ('0840042',209), ('02A945413C',4999), ('13621284397',4999), ('13621357414',4999), ('V251841',183), ('V259695',183), ('253800',21), ('254007',21), ('366282',21), ('366423',21), ('700019',21), ('VE52211',4425), ('V20720443',183), ('V20720454',183), ('V25720004',183), ('V25720034',183), ('V25720037',183), ('V25720062',183), ('V25720206',183), ('V25720207',183), ('V25721049',183), ('V25721059',183), ('V257210591',183), ('V25721069',183), ('V25721075',183), ('V25721076',183), ('V25721086',183), ('V25721171',183), ('V25730008',183), ('V32720003',183), ('V40720322',183), ('98450000101',4346), ('99190080601',4346), ('99191783001',4346), ('MAF10254',4627), ('MAF10255',4627), ('2351027',303), ('2351067',303), ('2351499',303), ('2352155',303), ('2421063',303), ('2451480',303), ('330870412',4275), ('330880041',4275), ('330880103',4275), ('410570106',4275), ('410570148',4275), ('410570335',4275), ('410570387',4275), ('410570473',4275), ('410570990',4275), ('410580016',4275), ('410580055',4275), ('410580197',4275), ('410590051',4275), ('410590305',4275), ('411140109',4275), ('411140124',4275), ('411140126',4275), ('411140130',4275), ('411790036',4275), ('461640047',4275), ('WG1013617',4832), ('WG1013634',4832), ('WG1014205',4832), ('WG1014227',4832), ('WG1014780',4832), ('WG1014911',4832), ('WG1026690',4832), ('WG1054658',4832), ('WG1407289',4832), ('WG1407347',4832), ('WG1408172',4832), ('WG1408329',4832), ('WG1408408',4832), ('WG1409616',4832), ('WG1409629',4832), ('WG1409631',4832), ('WG1409634',4832), ('WG1429634',4832), ('WG1430314',4832), ('WG1430316',4832), ('WG1430317',4832), ('WG1445352',4832), ('WG1492418',4832), ('WG1492435',4832), ('WG1493189',4832), ('WG1493190',4832), ('WG1493191',4832), ('WG1493314',4832), ('WG1493360',4832), ('WG1493371',4832), ('WG1493524',4832), ('WG1493525',4832), ('WG1493544',4832), ('WG1495138',4832), ('WG1495510',4832), ('WG1495515',4832), ('WG1498102',4832), ('WG1498103',4832), ('WG1499432',4832), ('WG1499504',4832), ('WG1499564',4832), ('WG1499575',4832), ('WG1499607',4832), ('WG1735801',4832), ('WG1755912',4832), ('WG1770291',4832), ('WG1773936',4832), ('WG1774002',4832), ('WG1774067',4832), ('WG1791673',4832), ('WG1791726',4832), ('WG1791729',4832), ('WG1796444',4832), ('WG1804691',4832), ('WG1889937',4832), ('WG1899074',4832), ('WG1945839',4832), ('WG1964804',4832), ('WG1965149',4832), ('WG2013775',4832), ('WG2015432',4832), ('WG2015435',4832), ('WG2033083',4832), ('WG2033144',4832), ('WG2101568',4832), ('WG2151271',4832), ('WG2151466',4832), ('11127',6347), ('230147',6347), ('320417',6347), ('320421',6347), ('320995',6347), ('550093',6347), ('660107',6347), ('RL1500',4894), ('WEKR0373',6274), ('ZVDA008',6274), ('ZVLF189',6274), ('ZVPK179',6274), ('TSE12',382), ('0280130023',30), ('0280130068',30), ('70610300',72), ('S70630303',72) ) 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.