#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTU2NDZ8fG1kZl9pZD09MV4xMzQwOXx8c3BhcmVfaWQ9PTIwMDg3MQ%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 = "13409" AND ( (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "01017059B" AND av.ProductID IN (630)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "447.080" AND av.ProductID IN (630)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "04516" AND av.ProductID IN (2755)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "011.409-00A" AND av.ProductID IN (1740)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "201.485" AND av.ProductID IN (5122)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "021.070" AND av.ProductID IN (630)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "200.378" AND av.ProductID IN (5121)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "201.472" AND av.ProductID IN (4091)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "010.848" AND av.ProductID IN (4022)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "200.386" AND av.ProductID IN (4002)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "200.417" AND av.ProductID IN (1740)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "202.035" AND av.ProductID IN (5122)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "200.389" AND av.ProductID IN (5122)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "201.473" AND av.ProductID IN (4091)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "200.381" AND av.ProductID IN (4023)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "200.387" AND av.ProductID IN (4002)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "201.484" AND av.ProductID IN (5122)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "200.383" AND av.ProductID IN (5088)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "201.475" AND av.ProductID IN (4023)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "010.804" AND av.ProductID IN (4022)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "200.069" AND av.ProductID IN (3520)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1192797" AND av.ProductID IN (630)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1220140" AND av.ProductID IN (630)) ) 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 = 140 AND aa.DataSupplierArticleNumber = "01017059B") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "447.080") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "04516") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "011.409-00A") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "201.485") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "021.070") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.378") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "201.472") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "010.848") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.386") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.417") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "202.035") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.389") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "201.473") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.381") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.387") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "201.484") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.383") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "201.475") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "010.804") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.069") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192797") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1220140") ) 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 = 140 AND aa.DataSupplierArticleNumber = "01017059B") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "447.080") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "04516") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "011.409-00A") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "201.485") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "021.070") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.378") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "201.472") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "010.848") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.386") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.417") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "202.035") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.389") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "201.473") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.381") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.387") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "201.484") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.383") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "201.475") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "010.804") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "200.069") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192797") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1220140") ) AND aa.Language = "ru" Продажа автозапчастей типа Дифференциал / детали для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
CORTECO 01017059B Уплотняющее кольцо, дифференциал
ELRING 447.080 Уплотняющее кольцо, дифференциал
FEBI BILSTEIN 04516 Резьбовая пробка, главная передача
PE Automotive 011.409-00A Гайка, коническое колесо
SAMPA 201.485 Установочное кольцо, дифференциал
021.070 Уплотняющее кольцо, дифференциал
200.378 Маслоуловитель, дифференциал
201.472 Корпус, дифференциал
010.848 Ремкомплект, дифференциал
200.386 Упорная прокладка, уравнив.конич.зубчат. колесо - дифференц.
200.417 Гайка, коническое колесо
202.035 Установочное кольцо, дифференциал
200.389 Установочное кольцо, дифференциал
201.473 Корпус, дифференциал
200.381 Комплект уравнив. конического зубчатого колеса, дифференциал
200.387 Упорная прокладка, уравнив.конич.зубчат. колесо - дифференц.
201.484 Установочное кольцо, дифференциал
200.383 Втулка, осевая шестерня (уравнив.конич.зубч. колесо-дифф.)
201.475 Комплект уравнив. конического зубчатого колеса, дифференциал
010.804 Ремкомплект, дифференциал
200.069 Подшипник, дифференциальный вал
WILMINK GROUP WG1192797 Уплотняющее кольцо, дифференциал
WG1220140 Уплотняющее кольцо, дифференциал
2026 CATCAR.INFO (v 2.0)