#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4Nnx8bW9kZWxfaWQ9PTYzOTB8fG1kZl9pZD09MF4xMDI3NHx8c3BhcmVfaWQ9PTEwMDExMw%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 = "10274" AND ( (av.SupplierID = 467 AND av.DataSupplierArticleNumber = "14.871.675" AND av.ProductID IN (188)) OR (av.SupplierID = 467 AND av.DataSupplierArticleNumber = "14.871.677" AND av.ProductID IN (188)) OR (av.SupplierID = 467 AND av.DataSupplierArticleNumber = "14.871.660" AND av.ProductID IN (188)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "9986552" AND av.ProductID IN (188)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "99958184" AND av.ProductID IN (189)) OR (av.SupplierID = 112 AND av.DataSupplierArticleNumber = "F11-84-010-01-VA" AND av.ProductID IN (188)) OR (av.SupplierID = 112 AND av.DataSupplierArticleNumber = "E10-84-012-01-22" AND av.ProductID IN (189)) OR (av.SupplierID = 112 AND av.DataSupplierArticleNumber = "F11-35-017-01-HA" AND av.ProductID IN (188)) OR (av.SupplierID = 176 AND av.DataSupplierArticleNumber = "66041" AND av.ProductID IN (188)) OR (av.SupplierID = 85 AND av.DataSupplierArticleNumber = "RA6660" AND av.ProductID IN (188)) OR (av.SupplierID = 85 AND av.DataSupplierArticleNumber = "RA6662" AND av.ProductID IN (188)) OR (av.SupplierID = 85 AND av.DataSupplierArticleNumber = "RH3053" AND av.ProductID IN (188)) OR (av.SupplierID = 175 AND av.DataSupplierArticleNumber = "4295859" AND av.ProductID IN (188)) OR (av.SupplierID = 4764 AND av.DataSupplierArticleNumber = "MC6552" AND av.ProductID IN (188)) OR (av.SupplierID = 4764 AND av.DataSupplierArticleNumber = "10128184" AND av.ProductID IN (189)) OR (av.SupplierID = 4764 AND av.DataSupplierArticleNumber = "MC6555" AND av.ProductID IN (188)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "SP4116" AND av.ProductID IN (188)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "SP4117" AND av.ProductID IN (188)) OR (av.SupplierID = 401 AND av.DataSupplierArticleNumber = "CS7478" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "994 826" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "993 772" AND av.ProductID IN (188)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "994 825" AND av.ProductID IN (188)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "87564" AND av.ProductID IN (188)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "87560" AND av.ProductID IN (188)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "87561" AND av.ProductID IN (188)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "10-22438-SX" AND av.ProductID IN (188)) OR (av.SupplierID = 390 AND av.DataSupplierArticleNumber = "38145" AND av.ProductID IN (188)) OR (av.SupplierID = 390 AND av.DataSupplierArticleNumber = "38137" AND av.ProductID IN (188)) OR (av.SupplierID = 390 AND av.DataSupplierArticleNumber = "38139" AND av.ProductID IN (188)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8750 2781" AND av.ProductID IN (188)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8750 2788" AND av.ProductID IN (188)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8750 2790" AND av.ProductID IN (188)) OR (av.SupplierID = 51 AND av.DataSupplierArticleNumber = "407405500001" AND av.ProductID IN (1717)) ) 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 = 467 AND aa.DataSupplierArticleNumber = "14.871.675") OR (aa.SupplierID = 467 AND aa.DataSupplierArticleNumber = "14.871.677") OR (aa.SupplierID = 467 AND aa.DataSupplierArticleNumber = "14.871.660") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "9986552") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "99958184") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "F11-84-010-01-VA") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "E10-84-012-01-22") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "F11-35-017-01-HA") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "66041") OR (aa.SupplierID = 85 AND aa.DataSupplierArticleNumber = "RA6660") OR (aa.SupplierID = 85 AND aa.DataSupplierArticleNumber = "RA6662") OR (aa.SupplierID = 85 AND aa.DataSupplierArticleNumber = "RH3053") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "4295859") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "MC6552") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "10128184") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "MC6555") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "SP4116") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "SP4117") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "CS7478") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "994 826") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "993 772") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "994 825") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "87564") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "87560") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "87561") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "10-22438-SX") OR (aa.SupplierID = 390 AND aa.DataSupplierArticleNumber = "38145") OR (aa.SupplierID = 390 AND aa.DataSupplierArticleNumber = "38137") OR (aa.SupplierID = 390 AND aa.DataSupplierArticleNumber = "38139") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8750 2781") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8750 2788") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8750 2790") OR (aa.SupplierID = 51 AND aa.DataSupplierArticleNumber = "407405500001") ) 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 = 467 AND aa.DataSupplierArticleNumber = "14.871.675") OR (aa.SupplierID = 467 AND aa.DataSupplierArticleNumber = "14.871.677") OR (aa.SupplierID = 467 AND aa.DataSupplierArticleNumber = "14.871.660") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "9986552") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "99958184") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "F11-84-010-01-VA") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "E10-84-012-01-22") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "F11-35-017-01-HA") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "66041") OR (aa.SupplierID = 85 AND aa.DataSupplierArticleNumber = "RA6660") OR (aa.SupplierID = 85 AND aa.DataSupplierArticleNumber = "RA6662") OR (aa.SupplierID = 85 AND aa.DataSupplierArticleNumber = "RH3053") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "4295859") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "MC6552") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "10128184") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "MC6555") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "SP4116") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "SP4117") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "CS7478") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "994 826") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "993 772") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "994 825") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "87564") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "87560") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "87561") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "10-22438-SX") OR (aa.SupplierID = 390 AND aa.DataSupplierArticleNumber = "38145") OR (aa.SupplierID = 390 AND aa.DataSupplierArticleNumber = "38137") OR (aa.SupplierID = 390 AND aa.DataSupplierArticleNumber = "38139") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8750 2781") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8750 2788") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8750 2790") OR (aa.SupplierID = 51 AND aa.DataSupplierArticleNumber = "407405500001") ) AND aa.Language = "ru" Продажа автозапчастей типа Подвеска для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
CS Germany 14.871.675 Пружина ходовой части
14.871.677 Пружина ходовой части
14.871.660 Пружина ходовой части
DIEDERICHS 9986552 Пружина ходовой части
99958184 Комплект ходовой части, пружины
EIBACH F11-84-010-01-VA Пружина ходовой части
E10-84-012-01-22 Комплект ходовой части, пружины
F11-35-017-01-HA Пружина ходовой части
KILEN 66041 Пружина ходовой части
KYB RA6660 Пружина ходовой части
RA6662 Пружина ходовой части
RH3053 Пружина ходовой части
LESJÖFORS 4295859 Пружина ходовой части
MAXTRAC MC6552 Пружина ходовой части
10128184 Комплект ходовой части, пружины
MC6555 Пружина ходовой части
MONROE SP4116 Пружина ходовой части
SP4117 Пружина ходовой части
ROC CS7478 Пружина ходовой части
SACHS 994 826 Пружина ходовой части
993 772 Пружина ходовой части
994 825 Пружина ходовой части
SPIDAN 87564 Пружина ходовой части
87560 Пружина ходовой части
87561 Пружина ходовой части
STELLOX 10-22438-SX Пружина ходовой части
SUPLEX 38145 Пружина ходовой части
38137 Пружина ходовой части
38139 Пружина ходовой части
TRISCAN 8750 2781 Пружина ходовой части
8750 2788 Пружина ходовой части
8750 2790 Пружина ходовой части
WESTFALIA 407405500001 Дополнительная рессора
2026 CATCAR.INFO (v 2.0)