SELECT DISTINCT 
    m.manufacturerName AS cross_brand, 
    ao.oemSearch, 
    ao.oemnumber, 
    ps_sub.id AS id
FROM (
    
    VALUES 
        ('717040',10), ('101965',101), ('102142',101), ('105888',101), ('107825',101), ('107830',101), ('109100',101), ('EG363HD448',81), ('FT063',156), ('JT537',4378), ('JT474K',4378), ('JT505K',4378), ('LT1004',4600), ('LT1039',4600), ('21090',244), ('21067',4664), ('1001360009',144), ('1001370003',144), ('1001370009',144), ('1001371003',144), ('1001371004',144), ('17798',4683), ('30102142',151), ('0725013',209), ('33251783401',4346), ('33251784001',4346), ('54512',6558), ('57372',6558), ('57373',6558), ('57374',6558), ('57377',6558), ('X1578058',4975), ('X1578062',4975), ('X1578063',4975), ('X1578137',4975), ('FTA056',257), ('FTA058',257), ('FTA062',257), ('FTA063',257), ('FTA137',257), ('FMVW00111',4972), ('FMVW00112',4972), ('FMZF00161',4972), ('FMZF00162',4972), ('FMZF00171',4972), ('FMZF00172',4972), ('FMZF00251',4972), ('FMZF00252',4972), ('180055210',323), ('180055510',323), ('TA1317K',4280), ('TA1321K',4280), ('TA1321KPLUS',4280), ('0011019662',4995), ('0011021941',4995), ('ADBP210005',350), ('ADBP210048',350), ('ADBP640001',350), ('ADV182146',350), ('ADV182151',350), ('ADV182169',350), ('ADV182170',350), ('ADV182173',350), ('ADV182174',350), ('751204',405), ('751205',405), ('751223',405), ('766909',405), ('AC01002',4396), ('AC01007',4396), ('DP1110140007',4948), ('DP1110140022',4948), ('357310',10), ('451350',10), ('451351',10), ('105812',101), ('171640',101), ('171641',101), ('171783',101), ('56092AS',441), ('57041AS',441), ('57053AS',441), ('57054AS',441), ('57054BAS',441), ('57092AS',441), ('57092BAS',441), ('SHB62407',6309), ('SHB62408',6309), ('SHB62491',6309), ('21090',341), ('KIT21041',341), ('KIT21053',341), ('KIT21054',341), ('KIT21054B',341), ('KIT21092',341), ('FT056',156), ('FT058',156), ('FT062',156), ('FT137',156), ('FTJ056',481), ('FTJ058',481), ('FTJ062',481), ('FTJ063',481), ('FTJ137',481), ('F602601',185), ('F602701',185), ('HX185D',287), ('HX186D',287), ('HX189KIT',287), ('LT1100',4600), ('LT1180',4600), ('69025',133), ('MFT9001',6270), ('261492',403), ('261668',403), ('261670',403), ('MTF3FO07',4773), ('MTF3VW17',4773), ('MTF3VW20',4773), ('KIT21041',244), ('KIT21053',244), ('KIT21054',244), ('KIT21054B',244), ('KIT21092',244), ('21068',4664), ('21108',4664), ('38831',4664), ('7990104',94), ('8020024',94), ('8020039',94), ('8020089',94), ('8020090',94), ('8020095',94), ('8020097',94), ('1001350005',144), ('1001350005SK',144), ('1001350013',144), ('1001350114',144), ('1001360006',144), ('1001370006',144), ('1001390004',144), ('1001400002',144), ('1001400003',144), ('12982',4683), ('17800',4683), ('27113',4683), ('PG30049',4558), ('P120014',6339), ('P120024',6339), ('P120025',6339), ('P120031',6339), ('P120055',6339), ('P120056',6339), ('P120094',6339), ('P120102',6339), ('SG1095',225), ('SG1097',225), ('56092AS',27), ('57041AS',27), ('57053AS',27), ('57054AS',27), ('57054BAS',27), ('57092AS',27), ('57092BAS',27), ('T421067',4667), ('T421068',4667), ('T421108',4667), ('T438831',4667), ('2051055SX',4595), ('2051099SX',4595), ('30101965',151), ('30105812',151), ('30105888',151), ('30107825',151), ('30107830',151), ('30109100',151), ('33101054',151), ('1051060011',4342), ('1051061011',4342), ('1051062011',4342), ('1051110016',4342), ('1051110017',4342), ('1051110025',4342), ('1051111016',4342), ('1051111017',4342), ('1051111025',4342), ('1051112016',4342), ('1051112017',4342), ('1051112025',4342), ('AT110',4011), ('AT1161',4011), ('113395',301), ('113727',301), ('113728',301), ('113743',301), ('114659',301), ('115873',301), ('V101866',183), ('V101867',183), ('V1018671',183), ('V101868',183), ('V1018681',183), ('V102219',183), ('V102220',183), ('V102221',183), ('V102289',183), ('V103016',183), ('V1030161',183), ('V103018',183), ('V1030181',183), ('V103216',183), ('V103216BEK',183), ('V103220',183), ('V103220BEK',183), ('V103220XXL',183), ('V103225',183), ('V103225BEK',183), ('V103225XXL',183), ('V103229',183), ('V103229BEK',183), ('V105361',183), ('V106577',183), ('711231600',9), ('33211637301',4346), ('33980000101',4346), ('21090',4275), ('KIT21041',4275), ('KIT21053',4275), ('KIT21054',4275), ('KIT21054B',4275), ('KIT21092',4275), ('WG1791416',4832), ('WG1836563',4832), ('WG1966615',4832), ('WG2029756',4832), ('WG2029758',4832), ('WG2029878',4832), ('WG2029943',4832), ('WG2029984',4832), ('WG2099409',4832), ('WG2099934',4832), ('WG2099945',4832), ('WG2099946',4832), ('WG2099947',4832), ('WG2099958',4832), ('WG2112066',4832), ('OF4429G',4894), ('1084298013',68), ('1084298014',68), ('1087298368',68), ('5961308373',68)
        
) 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.