#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTY5ODh8fG1kZl9pZD09MF4yNTUwNnx8c3BhcmVfaWQ9PTEwMDU3OA%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 = "25506" AND ( (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "201409" AND av.ProductID IN (653)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADV188202C" AND av.ProductID IN (654)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "14128" AND av.ProductID IN (653)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "13748" AND av.ProductID IN (653)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "1782-Q5R" AND av.ProductID IN (653)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "30271" AND av.ProductID IN (654)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "45996" AND av.ProductID IN (653)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "36650" AND av.ProductID IN (654)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "WHB73197" AND av.ProductID IN (653)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1151402700" AND av.ProductID IN (653)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "5500153" AND av.ProductID IN (653)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "90132" AND av.ProductID IN (653)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "90135" AND av.ProductID IN (653)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 650 0011" AND av.ProductID IN (653)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T490135" AND av.ProductID IN (653)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T490132" AND av.ProductID IN (653)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 4823" AND av.ProductID IN (654)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 6650" AND av.ProductID IN (654)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 0271" AND av.ProductID IN (654)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 94 5996" AND av.ProductID IN (653)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "115 429" AND av.ProductID IN (653)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "903645" AND av.ProductID IN (653)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.31.274" AND av.ProductID IN (653)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-3739" AND av.ProductID IN (653)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "RL-1160" AND av.ProductID IN (653)) ) 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 = "201409") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADV188202C") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "14128") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13748") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "1782-Q5R") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "30271") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "45996") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "36650") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "WHB73197") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1151402700") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "5500153") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "90132") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "90135") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 650 0011") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T490135") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T490132") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 4823") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 6650") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 0271") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 94 5996") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 429") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "903645") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.31.274") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3739") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "RL-1160") ) 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 = "201409") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADV188202C") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "14128") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13748") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "1782-Q5R") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "30271") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "45996") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "36650") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "WHB73197") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1151402700") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "5500153") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "90132") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "90135") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 650 0011") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T490135") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T490132") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 4823") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 6650") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 0271") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 94 5996") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 429") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "903645") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.31.274") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3739") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "RL-1160") ) AND aa.Language = "ru" Продажа автозапчастей типа Ступица колеса для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
A.B.S. 201409 Ступица колеса
BLUE PRINT ADV188202C Комплект подшипника ступицы колеса
FARE SA 14128 Ступица колеса
13748 Ступица колеса
FEBEST 1782-Q5R Ступица колеса
FEBI BILSTEIN 30271 Комплект подшипника ступицы колеса
45996 Ступица колеса
36650 Комплект подшипника ступицы колеса
FENOX WHB73197 Ступица колеса
JP GROUP 1151402700 Ступица колеса
KAMOKA 5500153 Ступица колеса
Metalcaucho 90132 Ступица колеса
90135 Ступица колеса
MEYLE 100 650 0011 Ступица колеса
STC T490135 Ступица колеса
T490132 Ступица колеса
SWAG 30 93 4823 Комплект подшипника ступицы колеса
30 93 6650 Комплект подшипника ступицы колеса
30 93 0271 Комплект подшипника ступицы колеса
30 94 5996 Ступица колеса
TOPRAN 115 429 Ступица колеса
TRICLO 903645 Ступица колеса
TRUCKTEC AUTOMOTIVE 07.31.274 Ступица колеса
VAICO V10-3739 Ступица колеса
ZEKKERT RL-1160 Ступица колеса
2026 CATCAR.INFO (v 2.0)