#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTE5fHxtZGZfaWQ9PTBeMTM4Nnx8c3BhcmVfaWQ9PTEwMDIxMw%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 = "1386" AND ( (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "83038" AND av.ProductID IN (2070)) OR (av.SupplierID = 157 AND av.DataSupplierArticleNumber = "BSP21124" AND av.ProductID IN (2070)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "460927" AND av.ProductID IN (2070)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "27056" AND av.ProductID IN (2070)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "46632" AND av.ProductID IN (2070)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "09801" AND av.ProductID IN (2070)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1160400500" AND av.ProductID IN (2070)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "119007" AND av.ProductID IN (657)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "49-0786" AND av.ProductID IN (2070)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "99 90 9801" AND av.ProductID IN (2070)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 92 7056" AND av.ProductID IN (2070)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "111 477" AND av.ProductID IN (2070)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "334352" AND av.ProductID IN (657)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-3211" AND av.ProductID IN (2070)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "56010045901" AND av.ProductID IN (2070)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "56010046001" AND av.ProductID IN (2070)) ) 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 = 4598 AND aa.DataSupplierArticleNumber = "83038") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP21124") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "460927") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "27056") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "46632") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09801") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1160400500") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "119007") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "49-0786") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "99 90 9801") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 7056") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "111 477") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "334352") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3211") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "56010045901") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "56010046001") ) 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 = 4598 AND aa.DataSupplierArticleNumber = "83038") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP21124") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "460927") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "27056") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "46632") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09801") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1160400500") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "119007") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "49-0786") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "99 90 9801") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 7056") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "111 477") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "334352") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3211") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "56010045901") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "56010046001") ) AND aa.Language = "ru" Продажа автозапчастей типа Колесо / крепление колеса для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
3RG 83038 Болт для крепления колеса
BUGIAD BSP21124 Болт для крепления колеса
CAUTEX 460927 Болт для крепления колеса
FEBI BILSTEIN 27056 Болт для крепления колеса
46632 Болт для крепления колеса
09801 Болт для крепления колеса
JP GROUP 1160400500 Болт для крепления колеса
MALÒ 119007 Болт крепления колеса
MAXGEAR 49-0786 Болт для крепления колеса
SWAG 99 90 9801 Болт для крепления колеса
30 92 7056 Болт для крепления колеса
TOPRAN 111 477 Болт для крепления колеса
TRICLO 334352 Болт крепления колеса
VAICO V10-3211 Болт для крепления колеса
vika 56010045901 Болт для крепления колеса
56010046001 Болт для крепления колеса
2026 CATCAR.INFO (v 2.0)