SELECT DISTINCT 
    m.manufacturerName AS cross_brand, 
    ao.oemSearch, 
    ao.oemnumber, 
    ps_sub.id AS id
FROM (
    
    VALUES 
        ('38475,205), ('380013,205), ('KTT040069,4466), ('130531,4654), ('130531R,4654), ('130532,4654), ('130532R,4654), ('130534,4654), ('130534R,4654), ('130553,4654), ('130553R,4654), ('130605,4654), ('130605R,4654), ('130638,4654), ('130638R,4654), ('133099,4654), ('133099G,4654), ('133112,4654), ('133112G,4654), ('133181,4654), ('133181R,4654), ('57744,422), ('67113,422), ('67190,422), ('68190A,422), ('68232A,422), ('77590,422), ('78590,422), ('78590A,422), ('100072,4381), ('100074,4381), ('100076,4381), ('100087,4381), ('100088,4381), ('100089,4381), ('100151,4381), ('100466,4381), ('100618,4381), ('100785,4381), ('100812,4381), ('100837,4381), ('100849,4381), ('103364,4381), ('850517N,80), ('850708N,80), ('850898N,80), ('850914N,80), ('851042N,80), ('851356N,80), ('851859N,80), ('851861N,80), ('851863N,80), ('852966N,80), ('853105N,80), ('855005N,80), ('10550074,479), ('10550076,479), ('10550087,479), ('10550088,479), ('10550151,479), ('10550618,479), ('CMP2020132,257), ('40405097,4656), ('40405128,4656), ('40405128DV,4656), ('40405335,4656), ('40420017,4656), ('40420026,4656), ('40420033,4656), ('108019,4688), ('108043,4688), ('108135,4688), ('108586,4688), ('108907,4688), ('OLAK139,247), ('OLAK319,247), ('OLAK358,247), ('OLAK373,247), ('OLAK389,247), ('OLAK477,247), ('OLK139,247), ('OLK287,247), ('OLK319,247), ('OLK350,247), ('OLK358,247), ('OLK373,247), ('OLK389,247), ('OLK464,247), ('OLK466,247), ('OLK477,247), ('8600114,393), ('8600115,393), ('8600120,393), ('8600185,393), ('8600186,393), ('8600187,393), ('8600257,393), ('8600259,393), ('8600260,393), ('1201112,4553), ('1201130,4553), ('1201135,4553), ('1201136,4553), ('1201136X,4553), ('1201137,4553), ('1201230,4553), ('1201230X,4553), ('1201231,4553), ('CS20435,89), ('CS20635,89), ('TSP0155056,89), ('TSP0155249,89), ('TSP0155270,89), ('TSP0155428,89), ('TSP0155429,89), ('TSP0155439,89), ('TSP0155452,89), ('TSP0155875,89), ('TSP0159249,89), ('TSP0159270,89), ('TSP0159428,89), ('DCK1381,253), ('DCK1388,253), ('DCK1396,253), ('DCK1399,253), ('DCK1400,253), ('DCK1402,253), ('DCK1403,253), ('DCK1419,253), ('DCK1421,253), ('ARC090CTRN,4882), ('ARC090DLPN,4882), ('ARC145HLLN,4882), ('700510106,460), ('700510239,460), ('700510248,460), ('700510291,460), ('700510428,460), ('700510486,460), ('510106,226), ('510239,226), ('510248,226), ('510291,226), ('510428,226), ('510486,226), ('670032,234), ('671000,234), ('671005,234), ('671007,234), ('671049,234), ('671120,234), ('671156,234), ('671174,234), ('AC35444,224), ('AC35490,224), ('AC35492,224), ('AC35951,224), ('AC35954,224), ('AC35957,224), ('AC50932,224), ('AC51236,224), ('AC51570,224), ('11243,441), ('11243A,441), ('11249,441), ('11249A,441), ('11252,441), ('11252R,441), ('11261,441), ('11442,441), ('11442A,441), ('14055,441), ('14055A,441), ('14070,441), ('14070A,441), ('92010923,313), ('92020065,313), ('93010923,313), ('93020065,313), ('94010923,313), ('94020065,313), ('240040,4819), ('240041,4819), ('240884,4819), ('241005,4819), ('241515,4819), ('8FK351127761,4734), ('8FK351134361,4734), ('8FK351135021,4734), ('8FK351135511,4734), ('8FK351135521,4734), ('8FK351316401,4734), ('8FK351316901,4734), ('8FK351334151,4734), ('8FK351334821,4734), ('K11243,341), ('K11243A,341), ('K11249,341), ('K11249A,341), ('K11252,341), ('K11252R,341), ('K11261,341), ('K11442,341), ('K11442A,341), ('K14055,341), ('K14055A,341), ('K14070,341), ('K14070A,341), ('CMP2020132,156), ('CMP2020132,481), ('11243,4399), ('11243A,4399), ('11249,4399), ('11249A,4399), ('11252,4399), ('11252R,4399), ('11261,4399), ('11442,4399), ('11442A,4399), ('14055,4399), ('14055A,4399), ('14070,4399), ('14070A,4399), ('220137,6012), ('220190,6012), ('220199,6012), ('220568,6012), ('220575,6012), ('221120,6012), ('710617013,292), ('711040011,292), ('711040023,292), ('810617005,292), ('810617013,292), ('811038001,292), ('811040005,292), ('811040010,292), ('811040011,292), ('811040023,292), ('ACP205,4501), ('ACP338,4501), ('ACP347,4501), ('ACP390,4501), ('ACP527,4501), ('ACP585,4501), ('ACP107000S,287), ('ACP1107000S,287), ('ACP1115000S,287), ('ACP1276000P,287), ('ACP1276000S,287), ('ACP1340000P,287), ('ACP16000P,287), ('ACP16000S,287), ('ACP370000S,287), ('ACP83000P,287), ('ACP83000S,287), ('AC130016,403), ('AC168497,403), ('AC322422,403), ('K11243,244), ('K11243A,244), ('K11249,244), ('K11249A,244), ('K11252,244), ('K11252R,244), ('K11261,244), ('K11442,244), ('K11442A,244), ('K14055,244), ('K14055A,244), ('K14070,244), ('K14070A,244), ('890388,123), ('89042,123), ('89095,123), ('89196,123), ('89322,123), ('32172,205), ('32172G,205), ('32197,205), ('32230,205), ('32230G,205), ('32232,205), ('7010164,4543), ('7010240,4543), ('7010586,4543), ('7011019,4543), ('OLAK139,340), ('OLAK319,340), ('OLAK358,340), ('OLAK373,340), ('OLAK477,340), ('OLK139,340), ('OLK287,340), ('OLK319,340), ('OLK350,340), ('OLK358,340), ('OLK373,340), ('OLK389,340), ('OLK464,340), ('OLK466,340), ('OLK477,340), ('RCA930136574,492), ('50500106,4534), ('50500241,4534), ('50500250,4534), ('50500293,4534), ('50500430,4534), ('50500488,4534), ('447K0071,6358), ('11243,27), ('11243A,27), ('11249,27), ('11249A,27), ('11252,27), ('11252R,27), ('11261,27), ('11442,27), ('11442A,27), ('14055,27), ('14055A,27), ('14070,27), ('14070A,27), ('SKKM0340071,6357), ('AC35490N,6480), ('AC35954N,6480), ('AC35957N,6480), ('KTT030001,4466), ('KTT030002,4466), ('KTT030007,4466), ('AC00106,4830), ('AC00241,4830), ('AC00250,4830), ('AC00293,4830), ('AC00430,4830), ('AC00488,4830), ('699306,21), ('699308,21), ('699367,21), ('699399,21), ('699400,21), ('699749,21), ('699806,21), ('699870,21), ('699895,21), ('699900,21), ('813626,21), ('3700K287,36), ('3700K316,36), ('3700K358,36), ('3700K373,36), ('3700K377,36), ('3700K389,36), ('3700K464,36), ('3700K477,36), ('V40150028,183), ('V40151005,183), ('V40151031,183), ('V40152026,183), ('V40771002,183), ('V40771003,183), ('8880100138,97), ('8880100141,97), ('8880100254,97), ('K11243A,4275), ('K11249,4275), ('K11249A,4275), ('K11252,4275), ('K11252R,4275), ('K11261,4275), ('K11442,4275), ('K11442A,4275), ('K14055A,4275), ('K14070A,4275), ('WG2017106,4832), ('WG2041301,4832), ('WG2041304,4832), ('WG2041375,4832), ('WG2041377,4832), ('WG2041404,4832), ('WG2159186,4832), ('WG2159187,4832), ('WG2159201,4832), ('WG2159241,4832), ('WG2159242,4832), ('WG2159244,4832), ('OLK377,340), ('8600264,393), ('67114,422), ('68113A,422), ('68114A,422), ('97967,422), ('699808,21), ('851445N,80), ('851586N,80), ('851507N,80), ('852961N,80), ('TSP0155133,89), ('510155,226), ('510302,226), ('OLK377,247)
        
) 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.