#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2Nnx8bW9kZWxfaWQ9PTY0NDZ8fG1kZl9pZD09MF4zNDc0OHx8c3BhcmVfaWQ9PTEwMDcyOQ%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 = "34748" AND ( (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-48900" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-48906" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49902" AND av.ProductID IN (3922)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADN17016" AND av.ProductID IN (3922)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADN17036" AND av.ProductID IN (3922)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 258 986 615" AND av.ProductID IN (3922)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 258 006 046" AND av.ProductID IN (3922)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "LS140132" AND av.ProductID IN (3922)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DOX-0150" AND av.ProductID IN (3922)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DOX-2002" AND av.ProductID IN (3922)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "XLS1008" AND av.ProductID IN (3922)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.998.280" AND av.ProductID IN (3922)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.998.306" AND av.ProductID IN (3922)) OR (av.SupplierID = 4969 AND av.DataSupplierArticleNumber = "09SKV909" AND av.ProductID IN (3922)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "10.8280" AND av.ProductID IN (3922)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "10.8306" AND av.ProductID IN (3922)) OR (av.SupplierID = 240 AND av.DataSupplierArticleNumber = "77153" AND av.ProductID IN (3922)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "90134" AND av.ProductID IN (3922)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "90135" AND av.ProductID IN (3922)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "90283" AND av.ProductID IN (3922)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "6PA 009 166-971" AND av.ProductID IN (3922)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "7481710" AND av.ProductID IN (3922)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "LSO 60 09-001" AND av.ProductID IN (3922)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "498 306" AND av.ProductID IN (3922)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "498 280" AND av.ProductID IN (3922)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "466016355006" AND av.ProductID IN (3922)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "81710" AND av.ProductID IN (3922)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0893413" AND av.ProductID IN (3922)) OR (av.SupplierID = 15 AND av.DataSupplierArticleNumber = "93419" AND av.ProductID IN (3922)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DOX-1371" AND av.ProductID IN (3922)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DOX-2002" AND av.ProductID IN (3922)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "90135" AND av.ProductID IN (3922)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "90283" AND av.ProductID IN (3922)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "90134" AND av.ProductID IN (3922)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "20-00023-SX" AND av.ProductID IN (3922)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "20-00008-SX" AND av.ProductID IN (3922)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8845 25005" AND av.ProductID IN (3922)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8845 25019" AND av.ProductID IN (3922)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V46-76-0001" AND av.ProductID IN (3922)) OR (av.SupplierID = 303 AND av.DataSupplierArticleNumber = "250-24585" AND av.ProductID IN (3922)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1013992" AND av.ProductID IN (3922)) ) 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 = 442 AND aa.DataSupplierArticleNumber = "9200-48900") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48906") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49902") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADN17016") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADN17036") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 986 615") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 006 046") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "LS140132") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DOX-0150") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DOX-2002") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "XLS1008") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.998.280") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.998.306") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "09SKV909") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "10.8280") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "10.8306") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "77153") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90134") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90135") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90283") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6PA 009 166-971") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7481710") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "LSO 60 09-001") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "498 306") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "498 280") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "466016355006") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "81710") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0893413") OR (aa.SupplierID = 15 AND aa.DataSupplierArticleNumber = "93419") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DOX-1371") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DOX-2002") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90135") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90283") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90134") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "20-00023-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "20-00008-SX") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 25005") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 25019") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V46-76-0001") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-24585") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1013992") ) 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 = 442 AND aa.DataSupplierArticleNumber = "9200-48900") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48906") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49902") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADN17016") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADN17036") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 986 615") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 006 046") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "LS140132") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DOX-0150") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DOX-2002") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "XLS1008") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.998.280") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.998.306") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "09SKV909") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "10.8280") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "10.8306") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "77153") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90134") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90135") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90283") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6PA 009 166-971") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7481710") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "LSO 60 09-001") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "498 306") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "498 280") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "466016355006") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "81710") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0893413") OR (aa.SupplierID = 15 AND aa.DataSupplierArticleNumber = "93419") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DOX-1371") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DOX-2002") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90135") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90283") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90134") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "20-00023-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "20-00008-SX") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 25005") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 25019") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V46-76-0001") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-24585") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1013992") ) AND aa.Language = "ru" Продажа автозапчастей типа Лямбда-регулирование для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ASHUKI 9200-48900 Лямбда-зонд
9200-48906 Лямбда-зонд
9200-49902 Лямбда-зонд
BLUE PRINT ADN17016 Лямбда-зонд
ADN17036 Лямбда-зонд
BOSCH 0 258 986 615 Лямбда-зонд
0 258 006 046 Лямбда-зонд
CALORSTAT by Vernet LS140132 Лямбда-зонд
DENSO DOX-0150 Лямбда-зонд
DOX-2002 Лямбда-зонд
ELTA AUTOMOTIVE XLS1008 Лямбда-зонд
EPS 1.998.280 Лямбда-зонд
1.998.306 Лямбда-зонд
ESEN SKV 09SKV909 Лямбда-зонд
FACET 10.8280 Лямбда-зонд
10.8306 Лямбда-зонд
FAE 77153 Лямбда-зонд
FISPA 90134 Лямбда-зонд
90135 Лямбда-зонд
90283 Лямбда-зонд
HELLA 6PA 009 166-971 Лямбда-зонд
HOFFER 7481710 Лямбда-зонд
JOHNS LSO 60 09-001 Лямбда-зонд
KW 498 306 Лямбда-зонд
498 280 Лямбда-зонд
MAGNETI MARELLI 466016355006 Лямбда-зонд
MEAT & DORIA 81710 Лямбда-зонд
METZGER 0893413 Лямбда-зонд
NGK 93419 Лямбда-зонд
NPS DOX-1371 Лямбда-зонд
DOX-2002 Лямбда-зонд
SIDAT 90135 Лямбда-зонд
90283 Лямбда-зонд
90134 Лямбда-зонд
STELLOX 20-00023-SX Лямбда-зонд
20-00008-SX Лямбда-зонд
TRISCAN 8845 25005 Лямбда-зонд
8845 25019 Лямбда-зонд
VEMO V46-76-0001 Лямбда-зонд
WALKER PRODUCTS 250-24585 Лямбда-зонд
WILMINK GROUP WG1013992 Лямбда-зонд
2026 CATCAR.INFO (v 2.0)