#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTM0Mzl8fG1kZl9pZD09MF44MDUyfHxzcGFyZV9pZD09MTAwODAz&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 = "8052" AND ( (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "910170" AND av.ProductID IN (2065)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "911120" AND av.ProductID IN (2065)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BHN213" AND av.ProductID IN (2065)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "951005" AND av.ProductID IN (2065)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "02160" AND av.ProductID IN (2065)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FHN213" AND av.ProductID IN (2065)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "02609" AND av.ProductID IN (2065)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T402609" AND av.ProductID IN (2065)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "104 456" AND av.ProductID IN (2065)) ) 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 = 206 AND aa.DataSupplierArticleNumber = "910170") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "911120") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BHN213") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "951005") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "02160") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FHN213") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "02609") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T402609") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "104 456") ) 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 = 206 AND aa.DataSupplierArticleNumber = "910170") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "911120") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BHN213") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "951005") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "02160") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FHN213") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "02609") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T402609") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "104 456") ) AND aa.Language = "ru" Продажа автозапчастей типа Шейка оси для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
A.B.S. 910170 Гайка, шейка оси
911120 Гайка, шейка оси
BORG & BECK BHN213 Гайка, шейка оси
CAUTEX 951005 Гайка, шейка оси
FEBI BILSTEIN 02160 Гайка, шейка оси
FIRST LINE FHN213 Гайка, шейка оси
Metalcaucho 02609 Гайка, шейка оси
STC T402609 Гайка, шейка оси
TOPRAN 104 456 Гайка, шейка оси
2026 CATCAR.INFO (v 2.0)