#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2Nnx8bW9kZWxfaWQ9PTY0NDd8fG1kZl9pZD09MF4yMzQ2Nnx8c3BhcmVfaWQ9PTEwMDIyNQ%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 = "23466" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "10177900" AND av.ProductID IN (318)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "52343400" AND av.ProductID IN (319)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "CH9528" AND av.ProductID IN (318)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "HK2973" AND av.ProductID IN (319)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "418678P" AND av.ProductID IN (319)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "415244P" AND av.ProductID IN (318)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "338.861" AND av.ProductID IN (318)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "382.420" AND av.ProductID IN (319)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "456.710" AND av.ProductID IN (318)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "688.422" AND av.ProductID IN (318)) OR (av.SupplierID = 237 AND av.DataSupplierArticleNumber = "0046870" AND av.ProductID IN (318)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "HG1432" AND av.ProductID IN (318)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "HS1767" AND av.ProductID IN (319)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "H80740-00" AND av.ProductID IN (318)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "H80740-10" AND av.ProductID IN (318)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "D37127-00" AND av.ProductID IN (319)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "30-029497-00" AND av.ProductID IN (318)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PG2-0114" AND av.ProductID IN (318)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "AG9490" AND av.ProductID IN (318)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "1504008" AND av.ProductID IN (318)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "02-36975-02" AND av.ProductID IN (319)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "61-36975-00" AND av.ProductID IN (318)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "61-36975-10" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1177859" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1001879" AND av.ProductID IN (319)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1192071" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1003930" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1240729" AND av.ProductID IN (319)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1245030" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1103547" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1380244" 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 = "10177900") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "52343400") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "CH9528") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "HK2973") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "418678P") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "415244P") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "338.861") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "382.420") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "456.710") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "688.422") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "0046870") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "HG1432") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "HS1767") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H80740-00") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H80740-10") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "D37127-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "30-029497-00") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PG2-0114") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "AG9490") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "1504008") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "02-36975-02") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-36975-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-36975-10") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177859") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1001879") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192071") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1003930") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1240729") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1245030") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103547") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1380244") ) 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 = "10177900") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "52343400") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "CH9528") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "HK2973") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "418678P") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "415244P") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "338.861") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "382.420") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "456.710") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "688.422") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "0046870") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "HG1432") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "HS1767") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H80740-00") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H80740-10") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "D37127-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "30-029497-00") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PG2-0114") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "AG9490") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "1504008") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "02-36975-02") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-36975-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-36975-10") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177859") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1001879") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192071") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1003930") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1240729") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1245030") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103547") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1380244") ) AND aa.Language = "ru" Продажа автозапчастей типа Прокладка головки цилиндра для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AJUSA 10177900 Прокладка, головка цилиндра
52343400 Комплект прокладок, головка цилиндра
BGA CH9528 Прокладка, головка цилиндра
HK2973 Комплект прокладок, головка цилиндра
CORTECO 418678P Комплект прокладок, головка цилиндра
415244P Прокладка, головка цилиндра
ELRING 338.861 Прокладка, головка цилиндра
382.420 Комплект прокладок, головка цилиндра
456.710 Прокладка, головка цилиндра
688.422 Прокладка, головка цилиндра
ELWIS ROYAL 0046870 Прокладка, головка цилиндра
FAI AutoParts HG1432 Прокладка, головка цилиндра
HS1767 Комплект прокладок, головка цилиндра
GLASER H80740-00 Прокладка, головка цилиндра
H80740-10 Прокладка, головка цилиндра
D37127-00 Комплект прокладок, головка цилиндра
GOETZE 30-029497-00 Прокладка, головка цилиндра
PATRON PG2-0114 Прокладка, головка цилиндра
PAYEN AG9490 Прокладка, головка цилиндра
SASIC 1504008 Прокладка, головка цилиндра
VICTOR REINZ 02-36975-02 Комплект прокладок, головка цилиндра
61-36975-00 Прокладка, головка цилиндра
61-36975-10 Прокладка, головка цилиндра
WILMINK GROUP WG1177859 Прокладка, головка цилиндра
WG1001879 Комплект прокладок, головка цилиндра
WG1192071 Прокладка, головка цилиндра
WG1003930 Прокладка, головка цилиндра
WG1240729 Комплект прокладок, головка цилиндра
WG1245030 Прокладка, головка цилиндра
WG1103547 Прокладка, головка цилиндра
WG1380244 Комплект прокладок, головка цилиндра
2026 CATCAR.INFO (v 2.0)