#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTQ3OTd8fG1kZl9pZD09MF4xNjQ2NHx8c3BhcmVfaWQ9PTEwMDM3MA%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 = "16464" AND ( (av.SupplierID = 16 AND av.DataSupplierArticleNumber = "46-188564" AND av.ProductID IN (190,190)) OR (av.SupplierID = 16 AND av.DataSupplierArticleNumber = "46-183071" AND av.ProductID IN (190,190)) OR (av.SupplierID = 16 AND av.DataSupplierArticleNumber = "48-169301" AND av.ProductID IN (190,190)) OR (av.SupplierID = 16 AND av.DataSupplierArticleNumber = "47-086852" AND av.ProductID IN (190,190)) OR (av.SupplierID = 16 AND av.DataSupplierArticleNumber = "46-188571" AND av.ProductID IN (190,190)) OR (av.SupplierID = 16 AND av.DataSupplierArticleNumber = "46-183064" AND av.ProductID IN (190,190)) OR (av.SupplierID = 16 AND av.DataSupplierArticleNumber = "47-169289" AND av.ProductID IN (190,190)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "9999126" AND av.ProductID IN (190)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "99932310" AND av.ProductID IN (190)) OR (av.SupplierID = 112 AND av.DataSupplierArticleNumber = "PSS65-15-006-07-22" AND av.ProductID IN (190)) OR (av.SupplierID = 112 AND av.DataSupplierArticleNumber = "E90-15-006-22-22" AND av.ProductID IN (190)) OR (av.SupplierID = 112 AND av.DataSupplierArticleNumber = "PSS65-15-006-08-22" AND av.ProductID IN (190)) OR (av.SupplierID = 112 AND av.DataSupplierArticleNumber = "E90-15-006-23-22" AND av.ProductID IN (190)) OR (av.SupplierID = 112 AND av.DataSupplierArticleNumber = "E90-15-006-24-22" AND av.ProductID IN (190)) OR (av.SupplierID = 112 AND av.DataSupplierArticleNumber = "E90-15-006-21-22" AND av.ProductID IN (190)) OR (av.SupplierID = 18 AND av.DataSupplierArticleNumber = "1140-3692" AND av.ProductID IN (190)) OR (av.SupplierID = 18 AND av.DataSupplierArticleNumber = "1140-3681" AND av.ProductID IN (190)) OR (av.SupplierID = 18 AND av.DataSupplierArticleNumber = "1120-3682" AND av.ProductID IN (190)) OR (av.SupplierID = 18 AND av.DataSupplierArticleNumber = "1150-5061" AND av.ProductID IN (190)) OR (av.SupplierID = 18 AND av.DataSupplierArticleNumber = "1140-3682" AND av.ProductID IN (190)) OR (av.SupplierID = 18 AND av.DataSupplierArticleNumber = "1120-3691" AND av.ProductID IN (190)) OR (av.SupplierID = 18 AND av.DataSupplierArticleNumber = "1140-3691" AND av.ProductID IN (190)) OR (av.SupplierID = 18 AND av.DataSupplierArticleNumber = "1120-3692" AND av.ProductID IN (190)) OR (av.SupplierID = 18 AND av.DataSupplierArticleNumber = "1120-3681" AND av.ProductID IN (190)) OR (av.SupplierID = 4764 AND av.DataSupplierArticleNumber = "20102310" AND av.ProductID IN (190)) OR (av.SupplierID = 4764 AND av.DataSupplierArticleNumber = "30402126" AND av.ProductID IN (190)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "123210102" AND av.ProductID IN (190)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "123210103" AND av.ProductID IN (190)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "113210057" AND av.ProductID IN (190)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "113210058" AND av.ProductID IN (190)) ) 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 = 16 AND aa.DataSupplierArticleNumber = "46-188564") OR (aa.SupplierID = 16 AND aa.DataSupplierArticleNumber = "46-183071") OR (aa.SupplierID = 16 AND aa.DataSupplierArticleNumber = "48-169301") OR (aa.SupplierID = 16 AND aa.DataSupplierArticleNumber = "47-086852") OR (aa.SupplierID = 16 AND aa.DataSupplierArticleNumber = "46-188571") OR (aa.SupplierID = 16 AND aa.DataSupplierArticleNumber = "46-183064") OR (aa.SupplierID = 16 AND aa.DataSupplierArticleNumber = "47-169289") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "9999126") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "99932310") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "PSS65-15-006-07-22") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "E90-15-006-22-22") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "PSS65-15-006-08-22") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "E90-15-006-23-22") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "E90-15-006-24-22") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "E90-15-006-21-22") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1140-3692") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1140-3681") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1120-3682") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1150-5061") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1140-3682") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1120-3691") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1140-3691") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1120-3692") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1120-3681") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "20102310") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "30402126") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "123210102") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "123210103") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "113210057") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "113210058") ) 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 = 16 AND aa.DataSupplierArticleNumber = "46-188564") OR (aa.SupplierID = 16 AND aa.DataSupplierArticleNumber = "46-183071") OR (aa.SupplierID = 16 AND aa.DataSupplierArticleNumber = "48-169301") OR (aa.SupplierID = 16 AND aa.DataSupplierArticleNumber = "47-086852") OR (aa.SupplierID = 16 AND aa.DataSupplierArticleNumber = "46-188571") OR (aa.SupplierID = 16 AND aa.DataSupplierArticleNumber = "46-183064") OR (aa.SupplierID = 16 AND aa.DataSupplierArticleNumber = "47-169289") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "9999126") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "99932310") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "PSS65-15-006-07-22") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "E90-15-006-22-22") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "PSS65-15-006-08-22") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "E90-15-006-23-22") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "E90-15-006-24-22") OR (aa.SupplierID = 112 AND aa.DataSupplierArticleNumber = "E90-15-006-21-22") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1140-3692") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1140-3681") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1120-3682") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1150-5061") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1140-3682") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1120-3691") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1140-3691") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1120-3692") OR (aa.SupplierID = 18 AND aa.DataSupplierArticleNumber = "1120-3681") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "20102310") OR (aa.SupplierID = 4764 AND aa.DataSupplierArticleNumber = "30402126") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "123210102") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "123210103") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "113210057") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "113210058") ) AND aa.Language = "ru" Продажа автозапчастей типа Ходовая часть в сборе для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BILSTEIN 46-188564 Комплект ходовой части, пружины / амортизаторы
46-183071 Комплект ходовой части, пружины / амортизаторы
48-169301 Комплект ходовой части, пружины / амортизаторы
47-086852 Комплект ходовой части, пружины / амортизаторы
46-188571 Комплект ходовой части, пружины / амортизаторы
46-183064 Комплект ходовой части, пружины / амортизаторы
47-169289 Комплект ходовой части, пружины / амортизаторы
DIEDERICHS 9999126 Комплект ходовой части, пружины / амортизаторы
99932310 Комплект ходовой части, пружины / амортизаторы
EIBACH PSS65-15-006-07-22 Комплект ходовой части, пружины / амортизаторы
E90-15-006-22-22 Комплект ходовой части, пружины / амортизаторы
PSS65-15-006-08-22 Комплект ходовой части, пружины / амортизаторы
E90-15-006-23-22 Комплект ходовой части, пружины / амортизаторы
E90-15-006-24-22 Комплект ходовой части, пружины / амортизаторы
E90-15-006-21-22 Комплект ходовой части, пружины / амортизаторы
KONI 1140-3692 Комплект ходовой части, пружины / амортизаторы
1140-3681 Комплект ходовой части, пружины / амортизаторы
1120-3682 Комплект ходовой части, пружины / амортизаторы
1150-5061 Комплект ходовой части, пружины / амортизаторы
1140-3682 Комплект ходовой части, пружины / амортизаторы
1120-3691 Комплект ходовой части, пружины / амортизаторы
1140-3691 Комплект ходовой части, пружины / амортизаторы
1120-3692 Комплект ходовой части, пружины / амортизаторы
1120-3681 Комплект ходовой части, пружины / амортизаторы
MAXTRAC 20102310 Комплект ходовой части, пружины / амортизаторы
30402126 Комплект ходовой части, пружины / амортизаторы
METZGER 123210102 Комплект ходовой части, пружины / амортизаторы
123210103 Комплект ходовой части, пружины / амортизаторы
113210057 Комплект ходовой части, пружины / амортизаторы
113210058 Комплект ходовой части, пружины / амортизаторы
2026 CATCAR.INFO (v 2.0)