#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3Mnx8bW9kZWxfaWQ9PTU1MzZ8fG1kZl9pZD09MV41NDMwfHxzcGFyZV9pZD09MjAwODM3&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 = "5430" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "38897" AND av.ProductID IN (4067)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "47503" AND av.ProductID IN (608)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "46247" AND av.ProductID IN (4067)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "35513" AND av.ProductID IN (608)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "46277" AND av.ProductID IN (4067)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "39850" AND av.ProductID IN (608)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "TEQ-03.068" AND av.ProductID IN (608)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.639" AND av.ProductID IN (4067)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "030.571" AND av.ProductID IN (4067)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.586" AND av.ProductID IN (4067)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "041.056" AND av.ProductID IN (608)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.595" AND av.ProductID IN (4067)) ) 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 = 101 AND aa.DataSupplierArticleNumber = "38897") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "47503") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "46247") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "35513") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "46277") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39850") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "TEQ-03.068") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.639") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "030.571") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.586") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "041.056") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.595") ) 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 = 101 AND aa.DataSupplierArticleNumber = "38897") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "47503") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "46247") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "35513") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "46277") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39850") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "TEQ-03.068") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.639") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "030.571") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.586") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "041.056") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.595") ) AND aa.Language = "ru" Продажа автозапчастей типа Насос для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FEBI BILSTEIN 38897 Ремонтный комплект, опрокидывающий насос
47503 Опрокидывающий насос, кабина
46247 Ремонтный комплект, опрокидывающий насос
35513 Опрокидывающий насос, кабина
46277 Ремонтный комплект, опрокидывающий насос
39850 Опрокидывающий насос, кабина
S-TR TEQ-03.068 Опрокидывающий насос, кабина
SAMPA 040.639 Ремонтный комплект, опрокидывающий насос
030.571 Ремонтный комплект, опрокидывающий насос
040.586 Ремонтный комплект, опрокидывающий насос
041.056 Опрокидывающий насос, кабина
040.595 Ремонтный комплект, опрокидывающий насос
2026 CATCAR.INFO (v 2.0)