#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUzOXx8bW9kZWxfaWQ9PTM0MjF8fG1kZl9pZD09MV4xNTU5fHxzcGFyZV9pZD09MjAwMTA5&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 = "1559" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "15340" AND av.ProductID IN (1226)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "096.253" AND av.ProductID IN (412)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "096.320" AND av.ProductID IN (412)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "03.150.8711.010" AND av.ProductID IN (672)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "03.150.8710.170" AND av.ProductID IN (412)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "03.150.8710.110" AND av.ProductID IN (412)) OR (av.SupplierID = 22 AND av.DataSupplierArticleNumber = "899 760 510 4" AND av.ProductID IN (1226)) OR (av.SupplierID = 22 AND av.DataSupplierArticleNumber = "441 032 591 0" AND av.ProductID IN (412)) ) 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 = "15340") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "096.253") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "096.320") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.150.8711.010") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.150.8710.170") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.150.8710.110") OR (aa.SupplierID = 22 AND aa.DataSupplierArticleNumber = "899 760 510 4") OR (aa.SupplierID = 22 AND aa.DataSupplierArticleNumber = "441 032 591 0") ) 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 = "15340") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "096.253") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "096.320") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.150.8711.010") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.150.8710.170") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.150.8710.110") OR (aa.SupplierID = 22 AND aa.DataSupplierArticleNumber = "899 760 510 4") OR (aa.SupplierID = 22 AND aa.DataSupplierArticleNumber = "441 032 591 0") ) AND aa.Language = "ru" Продажа автозапчастей типа Регулировка динамики движения для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FEBI BILSTEIN 15340 Зажимная гильза, датчик частоты вращения колеса
SAMPA 096.253 Датчик, частота вращения колеса
096.320 Датчик, частота вращения колеса
ST-TEMPLIN 03.150.8711.010 Соединительный кабель ABS
03.150.8710.170 Датчик, частота вращения колеса
03.150.8710.110 Датчик, частота вращения колеса
WABCO 899 760 510 4 Зажимная гильза, датчик частоты вращения колеса
441 032 591 0 Датчик, частота вращения колеса
2026 CATCAR.INFO (v 2.0)