#216.73.216.140 catcar.info/totalcatalog/?l=YnJhbmRfaWQ9PTU3Mnx8bW9kZWxfaWQ9PTU1MzV8fG1kZl9pZD09MV40OTExfHxzcGFyZV9pZD09MjAxNDc1&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 = "4911" AND ( (av.SupplierID = 141 AND av.DataSupplierArticleNumber = "V91201" AND av.ProductID IN (1269)) OR (av.SupplierID = 141 AND av.DataSupplierArticleNumber = "V91202" AND av.ProductID IN (1270)) OR (av.SupplierID = 141 AND av.DataSupplierArticleNumber = "V91200" AND av.ProductID IN (1269)) OR (av.SupplierID = 141 AND av.DataSupplierArticleNumber = "V34963" AND av.ProductID IN (1270)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "21965" AND av.ProductID IN (1269)) OR (av.SupplierID = 235 AND av.DataSupplierArticleNumber = "R4371/RCR" AND av.ProductID IN (1269)) OR (av.SupplierID = 235 AND av.DataSupplierArticleNumber = "R3744/RCR" AND av.ProductID IN (1270)) OR (av.SupplierID = 235 AND av.DataSupplierArticleNumber = "R6047/RCR" AND av.ProductID IN (1269)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "061 VE 30986 000" AND av.ProductID IN (1269)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "061 VA 30987 000" AND av.ProductID IN (1270)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "81-24607-SX" AND av.ProductID IN (1270)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "81-23920-SX" AND av.ProductID IN (1269)) OR (av.SupplierID = 347 AND av.DataSupplierArticleNumber = "105-35505" AND av.ProductID IN (1270)) OR (av.SupplierID = 347 AND av.DataSupplierArticleNumber = "105-35355" AND av.ProductID IN (1269)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1173812" AND av.ProductID IN (1269)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1025314" AND av.ProductID IN (1269)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1213248" AND av.ProductID IN (1270)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1093383" AND av.ProductID IN (1270)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1173813" AND av.ProductID IN (1269)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1052906" AND av.ProductID IN (1269)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1157181" AND av.ProductID IN (1270)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1213251" AND av.ProductID IN (1269)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1053002" AND av.ProductID IN (1269)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1173814" AND av.ProductID IN (1270)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1025340" 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 = "V91201") OR (aa.SupplierID = 141 AND aa.DataSupplierArticleNumber = "V91202") OR (aa.SupplierID = 141 AND aa.DataSupplierArticleNumber = "V91200") OR (aa.SupplierID = 141 AND aa.DataSupplierArticleNumber = "V34963") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "21965") OR (aa.SupplierID = 235 AND aa.DataSupplierArticleNumber = "R4371/RCR") OR (aa.SupplierID = 235 AND aa.DataSupplierArticleNumber = "R3744/RCR") OR (aa.SupplierID = 235 AND aa.DataSupplierArticleNumber = "R6047/RCR") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "061 VE 30986 000") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "061 VA 30987 000") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-24607-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-23920-SX") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "105-35505") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "105-35355") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173812") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025314") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1213248") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1093383") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173813") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1052906") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1157181") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1213251") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1053002") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173814") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025340") ) 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 = "V91201") OR (aa.SupplierID = 141 AND aa.DataSupplierArticleNumber = "V91202") OR (aa.SupplierID = 141 AND aa.DataSupplierArticleNumber = "V91200") OR (aa.SupplierID = 141 AND aa.DataSupplierArticleNumber = "V34963") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "21965") OR (aa.SupplierID = 235 AND aa.DataSupplierArticleNumber = "R4371/RCR") OR (aa.SupplierID = 235 AND aa.DataSupplierArticleNumber = "R3744/RCR") OR (aa.SupplierID = 235 AND aa.DataSupplierArticleNumber = "R6047/RCR") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "061 VE 30986 000") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "061 VA 30987 000") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-24607-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-23920-SX") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "105-35505") OR (aa.SupplierID = 347 AND aa.DataSupplierArticleNumber = "105-35355") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173812") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025314") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1213248") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1093383") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173813") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1052906") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1157181") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1213251") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1053002") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1173814") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025340") ) AND aa.Language = "ru" Продажа автозапчастей типа Клапаны / комплектующие для автомобилей - Catcar.info
Каталог автозапчастей
Catcar Aftermarket
Каталог автозапчастей
Catcar Aftermarket
Уже продаёте автозапчасти? Подключите каталоги на свой сайт, чтобы повысить продажи
Подключить каталоги

Автозапчасти


Производители Артикул Наименование Сведения Полная информация
AE V91201 Впускной клапан
V91202 Выпускной клапан
V91200 Впускной клапан
V34963 Выпускной клапан
FEBI BILSTEIN 21965 Впускной клапан
FRECCIA R4371/RCR Впускной клапан
R3744/RCR Выпускной клапан
R6047/RCR Впускной клапан
MAHLE ORIGINAL 061 VE 30986 000 Впускной клапан
061 VA 30987 000 Выпускной клапан
STELLOX 81-24607-SX Выпускной клапан
81-23920-SX Впускной клапан
TRW Engine Component 105-35505 Выпускной клапан
105-35355 Впускной клапан
WILMINK GROUP WG1173812 Впускной клапан
WG1025314 Впускной клапан
WG1213248 Выпускной клапан
WG1093383 Выпускной клапан
WG1173813 Впускной клапан
WG1052906 Впускной клапан
WG1157181 Выпускной клапан
WG1213251 Впускной клапан
WG1053002 Впускной клапан
WG1173814 Выпускной клапан
WG1025340 Выпускной клапан
2026 CATCAR.INFO (v 2.0)