SELECT DISTINCT 
        m.manufacturerName AS cross_brand, 
        ao.oemSearch, 
        ao.oemnumber, 
        ps.id 
    FROM (    
        VALUES ('BSG30840031', 4455), ('TSN22284', 271), ('82107', 244), ('08897', 4683), ('0604038SX', 4595), ('55133', 6558), ('56474', 6558), ('XS2677', 4975), ('AS2074', 4737), ('AS2123', 4737), ('150014010', 323), ('150110110', 323), ('PES0085', 4337), ('PES0099', 4337), ('0011024241', 4995), ('ST232', 6444), ('ST267', 6444), ('ADBP720005', 350), ('BTS3004', 475), ('BTS3020', 475), ('AS0011', 215), ('WS2596', 215), ('WS2677', 215), ('CST9309', 4334), ('CST9516', 4334), ('CST9536', 4334), ('CST9537', 4334), ('CST9583', 4334), ('TS10198', 89), ('TS1024012B1', 89), ('TS10287', 89), ('TS10294', 89), ('1040300011', 4345), ('1040300014', 4345), ('1343125', 355), ('1343127', 355), ('145565', 211), ('295083', 211), ('295154', 211), ('EV0011', 4344), ('EV0022', 4344), ('EV0039', 4344), ('EV0042', 4344), ('EV0309', 4344), ('XTS7712', 4344), ('XTS7728', 4344), ('XTS7741', 4344), ('XTS7761', 4344), ('XTS7827', 4344), ('1830234', 4005), ('1830363', 4005), ('330144', 234), ('330640', 234), ('73234', 4005), ('73363', 4005), ('33425', 240), ('33734', 240), ('33735', 240), ('170480', 101), ('24467', 101), ('TSN22602', 271), ('FTS3004', 407), ('FTS3020', 407), ('82309', 441), ('82516', 441), ('82536', 441), ('82537', 441), ('82583', 441), ('GAS0011', 6456), ('122500003', 4524), ('6PT009107831', 4734), ('6PT009309561', 4734), ('6PT009309651', 4734), ('J5622006', 72), ('7472032', 341), ('7472107', 341), ('7472108', 341), ('7472175', 341), ('7472405', 341), ('55508', 269), ('55530', 269), ('55574', 269), ('SD12099', 6387), ('1593100800', 268), ('1593100900', 268), ('ECT4505', 201), ('ECT4508', 201), ('862610031', 286), ('862610057', 286), ('862610058', 286), ('530234', 4006), ('530363', 4006), ('LWS040', 6518), ('LWS042', 6518), ('LWS111', 6518), ('SNB232', 4501), ('SNB834', 4501), ('171916011160', 4723), ('171916011680', 4723), ('171916011700', 4723), ('TSE26', 287), ('88606', 133), ('88607', 133), ('210127', 403), ('210247', 403), ('EPS1830234', 4773), ('EPS1830363', 4773), ('82032', 244), ('82108', 244), ('82175', 244), ('82405', 244), ('0905126', 94), ('0905154', 94), ('0905400', 94), ('7148210000', 144), ('7148210005', 144), ('LVCT118', 4564), ('LVCT264', 4564), ('VCT135', 4564), ('4037', 320), ('4057', 320), ('4182', 320), ('4258', 320), ('5045', 320), ('N5623014', 248), ('02036', 4683), ('19994', 4683), ('PE13017', 4558), ('PE13176', 4558), ('QF25A00023', 4339), ('QF25A00029', 4339), ('QF25A00046', 4339), ('XEMS72', 57), ('XEMS89', 57), ('XTT221', 57), ('830C0059', 6358), ('830C0066', 6358), ('3256005', 260), ('3256015', 260), ('E534416', 6377), ('E534460', 6377), ('82309', 27), ('82516', 27), ('82536', 27), ('82537', 27), ('82583', 27), ('SKCTS0850058', 6357), ('SKCTS0850065', 6357), ('0604028SX', 4595), ('50924467', 151), ('300675', 301), ('302139', 301), ('437071', 4970), ('437072', 4970), ('862610031', 108), ('862610057', 108), ('862610058', 108), ('LNA1600AA', 4999), ('700026', 21), ('V25720046', 183), ('V25720047', 183), ('V25720090', 183), ('V25721023', 183), ('2111026', 303), ('2111042', 303), ('410580015', 4275), ('410580077', 4275), ('410580078', 4275), ('410580100', 4275), ('410580177', 4275), ('WG1015169', 4832), ('WG1407255', 4832), ('WG1407313', 4832), ('WG1407314', 4832), ('WG1407350', 4832), ('WG1430310', 4832), ('WG1445358', 4832), ('WG1445378', 4832), ('WG1492443', 4832), ('WG1492561', 4832), ('WG1499600', 4832), ('WG1499643', 4832), ('WG1499650', 4832), ('11127', 6347), ('12196', 6347)
    ) 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 products.products_suppliers ps 
        ON p.id = ps.product_id 
       AND ps.supplier_id IN (223)
An internal server error occurred.