#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTMzfHxtZGZfaWQ9PTBeNTQ5fHxzcGFyZV9pZD09MTAwMjAx&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 = "549" AND ( (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "506086" AND av.ProductID IN (195)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "900930A" AND av.ProductID IN (195)) OR (av.SupplierID = 178 AND av.DataSupplierArticleNumber = "35-5081" AND av.ProductID IN (195)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "35-5081" AND av.ProductID IN (195)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "5093601" AND av.ProductID IN (195)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "1211104" AND av.ProductID IN (191)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QG1158" AND av.ProductID IN (195)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "19075093601" AND av.ProductID IN (195)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKJP 2092" AND av.ProductID IN (195)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "83516" 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 = 300 AND aa.DataSupplierArticleNumber = "506086") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "900930A") OR (aa.SupplierID = 178 AND aa.DataSupplierArticleNumber = "35-5081") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "35-5081") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5093601") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1211104") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QG1158") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19075093601") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKJP 2092") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "83516") ) 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 = 300 AND aa.DataSupplierArticleNumber = "506086") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "900930A") OR (aa.SupplierID = 178 AND aa.DataSupplierArticleNumber = "35-5081") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "35-5081") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5093601") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1211104") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QG1158") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19075093601") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKJP 2092") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "83516") ) AND aa.Language = "ru" Продажа автозапчастей типа Гофрированный кожух / прокладки для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTEX 506086 Комплект пылника, рулевое управление
CAUTEX 900930A Комплект пылника, рулевое управление
HEPU 35-5081 Комплект пылника, рулевое управление
IPD 35-5081 Комплект пылника, рулевое управление
NK 5093601 Комплект пылника, рулевое управление
OCAP 1211104 Пыльник, рулевое управление
QUINTON HAZELL QG1158 Комплект пылника, рулевое управление
sbs 19075093601 Комплект пылника, рулевое управление
SKF VKJP 2092 Комплект пылника, рулевое управление
SPIDAN 83516 Пыльник, рулевое управление
2026 CATCAR.INFO (v 2.0)