SELECT DISTINCT m.manufacturerName AS cross_brand, ao.manufacturerId, ao.oemSearch, ao.oemnumber, ps.id AS supplier_product_id, ps.supplier_id AS real_supplier_id FROM article a 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 ps.product_id = p.id AND ps.supplier_id IN (224, 226, 223, 225, 227) WHERE (a.articleSearch='170554' AND a.supplierId=101) OR (a.articleSearch='42157' AND a.supplierId=4683) OR (a.articleSearch='11031823701' AND a.supplierId=4346) OR (a.articleSearch='58368' AND a.supplierId=6558) OR (a.articleSearch='2141035' AND a.supplierId=94) OR (a.articleSearch='33100440' AND a.supplierId=151) OR (a.articleSearch='116744' AND a.supplierId=301) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Vw (пасажирский) -> Vw GOLF VII Variant (BA5, BV5) ->Vw 1.6 TDI, 05.2013- 03.2017, , 105 ->Крышка маслозаливной горловины / прокладка