SELECT DISTINCT 
    m.manufacturerName AS cross_brand, 
    ao.oemSearch, 
    ao.oemnumber, 
    ps_sub.id AS id
FROM (
    
    VALUES 
        ('D3196',351), ('D3286',351), ('320009',380), ('PRK114',4558), ('81053655',108), ('C50504ABE',4426), ('C5C005ABE',4426), ('C5G017ABE',4426), ('C5P021ABE',4426), ('C5P036ABE',4426), ('C5P040ABE',4426), ('C5P041ABE',4426), ('2344',206), ('2572',206), ('2805',206), ('2853',206), ('AY001',4951), ('89556',317), ('89560',317), ('89561',317), ('89688',317), ('89693',317), ('90119',317), ('90122',317), ('90134',317), ('90150',317), ('BCY1036',4537), ('BCY1103',4537), ('BCY1156',4537), ('BCY1179',4537), ('BCY1180',4537), ('BCY1184',4537), ('BCY1188',4537), ('BCY1234',4537), ('BCY1323',4537), ('BCY1351',4537), ('BCY1357',4537), ('BCY1525',4537), ('BCY1526',4537), ('BWC8059',4537), ('BWC8066',4537), ('BWC8077',4537), ('BWC8087',4537), ('71432',4576), ('79498',4576), ('6705572',257), ('6705573',257), ('6705597',257), ('6705599',257), ('24322011113',3), ('24322011133',3), ('24322016153',3), ('24322016163',3), ('24322016193',3), ('24322017113',3), ('24322017173',3), ('CPDCIT403',6531), ('CPDFOR411',6531), ('D3073',351), ('D3080',351), ('D3278',351), ('D3289',351), ('D3431',351), ('120048310',323), ('290CL00024',6271), ('290CL00025',6271), ('290CL00029',6271), ('290CL00031',6271), ('290CR00024',6271), ('290CR00025',6271), ('290CR00027',6271), ('290CR00029',6271), ('290CR00031',6271), ('290CR00100',6271), ('290CR00254',6271), ('290CR00297',6271), ('BAW2001',394), ('ADG04406',350), ('ADG04407',350), ('ADG04408',350), ('BBW1128',475), ('BBW1276',475), ('BBW1333',475), ('BBW1334',475), ('BBW1456',475), ('BBW1678',475), ('0986475428',30), ('0986475635',30), ('0986475636',30), ('0986475732',30), ('0986475733',30), ('0986475750',30), ('0986475797',30), ('0986475833',30), ('0986475839',30), ('AJ2047',4993), ('AJ2062',4993), ('AJ2078',4993), ('AJ2079',4993), ('AJ2110',4993), ('A12097',65), ('A12109',65), ('A12114',65), ('A12219',65), ('A12220',65), ('A12239',65), ('A12269',65), ('A12270',65), ('A12280',65), ('A12312',65), ('A12340',65), ('A12357',65), ('A12383',65), ('51693',4805), ('52523',4805), ('BSG70220006',4455), ('BSG70220007',4455), ('3357',243), ('3664',243), ('3759',243), ('3775',243), ('3798C',243), ('3799C',243), ('3876',243), ('4411',243), ('4850',243), ('101326',311), ('101365',311), ('101393',311), ('101437',311), ('101438',311), ('101605',311), ('101648',311), ('101658',311), ('101704',311), ('74402A0',6411), ('74402A1',6411), ('LW30005',89), ('LW30318',89), ('LW30412',89), ('LW30989',89), ('LW30990',89), ('LW31746',89), ('LW31747',89), ('LW36031',89), ('LW39036',89), ('LW60642',89), ('LW61064',89), ('N03080',4396), ('N03084',4396), ('N03085',4396), ('N03086',4396), ('N03093',4396), ('N03111',4396), ('N03302',4396), ('1070020052',4345), ('300142',4512), ('300146',4512), ('300244',4512), ('300353',4512), ('300425',4512), ('300531',4512), ('04097',101), ('09599',101), ('09600',101), ('09601',101), ('102712',101), ('108084',101), ('19624',101), ('22485',101), ('22486',101), ('K20048',271), ('K20102',271), ('K20103',271), ('K20131',271), ('K2048',271), ('K2068',271), ('K2085',271), ('K2086',271), ('FHW054',62), ('FHW091',62), ('FHW092',62), ('FHW100',62), ('FHW195',62), ('FHW219',62), ('FHW220',62), ('FHW222',62), ('FHW358',62), ('FHW4242',62), ('FHW4256',62), ('320015',380), ('320020',380), ('320035',380), ('322010',380), ('CF042',295), ('CF043',295), ('CF096',295), ('CF104',295), ('CF123',295), ('CF159',295), ('CF162',295), ('CF472',295), ('CF538',295), ('R200004A1',54), ('R200013A1',54), ('R20013A1',54), ('R20052A1',54), ('R20053A1',54), ('R20060A1',54), ('R20061A1',54), ('R20062A1',54), ('R2099B1',54), ('5005117',279), ('5005118',279), ('5005119',279), ('5005122',279), ('5005129',279), ('5005130',279), ('5005132',279), ('5005191',279), ('5005247',279), ('5005252',279), ('5005290',279), ('5005308',279), ('5005366',279), ('8AW355530011',4734), ('8AW355530021',4734), ('8AW355530911',4734), ('8AW355530921',4734), ('8AW355532071',4734), ('8AW355532091',4734), ('8AW355532491',4734), ('8AW355532681',4734), ('8AW355532991',4734), ('70307011',6359), ('70307040',6359), ('CS572',156), ('CS573',156), ('CS597',156), ('CS599',156), ('67572',481), ('67573',481), ('67597',481), ('67599',481), ('1561301700',268), ('4161301000',268), ('4161301100',268), ('4161301200',268), ('4161301800',268), ('211848J',49), ('212223J',49), ('212322J',49), ('251042J',49), ('251043J',49), ('251064J',49), ('WC20016',6911), ('WCY004',4461), ('WCY014',4461), ('W4180',286), ('W4213',286), ('W4243',286), ('W4552',286), ('W4625',286), ('W4668',286), ('W4690',286), ('W4824',286), ('W4874',286), ('W4875',286), ('W5003',286), ('W5004',286), ('W5524',286), ('6032060',4546), ('6035122',4546), ('6035320',4546), ('6035591',4546), ('6035592',4546), ('6035700',4546), ('6035975',4546), ('6036300',4546), ('6036305',4546), ('15031',35), ('21752',35), ('4180',283), ('4213',283), ('4243',283), ('4552',283), ('4625',283), ('4668',283), ('4690',283), ('4824',283), ('4874',283), ('4875',283), ('5003',283), ('5004',283), ('5524',283), ('360219230043',4723), ('360219230197',4723), ('360219230227',4723), ('360219230288',4723), ('360219230339',4723), ('360219230340',4723), ('360219230373',4723), ('360219230386',4723), ('2165',133), ('2366',133), ('2781',133), ('190014',403), ('190020',403), ('190024',403), ('190177',403), ('190178',403), ('190509',403), ('MWC2572',4773), ('MWC2597',4773), ('040326',121), ('040365',121), ('040393',121), ('040437',121), ('040438',121), ('040605',121), ('040648',121), ('040658',121), ('040704',121), ('101365',94), ('101437',94), ('101438',94), ('101605',94), ('101648',94), ('101704',94), ('11145310009',144), ('11145310010',144), ('11145310020',144), ('11145310024',144), ('11145330027',144), ('11145330028',144), ('11145330030',144), ('16145330027',144), ('VWC578',4564), ('VWC666',4564), ('VWC667',4564), ('VWC668',4564), ('VWC692',4564), ('VWC758',4564), ('J3230504',248), ('J3230505',248), ('801930',127), ('802561',127), ('803407',127), ('803409',127), ('803755',127), ('804808',127), ('804811',127), ('804812',127), ('809934',127), ('809949',127), ('809950',127), ('H323I03',440), ('H323I04',440), ('H323I13',440), ('FWC312600',378), ('FWC318900',378), ('FWC322400',378), ('FWC322800',378), ('FWC324700',378), ('FWC324800',378), ('FWC334800',378), ('28882',331), ('28893',331), ('11652',4683), ('11666',4683), ('26564',4683), ('PBC4552',4558), ('PBC4625',4558), ('PBC4690',4558), ('PBC4874',4558), ('PBC4875',4558), ('PRK116',4558), ('PRK123',4558), ('PRK142',4558), ('PRK153',4558), ('PRH2193',4520), ('PRH2425',4520), ('PRH2472',4520), ('PRH2479',4520), ('PRH2502',4520), ('PRH2503',4520), ('PRH2558',4520), ('PRH2661',4520), ('PRH2697',4520), ('QF11F00146',4339), ('0107',6304), ('BWC3210',57), ('BWC3552',57), ('BWC3556',57), ('BWC3602',57), ('BWC3605',57), ('BWC3606',57), ('BWC3683',57), ('BWC3698',57), ('10HY031',4869), ('10HY035',4869), ('277W0025',6358), ('277W0033',6358), ('C05158',343), ('C05913',343), ('C06699',343), ('C06701',343), ('C08592',343), ('C11317',343), ('C11795',343), ('C16356',343), ('C16394',343), ('C16395',343), ('C24062',343), ('C24868',343), ('C31087',343), ('4024A04',260), ('4024A14',260), ('SKWBC0680024',6357), ('SKWBC0680032',6357), ('0583031SX',4595), ('0583037SX',4595), ('0583047SX',4595), ('0583048SX',4595), ('0583306SX',4595), ('0583360SX',4595), ('0583386SX',4595), ('0583387SX',4595), ('0583502SX',4595), ('20904097',151), ('50919624',151), ('55922485',151), ('55922486',151), ('62108084',151), ('62909599',151), ('62909600',151), ('62909601',151), ('500503',301), ('720981',301), ('720982',301), ('720996',301), ('720997',301), ('813010033',108), ('813010034',108), ('813016052',108), ('813025043',108), ('813027004',108), ('813028016',108), ('813028045',108), ('813043003',108), ('813043006',108), ('CF042',199), ('CF043',199), ('CF096',199), ('CF104',199), ('CF123',199), ('CF159',199), ('CF162',199), ('CF472',199), ('CF538',199), ('BWF117',4501), ('BWF118',4501), ('BWF119',4501), ('BWF122',4501), ('BWF129',4501), ('BWF130',4501), ('BWF132',4501), ('BWF191',4501), ('BWF247',4501), ('BWF252',4501), ('BWF290',4501), ('BWF308',4501), ('BWF366',4501), ('350954',21), ('402017',21), ('402089',21), ('402090',21), ('402262',21), ('ZD1051',4894), ('67575',481), ('VWC411',4564), ('MWC2575',4773), ('813038017',108), ('813038020',108), ('801935',127), ('CS575',156), ('6705575',257), ('28688',331)
        
) 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.