SELECT DISTINCT m.manufacturerName AS cross_brand, ao.oemSearch, ao.oemnumber, ps_sub.id AS id FROM ( VALUES ('FT94434',4938), ('442504',4849), ('601007006410WP',4555), ('1280016',355), ('1280016SP',355), ('ZR60160',4603), ('LT60160',4719), ('350105032100',4723), ('60160',4721), ('AL60160',4720), ('FT9208502',340), ('FT9208503',340) ) 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; Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Fiat (пасажирский) -> Fiat DUCATO c бортовой платформой/ходовая часть (230_) ->Fiat 2.5 D 4x4, 03.1994- 04.2002, , 84 ->Ручки