#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUzOXx8bW9kZWxfaWQ9PTM4NzR8fG1kZl9pZD09MV4xMjcxMHx8c3BhcmVfaWQ9PTIwMDAyNQ%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 = "12710" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "45146" AND av.ProductID IN (523)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "44591" AND av.ProductID IN (523)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "28001" AND av.ProductID IN (3243)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "35514" AND av.ProductID IN (608)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-90803" AND av.ProductID IN (5050)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "TEQ-03.010" AND av.ProductID IN (608)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-120133" AND av.ProductID IN (3243)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.515" AND av.ProductID IN (3216)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.291" AND av.ProductID IN (608)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.572" AND av.ProductID IN (4066)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.140" AND av.ProductID IN (3243)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.033" AND av.ProductID IN (3243)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.280" AND av.ProductID IN (523)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.516" AND av.ProductID IN (3216)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.574" AND av.ProductID IN (4067)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.248" AND av.ProductID IN (3243)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.034" AND av.ProductID IN (3243)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.281" AND av.ProductID IN (523)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.027" AND av.ProductID IN (3243)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.507" AND av.ProductID IN (3216)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "061.399" AND av.ProductID IN (5050)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.290" AND av.ProductID IN (608)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.039" AND av.ProductID IN (3243)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.030" AND av.ProductID IN (3243)) OR (av.SupplierID = 4614 AND av.DataSupplierArticleNumber = "9404" AND av.ProductID IN (608)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "09.010.0802.500" AND av.ProductID IN (3243,3243)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "09.010.0868.300" AND av.ProductID IN (608,608)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-50632-SX" AND av.ProductID IN (608)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "37 93 5514" AND av.ProductID IN (608)) ) 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 = "45146") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44591") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "28001") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "35514") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-90803") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "TEQ-03.010") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-120133") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.515") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.291") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.572") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.140") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.033") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.280") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.516") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.574") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.248") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.034") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.281") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.027") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.507") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "061.399") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.290") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.039") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.030") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "9404") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0802.500") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0868.300") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-50632-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "37 93 5514") ) 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 = "45146") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44591") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "28001") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "35514") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-90803") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "TEQ-03.010") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-120133") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.515") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.291") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.572") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.140") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.033") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.280") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.516") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.574") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.248") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.034") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.281") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.027") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.507") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "061.399") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.290") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.039") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.030") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "9404") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0802.500") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0868.300") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-50632-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "37 93 5514") ) AND aa.Language = "ru" Продажа автозапчастей типа Подвеска кабины для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FEBI BILSTEIN 45146 Опрокидывающий цилиндр, кабина
44591 Опрокидывающий цилиндр, кабина
28001 Втулка, подушка кабины водителя
35514 Опрокидывающий насос, кабина
S-TR STR-90803 Шарнирный кронштейн, стойка амортизатора (кабина водителя)
TEQ-03.010 Опрокидывающий насос, кабина
STR-120133 Втулка, подушка кабины водителя
SAMPA 060.515 Ремкомплект, стабилизатор кабины водителя
060.291 Опрокидывающий насос, кабина
060.572 Ремонтный комплект, опрокидывающий цилиндр
060.140 Втулка, подушка кабины водителя
060.033 Втулка, подушка кабины водителя
060.280 Опрокидывающий цилиндр, кабина
060.516 Ремкомплект, стабилизатор кабины водителя
060.574 Ремонтный комплект, опрокидывающий насос
060.248 Втулка, подушка кабины водителя
060.034 Втулка, подушка кабины водителя
060.281 Опрокидывающий цилиндр, кабина
060.027 Втулка, подушка кабины водителя
060.507 Ремкомплект, стабилизатор кабины водителя
061.399 Шарнирный кронштейн, стойка амортизатора (кабина водителя)
060.290 Опрокидывающий насос, кабина
060.039 Втулка, подушка кабины водителя
060.030 Втулка, подушка кабины водителя
SEM LASTIK 9404 Опрокидывающий насос, кабина
ST-TEMPLIN 09.010.0802.500 Втулка, подушка кабины водителя
09.010.0868.300 Опрокидывающий насос, кабина
STELLOX 87-50632-SX Опрокидывающий насос, кабина
SWAG 37 93 5514 Опрокидывающий насос, кабина
2026 CATCAR.INFO (v 2.0)