#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTQ4NjV8fG1kZl9pZD09MF4xOTI4MXx8c3BhcmVfaWQ9PTEwMDM3NA%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 = "19281" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "10175200" AND av.ProductID IN (318)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "52255300" AND av.ProductID IN (319)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "CH9509" AND av.ProductID IN (318)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "HK1706" AND av.ProductID IN (319)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "418323P" AND av.ProductID IN (319)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "415429P" AND av.ProductID IN (318)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "354.010" AND av.ProductID IN (319)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "076.892" AND av.ProductID IN (318)) OR (av.SupplierID = 237 AND av.DataSupplierArticleNumber = "0042616" AND av.ProductID IN (318)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "HS1444" AND av.ProductID IN (319)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "HG1444" AND av.ProductID IN (318)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "H80748-00" AND av.ProductID IN (318)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "D37089-00" AND av.ProductID IN (319)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "30-030561-00" AND av.ProductID IN (318)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "21-30561-00/0" AND av.ProductID IN (319)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PG1-2041" AND av.ProductID IN (319)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "CH5240" AND av.ProductID IN (319)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "AH5240" AND av.ProductID IN (318)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "598-50118" AND av.ProductID IN (319)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "61-37240-00" AND av.ProductID IN (318)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "02-37240-01" AND av.ProductID IN (319)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1090926" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1090996" AND av.ProductID IN (319)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1001852" AND av.ProductID IN (319)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1103570" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1102814" AND av.ProductID IN (319)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1003942" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1009393" AND av.ProductID IN (319)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1087372" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1087227" 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 = 139 AND aa.DataSupplierArticleNumber = "10175200") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "52255300") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "CH9509") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "HK1706") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "418323P") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "415429P") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "354.010") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "076.892") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "0042616") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "HS1444") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "HG1444") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H80748-00") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "D37089-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "30-030561-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "21-30561-00/0") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PG1-2041") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "CH5240") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "AH5240") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "598-50118") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-37240-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "02-37240-01") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1090926") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1090996") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1001852") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103570") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1102814") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1003942") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1009393") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1087372") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1087227") ) 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 = "10175200") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "52255300") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "CH9509") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "HK1706") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "418323P") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "415429P") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "354.010") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "076.892") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "0042616") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "HS1444") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "HG1444") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H80748-00") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "D37089-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "30-030561-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "21-30561-00/0") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PG1-2041") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "CH5240") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "AH5240") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "598-50118") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-37240-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "02-37240-01") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1090926") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1090996") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1001852") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103570") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1102814") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1003942") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1009393") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1087372") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1087227") ) AND aa.Language = "ru" Продажа автозапчастей типа Прокладка головки цилиндра для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AJUSA 10175200 Прокладка, головка цилиндра
52255300 Комплект прокладок, головка цилиндра
BGA CH9509 Прокладка, головка цилиндра
HK1706 Комплект прокладок, головка цилиндра
CORTECO 418323P Комплект прокладок, головка цилиндра
415429P Прокладка, головка цилиндра
ELRING 354.010 Комплект прокладок, головка цилиндра
076.892 Прокладка, головка цилиндра
ELWIS ROYAL 0042616 Прокладка, головка цилиндра
FAI AutoParts HS1444 Комплект прокладок, головка цилиндра
HG1444 Прокладка, головка цилиндра
GLASER H80748-00 Прокладка, головка цилиндра
D37089-00 Комплект прокладок, головка цилиндра
GOETZE 30-030561-00 Прокладка, головка цилиндра
21-30561-00/0 Комплект прокладок, головка цилиндра
PATRON PG1-2041 Комплект прокладок, головка цилиндра
PAYEN CH5240 Комплект прокладок, головка цилиндра
AH5240 Прокладка, головка цилиндра
TRISCAN 598-50118 Комплект прокладок, головка цилиндра
VICTOR REINZ 61-37240-00 Прокладка, головка цилиндра
02-37240-01 Комплект прокладок, головка цилиндра
WILMINK GROUP WG1090926 Прокладка, головка цилиндра
WG1090996 Комплект прокладок, головка цилиндра
WG1001852 Комплект прокладок, головка цилиндра
WG1103570 Прокладка, головка цилиндра
WG1102814 Комплект прокладок, головка цилиндра
WG1003942 Прокладка, головка цилиндра
WG1009393 Комплект прокладок, головка цилиндра
WG1087372 Прокладка, головка цилиндра
WG1087227 Комплект прокладок, головка цилиндра
2026 CATCAR.INFO (v 2.0)