#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTU1ODl8fG1kZl9pZD09MF4zMDkzOXx8c3BhcmVfaWQ9PTEwMTk3MQ%3D%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 articlepassengercars av JOIN passengercarlinkageattributes_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 = "30939" AND ( (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.11.050" AND av.ProductID IN (3213)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.11.042" AND av.ProductID IN (3213)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.11.051" AND av.ProductID IN (3213)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.11.044" AND av.ProductID IN (3213)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.19.256" AND av.ProductID IN (4204)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.11.045" AND av.ProductID IN (3213)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.11.041" AND av.ProductID IN (3213)) ) 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 = 209 AND aa.DataSupplierArticleNumber = "02.11.050") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.11.042") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.11.051") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.11.044") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.19.256") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.11.045") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.11.041") ) 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 = 209 AND aa.DataSupplierArticleNumber = "02.11.050") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.11.042") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.11.051") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.11.044") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.19.256") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.11.045") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.11.041") ) AND aa.Language = "ru" Продажа автозапчастей типа Ременный шкив для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
TRUCKTEC AUTOMOTIVE 02.11.050 Ременный шкив, коленчатый вал
02.11.042 Ременный шкив, коленчатый вал
02.11.051 Ременный шкив, коленчатый вал
02.11.044 Ременный шкив, коленчатый вал
02.19.256 Ременный шкив, насос гидроусилителя
02.11.045 Ременный шкив, коленчатый вал
02.11.041 Ременный шкив, коленчатый вал
2026 CATCAR.INFO (v 2.0)