SELECT DISTINCT 
    m.manufacturerName AS cross_brand, 
    ao.oemSearch, 
    ao.oemnumber, 
    ps_sub.id AS id
FROM (
    
    VALUES 
        ('29602',101), ('04461',4664), ('04462',4664), ('04467',4664), ('04468',4664), ('04469',4664), ('04587',4664), ('04588',4664), ('05216',4664), ('05653',4664), ('PSE3828',4558), ('2704006',260), ('2704080',260), ('4001833',260), ('60929602',151), ('40674',4598), ('40675',4598), ('40689',4598), ('40690',4598), ('40695',4598), ('40697',4598), ('41611',4598), ('41612',4598), ('18410',317), ('184101',317), ('184102',317), ('184103',317), ('184104',317), ('18411',317), ('184112',317), ('18412',317), ('184121',317), ('18413',317), ('18856',317), ('188561',317), ('56088',4576), ('76533',4576), ('76633',4576), ('2412LAHRR',4631), ('130076910',323), ('130078010',323), ('130080110',323), ('130080210',323), ('130081810',323), ('130081910',323), ('0011028462',4995), ('0011028463',4995), ('0011028518',4995), ('0011028548',4995), ('0011028549',4995), ('0011028553',4995), ('0011028787',4995), ('046646B',49), ('046648B',49), ('046651B',49), ('046652B',49), ('046941B',49), ('MT7369',478), ('MT8164',478), ('MT9129',478), ('MT9544',478), ('MT9774',478), ('51206',208), ('51425',208), ('51426',208), ('51427',208), ('51428',208), ('51430',208), ('51431',208), ('51658',208), ('51885',208), ('BEM3830',475), ('BEM3957',475), ('BEM3958',475), ('BEM3959',475), ('BEM3960',475), ('BEM3961',475), ('BEM3965',475), ('BEM4054',475), ('BEM4058',475), ('020441',405), ('020445',405), ('020447',405), ('021057',405), ('021058',405), ('021164',405), ('021395',405), ('756127',405), ('756195',405), ('756562',405), ('756563',405), ('782000002',6411), ('782000003',6411), ('782000010',6411), ('782000016',6411), ('782000017',6411), ('782000514',6411), ('782000515',6411), ('782052026',6411), ('782052028',6411), ('782302003',6411), ('80000716',140), ('80001305',140), ('80001342',140), ('80001381',140), ('80001531',140), ('80001554',140), ('80005081',140), ('TEM079',89), ('TEM108',89), ('A1058',4396), ('A1090',4396), ('A1175',4396), ('A1213',4396), ('A1338',4396), ('A1341',4396), ('7122570',4135), ('7122571',4135), ('7122572',4135), ('7122573',4135), ('7122623',4135), ('7222622',4135), ('22EM097',4003), ('22SB087',4003), ('22ST615',4003), ('22ST634',4003), ('22ST635',4003), ('22ST674',4003), ('22ST675',4003), ('22TM087',4003), ('22TM675',4003), ('10138',4834), ('13492',4834), ('4044',4834), ('4045',4834), ('4046',4834), ('4391',4834), ('4393',4834), ('4751',4834), ('4974',4834), ('5289',4834), ('5291',4834), ('5300',4834), ('174985',101), ('22077',101), ('22128',101), ('24270',101), ('29601',101), ('29663',101), ('44555',101), ('FEM3830',407), ('FEM3957',407), ('FEM3958',407), ('FEM3959',407), ('FEM3960',407), ('FEM3961',407), ('FEM3965',407), ('FEM4054',407), ('FEM4058',407), ('FZ90634',4467), ('FZ90642',4467), ('FZ90643',4467), ('FZ91133',4467), ('FZ91377',4467), ('EM0116',6443), ('EM0279',6443), ('EM0296',6443), ('EM0297',6443), ('EM0378',6443), ('EM0428',6443), ('EM0599',6443), ('EM0635',6443), ('511508',373), ('532A10',239), ('532A51',239), ('532C08',239), ('532C09',239), ('538886',239), ('538907',239), ('586349',239), ('586350',239), ('4317901800',268), ('890078',185), ('1495240',4546), ('1495272',4546), ('1495280',4546), ('3649001',35), ('3746001',35), ('ME2281',4600), ('ME2282',4600), ('ME2287',4600), ('ME2288',4600), ('ME2309',4600), ('030607010779',4723), ('030607010781',4723), ('36181',133), ('36185',133), ('36193',133), ('36194',133), ('37110',133), ('400087',403), ('400221',403), ('400222',403), ('400263',403), ('400266',403), ('400279',403), ('400563',403), ('MRP2B03',4773), ('05647',4664), ('06155',4664), ('16140300018',144), ('16140300020',144), ('16140300028',144), ('16140300049',144), ('16140300051',144), ('59739032',127), ('59739057',127), ('59739061',127), ('59739066',127), ('59739082',127), ('ZPSRE046',6355), ('ZPSRE048',6355), ('ZPSRE060',6355), ('ZPSRE062',6355), ('ZPSRE063',6355), ('1225439',198), ('1225446',198), ('1225459',198), ('1225896',198), ('1225982',198), ('1226145',198), ('1226150',198), ('1226151',198), ('1226153',198), ('F86666',129), ('F86668',129), ('F86671',129), ('F86672',129), ('F87009',129), ('31609',331), ('36515',331), ('36522',331), ('36524',331), ('36553',331), ('36554',331), ('36555',331), ('36556',331), ('36557',331), ('36796',331), ('36803',331), ('36830',331), ('40047',4683), ('PSE11737',4558), ('PSE30283',4558), ('PSE30284',4558), ('PSE30504',4558), ('PSE30523',4558), ('PSE30524',4558), ('PCM194',4655), ('PCM198',4655), ('PCM426',4655), ('PCM548',4655), ('PCM549',4655), ('EM4299',57), ('EM4300',57), ('EM4301',57), ('EM4302',57), ('EM4303',57), ('EM4305',57), ('EM4306',57), ('EM4402',57), ('EM4403',57), ('EM4549',57), ('EM4650',57), ('EM4651',57), ('R51506',4303), ('R51931',4303), ('R52100',4303), ('R52101',4303), ('R52102',4303), ('R52103',4303), ('R52104',4303), ('R52107',4303), ('R52107B',4303), ('R59871',4303), ('R59872',4303), ('RH112033',6892), ('RH112039',6892), ('RH112068',6892), ('RH112163',6892), ('RH122002',6892), ('325537',23), ('325548',23), ('325558',23), ('325565',23), ('2704119',260), ('4001778',260), ('4001779',260), ('4001782',260), ('4001786',260), ('4001787',260), ('4001817',260), ('4001832',260), ('4003386',260), ('4003388',260), ('T404461',4667), ('T404462',4667), ('T404467',4667), ('T404468',4667), ('T404469',4667), ('T404587',4667), ('T404588',4667), ('T405216',4667), ('T405647',4667), ('T405653',4667), ('T406155',4667), ('2518240SX',4595), ('2518247SX',4595), ('2519782SX',4595), ('7111407SX',4595), ('33102607',151), ('60922077',151), ('60922128',151), ('60924270',151), ('60929601',151), ('60929663',151), ('60944555',151), ('4910840',4758), ('6105193',4758), ('6105194',4758), ('6105195',4758), ('6105196',4758), ('6105246',4758), ('6205245',4758), ('00583025',4593), ('TED36940',4593), ('634409',301), ('700808',301), ('700815',301), ('700821',301), ('701726',301), ('365477',4970), ('365478',4970), ('365479',4970), ('365525',4970), ('365598',4970), ('365629',4970), ('365644',4970), ('10810',6311), ('10824',6311), ('10825',6311), ('10826',6311), ('10829',6311), ('10840',6311), ('10843',6311), ('396759',4730), ('396760',4730), ('396778',4730), ('396796',4730), ('396797',4730), ('396798',4730), ('397756',4730), ('397757',4730), ('397759',4730), ('V460351',183), ('V460353',183), ('V460354',183), ('V460355',183), ('V460369',183), ('V460676',183), ('V460879',183), ('VE51206',4425), ('VE51425',4425), ('VE51426',4425), ('VE51427',4425), ('VE51428',4425), ('VE51430',4425), ('VE51431',4425), ('VE51658',4425), ('WG1233633',4832), ('WG1234018',4832), ('WG1234036',4832), ('WG1234112',4832), ('WG1234124',4832), ('WG1393155',4832), ('WG1393157',4832), ('WG1393165',4832), ('WG1393186',4832), ('WG1393187',4832), ('WG1393188',4832), ('WG1393261',4832), ('WG1755656',4832), ('WG1755765',4832), ('WG1977957',4832), ('WG1977985',4832), ('532A08',239), ('538472',239), ('538471',239), ('538600',239), ('586257',239)
        
) 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.