#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTczOXx8bW9kZWxfaWQ9PTQ3MDd8fG1kZl9pZD09MV42NTQyfHxzcGFyZV9pZD09MjAwMjA0&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 = "6542" AND ( (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "R38773-00" AND av.ProductID IN (151)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "50007889" AND av.ProductID IN (151)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "LB802" AND av.ProductID IN (151)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "15-73295-01" AND av.ProductID IN (151)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1183130" AND av.ProductID IN (151)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1379507" AND av.ProductID IN (151)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1017889" AND av.ProductID IN (151)) ) 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 = 88 AND aa.DataSupplierArticleNumber = "R38773-00") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50007889") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "LB802") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "15-73295-01") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1183130") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1379507") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1017889") ) 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 = 88 AND aa.DataSupplierArticleNumber = "R38773-00") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50007889") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "LB802") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "15-73295-01") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1183130") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1379507") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1017889") ) AND aa.Language = "ru" Продажа автозапчастей типа Комплект уплотнительных колец гильзы для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
GLASER R38773-00 Комплект прокладок, гильза цилиндра
KOLBENSCHMIDT 50007889 Комплект прокладок, гильза цилиндра
PAYEN LB802 Комплект прокладок, гильза цилиндра
VICTOR REINZ 15-73295-01 Комплект прокладок, гильза цилиндра
WILMINK GROUP WG1183130 Комплект прокладок, гильза цилиндра
WG1379507 Комплект прокладок, гильза цилиндра
WG1017889 Комплект прокладок, гильза цилиндра
2026 CATCAR.INFO (v 2.0)