#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTg1MjR8fG1kZl9pZD09MF4xMDM0Nnx8c3BhcmVfaWQ9PTEwMDQ0MQ%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 = "10346" AND ( (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "AA1026" AND av.ProductID IN (541)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "89186" AND av.ProductID IN (541)) OR (av.SupplierID = 42 AND av.DataSupplierArticleNumber = "APV2838" AND av.ProductID IN (541)) OR (av.SupplierID = 42 AND av.DataSupplierArticleNumber = "APV2847" AND av.ProductID IN (541)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "47975" AND av.ProductID IN (541)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "FI25260" AND av.ProductID IN (541)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 94 7975" AND av.ProductID IN (541)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V30-2528" AND av.ProductID IN (541)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1427550" AND av.ProductID IN (541)) ) 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 = 4464 AND aa.DataSupplierArticleNumber = "AA1026") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "89186") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "APV2838") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "APV2847") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "47975") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI25260") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 94 7975") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-2528") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1427550") ) 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 = 4464 AND aa.DataSupplierArticleNumber = "AA1026") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "89186") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "APV2838") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "APV2847") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "47975") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI25260") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 94 7975") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-2528") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1427550") ) AND aa.Language = "ru" Продажа автозапчастей типа Натяжитель ремня (блок натяжения) для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTOTEAM AA1026 Натяжитель ремня, клиновой зубча
CALIBER 89186 Натяжитель ремня, клиновой зубча
DAYCO APV2838 Натяжитель ремня, клиновой зубча
APV2847 Натяжитель ремня, клиновой зубча
FEBI BILSTEIN 47975 Натяжитель ремня, клиновой зубча
KM International FI25260 Натяжитель ремня, клиновой зубча
SWAG 10 94 7975 Натяжитель ремня, клиновой зубча
VAICO V30-2528 Натяжитель ремня, клиновой зубча
WILMINK GROUP WG1427550 Натяжитель ремня, клиновой зубча
2026 CATCAR.INFO (v 2.0)