#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY3OXx8bW9kZWxfaWQ9PTUyMDR8fG1kZl9pZD09MV4xNjQ5NXx8c3BhcmVfaWQ9PTIwMjg0Nw%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 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 = "16495" AND ( (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "84.3022" AND av.ProductID IN (3945)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "6PP 013 400-041" AND av.ProductID IN (3945)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "7472585" AND av.ProductID IN (3945)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "82585" AND av.ProductID IN (3945)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "84.3022" AND av.ProductID IN (3945)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1484289" AND av.ProductID IN (3945)) ) 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 = 441 AND aa.DataSupplierArticleNumber = "84.3022") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6PP 013 400-041") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7472585") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "82585") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "84.3022") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1484289") ) 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 = 441 AND aa.DataSupplierArticleNumber = "84.3022") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6PP 013 400-041") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7472585") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "82585") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "84.3022") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1484289") ) AND aa.Language = "ru" Продажа автозапчастей типа Датчик / зонд для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FISPA 84.3022 Датчик, давление наддува
HELLA 6PP 013 400-041 Датчик, давление наддува
HOFFER 7472585 Датчик, давление наддува
MEAT & DORIA 82585 Датчик, давление наддува
SIDAT 84.3022 Датчик, давление наддува
WILMINK GROUP WG1484289 Датчик, давление наддува
2026 CATCAR.INFO (v 2.0)