#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxMXx8bW9kZWxfaWQ9PTk2MjB8fG1kZl9pZD09MF4xNjk5Nnx8c3BhcmVfaWQ9PTEwMDc2MQ%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 = "16996" AND ( (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "271703" AND av.ProductID IN (1614)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "26643" AND av.ProductID IN (1614)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "37698 01" AND av.ProductID IN (1614)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "37699 01" AND av.ProductID IN (1614)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "20 92 6643" AND av.ProductID IN (1614)) ) 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 = 206 AND aa.DataSupplierArticleNumber = "271703") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26643") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "37698 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "37699 01") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "20 92 6643") ) 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 = 206 AND aa.DataSupplierArticleNumber = "271703") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26643") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "37698 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "37699 01") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "20 92 6643") ) AND aa.Language = "ru" Продажа автозапчастей типа Балка моста/надрамник для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
A.B.S. 271703 Втулка, балка моста
FEBI BILSTEIN 26643 Втулка, балка моста
LEMFÖRDER 37698 01 Втулка, балка моста
37699 01 Втулка, балка моста
SWAG 20 92 6643 Втулка, балка моста
2026 CATCAR.INFO (v 2.0)