#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTU0Mjd8fG1kZl9pZD09MF4xODczMXx8c3BhcmVfaWQ9PTEwMjIxOQ%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 = "18731" AND ( (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "663025" AND av.ProductID IN (2073)) OR (av.SupplierID = 240 AND av.DataSupplierArticleNumber = "55001" AND av.ProductID IN (2073)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "83.879" AND av.ProductID IN (2073)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "8029905" AND av.ProductID IN (2073)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "9905" AND av.ProductID IN (2073)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0899005" AND av.ProductID IN (2073)) OR (av.SupplierID = 5 AND av.DataSupplierArticleNumber = "7.02256.40.0" AND av.ProductID IN (2073)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "83.879" AND av.ProductID IN (2073)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-77-0009" AND av.ProductID IN (2073)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1354455" AND av.ProductID IN (2073)) ) 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 = 234 AND aa.DataSupplierArticleNumber = "663025") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "55001") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "83.879") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "8029905") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "9905") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0899005") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.02256.40.0") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "83.879") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-77-0009") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1354455") ) 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 = 234 AND aa.DataSupplierArticleNumber = "663025") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "55001") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "83.879") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "8029905") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "9905") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0899005") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.02256.40.0") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "83.879") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-77-0009") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1354455") ) AND aa.Language = "ru" Продажа автозапчастей типа Клапан/управление для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ERA 663025 Регулирующий клапан охлаждающей жидкости
FAE 55001 Регулирующий клапан охлаждающей жидкости
FISPA 83.879 Регулирующий клапан охлаждающей жидкости
HOFFER 8029905 Регулирующий клапан охлаждающей жидкости
MEAT & DORIA 9905 Регулирующий клапан охлаждающей жидкости
METZGER 0899005 Регулирующий клапан охлаждающей жидкости
PIERBURG 7.02256.40.0 Регулирующий клапан охлаждающей жидкости
SIDAT 83.879 Регулирующий клапан охлаждающей жидкости
VEMO V15-77-0009 Регулирующий клапан охлаждающей жидкости
WILMINK GROUP WG1354455 Регулирующий клапан охлаждающей жидкости
2026 CATCAR.INFO (v 2.0)