#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTUwODJ8fG1kZl9pZD09MV4xMzA3M3x8c3BhcmVfaWQ9PTIwMDMwMQ%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 = "13073" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "101276" AND av.ProductID IN (234)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "101822" AND av.ProductID IN (234)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "6284 605 065" AND av.ProductID IN (234)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "6284 605 064" AND av.ProductID IN (234)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "202.078" AND av.ProductID IN (234)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "096.412" AND av.ProductID IN (234)) ) 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 = "101276") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "101822") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "6284 605 065") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "6284 605 064") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "202.078") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "096.412") ) 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 = "101276") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "101822") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "6284 605 065") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "6284 605 064") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "202.078") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "096.412") ) AND aa.Language = "ru" Продажа автозапчастей типа Основной цилиндр для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FEBI BILSTEIN 101276 Главный цилиндр, система сцепления
101822 Главный цилиндр, система сцепления
SACHS 6284 605 065 Главный цилиндр, система сцепления
6284 605 064 Главный цилиндр, система сцепления
SAMPA 202.078 Главный цилиндр, система сцепления
096.412 Главный цилиндр, система сцепления
2026 CATCAR.INFO (v 2.0)