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='4004120' AND a.supplierId=260) OR (a.articleSearch='83052' AND a.supplierId=4598) OR (a.articleSearch='A389593' AND a.supplierId=4364) OR (a.articleSearch='52918' AND a.supplierId=6558) OR (a.articleSearch='119019' AND a.supplierId=317) OR (a.articleSearch='021329' AND a.supplierId=405) OR (a.articleSearch='S1112502619' AND a.supplierId=112) OR (a.articleSearch='10350' AND a.supplierId=4834) OR ( a.articleSearch IN ('02062', '46615') AND a.supplierId=101) OR (a.articleSearch='BOL0005' AND a.supplierId=6443) OR (a.articleSearch='MLS233' AND a.supplierId=6270) OR (a.articleSearch='491032' AND a.supplierId=403) OR (a.articleSearch='05437' AND a.supplierId=4664) OR (a.articleSearch='T405437' AND a.supplierId=4667) OR (a.articleSearch='7901907SX' AND a.supplierId=4595) OR (a.articleSearch='60902062' AND a.supplierId=151) OR (a.articleSearch='701244' AND a.supplierId=301) OR (a.articleSearch='335140' AND a.supplierId=4970) OR (a.articleSearch='V389593' AND a.supplierId=183) OR (a.articleSearch='3185' AND a.supplierId=4425) OR (a.articleSearch='BE4082' AND a.supplierId=4894) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Renault (пасажирский) -> Renault 18 (134_) ->Renault 2.1 Diesel (1344), 11.1981- 07.1986, , 67 ->Колесо / крепление колеса