#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTc1ODF8fG1kZl9pZD09MF4yMDczOXx8c3BhcmVfaWQ9PTEwMDgxMQ%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 = "20739" AND ( (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "VEG1143" AND av.ProductID IN (1145)) OR (av.SupplierID = 460 AND av.DataSupplierArticleNumber = "717730142" AND av.ProductID IN (1145)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "752.070" AND av.ProductID IN (3507)) OR (av.SupplierID = 226 AND av.DataSupplierArticleNumber = "73-0142" AND av.ProductID IN (1145)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "XEG9040" AND av.ProductID IN (1145)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "83.1113" AND av.ProductID IN (1145)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "7518331" AND av.ProductID IN (1145)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "88331" AND av.ProductID IN (1145)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVER162" AND av.ProductID IN (1145)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVER252" AND av.ProductID IN (1145)) OR (av.SupplierID = 5 AND av.DataSupplierArticleNumber = "7.24809.78.0" AND av.ProductID IN (1145)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XEGR139" AND av.ProductID IN (1145)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "83.1113" AND av.ProductID IN (1145)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LEGR086" AND av.ProductID IN (1145,1145)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "ERV198" AND av.ProductID IN (1145,1145)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "EGR180" AND av.ProductID IN (1145,1145)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "14423" AND av.ProductID IN (1145,1145)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LEGR244" AND av.ProductID IN (1145)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "ERV295" AND av.ProductID IN (1145)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "EGR390" AND av.ProductID IN (1145)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "18031" AND av.ProductID IN (1145)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8813 24083" AND av.ProductID IN (1145)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V40-63-0030" AND av.ProductID IN (1145)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1194787" AND av.ProductID IN (3507)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1015263" AND av.ProductID IN (1145)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1494511" AND av.ProductID IN (1145)) ) 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 = 4534 AND aa.DataSupplierArticleNumber = "VEG1143") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "717730142") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "752.070") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "73-0142") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "XEG9040") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "83.1113") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7518331") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "88331") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVER162") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVER252") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.24809.78.0") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XEGR139") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "83.1113") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LEGR086") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "ERV198") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EGR180") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "14423") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LEGR244") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "ERV295") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EGR390") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "18031") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8813 24083") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-63-0030") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1194787") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1015263") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1494511") ) 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 = 4534 AND aa.DataSupplierArticleNumber = "VEG1143") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "717730142") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "752.070") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "73-0142") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "XEG9040") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "83.1113") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7518331") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "88331") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVER162") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVER252") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.24809.78.0") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XEGR139") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "83.1113") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LEGR086") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "ERV198") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EGR180") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "14423") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LEGR244") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "ERV295") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EGR390") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "18031") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8813 24083") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-63-0030") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1194787") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1015263") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1494511") ) AND aa.Language = "ru" Продажа автозапчастей типа Клапан системы рециркуляции ОГ для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AMK VEG1143 Клапан возврата ОГ
DRI 717730142 Клапан возврата ОГ
ELRING 752.070 Прокладка, клапан возврата ОГ
ELSTOCK 73-0142 Клапан возврата ОГ
ELTA AUTOMOTIVE XEG9040 Клапан возврата ОГ
FISPA 83.1113 Клапан возврата ОГ
HOFFER 7518331 Клапан возврата ОГ
MEAT & DORIA 88331 Клапан возврата ОГ
MOTAQUIP LVER162 Клапан возврата ОГ
LVER252 Клапан возврата ОГ
PIERBURG 7.24809.78.0 Клапан возврата ОГ
QUINTON HAZELL XEGR139 Клапан возврата ОГ
SIDAT 83.1113 Клапан возврата ОГ
SMPE LEGR086 Клапан возврата ОГ
ERV198 Клапан возврата ОГ
EGR180 Клапан возврата ОГ
14423 Клапан возврата ОГ
LEGR244 Клапан возврата ОГ
ERV295 Клапан возврата ОГ
EGR390 Клапан возврата ОГ
18031 Клапан возврата ОГ
TRISCAN 8813 24083 Клапан возврата ОГ
VEMO V40-63-0030 Клапан возврата ОГ
WILMINK GROUP WG1194787 Прокладка, клапан возврата ОГ
WG1015263 Клапан возврата ОГ
WG1494511 Клапан возврата ОГ
2026 CATCAR.INFO (v 2.0)