SELECT DISTINCT m.manufacturerName AS cross_brand, ao.oemSearch, ao.oemnumber, ps_sub.id AS id FROM ( VALUES ('19893',101), ('60919893',151), ('910980',206), ('74971',4576), ('BHN200',475), ('470R0025BTA',4693), ('FHN200',407), ('460027',441), ('460077',441), ('460088',441), ('460134',441), ('460138',441), ('460140',441), ('WB1173',4600), ('WB1204',4600), ('WB1215',4600), ('WB1298',4600), ('MWBR5003',4773), ('6111505',94), ('N471N50C',440), ('9811',6304), ('9811K',6304), ('460027',27), ('460077',27), ('460088',27), ('460134',27), ('460138',27), ('460140',27) ) 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
Главная -> Каталог -> Renault (пасажирский) -> Renault TWINGO I (C06_) ->Renault 1.2 (C067), 05.1996- 03.2007, , 54 ->Шейка оси