#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxMXx8bW9kZWxfaWQ9PTUwODV8fG1kZl9pZD09MF4zMTAxMnx8c3BhcmVfaWQ9PTEwMDU3OA%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 = "31012" AND ( (av.SupplierID = 4631 AND av.DataSupplierArticleNumber = "BMWH-E83F" AND av.ProductID IN (653)) OR (av.SupplierID = 4631 AND av.DataSupplierArticleNumber = "BMWH-E83R" AND av.ProductID IN (653)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "H5B007BTA" AND av.ProductID IN (653)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "H5B008BTA" AND av.ProductID IN (653)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "14133" AND av.ProductID IN (653)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "14132" AND av.ProductID IN (653)) OR (av.SupplierID = 4727 AND av.DataSupplierArticleNumber = "12498049/S" AND av.ProductID IN (653)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "10-2007" AND av.ProductID IN (653)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "90140" AND av.ProductID IN (653)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "90139" AND av.ProductID IN (653)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "300 312 1112" AND av.ProductID IN (653)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T490139" AND av.ProductID IN (653)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T490140" AND av.ProductID IN (653)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "502 477" AND av.ProductID IN (653)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "502 478" AND av.ProductID IN (653)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "902043" AND av.ProductID IN (653)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "902042" AND av.ProductID IN (653)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V20-2700" AND av.ProductID IN (653)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V20-2699" 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 = 4631 AND aa.DataSupplierArticleNumber = "BMWH-E83F") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "BMWH-E83R") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H5B007BTA") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H5B008BTA") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "14133") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "14132") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "12498049/S") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-2007") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "90140") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "90139") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "300 312 1112") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T490139") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T490140") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "502 477") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "502 478") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "902043") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "902042") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V20-2700") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V20-2699") ) 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 = 4631 AND aa.DataSupplierArticleNumber = "BMWH-E83F") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "BMWH-E83R") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H5B007BTA") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H5B008BTA") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "14133") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "14132") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "12498049/S") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-2007") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "90140") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "90139") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "300 312 1112") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T490139") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T490140") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "502 477") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "502 478") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "902043") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "902042") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V20-2700") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V20-2699") ) AND aa.Language = "ru" Продажа автозапчастей типа Ступица колеса для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ASVA BMWH-E83F Ступица колеса
BMWH-E83R Ступица колеса
BTA H5B007BTA Ступица колеса
H5B008BTA Ступица колеса
FARE SA 14133 Ступица колеса
14132 Ступица колеса
FORMPART 12498049/S Ступица колеса
IJS GROUP 10-2007 Ступица колеса
Metalcaucho 90140 Ступица колеса
90139 Ступица колеса
MEYLE 300 312 1112 Ступица колеса
STC T490139 Ступица колеса
T490140 Ступица колеса
TOPRAN 502 477 Ступица колеса
502 478 Ступица колеса
TRICLO 902043 Ступица колеса
902042 Ступица колеса
VAICO V20-2700 Ступица колеса
V20-2699 Ступица колеса
2026 CATCAR.INFO (v 2.0)