#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTM1Mzd8fG1kZl9pZD09MV4xODMwNXx8c3BhcmVfaWQ9PTIwMDAyNQ%3D%3D&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 = "18305" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "11553" AND av.ProductID IN (3243)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "35150" AND av.ProductID IN (522)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "27139" AND av.ProductID IN (608)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "033.654-00A" AND av.ProductID IN (523)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-1202165" AND av.ProductID IN (3243)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-1202250" AND av.ProductID IN (3242)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-1202149" AND av.ProductID IN (3243)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "09.010.0963.310" AND av.ProductID IN (608,608)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "09.010.0990.380" AND av.ProductID IN (522,522)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "09.010.0905.960" AND av.ProductID IN (3243,3243)) ) 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 = "11553") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "35150") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "27139") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "033.654-00A") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1202165") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1202250") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1202149") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0963.310") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0990.380") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0905.960") ) 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 = "11553") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "35150") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "27139") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "033.654-00A") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1202165") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1202250") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-1202149") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0963.310") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0990.380") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0905.960") ) AND aa.Language = "ru" Продажа автозапчастей типа Подвеска кабины для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FEBI BILSTEIN 11553 Втулка, подушка кабины водителя
35150 Поворотный шарнир, кабина
27139 Опрокидывающий насос, кабина
PE Automotive 033.654-00A Опрокидывающий цилиндр, кабина
S-TR STR-1202165 Втулка, подушка кабины водителя
STR-1202250 Ремкомплект, крепление кабины водителя
STR-1202149 Втулка, подушка кабины водителя
ST-TEMPLIN 09.010.0963.310 Опрокидывающий насос, кабина
09.010.0990.380 Поворотный шарнир, кабина
09.010.0905.960 Втулка, подушка кабины водителя
2026 CATCAR.INFO (v 2.0)