#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTYyNnx8bW9kZWxfaWQ9PTUwNjV8fG1kZl9pZD09MV43NjU4fHxzcGFyZV9pZD09MjA0MzM3&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 = "7658" AND ( (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "655027" AND av.ProductID IN (312)) OR (av.SupplierID = 4679 AND av.DataSupplierArticleNumber = "500312" AND av.ProductID IN (312)) OR (av.SupplierID = 42 AND av.DataSupplierArticleNumber = "APV2399" AND av.ProductID IN (312)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "30389" AND av.ProductID IN (312)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "45073" AND av.ProductID IN (312)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "15-4022" AND av.ProductID IN (312)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "12-34 000 1004" AND av.ProductID IN (312)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "08.040.8325.000" AND av.ProductID IN (312,312)) ) 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 = 300 AND aa.DataSupplierArticleNumber = "655027") OR (aa.SupplierID = 4679 AND aa.DataSupplierArticleNumber = "500312") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "APV2399") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "30389") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "45073") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-4022") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-34 000 1004") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "08.040.8325.000") ) 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 = 300 AND aa.DataSupplierArticleNumber = "655027") OR (aa.SupplierID = 4679 AND aa.DataSupplierArticleNumber = "500312") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "APV2399") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "30389") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "45073") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-4022") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-34 000 1004") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "08.040.8325.000") ) AND aa.Language = "ru" Продажа автозапчастей типа Паразитный / ведущий ролик для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTEX 655027 Паразитный / ведущий ролик, поликлиновой ремень
CAFFARO 500312 Паразитный / ведущий ролик, поликлиновой ремень
DAYCO APV2399 Паразитный / ведущий ролик, поликлиновой ремень
FEBI BILSTEIN 30389 Паразитный / ведущий ролик, поликлиновой ремень
45073 Паразитный / ведущий ролик, поликлиновой ремень
IPD 15-4022 Паразитный / ведущий ролик, поликлиновой ремень
MEYLE 12-34 000 1004 Паразитный / ведущий ролик, поликлиновой ремень
ST-TEMPLIN 08.040.8325.000 Паразитный / ведущий ролик, поликлиновой ремень
2026 CATCAR.INFO (v 2.0)