#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTczOXx8bW9kZWxfaWQ9PTQ2NTl8fG1kZl9pZD09MV42MzE3fHxzcGFyZV9pZD09MjAwMTI5&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 = "6317" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "13154200" AND av.ProductID IN (42)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "13154300" AND av.ProductID IN (27)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "48440" AND av.ProductID IN (27)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "X59617-01" AND av.ProductID IN (27)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "JD320" AND av.ProductID IN (42)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "JD321" AND av.ProductID IN (27)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "078.010" AND av.ProductID IN (42)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "079.201" AND av.ProductID IN (27)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "078.016" AND av.ProductID IN (27)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "078.012" AND av.ProductID IN (42)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "079.202" AND av.ProductID IN (27)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "078.032" AND av.ProductID IN (27)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "078.031" AND av.ProductID IN (42)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "078.009" AND av.ProductID IN (42)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "079.200" AND av.ProductID IN (27)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "079.404" AND av.ProductID IN (3979)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "71-37878-00" AND av.ProductID IN (27)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "71-37832-00" AND av.ProductID IN (42)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1181779" AND av.ProductID IN (27)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1181778" AND av.ProductID IN (42)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1248093" AND av.ProductID IN (27)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1248074" AND av.ProductID IN (42)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1162011" AND av.ProductID IN (27)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1162010" AND av.ProductID IN (42)) ) 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 = "13154200") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "13154300") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "48440") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "X59617-01") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "JD320") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "JD321") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.010") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.201") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.016") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.012") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.202") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.032") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.031") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.009") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.200") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.404") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "71-37878-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "71-37832-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1181779") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1181778") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1248093") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1248074") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1162011") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1162010") ) 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 = "13154200") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "13154300") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "48440") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "X59617-01") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "JD320") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "JD321") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.010") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.201") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.016") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.012") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.202") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.032") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.031") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.009") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.200") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.404") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "71-37878-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "71-37832-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1181779") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1181778") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1248093") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1248074") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1162011") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1162010") ) AND aa.Language = "ru" Продажа автозапчастей типа Прокладка / уплотнит. кольцо впускного/выпускного коллектора для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AJUSA 13154200 Прокладка, впускной коллектор
13154300 Прокладка, выпускной коллектор
FEBI BILSTEIN 48440 Прокладка, выпускной коллектор
GLASER X59617-01 Прокладка, выпускной коллектор
PAYEN JD320 Прокладка, впускной коллектор
JD321 Прокладка, выпускной коллектор
SAMPA 078.010 Прокладка, впускной коллектор
079.201 Прокладка, выпускной коллектор
078.016 Прокладка, выпускной коллектор
078.012 Прокладка, впускной коллектор
079.202 Прокладка, выпускной коллектор
078.032 Прокладка, выпускной коллектор
078.031 Прокладка, впускной коллектор
078.009 Прокладка, впускной коллектор
079.200 Прокладка, выпускной коллектор
079.404 Уплотнительное кольцо, выпускной коллектор
VICTOR REINZ 71-37878-00 Прокладка, выпускной коллектор
71-37832-00 Прокладка, впускной коллектор
WILMINK GROUP WG1181779 Прокладка, выпускной коллектор
WG1181778 Прокладка, впускной коллектор
WG1248093 Прокладка, выпускной коллектор
WG1248074 Прокладка, впускной коллектор
WG1162011 Прокладка, выпускной коллектор
WG1162010 Прокладка, впускной коллектор
2026 CATCAR.INFO (v 2.0)