#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1NXx8bW9kZWxfaWQ9PTYyMzN8fG1kZl9pZD09MF4yMjQ5Mnx8c3BhcmVfaWQ9PTEwMTc4Mw%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 = "22492" AND ( (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6803-00-3750281P" AND av.ProductID IN (531)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6803-00-3750280P" AND av.ProductID IN (531)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "5847800" AND av.ProductID IN (531)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "5847817" AND av.ProductID IN (740)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "5847816" AND av.ProductID IN (740)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "MD-005" AND av.ProductID IN (1708)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "033-43-100" AND av.ProductID IN (531)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "033-43-105" AND av.ProductID IN (531)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "MB7143100" AND av.ProductID IN (531)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "3272705" AND av.ProductID IN (1353)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "3273660" AND av.ProductID IN (531)) ) 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 = 4555 AND aa.DataSupplierArticleNumber = "6803-00-3750281P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6803-00-3750280P") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "5847800") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "5847817") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "5847816") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "MD-005") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "033-43-100") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "033-43-105") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "MB7143100") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3272705") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3273660") ) 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 = 4555 AND aa.DataSupplierArticleNumber = "6803-00-3750281P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6803-00-3750280P") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "5847800") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "5847817") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "5847816") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "MD-005") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "033-43-100") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "033-43-105") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "MB7143100") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3272705") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3273660") ) AND aa.Language = "ru" Продажа автозапчастей типа Капот двигателя/ составляющие/ изоляция для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BLIC 6803-00-3750281P Капот двигателя
6803-00-3750280P Капот двигателя
DIEDERICHS 5847800 Капот двигателя
5847817 Шарнир, капот
5847816 Шарнир, капот
FEBEST MD-005 Буфер, капот
LORO 033-43-100 Капот двигателя
033-43-105 Капот двигателя
PRASCO MB7143100 Капот двигателя
VAN WEZEL 3272705 Изоляция моторного отделения
3273660 Капот двигателя
2026 CATCAR.INFO (v 2.0)