SELECT DISTINCT m.manufacturerName AS cross_brand, ao.oemSearch, ao.oemnumber, ps.id FROM ( VALUES ('92183', 123), ('310145', 4654), ('820231N', 80), ('112217', 4688), ('112218', 4688), ('OLV300', 247), ('1225259', 4553), ('TSP0525129', 89), ('DCV1089', 253), ('36088', 205), ('OLV300', 340), ('KTT150010', 4466), ('3700V300', 36), ('WG2041867', 4832) ) 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) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Opel (пасажирский) -> Opel VECTRA B универсал (J96) ->Opel 1.8 i 16V (F35), 11.1996- 09.2000, , 115 ->Испаритель