#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3NXx8bW9kZWxfaWQ9PTUxMjB8fG1kZl9pZD09MF4zMTU5Mnx8c3BhcmVfaWQ9PTEwMDc3Mg%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 = "31592" AND ( (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B12271" AND av.ProductID IN (249)) OR (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B12270" AND av.ProductID IN (249)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-700-094" AND av.ProductID IN (249)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "80001235" AND av.ProductID IN (249)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "22724" AND av.ProductID IN (249)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "22766" AND av.ProductID IN (249)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "516544" AND av.ProductID IN (249)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1132406300" AND av.ProductID IN (249)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "ME-1297" AND av.ProductID IN (249)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "32 92 2724" AND av.ProductID IN (249)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "32 92 2766" AND av.ProductID IN (249)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "110 128" AND av.ProductID IN (249)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "114 321" AND av.ProductID IN (249)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "31990382701" AND av.ProductID IN (249)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "31990382901" AND av.ProductID IN (249)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "41991337501" AND av.ProductID IN (249)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1392552" AND av.ProductID IN (249)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1392555" AND av.ProductID IN (249)) ) 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 = 4815 AND aa.DataSupplierArticleNumber = "B12271") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B12270") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-700-094") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "80001235") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "22724") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "22766") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "516544") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1132406300") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "ME-1297") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 2724") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 2766") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "110 128") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "114 321") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "31990382701") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "31990382901") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "41991337501") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1392552") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1392555") ) 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 = 4815 AND aa.DataSupplierArticleNumber = "B12271") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B12270") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-700-094") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "80001235") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "22724") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "22766") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "516544") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1132406300") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "ME-1297") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 2724") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 2766") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "110 128") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "114 321") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "31990382701") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "31990382901") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "41991337501") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1392552") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1392555") ) AND aa.Language = "ru" Продажа автозапчастей типа Подвеска для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
Borsehung B12271 Подвеска, ступенчатая коробка передач
B12270 Подвеска, ступенчатая коробка передач
BSG BSG 90-700-094 Подвеска, ступенчатая коробка передач
CORTECO 80001235 Подвеска, ступенчатая коробка передач
FEBI BILSTEIN 22724 Подвеска, ступенчатая коробка передач
22766 Подвеска, ступенчатая коробка передач
GSP 516544 Подвеска, ступенчатая коробка передач
JP GROUP 1132406300 Подвеска, ступенчатая коробка передач
LYNXauto ME-1297 Подвеска, ступенчатая коробка передач
SWAG 32 92 2724 Подвеска, ступенчатая коробка передач
32 92 2766 Подвеска, ступенчатая коробка передач
TOPRAN 110 128 Подвеска, ступенчатая коробка передач
114 321 Подвеска, ступенчатая коробка передач
vika 31990382701 Подвеска, ступенчатая коробка передач
31990382901 Подвеска, ступенчатая коробка передач
41991337501 Подвеска, ступенчатая коробка передач
WILMINK GROUP WG1392552 Подвеска, ступенчатая коробка передач
WG1392555 Подвеска, ступенчатая коробка передач
2026 CATCAR.INFO (v 2.0)