#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTE1ODd8fG1kZl9pZD09MV43OTN8fHNwYXJlX2lkPT0yMDA4NzM%3D&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 = "793" AND ( (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "01034692B" AND av.ProductID IN (636)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "01034644B" AND av.ProductID IN (636)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "12014056B" AND av.ProductID IN (636)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "01034690B" AND av.ProductID IN (636)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "01029684B" AND av.ProductID IN (636)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "01034691B" AND av.ProductID IN (636)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "01034643B" AND av.ProductID IN (636)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1220918" AND av.ProductID IN (636)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1223219" AND av.ProductID IN (636)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1220934" AND av.ProductID IN (636)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1220935" AND av.ProductID IN (636)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1220479" AND av.ProductID IN (636)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1220936" AND av.ProductID IN (636)) ) 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 = "01034692B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "01034644B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12014056B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "01034690B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "01029684B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "01034691B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "01034643B") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1220918") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1223219") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1220934") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1220935") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1220479") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1220936") ) 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 = "01034692B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "01034644B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12014056B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "01034690B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "01029684B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "01034691B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "01034643B") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1220918") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1223219") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1220934") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1220935") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1220479") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1220936") ) AND aa.Language = "ru" Продажа автозапчастей типа Прокладки для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
CORTECO 01034692B Уплотняющее кольцо, вспомогательный привод
01034644B Уплотняющее кольцо, вспомогательный привод
12014056B Уплотняющее кольцо, вспомогательный привод
01034690B Уплотняющее кольцо, вспомогательный привод
01029684B Уплотняющее кольцо, вспомогательный привод
01034691B Уплотняющее кольцо, вспомогательный привод
01034643B Уплотняющее кольцо, вспомогательный привод
WILMINK GROUP WG1220918 Уплотняющее кольцо, вспомогательный привод
WG1223219 Уплотняющее кольцо, вспомогательный привод
WG1220934 Уплотняющее кольцо, вспомогательный привод
WG1220935 Уплотняющее кольцо, вспомогательный привод
WG1220479 Уплотняющее кольцо, вспомогательный привод
WG1220936 Уплотняющее кольцо, вспомогательный привод
2026 CATCAR.INFO (v 2.0)