#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTgwMzR8fG1kZl9pZD09MF4zMTA1MHx8c3BhcmVfaWQ9PTEwMDYxNA%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 = "31050" AND ( (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 392 022 010" AND av.ProductID IN (999)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 392 023 004" AND av.ProductID IN (999)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "5.5090" AND av.ProductID IN (999)) OR (av.SupplierID = 178 AND av.DataSupplierArticleNumber = "AP8230" AND av.ProductID IN (999)) OR (av.SupplierID = 178 AND av.DataSupplierArticleNumber = "AP8255" AND av.ProductID IN (999)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "7500039" AND av.ProductID IN (999)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "20039" AND av.ProductID IN (999)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2221026" AND av.ProductID IN (999)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "5.5090" AND av.ProductID IN (999)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.59.150" AND av.ProductID IN (999)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1719750" AND av.ProductID IN (999)) ) 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 = 30 AND aa.DataSupplierArticleNumber = "0 392 022 010") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 392 023 004") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "5.5090") OR (aa.SupplierID = 178 AND aa.DataSupplierArticleNumber = "AP8230") OR (aa.SupplierID = 178 AND aa.DataSupplierArticleNumber = "AP8255") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7500039") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "20039") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2221026") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "5.5090") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.59.150") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1719750") ) 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 = 30 AND aa.DataSupplierArticleNumber = "0 392 022 010") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 392 023 004") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "5.5090") OR (aa.SupplierID = 178 AND aa.DataSupplierArticleNumber = "AP8230") OR (aa.SupplierID = 178 AND aa.DataSupplierArticleNumber = "AP8255") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7500039") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "20039") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2221026") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "5.5090") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.59.150") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1719750") ) AND aa.Language = "ru" Продажа автозапчастей типа Автономное отопление для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BOSCH 0 392 022 010 Насос рециркуляции воды, автономное отопление
0 392 023 004 Насос рециркуляции воды, автономное отопление
FISPA 5.5090 Насос рециркуляции воды, автономное отопление
HEPU AP8230 Насос рециркуляции воды, автономное отопление
AP8255 Насос рециркуляции воды, автономное отопление
HOFFER 7500039 Насос рециркуляции воды, автономное отопление
MEAT & DORIA 20039 Насос рециркуляции воды, автономное отопление
METZGER 2221026 Насос рециркуляции воды, автономное отопление
SIDAT 5.5090 Насос рециркуляции воды, автономное отопление
TRUCKTEC AUTOMOTIVE 02.59.150 Насос рециркуляции воды, автономное отопление
WILMINK GROUP WG1719750 Насос рециркуляции воды, автономное отопление
2026 CATCAR.INFO (v 2.0)