#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTM1NDB8fG1kZl9pZD09MV4xMTY1fHxzcGFyZV9pZD09MjAxNDc1&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 = "1165" AND ( (av.SupplierID = 141 AND av.DataSupplierArticleNumber = "V91771" AND av.ProductID IN (1269)) OR (av.SupplierID = 141 AND av.DataSupplierArticleNumber = "V91374" AND av.ProductID IN (1270)) OR (av.SupplierID = 235 AND av.DataSupplierArticleNumber = "R6257/BMCR" AND av.ProductID IN (1270)) OR (av.SupplierID = 235 AND av.DataSupplierArticleNumber = "R6256/SCR" AND av.ProductID IN (1269)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "227 VE 31032 000" AND av.ProductID IN (1269)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "227 VA 31033 000" AND av.ProductID IN (1270)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "81-24615-SX" AND av.ProductID IN (1270)) OR (av.SupplierID = 347 AND av.DataSupplierArticleNumber = "25127" AND av.ProductID IN (1269)) OR (av.SupplierID = 347 AND av.DataSupplierArticleNumber = "KK-10H" AND av.ProductID IN (1271)) OR (av.SupplierID = 347 AND av.DataSupplierArticleNumber = "2560" AND av.ProductID IN (1270)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1053064" AND av.ProductID IN (1269)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1028290" AND av.ProductID IN (1271)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1105194" AND av.ProductID IN (1270)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1098448" AND av.ProductID IN (1269)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1173886" AND av.ProductID IN (1270)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1015452" AND av.ProductID IN (1270)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1173977" AND av.ProductID IN (1269)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1015643" AND av.ProductID IN (1269)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1053614" 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 = "V91771") OR (aa.SupplierID = 141 AND aa.DataSupplierArticleNumber = "V91374") OR (aa.SupplierID = 235 AND aa.DataSupplierArticleNumber = "R6257/BMCR") OR (aa.SupplierID = 235 AND aa.DataSupplierArticleNumber = "R6256/SCR") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "227 VE 31032 000") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "227 VA 31033 000") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-24615-SX") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "25127") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "KK-10H") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "2560") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1053064") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1028290") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1105194") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1098448") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173886") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1015452") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173977") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1015643") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1053614") ) 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 = "V91771") OR (aa.SupplierID = 141 AND aa.DataSupplierArticleNumber = "V91374") OR (aa.SupplierID = 235 AND aa.DataSupplierArticleNumber = "R6257/BMCR") OR (aa.SupplierID = 235 AND aa.DataSupplierArticleNumber = "R6256/SCR") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "227 VE 31032 000") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "227 VA 31033 000") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-24615-SX") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "25127") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "KK-10H") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "2560") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1053064") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1028290") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1105194") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1098448") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173886") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1015452") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173977") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1015643") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1053614") ) AND aa.Language = "ru" Продажа автозапчастей типа Клапаны / комплектующие для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AE V91771 Впускной клапан
V91374 Выпускной клапан
FRECCIA R6257/BMCR Выпускной клапан
R6256/SCR Впускной клапан
MAHLE ORIGINAL 227 VE 31032 000 Впускной клапан
227 VA 31033 000 Выпускной клапан
STELLOX 81-24615-SX Выпускной клапан
TRW Engine Component 25127 Впускной клапан
KK-10H Предохранительный клин клапана
2560 Выпускной клапан
WILMINK GROUP WG1053064 Впускной клапан
WG1028290 Предохранительный клин клапана
WG1105194 Выпускной клапан
WG1098448 Впускной клапан
WG1173886 Выпускной клапан
WG1015452 Выпускной клапан
WG1173977 Впускной клапан
WG1015643 Впускной клапан
WG1053614 Выпускной клапан
2026 CATCAR.INFO (v 2.0)