#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTM1NDF8fG1kZl9pZD09MV41NjE2fHxzcGFyZV9pZD09MjAwMTI3&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 = "5616" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "10139100" AND av.ProductID IN (318)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "451.690" AND av.ProductID IN (318)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "752.037" AND av.ProductID IN (318)) OR (av.SupplierID = 4514 AND av.DataSupplierArticleNumber = "TH0018" AND av.ProductID IN (318)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "19317" AND av.ProductID IN (318)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "H40623-00" AND av.ProductID IN (318)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "H50012-00" AND av.ProductID IN (318)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "30-026235-30" AND av.ProductID IN (318)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "12-34 001 0012" AND av.ProductID IN (318)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "72032" AND av.ProductID IN (318)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "BG850" AND av.ProductID IN (318)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "022.241" AND av.ProductID IN (318)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "81-10602-SX" AND av.ProductID IN (318)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "61-25275-20" AND av.ProductID IN (318)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "61-25275-00" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1244213" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1178249" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1449279" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1194785" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1003500" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1244212" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1086023" 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 = "10139100") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "451.690") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "752.037") OR (aa.SupplierID = 4514 AND aa.DataSupplierArticleNumber = "TH0018") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "19317") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H40623-00") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H50012-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "30-026235-30") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-34 001 0012") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "72032") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "BG850") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.241") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-10602-SX") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-25275-20") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-25275-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1244213") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1178249") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1449279") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1194785") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1003500") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1244212") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086023") ) 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 = "10139100") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "451.690") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "752.037") OR (aa.SupplierID = 4514 AND aa.DataSupplierArticleNumber = "TH0018") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "19317") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H40623-00") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H50012-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "30-026235-30") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-34 001 0012") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "72032") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "BG850") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.241") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-10602-SX") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-25275-20") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-25275-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1244213") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1178249") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1449279") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1194785") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1003500") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1244212") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086023") ) AND aa.Language = "ru" Продажа автозапчастей типа Прокладка головки цилиндра для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AJUSA 10139100 Прокладка, головка цилиндра
ELRING 451.690 Прокладка, головка цилиндра
752.037 Прокладка, головка цилиндра
ET ENGINETEAM TH0018 Прокладка, головка цилиндра
FEBI BILSTEIN 19317 Прокладка, головка цилиндра
GLASER H40623-00 Прокладка, головка цилиндра
H50012-00 Прокладка, головка цилиндра
GOETZE 30-026235-30 Прокладка, головка цилиндра
MEYLE 12-34 001 0012 Прокладка, головка цилиндра
NRF 72032 Прокладка, головка цилиндра
PAYEN BG850 Прокладка, головка цилиндра
SAMPA 022.241 Прокладка, головка цилиндра
STELLOX 81-10602-SX Прокладка, головка цилиндра
VICTOR REINZ 61-25275-20 Прокладка, головка цилиндра
61-25275-00 Прокладка, головка цилиндра
WILMINK GROUP WG1244213 Прокладка, головка цилиндра
WG1178249 Прокладка, головка цилиндра
WG1449279 Прокладка, головка цилиндра
WG1194785 Прокладка, головка цилиндра
WG1003500 Прокладка, головка цилиндра
WG1244212 Прокладка, головка цилиндра
WG1086023 Прокладка, головка цилиндра
2026 CATCAR.INFO (v 2.0)