#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTU0MjJ8fG1kZl9pZD09MV4xMTA2OXx8c3BhcmVfaWQ9PTIwMDQ2NA%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 = "11069" AND ( (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "23193 01" AND av.ProductID IN (273)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "23194 01" AND av.ProductID IN (273)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "MN-RK-8723" AND av.ProductID IN (2473)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "MN-DL-9381" AND av.ProductID IN (273)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "033.076-00A" AND av.ProductID IN (273)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-130206" AND av.ProductID IN (3203)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-130207" AND av.ProductID IN (772)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "095.473" AND av.ProductID IN (273)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "095.474" AND av.ProductID IN (273)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "84-08152-SX" AND av.ProductID IN (251)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JRK0028" AND av.ProductID IN (2473)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JRR0168" AND av.ProductID IN (273)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JRR0217" AND av.ProductID IN (273)) ) 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 = 35 AND aa.DataSupplierArticleNumber = "23193 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "23194 01") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "MN-RK-8723") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "MN-DL-9381") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "033.076-00A") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-130206") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-130207") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "095.473") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "095.474") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-08152-SX") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRK0028") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRR0168") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRR0217") ) 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 = 35 AND aa.DataSupplierArticleNumber = "23193 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "23194 01") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "MN-RK-8723") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "MN-DL-9381") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "033.076-00A") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-130206") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-130207") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "095.473") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "095.474") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-08152-SX") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRK0028") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRR0168") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRR0217") ) AND aa.Language = "ru" Продажа автозапчастей типа Рычаг независимой подвески колеса для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
LEMFÖRDER 23193 01 Рычаг независимой подвески колеса, подвеска колеса
23194 01 Рычаг независимой подвески колеса, подвеска колеса
MOOG MN-RK-8723 ремонтный комплект, рычаг подвески
MN-DL-9381 Рычаг независимой подвески колеса, подвеска колеса
PE Automotive 033.076-00A Рычаг независимой подвески колеса, подвеска колеса
S-TR STR-130206 Ремкомплект, центральный шарнир - треугольный рычаг
STR-130207 Ремкомплект, поперечный рычаг подвески
SAMPA 095.473 Рычаг независимой подвески колеса, подвеска колеса
095.474 Рычаг независимой подвески колеса, подвеска колеса
STELLOX 84-08152-SX Подвеска, рычаг независимой подвески колеса
TRW JRK0028 ремонтный комплект, рычаг подвески
JRR0168 Рычаг независимой подвески колеса, подвеска колеса
JRR0217 Рычаг независимой подвески колеса, подвеска колеса
2026 CATCAR.INFO (v 2.0)