#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUzOXx8bW9kZWxfaWQ9PTk1Mjd8fG1kZl9pZD09MF4zNDQ5M3x8c3BhcmVfaWQ9PTEwMjk2NA%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 = "34493" AND ( (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "LY1333" AND av.ProductID IN (1337)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT32315" AND av.ProductID IN (1537)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT32395" AND av.ProductID IN (1337)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT32316" AND av.ProductID IN (1537)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "105-0839" AND av.ProductID IN (1337)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVBS823" AND av.ProductID IN (1419)) OR (av.SupplierID = 400 AND av.DataSupplierArticleNumber = "RA20300" AND av.ProductID IN (1419)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8105 152560" AND av.ProductID IN (1337)) ) 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 = 89 AND aa.DataSupplierArticleNumber = "LY1333") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT32315") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT32395") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT32316") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "105-0839") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVBS823") OR (aa.SupplierID = 400 AND aa.DataSupplierArticleNumber = "RA20300") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8105 152560") ) 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 = 89 AND aa.DataSupplierArticleNumber = "LY1333") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT32315") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT32395") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT32316") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "105-0839") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVBS823") OR (aa.SupplierID = 400 AND aa.DataSupplierArticleNumber = "RA20300") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8105 152560") ) AND aa.Language = "ru" Продажа автозапчастей типа Стояночный тормоз для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DELPHI LY1333 Комплектующие, стояночная тормозная система
FAST FT32315 Комплект тормозных башмаков, барабанные тормоза
FT32395 Комплектующие, стояночная тормозная система
FT32316 Комплект тормозных башмаков, барабанные тормоза
KAWE 105-0839 Комплектующие, стояночная тормозная система
MOTAQUIP LVBS823 Комплект тормозных колодок, стояночная тормозная система
RAICAM RA20300 Комплект тормозных колодок, стояночная тормозная система
TRISCAN 8105 152560 Комплектующие, стояночная тормозная система
2026 CATCAR.INFO (v 2.0)