#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTc1ODB8fG1kZl9pZD09MF4xMTM4OXx8c3BhcmVfaWQ9PTEwMDIwMQ%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 = "11389" AND ( (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "K14584" AND av.ProductID IN (195)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "14584" AND av.ProductID IN (195)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "37567 01" AND av.ProductID IN (191)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "11009" AND av.ProductID IN (195)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "10009" AND av.ProductID IN (191)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "014 620 0012" AND av.ProductID IN (195)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "349.132" AND av.ProductID IN (191)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "84274" AND av.ProductID IN (191)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T411009" AND av.ProductID IN (195)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T410009" AND av.ProductID IN (191)) ) 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 = 4834 AND aa.DataSupplierArticleNumber = "K14584") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "14584") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "37567 01") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "11009") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "10009") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "014 620 0012") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "349.132") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "84274") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T411009") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T410009") ) 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 = 4834 AND aa.DataSupplierArticleNumber = "K14584") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "14584") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "37567 01") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "11009") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "10009") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "014 620 0012") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "349.132") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "84274") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T411009") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T410009") ) AND aa.Language = "ru" Продажа автозапчастей типа Гофрированный кожух / прокладки для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FARE SA K14584 Комплект пылника, рулевое управление
14584 Комплект пылника, рулевое управление
LEMFÖRDER 37567 01 Пыльник, рулевое управление
Metalcaucho 11009 Комплект пылника, рулевое управление
10009 Пыльник, рулевое управление
MEYLE 014 620 0012 Комплект пылника, рулевое управление
SIDEM 349.132 Пыльник, рулевое управление
SPIDAN 84274 Пыльник, рулевое управление
STC T411009 Комплект пылника, рулевое управление
T410009 Пыльник, рулевое управление
2026 CATCAR.INFO (v 2.0)