SELECT DISTINCT 
    m.manufacturerName AS cross_brand, 
    ao.oemSearch, 
    ao.oemnumber, 
    ps_sub.id AS id
FROM (
    
    VALUES 
        ('1882ASTR,4674), ('WHB83260,271), ('9400058,373), ('01541,4683), ('01601,4683), ('04364,4683), ('RL1063,4894), ('200059,206), ('200062,206), ('911230,206), ('51443,6558), ('52514,6558), ('53908,6558), ('BN0107,4024), ('BN0107E,4024), ('1110290,317), ('10342863,479), ('10342955,479), ('620093,96), ('620177,96), ('32047,4576), ('71752,4576), ('98821,4576), ('600W005,257), ('PAL62044,442), ('PAL62049,442), ('CHRWH004,4631), ('OPWHASTR,4631), ('805460,300), ('805461,300), ('RS1008,4737), ('RS1009,4737), ('01020,4651), ('01021,4651), ('01873,4651), ('110155910,323), ('110167010,323), ('110186810,323), ('AWH1790,4337), ('290RD00061,6271), ('290RD00062,6271), ('RA4455,4464), ('RA4456,4464), ('050009B,49), ('050015B,49), ('3118,208), ('3317,208), ('3395,208), ('BBD4904,475), ('BWK410,475), ('BWK411,475), ('KRT2580,195), ('KRT2587,195), ('BSG65600003,4455), ('BSG65600004,4455), ('H2X001BTA,4693), ('H2X002BTA,4693), ('H5X002BTA,4693), ('520370,6549), ('RC4455,4463), ('RC4456,4463), ('481042,405), ('481046,405), ('764443,405), ('CHA058,421), ('CHA059,421), ('KWD1062,42), ('BK679,89), ('BK970,89), ('W413353,186), ('R3066,4396), ('R3067,4396), ('1060200079,4345), ('1060200080,4345), ('PCD12202,278), ('DP2010100481,4948), ('DP2010100577,4948), ('DWH3409,4881), ('EBK1692A,6364), ('EBK1705A,6364), ('EA0101,4344), ('XBS101,4344), ('29SKV007,4969), ('29SKV056,4969), ('5815203613,4770), ('5815313613,4770), ('1623949680,4391), ('1623954180,4391), ('1637969380,4391), ('713644550,192), ('713644560,192), ('FHBK1064,267), ('6037,4834), ('02843,101), ('02895,101), ('03104,101), ('14696,101), ('FBK410,407), ('FBK411,407), ('460114,441), ('460243,441), ('GL4114S,6317), ('GL4343S,6317), ('FR291031,236), ('FR291039,236), ('FR961286,236), ('FRW090040,236), ('20498009K,4727), ('20498033K,4727), ('20498037S,4727), ('32498003S,4727), ('FWB0408KT,409), ('FWB0409KT,409), ('BS3680,54), ('BS3680B,54), ('BS3680HB,54), ('GH30890A,6666), ('GH31800,6666), ('9400058K,373), ('9400064,373), ('9400064K,373), ('9433007,373), ('9433013,373), ('8DD355101501,4734), ('J3300907,72), ('101008,4862), ('101252,4862), ('101252R,4862), ('101253,4862), ('101253R,4862), ('60622,269), ('304455,262), ('304456,262), ('DIW05,156), ('60W05,481), ('1241400200,268), ('1251400300,268), ('1251400400,268), ('1251400600,268), ('1263104200,268), ('5500079,185), ('5500080,185), ('85010209,286), ('853024212,286), ('853024213,286), ('KWB410,4879), ('KWB411,4879), ('22027Z,387), ('22028Z,387), ('RK4455,4462), ('RK4456,4462), ('4101630,4546), ('4101635,4546), ('4201501,4546), ('LAB057,6518), ('1602501,35), ('1602701,35), ('LKBA67011,4501), ('LKBA67028,4501), ('WH1171,4600), ('WH1194,4600), ('361111181574,4723), ('361111181575,4723), ('26806,133), ('26807,133), ('26814,133), ('3409SETMS,358), ('3422SETMS,358), ('330276,403), ('330277,403), ('8312150000,4899), ('8312150060,4899), ('8312150080,4899), ('8312156060,4899), ('8312156880,4899), ('8312156980,4899), ('MRP2B03,4773), ('90333,4664), ('90524,4664), ('6110062,94), ('N2588,94), ('WM876,94), ('WM877,94), ('6140320004,144), ('6147520004,144), ('DB83163,6495), ('MDC692,73), ('OPWB11117,134), ('OPWB11118,134), ('LVBW690,4564), ('LVBW691,4564), ('VBK690,4564), ('VBK691,4564), ('ASB0927,6874), ('ASB0928,6874), ('ASB1600,6874), ('70230035,4653), ('70230071,4653), ('N4710914,248), ('ND6083,4990), ('203613,127), ('313613,127), ('763614,127), ('763615,127), ('KH30054,4728), ('KH30055,4728), ('KLPDW020P,6355), ('KLTPL001,6355), ('KLTPL001Z,6355), ('KLTPL002,6355), ('HBK521103,378), ('04P145,129), ('04P483,129), ('202140,129), ('202142,129), ('PTA3210038,6457), ('PTA3210211,6457), ('PBK3409,4558), ('PBK3409H,4558), ('PBK3422,4558), ('PBK3422H,4558), ('86110034,4543), ('25013409,4686), ('25013422,4686), ('50100206,4686), ('QF04D00185,4339), ('QF10D00083,4339), ('QWB876,57), ('QWB877,57), ('RCAK1200,492), ('RKB0927,4330), ('RKB0928,4330), ('RKB1600,4330), ('654W0063,6358), ('654W0075,6358), ('82B0692,6358), ('485301,23), ('5322,23), ('5323,23), ('1815203613,297), ('1815313613,297), ('460114,27), ('460243,27), ('VKBA3409,50), ('VKBA3422,50), ('R15322,110), ('R15323,110), ('SKBD0022842,6357), ('SKBK1090153,6357), ('SKWB0180062,6357), ('SKWB0180074,6357), ('T490333,4667), ('T490524,4667), ('4030045SX,4595), ('4215108SX,4595), ('4215142SX,4595), ('4328563SX,4595), ('4328777SX,4595), ('291031,6691), ('291039,6691), ('40902843,151), ('40902845,151), ('40902895,151), ('40903104,151), ('92039203,39), ('200394,301), ('202440,301), ('205208,301), ('WB1519,4732), ('WB1530,4732), ('MR0502,4772), ('MR0587,4772), ('908034,4970), ('908038,4970), ('908385,4970), ('812024110,108), ('812024110C,108), ('85010209,108), ('853024212,108), ('853024213,108), ('V400387,183), ('V407005,183), ('17828,4425), ('19746,4425), ('704,4425), ('362097,6347), ('560003,6347), ('560141,6347), ('560199,6347), ('560201,6347), ('560215,6347), ('RL1053,4894), ('RL1064,4894), ('RL2003,4894), ('60W03,481), ('16025,35), ('16027,35), ('972397,129), ('DIW03,156), ('201473,206), ('600W003,257)
        
) 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.