#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTg1fHxtZGZfaWQ9PTBeNjA5fHxzcGFyZV9pZD09MTA0Mzc3&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 = "609" AND ( (av.SupplierID = 385 AND av.DataSupplierArticleNumber = "08-307200-00" AND av.ProductID IN (444)) OR (av.SupplierID = 385 AND av.DataSupplierArticleNumber = "08-306000-00" AND av.ProductID IN (444)) OR (av.SupplierID = 385 AND av.DataSupplierArticleNumber = "08-307207-00" AND av.ProductID IN (444)) OR (av.SupplierID = 385 AND av.DataSupplierArticleNumber = "08-306007-00" AND av.ProductID IN (444)) OR (av.SupplierID = 385 AND av.DataSupplierArticleNumber = "08-306100-00" AND av.ProductID IN (444)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "800021110000" AND av.ProductID IN (444)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "800021110050" AND av.ProductID IN (444)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "011 63 N0" AND av.ProductID IN (444)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "011 63 N1" AND av.ProductID IN (444)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "011 63 00" AND av.ProductID IN (443)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "011 63 N3" AND av.ProductID IN (444)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "011 63 02" AND av.ProductID IN (443)) OR (av.SupplierID = 4717 AND av.DataSupplierArticleNumber = "7135340000" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1201570" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1187257" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1096587" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1024437" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1201568" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1201565" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1187244" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1024438" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1201569" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1201567" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1187256" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1096358" 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 = 385 AND aa.DataSupplierArticleNumber = "08-307200-00") OR (aa.SupplierID = 385 AND aa.DataSupplierArticleNumber = "08-306000-00") OR (aa.SupplierID = 385 AND aa.DataSupplierArticleNumber = "08-307207-00") OR (aa.SupplierID = 385 AND aa.DataSupplierArticleNumber = "08-306007-00") OR (aa.SupplierID = 385 AND aa.DataSupplierArticleNumber = "08-306100-00") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "800021110000") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "800021110050") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "011 63 N0") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "011 63 N1") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "011 63 00") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "011 63 N3") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "011 63 02") OR (aa.SupplierID = 4717 AND aa.DataSupplierArticleNumber = "7135340000") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1201570") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1187257") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1096587") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1024437") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1201568") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1201565") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1187244") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1024438") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1201569") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1201567") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1187256") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1096358") ) 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 = 385 AND aa.DataSupplierArticleNumber = "08-307200-00") OR (aa.SupplierID = 385 AND aa.DataSupplierArticleNumber = "08-306000-00") OR (aa.SupplierID = 385 AND aa.DataSupplierArticleNumber = "08-307207-00") OR (aa.SupplierID = 385 AND aa.DataSupplierArticleNumber = "08-306007-00") OR (aa.SupplierID = 385 AND aa.DataSupplierArticleNumber = "08-306100-00") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "800021110000") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "800021110050") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "011 63 N0") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "011 63 N1") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "011 63 00") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "011 63 N3") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "011 63 02") OR (aa.SupplierID = 4717 AND aa.DataSupplierArticleNumber = "7135340000") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1201570") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1187257") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1096587") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1024437") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1201568") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1201565") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1187244") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1024438") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1201569") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1201567") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1187256") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1096358") ) AND aa.Language = "ru" Продажа автозапчастей типа Цилиндр / Поршень для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
GOETZE ENGINE 08-307200-00 Комплект поршневых колец
08-306000-00 Комплект поршневых колец
08-307207-00 Комплект поршневых колец
08-306007-00 Комплект поршневых колец
08-306100-00 Комплект поршневых колец
KOLBENSCHMIDT 800021110000 Комплект поршневых колец
800021110050 Комплект поршневых колец
MAHLE ORIGINAL 011 63 N0 Комплект поршневых колец
011 63 N1 Комплект поршневых колец
011 63 00 Поршень
011 63 N3 Комплект поршневых колец
011 63 02 Поршень
NE 7135340000 Поршень
WILMINK GROUP WG1201570 Комплект поршневых колец
WG1187257 Комплект поршневых колец
WG1096587 Комплект поршневых колец
WG1024437 Комплект поршневых колец
WG1201568 Комплект поршневых колец
WG1201565 Поршень
WG1187244 Комплект поршневых колец
WG1024438 Комплект поршневых колец
WG1201569 Комплект поршневых колец
WG1201567 Поршень
WG1187256 Комплект поршневых колец
WG1096358 Комплект поршневых колец
2026 CATCAR.INFO (v 2.0)