#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTQ2NjN8fG1kZl9pZD09MF4xNTAwOXx8c3BhcmVfaWQ9PTEwMDc5NA%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 = "15009" AND ( (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "AS2032" AND av.ProductID IN (2055)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.830.088" AND av.ProductID IN (2055)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.830.350" AND av.ProductID IN (2055)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.830.140" AND av.ProductID IN (2055)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.830.183" AND av.ProductID IN (2055)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.830.316" AND av.ProductID IN (2055)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "7.3316" AND av.ProductID IN (2055)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "7.3088" AND av.ProductID IN (2055)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "7.3350" AND av.ProductID IN (2055)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "7.3140" AND av.ProductID IN (2055)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "7.3183" AND av.ProductID IN (2055)) OR (av.SupplierID = 240 AND av.DataSupplierArticleNumber = "33280" AND av.ProductID IN (2055)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "530 183" AND av.ProductID IN (2055)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "530 316" AND av.ProductID IN (2055)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "530 088" AND av.ProductID IN (2055)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "530 350" AND av.ProductID IN (2055)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "530 140" AND av.ProductID IN (2055)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0905053" AND av.ProductID IN (2055)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "014 810 0005" AND av.ProductID IN (832)) ) 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 = 4737 AND aa.DataSupplierArticleNumber = "AS2032") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.830.088") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.830.350") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.830.140") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.830.183") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.830.316") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.3316") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.3088") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.3350") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.3140") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.3183") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "33280") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "530 183") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "530 316") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "530 088") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "530 350") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "530 140") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0905053") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "014 810 0005") ) 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 = 4737 AND aa.DataSupplierArticleNumber = "AS2032") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.830.088") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.830.350") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.830.140") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.830.183") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.830.316") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.3316") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.3088") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.3350") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.3140") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.3183") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "33280") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "530 183") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "530 316") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "530 088") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "530 350") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "530 140") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0905053") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "014 810 0005") ) AND aa.Language = "ru" Продажа автозапчастей типа Датчики для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTLOG AS2032 Датчик, температура охлаждающей жидкости
EPS 1.830.088 Датчик, температура охлаждающей жидкости
1.830.350 Датчик, температура охлаждающей жидкости
1.830.140 Датчик, температура охлаждающей жидкости
1.830.183 Датчик, температура охлаждающей жидкости
1.830.316 Датчик, температура охлаждающей жидкости
FACET 7.3316 Датчик, температура охлаждающей жидкости
7.3088 Датчик, температура охлаждающей жидкости
7.3350 Датчик, температура охлаждающей жидкости
7.3140 Датчик, температура охлаждающей жидкости
7.3183 Датчик, температура охлаждающей жидкости
FAE 33280 Датчик, температура охлаждающей жидкости
KW 530 183 Датчик, температура охлаждающей жидкости
530 316 Датчик, температура охлаждающей жидкости
530 088 Датчик, температура охлаждающей жидкости
530 350 Датчик, температура охлаждающей жидкости
530 140 Датчик, температура охлаждающей жидкости
METZGER 0905053 Датчик, температура охлаждающей жидкости
MEYLE 014 810 0005 Датчик, внутренняя температура
2026 CATCAR.INFO (v 2.0)