#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTk1MDh8fG1kZl9pZD09MF4zNDA0N3x8c3BhcmVfaWQ9PTEwMDM3NA%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 = "34047" AND ( (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "763.013" AND av.ProductID IN (318)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "813.869" AND av.ProductID IN (319)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "30-025093-20" AND av.ProductID IN (318)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "21-25093-51/0" AND av.ProductID IN (319)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "BS311" AND av.ProductID IN (318)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "DS310" AND av.ProductID IN (319)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "61-26305-60" AND av.ProductID IN (318)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "02-26305-02" AND av.ProductID IN (319)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1244272" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1188492" AND av.ProductID IN (319)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1086059" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1239997" AND av.ProductID IN (319)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1085674" AND av.ProductID IN (319)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1189047" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1179644" AND av.ProductID IN (319)) ) 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 = 10 AND aa.DataSupplierArticleNumber = "763.013") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "813.869") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "30-025093-20") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "21-25093-51/0") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "BS311") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "DS310") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-26305-60") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "02-26305-02") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1244272") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1188492") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086059") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1239997") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1085674") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1189047") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1179644") ) 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 = 10 AND aa.DataSupplierArticleNumber = "763.013") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "813.869") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "30-025093-20") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "21-25093-51/0") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "BS311") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "DS310") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-26305-60") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "02-26305-02") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1244272") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1188492") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086059") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1239997") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1085674") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1189047") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1179644") ) AND aa.Language = "ru" Продажа автозапчастей типа Прокладка головки цилиндра для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ELRING 763.013 Прокладка, головка цилиндра
813.869 Комплект прокладок, головка цилиндра
GOETZE 30-025093-20 Прокладка, головка цилиндра
21-25093-51/0 Комплект прокладок, головка цилиндра
PAYEN BS311 Прокладка, головка цилиндра
DS310 Комплект прокладок, головка цилиндра
VICTOR REINZ 61-26305-60 Прокладка, головка цилиндра
02-26305-02 Комплект прокладок, головка цилиндра
WILMINK GROUP WG1244272 Прокладка, головка цилиндра
WG1188492 Комплект прокладок, головка цилиндра
WG1086059 Прокладка, головка цилиндра
WG1239997 Комплект прокладок, головка цилиндра
WG1085674 Комплект прокладок, головка цилиндра
WG1189047 Прокладка, головка цилиндра
WG1179644 Комплект прокладок, головка цилиндра
2026 CATCAR.INFO (v 2.0)