#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3Mnx8bW9kZWxfaWQ9PTU1MzR8fG1kZl9pZD09MV45OTAyfHxzcGFyZV9pZD09MjAwMTk2&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 = "9902" AND ( (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "126.001" AND av.ProductID IN (4949)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "374.470" AND av.ProductID IN (128)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "126.010" AND av.ProductID IN (4949)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "374.460" AND av.ProductID IN (128)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "09970" AND av.ProductID IN (128)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1379921" AND av.ProductID IN (4949)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1190653" AND av.ProductID IN (4949)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1192316" AND av.ProductID IN (128)) ) 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 = 10 AND aa.DataSupplierArticleNumber = "126.001") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "374.470") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "126.010") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "374.460") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09970") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1379921") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190653") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192316") ) 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 = 10 AND aa.DataSupplierArticleNumber = "126.001") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "374.470") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "126.010") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "374.460") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09970") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1379921") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190653") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192316") ) AND aa.Language = "ru" Продажа автозапчастей типа Уплотняющее кольцо гильзы цилиндра для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ELRING 126.001 Уплотнительное кольцо, гильза цилиндра
374.470 Прокладка, гильза цилиндра
126.010 Уплотнительное кольцо, гильза цилиндра
374.460 Прокладка, гильза цилиндра
FEBI BILSTEIN 09970 Прокладка, гильза цилиндра
WILMINK GROUP WG1379921 Уплотнительное кольцо, гильза цилиндра
WG1190653 Уплотнительное кольцо, гильза цилиндра
WG1192316 Прокладка, гильза цилиндра
2026 CATCAR.INFO (v 2.0)