#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTczOXx8bW9kZWxfaWQ9PTQ2NTl8fG1kZl9pZD09MV42MjQ1fHxzcGFyZV9pZD09MjAwMTI3&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 = "6245" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "10130200" AND av.ProductID IN (318)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "569.320" AND av.ProductID IN (318)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "27550" AND av.ProductID IN (318)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "H50494-00" AND av.ProductID IN (318)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "30-025716-00" AND av.ProductID IN (318)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "16-34 001 0005" AND av.ProductID IN (318)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "72019" AND av.ProductID IN (318)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "BW390" AND av.ProductID IN (318)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "078.020" AND av.ProductID IN (318)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "61-31115-00" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1193684" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1003650" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1244440" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1159775" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1178613" AND av.ProductID IN (318)) ) 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 = 139 AND aa.DataSupplierArticleNumber = "10130200") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "569.320") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "27550") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H50494-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "30-025716-00") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "16-34 001 0005") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "72019") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "BW390") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.020") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-31115-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1193684") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1003650") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1244440") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1159775") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1178613") ) 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 = 139 AND aa.DataSupplierArticleNumber = "10130200") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "569.320") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "27550") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H50494-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "30-025716-00") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "16-34 001 0005") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "72019") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "BW390") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.020") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-31115-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1193684") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1003650") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1244440") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1159775") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1178613") ) AND aa.Language = "ru" Продажа автозапчастей типа Прокладка головки цилиндра для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AJUSA 10130200 Прокладка, головка цилиндра
ELRING 569.320 Прокладка, головка цилиндра
FEBI BILSTEIN 27550 Прокладка, головка цилиндра
GLASER H50494-00 Прокладка, головка цилиндра
GOETZE 30-025716-00 Прокладка, головка цилиндра
MEYLE 16-34 001 0005 Прокладка, головка цилиндра
NRF 72019 Прокладка, головка цилиндра
PAYEN BW390 Прокладка, головка цилиндра
SAMPA 078.020 Прокладка, головка цилиндра
VICTOR REINZ 61-31115-00 Прокладка, головка цилиндра
WILMINK GROUP WG1193684 Прокладка, головка цилиндра
WG1003650 Прокладка, головка цилиндра
WG1244440 Прокладка, головка цилиндра
WG1159775 Прокладка, головка цилиндра
WG1178613 Прокладка, головка цилиндра
2026 CATCAR.INFO (v 2.0)