#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUzOXx8bW9kZWxfaWQ9PTM0MjF8fG1kZl9pZD09MV4xODQyfHxzcGFyZV9pZD09MjAxNDc1&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 = "1842" AND ( (av.SupplierID = 141 AND av.DataSupplierArticleNumber = "V91679" AND av.ProductID IN (1269)) OR (av.SupplierID = 141 AND av.DataSupplierArticleNumber = "V91302" AND av.ProductID IN (1270)) OR (av.SupplierID = 141 AND av.DataSupplierArticleNumber = "V91301" AND av.ProductID IN (1269)) OR (av.SupplierID = 141 AND av.DataSupplierArticleNumber = "V91304" AND av.ProductID IN (1270)) OR (av.SupplierID = 347 AND av.DataSupplierArticleNumber = "17076" AND av.ProductID IN (1270)) OR (av.SupplierID = 347 AND av.DataSupplierArticleNumber = "17075" AND av.ProductID IN (1269)) OR (av.SupplierID = 347 AND av.DataSupplierArticleNumber = "KK-8H" AND av.ProductID IN (1271)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1173861" AND av.ProductID IN (1269)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1173864" AND av.ProductID IN (1270)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1173946" AND av.ProductID IN (1269)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1015576" AND av.ProductID IN (1270)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1015575" AND av.ProductID IN (1269)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1028295" AND av.ProductID IN (1271)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1173862" AND av.ProductID IN (1270)) ) 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 = 141 AND aa.DataSupplierArticleNumber = "V91679") OR (aa.SupplierID = 141 AND aa.DataSupplierArticleNumber = "V91302") OR (aa.SupplierID = 141 AND aa.DataSupplierArticleNumber = "V91301") OR (aa.SupplierID = 141 AND aa.DataSupplierArticleNumber = "V91304") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "17076") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "17075") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "KK-8H") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173861") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173864") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173946") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1015576") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1015575") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1028295") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173862") ) 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 = 141 AND aa.DataSupplierArticleNumber = "V91679") OR (aa.SupplierID = 141 AND aa.DataSupplierArticleNumber = "V91302") OR (aa.SupplierID = 141 AND aa.DataSupplierArticleNumber = "V91301") OR (aa.SupplierID = 141 AND aa.DataSupplierArticleNumber = "V91304") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "17076") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "17075") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "KK-8H") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173861") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173864") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173946") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1015576") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1015575") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1028295") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173862") ) AND aa.Language = "ru" Продажа автозапчастей типа Клапаны / комплектующие для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AE V91679 Впускной клапан
V91302 Выпускной клапан
V91301 Впускной клапан
V91304 Выпускной клапан
TRW Engine Component 17076 Выпускной клапан
17075 Впускной клапан
KK-8H Предохранительный клин клапана
WILMINK GROUP WG1173861 Впускной клапан
WG1173864 Выпускной клапан
WG1173946 Впускной клапан
WG1015576 Выпускной клапан
WG1015575 Впускной клапан
WG1028295 Предохранительный клин клапана
WG1173862 Выпускной клапан
2026 CATCAR.INFO (v 2.0)