#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTk1MTN8fG1kZl9pZD09MF4zNDIwNXx8c3BhcmVfaWQ9PTEwMDUxOA%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 = "34205" AND ( (av.SupplierID = 352 AND av.DataSupplierArticleNumber = "20090335203" AND av.ProductID IN (578,578)) OR (av.SupplierID = 352 AND av.DataSupplierArticleNumber = "20090390001" AND av.ProductID IN (577)) OR (av.SupplierID = 352 AND av.DataSupplierArticleNumber = "20090390010" AND av.ProductID IN (578,578)) OR (av.SupplierID = 352 AND av.DataSupplierArticleNumber = "20090390002" AND av.ProductID IN (577)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "V6041N" AND av.ProductID IN (577)) OR (av.SupplierID = 6 AND av.DataSupplierArticleNumber = "416 0061 10" AND av.ProductID IN (577)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "3421 601 056" AND av.ProductID IN (577)) OR (av.SupplierID = 4699 AND av.DataSupplierArticleNumber = "10-ME010" AND av.ProductID IN (578)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "83-10203-SX" AND av.ProductID IN (578)) ) 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 = 352 AND aa.DataSupplierArticleNumber = "20090335203") OR (aa.SupplierID = 352 AND aa.DataSupplierArticleNumber = "20090390001") OR (aa.SupplierID = 352 AND aa.DataSupplierArticleNumber = "20090390010") OR (aa.SupplierID = 352 AND aa.DataSupplierArticleNumber = "20090390002") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "V6041N") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "416 0061 10") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3421 601 056") OR (aa.SupplierID = 4699 AND aa.DataSupplierArticleNumber = "10-ME010") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "83-10203-SX") ) 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 = 352 AND aa.DataSupplierArticleNumber = "20090335203") OR (aa.SupplierID = 352 AND aa.DataSupplierArticleNumber = "20090390001") OR (aa.SupplierID = 352 AND aa.DataSupplierArticleNumber = "20090390010") OR (aa.SupplierID = 352 AND aa.DataSupplierArticleNumber = "20090390002") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "V6041N") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "416 0061 10") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3421 601 056") OR (aa.SupplierID = 4699 AND aa.DataSupplierArticleNumber = "10-ME010") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "83-10203-SX") ) AND aa.Language = "ru" Продажа автозапчастей типа Маховик для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BF 20090335203 Зубчатый венец, маховик
20090390001 Маховик
20090390010 Зубчатый венец, маховик
20090390002 Маховик
KAWE V6041N Маховик
LuK 416 0061 10 Маховик
SACHS 3421 601 056 Маховик
SBP 10-ME010 Зубчатый венец, маховик
STELLOX 83-10203-SX Зубчатый венец, маховик
2026 CATCAR.INFO (v 2.0)