#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxNHx8bW9kZWxfaWQ9PTk2ODV8fG1kZl9pZD09MF4xMDg3N3x8c3BhcmVfaWQ9PTEwMDc5Mw%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 = "10877" AND ( (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49138" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-48456" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49462" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49268" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-48490" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49680" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49380" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-48814" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-48260" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49842" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49414" AND av.ProductID IN (3922)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADB117004" AND av.ProductID IN (3922)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 258 010 081" AND av.ProductID IN (3922)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 258 986 602" AND av.ProductID IN (3922)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "LS140194" AND av.ProductID IN (3922)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "ES20413-12B1" 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-2005" AND av.ProductID IN (3922)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "XLS1014" AND av.ProductID IN (3922)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.998.078" AND av.ProductID IN (3922)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.998.246" AND av.ProductID IN (3922)) OR (av.SupplierID = 4969 AND av.DataSupplierArticleNumber = "09SKV696" AND av.ProductID IN (3922)) OR (av.SupplierID = 4969 AND av.DataSupplierArticleNumber = "09SKV703" 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.8078" AND av.ProductID IN (3922)) OR (av.SupplierID = 240 AND av.DataSupplierArticleNumber = "77433" AND av.ProductID IN (3922)) OR (av.SupplierID = 240 AND av.DataSupplierArticleNumber = "77494" AND av.ProductID IN (3922)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "26172" AND av.ProductID IN (3922)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "90344" AND av.ProductID IN (3922)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "7481091" AND av.ProductID IN (3922)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "7481744" AND av.ProductID IN (3922)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "498 246" AND av.ProductID IN (3922)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "498 078" AND av.ProductID IN (3922)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "81744" AND av.ProductID IN (3922)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "81091" AND av.ProductID IN (3922)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0893334" AND av.ProductID IN (3922)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0893473" AND av.ProductID IN (3922)) OR (av.SupplierID = 15 AND av.DataSupplierArticleNumber = "1579" AND av.ProductID IN (3922)) OR (av.SupplierID = 15 AND av.DataSupplierArticleNumber = "96375" AND av.ProductID IN (3922)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DOX-0240" AND av.ProductID IN (3922)) OR (av.SupplierID = 5 AND av.DataSupplierArticleNumber = "7.05271.74.0" AND av.ProductID IN (3922)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "90344" AND av.ProductID IN (3922)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "20-00022-SX" AND av.ProductID IN (3922)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "62 92 6172" AND av.ProductID IN (3922)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8845 28009" AND av.ProductID IN (3922)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8845 28046" AND av.ProductID IN (3922)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V22-76-0001" AND av.ProductID IN (3922)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V45-76-0006" AND av.ProductID IN (3922)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-76-0002" AND av.ProductID IN (3922)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V20-76-0041" AND av.ProductID IN (3922)) OR (av.SupplierID = 303 AND av.DataSupplierArticleNumber = "250-24546" AND av.ProductID IN (3922)) OR (av.SupplierID = 303 AND av.DataSupplierArticleNumber = "250-24841" AND av.ProductID IN (3922)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1013872" AND av.ProductID IN (3922)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1014019" AND av.ProductID IN (3922)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1431135" 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-49138") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48456") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49462") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49268") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48490") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49680") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49380") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48814") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48260") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49842") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49414") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADB117004") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 010 081") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 986 602") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "LS140194") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "ES20413-12B1") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DOX-0150") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DOX-2005") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "XLS1014") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.998.078") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.998.246") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "09SKV696") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "09SKV703") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "09SKV909") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "10.8078") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "77433") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "77494") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26172") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90344") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7481091") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7481744") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "498 246") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "498 078") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "81744") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "81091") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0893334") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0893473") OR (aa.SupplierID = 15 AND aa.DataSupplierArticleNumber = "1579") OR (aa.SupplierID = 15 AND aa.DataSupplierArticleNumber = "96375") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DOX-0240") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.05271.74.0") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90344") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "20-00022-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "62 92 6172") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 28009") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 28046") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V22-76-0001") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V45-76-0006") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-76-0002") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V20-76-0041") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-24546") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-24841") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1013872") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1014019") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1431135") ) 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-49138") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48456") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49462") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49268") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48490") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49680") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49380") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48814") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48260") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49842") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49414") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADB117004") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 010 081") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 986 602") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "LS140194") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "ES20413-12B1") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DOX-0150") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DOX-2005") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "XLS1014") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.998.078") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.998.246") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "09SKV696") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "09SKV703") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "09SKV909") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "10.8078") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "77433") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "77494") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26172") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90344") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7481091") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7481744") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "498 246") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "498 078") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "81744") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "81091") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0893334") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0893473") OR (aa.SupplierID = 15 AND aa.DataSupplierArticleNumber = "1579") OR (aa.SupplierID = 15 AND aa.DataSupplierArticleNumber = "96375") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DOX-0240") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.05271.74.0") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90344") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "20-00022-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "62 92 6172") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 28009") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 28046") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V22-76-0001") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V45-76-0006") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-76-0002") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V20-76-0041") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-24546") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-24841") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1013872") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1014019") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1431135") ) AND aa.Language = "ru" Продажа автозапчастей типа Лямбда-регулирование для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ASHUKI 9200-49138 Лямбда-зонд
9200-48456 Лямбда-зонд
9200-49462 Лямбда-зонд
9200-49268 Лямбда-зонд
9200-48490 Лямбда-зонд
9200-49680 Лямбда-зонд
9200-49380 Лямбда-зонд
9200-48814 Лямбда-зонд
9200-48260 Лямбда-зонд
9200-49842 Лямбда-зонд
9200-49414 Лямбда-зонд
BLUE PRINT ADB117004 Лямбда-зонд
BOSCH 0 258 010 081 Лямбда-зонд
0 258 986 602 Лямбда-зонд
CALORSTAT by Vernet LS140194 Лямбда-зонд
DELPHI ES20413-12B1 Лямбда-зонд
DENSO DOX-0150 Лямбда-зонд
DOX-2005 Лямбда-зонд
ELTA AUTOMOTIVE XLS1014 Лямбда-зонд
EPS 1.998.078 Лямбда-зонд
1.998.246 Лямбда-зонд
ESEN SKV 09SKV696 Лямбда-зонд
09SKV703 Лямбда-зонд
09SKV909 Лямбда-зонд
FACET 10.8078 Лямбда-зонд
FAE 77433 Лямбда-зонд
77494 Лямбда-зонд
FEBI BILSTEIN 26172 Лямбда-зонд
FISPA 90344 Лямбда-зонд
HOFFER 7481091 Лямбда-зонд
7481744 Лямбда-зонд
KW 498 246 Лямбда-зонд
498 078 Лямбда-зонд
MEAT & DORIA 81744 Лямбда-зонд
81091 Лямбда-зонд
METZGER 0893334 Лямбда-зонд
0893473 Лямбда-зонд
NGK 1579 Лямбда-зонд
96375 Лямбда-зонд
NPS DOX-0240 Лямбда-зонд
PIERBURG 7.05271.74.0 Лямбда-зонд
SIDAT 90344 Лямбда-зонд
STELLOX 20-00022-SX Лямбда-зонд
SWAG 62 92 6172 Лямбда-зонд
TRISCAN 8845 28009 Лямбда-зонд
8845 28046 Лямбда-зонд
VEMO V22-76-0001 Лямбда-зонд
V45-76-0006 Лямбда-зонд
V99-76-0002 Лямбда-зонд
V20-76-0041 Лямбда-зонд
WALKER PRODUCTS 250-24546 Лямбда-зонд
250-24841 Лямбда-зонд
WILMINK GROUP WG1013872 Лямбда-зонд
WG1014019 Лямбда-зонд
WG1431135 Лямбда-зонд
2026 CATCAR.INFO (v 2.0)