#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3Mnx8bW9kZWxfaWQ9PTU1MzR8fG1kZl9pZD09MV45ODc1fHxzcGFyZV9pZD09MjAwOTc0&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 = "9875" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "40509" AND av.ProductID IN (1420)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.242" AND av.ProductID IN (4323)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.233" AND av.ProductID IN (4323)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "042.433" AND av.ProductID IN (2109)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.477" AND av.ProductID IN (4323)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.234" AND av.ProductID IN (4323)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.270" AND av.ProductID IN (2111)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.190" AND av.ProductID IN (1420)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.235" AND av.ProductID IN (4323)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.229" AND av.ProductID IN (4323)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.191" AND av.ProductID IN (1420)) ) 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 = "40509") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.242") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.233") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "042.433") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.477") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.234") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.270") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.190") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.235") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.229") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.191") ) 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 = "40509") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.242") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.233") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "042.433") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.477") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.234") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.270") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.190") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.235") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.229") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.191") ) AND aa.Language = "ru" Продажа автозапчастей типа Карданный вал для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FEBI BILSTEIN 40509 Подвеска, карданный вал
SAMPA 040.242 Кронштейн, промежуточный подшипник карданного вала
040.233 Кронштейн, промежуточный подшипник карданного вала
042.433 Подшипник, промежуточный подшипник карданного вала
040.477 Кронштейн, промежуточный подшипник карданного вала
040.234 Кронштейн, промежуточный подшипник карданного вала
040.270 Уплотняющее кольцо вала, промежуточный подшипник карданного
040.190 Подвеска, карданный вал
040.235 Кронштейн, промежуточный подшипник карданного вала
040.229 Кронштейн, промежуточный подшипник карданного вала
040.191 Подвеска, карданный вал
2026 CATCAR.INFO (v 2.0)