#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0N3x8bW9kZWxfaWQ9PTgyNjB8fG1kZl9pZD09MF4zMzEzNXx8c3BhcmVfaWQ9PTEwMDM3MQ%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 articlepassengercars av JOIN passengercarlinkageattributes_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 = "33135" AND ( (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "KB-SL10F" AND av.ProductID IN (1626)) OR (av.SupplierID = 85 AND av.DataSupplierArticleNumber = "SM1005" AND av.ProductID IN (1632)) OR (av.SupplierID = 85 AND av.DataSupplierArticleNumber = "SM5850" AND av.ProductID IN (1180)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "MK408" AND av.ProductID IN (1180)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "H489I19" AND av.ProductID IN (1180)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "70969/2" AND av.ProductID IN (1632)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "70968" AND av.ProductID IN (1626)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "70969" AND av.ProductID IN (1632)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "70967" AND av.ProductID IN (1180)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PSE4412" AND av.ProductID IN (1626)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "EMR4935" AND av.ProductID IN (1180)) ) 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 = 4674 AND aa.DataSupplierArticleNumber = "KB-SL10F") OR (aa.SupplierID = 85 AND aa.DataSupplierArticleNumber = "SM1005") OR (aa.SupplierID = 85 AND aa.DataSupplierArticleNumber = "SM5850") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "MK408") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "H489I19") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "70969/2") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "70968") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "70969") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "70967") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PSE4412") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMR4935") ) 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 = 4674 AND aa.DataSupplierArticleNumber = "KB-SL10F") OR (aa.SupplierID = 85 AND aa.DataSupplierArticleNumber = "SM1005") OR (aa.SupplierID = 85 AND aa.DataSupplierArticleNumber = "SM5850") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "MK408") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "H489I19") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "70969/2") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "70968") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "70969") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "70967") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PSE4412") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMR4935") ) AND aa.Language = "ru" Продажа автозапчастей типа Подвеска амортизатора/стойка амортизатора для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FEBEST KB-SL10F Подшипник качения, опора стойки амортизатора
KYB SM1005 Ремкомплект, опора стойки амортизатора
SM5850 Опора стойки амортизатора
MONROE MK408 Опора стойки амортизатора
NPS H489I19 Опора стойки амортизатора
ORIGINAL IMPERIUM 70969/2 Ремкомплект, опора стойки амортизатора
70968 Подшипник качения, опора стойки амортизатора
70969 Ремкомплект, опора стойки амортизатора
70967 Опора стойки амортизатора
PATRON PSE4412 Подшипник качения, опора стойки амортизатора
QUINTON HAZELL EMR4935 Опора стойки амортизатора
2026 CATCAR.INFO (v 2.0)