#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTczOXx8bW9kZWxfaWQ9PTQ3MDl8fG1kZl9pZD09MV42Njg4fHxzcGFyZV9pZD09MjAwODcx&st=50 SELECT CONCAT(av.SupplierID, "^", av.DataSupplierArticleNumber) AS article_id, d.`Description` AS crit_designation, dv.`DisplayValue` AS crit_value, "" crit_unit, 2 criteria_art, "articletypes" as source FROM articlecommercialvehicles av JOIN commercialvehiclelinkageattributes_ru vla ON av.Idx = vla.Idx JOIN linkageattributedescriptions d ON vla.DescriptionIdx = d.Idx JOIN linkageattributedisplayvalues dv ON vla.DisplayValueIdx = dv.Idx WHERE av.VehicleID = "6688" AND ( (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "07016736B" AND av.ProductID IN (630)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "45372" AND av.ProductID IN (630)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "079.102" AND av.ProductID IN (630)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "079.086" AND av.ProductID IN (630)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "079.087" AND av.ProductID IN (630)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "078.004" AND av.ProductID IN (4002)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "079.097" AND av.ProductID IN (630)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "010.242" AND av.ProductID IN (630)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1222091" AND av.ProductID IN (630)) ) UNION ALL SELECT CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber) as article_id, if (aa.Description = "", aa.DisplayTitle, aa.Description) as crit_designation, aa.DisplayValue as crit_value, "" crit_unit, 1 criteria_art, "articleattributes" as source FROM articleattributes aa WHERE ( (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "07016736B") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "45372") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.102") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.086") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.087") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.004") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.097") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "010.242") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1222091") ) AND aa.Language = "ru" UNION ALL SELECT CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber) as article_id, if (aa.Description = "", aa.DisplayTitle, aa.Description) as crit_designation, aa.DisplayValue as crit_value, "" crit_unit, 1 criteria_art, "articleattributes_2018_2" as source FROM articleattributes_2018_2 aa WHERE ( (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "07016736B") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "45372") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.102") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.086") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.087") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.004") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.097") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "010.242") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1222091") ) AND aa.Language = "ru" Продажа автозапчастей типа Дифференциал / детали для автомобилей

Выбор автозапчасти

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
CORTECO 07016736B Уплотняющее кольцо, дифференциал
FEBI BILSTEIN 45372 Уплотняющее кольцо, дифференциал
SAMPA 079.102 Уплотняющее кольцо, дифференциал
079.086 Уплотняющее кольцо, дифференциал
079.087 Уплотняющее кольцо, дифференциал
078.004 Упорная прокладка, уравнив.конич.зубчат. колесо - дифференц.
079.097 Уплотняющее кольцо, дифференциал
010.242 Уплотняющее кольцо, дифференциал
WILMINK GROUP WG1222091 Уплотняющее кольцо, дифференциал
2026 CATCAR.INFO (v 2.0)