#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTM1NDF8fG1kZl9pZD09MV4yMDU5NXx8c3BhcmVfaWQ9PTIwMDAyNQ%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 = "20595" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "16289" AND av.ProductID IN (3242)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "28686" AND av.ProductID IN (525)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "35023" AND av.ProductID IN (523)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "09219" AND av.ProductID IN (3243)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "10780" AND av.ProductID IN (3242)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "27139" AND av.ProductID IN (608)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "11783 01" AND av.ProductID IN (3243)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "033.653-00A" AND av.ProductID IN (523)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "030.125-00A" AND av.ProductID IN (3243)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "09.010.0908.120" AND av.ProductID IN (522)) 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.0963.030" AND av.ProductID IN (523,523)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "09.010.0901.190" AND av.ProductID IN (3243,3243)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "09.010.0990.270" AND av.ProductID IN (522,522)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "09.010.0917.288" AND av.ProductID IN (3242,3242)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "09.010.0990.250" AND av.ProductID IN (522,522)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "09.010.0917.208" AND av.ProductID IN (3242,3242)) 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.0918.208" AND av.ProductID IN (3242)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "04.110.0908.300" AND av.ProductID IN (522)) ) 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 = "16289") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "28686") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "35023") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09219") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "10780") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "27139") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "11783 01") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "033.653-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "030.125-00A") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0908.120") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0963.310") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0963.030") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0901.190") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0990.270") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0917.288") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0990.250") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0917.208") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0990.380") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0918.208") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "04.110.0908.300") ) 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 = "16289") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "28686") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "35023") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09219") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "10780") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "27139") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "11783 01") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "033.653-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "030.125-00A") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0908.120") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0963.310") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0963.030") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0901.190") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0990.270") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0917.288") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0990.250") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0917.208") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0990.380") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0918.208") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "04.110.0908.300") ) AND aa.Language = "ru" Продажа автозапчастей типа Подвеска кабины для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FEBI BILSTEIN 16289 Ремкомплект, крепление кабины водителя
28686 Замок, кабина
35023 Опрокидывающий цилиндр, кабина
09219 Втулка, подушка кабины водителя
10780 Ремкомплект, крепление кабины водителя
27139 Опрокидывающий насос, кабина
LEMFÖRDER 11783 01 Втулка, подушка кабины водителя
PE Automotive 033.653-00A Опрокидывающий цилиндр, кабина
030.125-00A Втулка, подушка кабины водителя
ST-TEMPLIN 09.010.0908.120 Поворотный шарнир, кабина
09.010.0963.310 Опрокидывающий насос, кабина
09.010.0963.030 Опрокидывающий цилиндр, кабина
09.010.0901.190 Втулка, подушка кабины водителя
09.010.0990.270 Поворотный шарнир, кабина
09.010.0917.288 Ремкомплект, крепление кабины водителя
09.010.0990.250 Поворотный шарнир, кабина
09.010.0917.208 Ремкомплект, крепление кабины водителя
09.010.0990.380 Поворотный шарнир, кабина
09.010.0918.208 Ремкомплект, крепление кабины водителя
04.110.0908.300 Поворотный шарнир, кабина
2026 CATCAR.INFO (v 2.0)