#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUzOXx8bW9kZWxfaWQ9PTM0MjF8fG1kZl9pZD09MV4yNDA2fHxzcGFyZV9pZD09MjAwNDY0&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 = "2406" AND ( (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BCA32415" AND av.ProductID IN (273)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BBJ32325K" AND av.ProductID IN (2473)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BSK32324" AND av.ProductID IN (2473)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BCA32377" AND av.ProductID IN (273)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "NR1000" AND av.ProductID IN (273)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "NS1001" AND av.ProductID IN (273)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "39391" AND av.ProductID IN (273)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "11732 02" AND av.ProductID IN (273)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "23049 01" AND av.ProductID IN (273)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "DF-RK-8503" AND av.ProductID IN (2473)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "IV-DL-8613" AND av.ProductID IN (273)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "IV-VB-8146" AND av.ProductID IN (273)) OR (av.SupplierID = 4609 AND av.DataSupplierArticleNumber = "2016079" AND av.ProductID IN (273)) OR (av.SupplierID = 4609 AND av.DataSupplierArticleNumber = "2018485" AND av.ProductID IN (273)) OR (av.SupplierID = 4609 AND av.DataSupplierArticleNumber = "2016075" AND av.ProductID IN (273)) OR (av.SupplierID = 4614 AND av.DataSupplierArticleNumber = "10795" AND av.ProductID IN (273)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "84-11713-SX" AND av.ProductID IN (273)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "84-08135-SX" AND av.ProductID IN (251)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "84-12074-SX" AND av.ProductID IN (2473)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JRR0119" AND av.ProductID IN (273)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JRK0027" AND av.ProductID IN (2473)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JVL0104" AND av.ProductID IN (273)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JRK0033" AND av.ProductID IN (2473)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JRK0036" AND av.ProductID IN (2473)) ) 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 = 475 AND aa.DataSupplierArticleNumber = "BCA32415") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BBJ32325K") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK32324") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BCA32377") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "NR1000") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "NS1001") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39391") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "11732 02") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "23049 01") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "DF-RK-8503") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "IV-DL-8613") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "IV-VB-8146") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2016079") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2018485") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2016075") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "10795") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-11713-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-08135-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-12074-SX") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRR0119") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRK0027") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JVL0104") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRK0033") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRK0036") ) 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 = 475 AND aa.DataSupplierArticleNumber = "BCA32415") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BBJ32325K") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK32324") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BCA32377") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "NR1000") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "NS1001") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39391") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "11732 02") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "23049 01") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "DF-RK-8503") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "IV-DL-8613") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "IV-VB-8146") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2016079") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2018485") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2016075") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "10795") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-11713-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-08135-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-12074-SX") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRR0119") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRK0027") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JVL0104") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRK0033") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRK0036") ) AND aa.Language = "ru" Продажа автозапчастей типа Рычаг независимой подвески колеса для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BORG & BECK BCA32415 Рычаг независимой подвески колеса, подвеска колеса
BBJ32325K ремонтный комплект, рычаг подвески
BSK32324 ремонтный комплект, рычаг подвески
BCA32377 Рычаг независимой подвески колеса, подвеска колеса
DELPHI NR1000 Рычаг независимой подвески колеса, подвеска колеса
NS1001 Рычаг независимой подвески колеса, подвеска колеса
FEBI BILSTEIN 39391 Рычаг независимой подвески колеса, подвеска колеса
LEMFÖRDER 11732 02 Рычаг независимой подвески колеса, подвеска колеса
23049 01 Рычаг независимой подвески колеса, подвеска колеса
MOOG DF-RK-8503 ремонтный комплект, рычаг подвески
IV-DL-8613 Рычаг независимой подвески колеса, подвеска колеса
IV-VB-8146 Рычаг независимой подвески колеса, подвеска колеса
ROTA 2016079 Рычаг независимой подвески колеса, подвеска колеса
2018485 Рычаг независимой подвески колеса, подвеска колеса
2016075 Рычаг независимой подвески колеса, подвеска колеса
SEM LASTIK 10795 Рычаг независимой подвески колеса, подвеска колеса
STELLOX 84-11713-SX Рычаг независимой подвески колеса, подвеска колеса
84-08135-SX Подвеска, рычаг независимой подвески колеса
84-12074-SX ремонтный комплект, рычаг подвески
TRW JRR0119 Рычаг независимой подвески колеса, подвеска колеса
JRK0027 ремонтный комплект, рычаг подвески
JVL0104 Рычаг независимой подвески колеса, подвеска колеса
JRK0033 ремонтный комплект, рычаг подвески
JRK0036 ремонтный комплект, рычаг подвески
2026 CATCAR.INFO (v 2.0)