#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTgwMjV8fG1kZl9pZD09MF4xMDA3OTZ8fHNwYXJlX2lkPT0xMDAzMzQ%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 = "100796" AND ( (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BTS3001" AND av.ProductID IN (830)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BTS3002" AND av.ProductID IN (830)) OR (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B18252" AND av.ProductID IN (830)) OR (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B13129" AND av.ProductID IN (1103)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "TS2671" AND av.ProductID IN (1103)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "WS3070" AND av.ProductID IN (830)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "TS2783" AND av.ProductID IN (1103)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.850.690" AND av.ProductID IN (1103)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.830.355" AND av.ProductID IN (830)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.850.262" AND av.ProductID IN (1103)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "7.3355" AND av.ProductID IN (830)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "7.5262" AND av.ProductID IN (1103)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "7.5690" AND av.ProductID IN (1103)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "36563" AND av.ProductID IN (1103)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FTS3001" AND av.ProductID IN (830)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FTS3002" AND av.ProductID IN (830)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "82.400" AND av.ProductID IN (1103)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "6ZT 007 800-111" AND av.ProductID IN (1103)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "7472701" AND av.ProductID IN (1103)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1193102700" AND av.ProductID IN (830)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "530 355" AND av.ProductID IN (830)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "550 262" AND av.ProductID IN (1103)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "550 690" AND av.ProductID IN (1103)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "82701" AND av.ProductID IN (1103)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0905436" AND av.ProductID IN (830)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "82.400" AND av.ProductID IN (1103)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 6563" AND av.ProductID IN (1103)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "115 879" AND av.ProductID IN (830)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8625 137095" AND av.ProductID IN (1103)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8625 120097" AND av.ProductID IN (1103)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V10-72-1361" AND av.ProductID IN (830)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99590082401" AND av.ProductID IN (1103)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99191539701" AND av.ProductID IN (830)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1499648" AND av.ProductID IN (1103)) ) 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 = 475 AND aa.DataSupplierArticleNumber = "BTS3001") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTS3002") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B18252") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B13129") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "TS2671") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "WS3070") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "TS2783") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.850.690") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.830.355") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.850.262") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.3355") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.5262") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.5690") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "36563") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FTS3001") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FTS3002") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "82.400") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZT 007 800-111") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7472701") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193102700") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "530 355") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "550 262") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "550 690") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "82701") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0905436") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "82.400") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 6563") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 879") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8625 137095") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8625 120097") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-72-1361") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99590082401") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99191539701") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1499648") ) 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 = 475 AND aa.DataSupplierArticleNumber = "BTS3001") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTS3002") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B18252") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B13129") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "TS2671") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "WS3070") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "TS2783") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.850.690") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.830.355") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.850.262") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.3355") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.5262") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.5690") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "36563") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FTS3001") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FTS3002") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "82.400") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZT 007 800-111") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7472701") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193102700") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "530 355") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "550 262") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "550 690") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "82701") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0905436") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "82.400") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 6563") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 879") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8625 137095") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8625 120097") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-72-1361") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99590082401") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99191539701") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1499648") ) AND aa.Language = "ru" Продажа автозапчастей типа Выключатель / датчик для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BORG & BECK BTS3001 Датчик, температура охлаждающей жидкости
BTS3002 Датчик, температура охлаждающей жидкости
Borsehung B18252 Датчик, температура охлаждающей жидкости
B13129 Термовыключатель, вентилятор радиатора
CALORSTAT by Vernet TS2671 Термовыключатель, вентилятор радиатора
WS3070 Датчик, температура охлаждающей жидкости
TS2783 Термовыключатель, вентилятор радиатора
EPS 1.850.690 Термовыключатель, вентилятор радиатора
1.830.355 Датчик, температура охлаждающей жидкости
1.850.262 Термовыключатель, вентилятор радиатора
FACET 7.3355 Датчик, температура охлаждающей жидкости
7.5262 Термовыключатель, вентилятор радиатора
7.5690 Термовыключатель, вентилятор радиатора
FEBI BILSTEIN 36563 Термовыключатель, вентилятор радиатора
FIRST LINE FTS3001 Датчик, температура охлаждающей жидкости
FTS3002 Датчик, температура охлаждающей жидкости
FISPA 82.400 Термовыключатель, вентилятор радиатора
HELLA 6ZT 007 800-111 Термовыключатель, вентилятор радиатора
HOFFER 7472701 Термовыключатель, вентилятор радиатора
JP GROUP 1193102700 Датчик, температура охлаждающей жидкости
KW 530 355 Датчик, температура охлаждающей жидкости
550 262 Термовыключатель, вентилятор радиатора
550 690 Термовыключатель, вентилятор радиатора
MEAT & DORIA 82701 Термовыключатель, вентилятор радиатора
METZGER 0905436 Датчик, температура охлаждающей жидкости
SIDAT 82.400 Термовыключатель, вентилятор радиатора
SWAG 30 93 6563 Термовыключатель, вентилятор радиатора
TOPRAN 115 879 Датчик, температура охлаждающей жидкости
TRISCAN 8625 137095 Термовыключатель, вентилятор радиатора
8625 120097 Термовыключатель, вентилятор радиатора
VEMO V10-72-1361 Датчик, температура охлаждающей жидкости
vika 99590082401 Термовыключатель, вентилятор радиатора
99191539701 Датчик, температура охлаждающей жидкости
WILMINK GROUP WG1499648 Термовыключатель, вентилятор радиатора
2026 CATCAR.INFO (v 2.0)