#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3OXx8bW9kZWxfaWQ9PTM1NjZ8fG1kZl9pZD09MF45NTYwfHxzcGFyZV9pZD09MTAwMjI3&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 = "9560" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "11076600" AND av.ProductID IN (321)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "BGSILC" AND av.ProductID IN (321)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "RC9367" AND av.ProductID IN (321)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADT36765" AND av.ProductID IN (321)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "440342P" AND av.ProductID IN (321)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "354.370" AND av.ProductID IN (321)) OR (av.SupplierID = 237 AND av.DataSupplierArticleNumber = "1552828" AND av.ProductID IN (321)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "RC1267S" AND av.ProductID IN (321)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "X59840-01" AND av.ProductID IN (321)) OR (av.SupplierID = 459 AND av.DataSupplierArticleNumber = "IVC-9216" AND av.ProductID IN (321)) OR (av.SupplierID = 248 AND av.DataSupplierArticleNumber = "J1222066" AND av.ProductID IN (321)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "T122A74" AND av.ProductID IN (321)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "HM5241" AND av.ProductID IN (979)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "71-54311-00" AND av.ProductID IN (321)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1160437" AND av.ProductID IN (321)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1181186" AND av.ProductID IN (979)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1192160" AND av.ProductID IN (321)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1249682" AND av.ProductID IN (321)) ) 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 = "11076600") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "BGSILC") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "RC9367") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADT36765") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "440342P") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "354.370") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "1552828") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "RC1267S") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "X59840-01") OR (aa.SupplierID = 459 AND aa.DataSupplierArticleNumber = "IVC-9216") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "J1222066") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "T122A74") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "HM5241") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "71-54311-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1160437") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1181186") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192160") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1249682") ) 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 = "11076600") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "BGSILC") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "RC9367") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADT36765") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "440342P") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "354.370") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "1552828") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "RC1267S") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "X59840-01") OR (aa.SupplierID = 459 AND aa.DataSupplierArticleNumber = "IVC-9216") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "J1222066") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "T122A74") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "HM5241") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "71-54311-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1160437") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1181186") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192160") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1249682") ) AND aa.Language = "ru" Продажа автозапчастей типа Прокладка крышки клапана для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AJUSA 11076600 Прокладка, крышка головки цилиндра
BGA BGSILC Прокладка, крышка головки цилиндра
RC9367 Прокладка, крышка головки цилиндра
BLUE PRINT ADT36765 Прокладка, крышка головки цилиндра
CORTECO 440342P Прокладка, крышка головки цилиндра
ELRING 354.370 Прокладка, крышка головки цилиндра
ELWIS ROYAL 1552828 Прокладка, крышка головки цилиндра
FAI AutoParts RC1267S Прокладка, крышка головки цилиндра
GLASER X59840-01 Прокладка, крышка головки цилиндра
IPS Parts IVC-9216 Прокладка, крышка головки цилиндра
NIPPARTS J1222066 Прокладка, крышка головки цилиндра
NPS T122A74 Прокладка, крышка головки цилиндра
PAYEN HM5241 Комплект прокладок, крышка головки цилиндра
VICTOR REINZ 71-54311-00 Прокладка, крышка головки цилиндра
WILMINK GROUP WG1160437 Прокладка, крышка головки цилиндра
WG1181186 Комплект прокладок, крышка головки цилиндра
WG1192160 Прокладка, крышка головки цилиндра
WG1249682 Прокладка, крышка головки цилиндра
2026 CATCAR.INFO (v 2.0)