#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTUwODJ8fG1kZl9pZD09MV4xMzU5NXx8c3BhcmVfaWQ9PTIwMDA0NA%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 articlecommercialvehicles av JOIN commercialvehiclelinkageattributes_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 = "13595" AND ( (av.SupplierID = 4514 AND av.DataSupplierArticleNumber = "PM003900" AND av.ProductID IN (443)) OR (av.SupplierID = 4514 AND av.DataSupplierArticleNumber = "UV0007" AND av.ProductID IN (4668)) OR (av.SupplierID = 385 AND av.DataSupplierArticleNumber = "08-420900-00" AND av.ProductID IN (444)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "001 RS 00136 0N0" AND av.ProductID IN (444)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "004 67 00" AND av.ProductID IN (443)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "004 67 90" AND av.ProductID IN (4668)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "005 26 N0" AND av.ProductID IN (444)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "89-420900-30" AND av.ProductID IN (4668)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "87-420900-10" AND av.ProductID IN (443)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "89-420900-40" AND av.ProductID IN (4668)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "88-420900-00" AND av.ProductID IN (4668)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "88-420900-10" AND av.ProductID IN (4668)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "87-420900-00" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1200388" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1104165" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1422982" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1104170" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1147682" AND av.ProductID IN (444)) ) 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 = 4514 AND aa.DataSupplierArticleNumber = "PM003900") OR (aa.SupplierID = 4514 AND aa.DataSupplierArticleNumber = "UV0007") OR (aa.SupplierID = 385 AND aa.DataSupplierArticleNumber = "08-420900-00") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "001 RS 00136 0N0") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "004 67 00") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "004 67 90") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "005 26 N0") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-420900-30") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-420900-10") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-420900-40") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "88-420900-00") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "88-420900-10") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-420900-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1200388") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104165") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1422982") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104170") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1147682") ) 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 = 4514 AND aa.DataSupplierArticleNumber = "PM003900") OR (aa.SupplierID = 4514 AND aa.DataSupplierArticleNumber = "UV0007") OR (aa.SupplierID = 385 AND aa.DataSupplierArticleNumber = "08-420900-00") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "001 RS 00136 0N0") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "004 67 00") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "004 67 90") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "005 26 N0") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-420900-30") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-420900-10") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-420900-40") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "88-420900-00") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "88-420900-10") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-420900-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1200388") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104165") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1422982") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104170") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1147682") ) AND aa.Language = "ru" Продажа автозапчастей типа Поршень / комплектующие для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ET ENGINETEAM PM003900 Поршень
UV0007 Ремонтный комплект, поршень / гильза цилиндра
GOETZE ENGINE 08-420900-00 Комплект поршневых колец
MAHLE ORIGINAL 001 RS 00136 0N0 Комплект поршневых колец
004 67 00 Поршень
004 67 90 Ремонтный комплект, поршень / гильза цилиндра
005 26 N0 Комплект поршневых колец
NÜRAL 89-420900-30 Ремонтный комплект, поршень / гильза цилиндра
87-420900-10 Поршень
89-420900-40 Ремонтный комплект, поршень / гильза цилиндра
88-420900-00 Ремонтный комплект, поршень / гильза цилиндра
88-420900-10 Ремонтный комплект, поршень / гильза цилиндра
87-420900-00 Поршень
WILMINK GROUP WG1200388 Комплект поршневых колец
WG1104165 Поршень
WG1422982 Ремонтный комплект, поршень / гильза цилиндра
WG1104170 Комплект поршневых колец
WG1147682 Комплект поршневых колец
2026 CATCAR.INFO (v 2.0)