#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0OHx8bW9kZWxfaWQ9PTYyMzR8fG1kZl9pZD09MF4yMjQ5N3x8c3BhcmVfaWQ9PTEwMDgxMg%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 = "22497" AND ( (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "959303" AND av.ProductID IN (1134)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "83.947" AND av.ProductID IN (1134)) OR (av.SupplierID = 449 AND av.DataSupplierArticleNumber = "139334" AND av.ProductID IN (1134)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "8029280" AND av.ProductID IN (1134)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "45-8298" AND av.ProductID IN (1134)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "9280" AND av.ProductID IN (1134)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0892345" AND av.ProductID IN (1134)) OR (av.SupplierID = 5 AND av.DataSupplierArticleNumber = "7.00272.03.0" AND av.ProductID IN (1134)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "83.947" AND av.ProductID IN (1134)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LEV075" AND av.ProductID IN (170,170)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "EV075" AND av.ProductID IN (170,170)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "14267" AND av.ProductID IN (170,170)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "ESV083" AND av.ProductID IN (170,170)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V52-63-0009" AND av.ProductID IN (1134,170)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1013368" AND av.ProductID IN (1134)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1025554" AND av.ProductID IN (1134)) ) 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 = 300 AND aa.DataSupplierArticleNumber = "959303") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "83.947") OR (aa.SupplierID = 449 AND aa.DataSupplierArticleNumber = "139334") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "8029280") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-8298") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "9280") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0892345") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.00272.03.0") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "83.947") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LEV075") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EV075") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "14267") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "ESV083") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V52-63-0009") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1013368") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025554") ) 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 = 300 AND aa.DataSupplierArticleNumber = "959303") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "83.947") OR (aa.SupplierID = 449 AND aa.DataSupplierArticleNumber = "139334") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "8029280") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-8298") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "9280") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0892345") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.00272.03.0") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "83.947") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LEV075") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EV075") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "14267") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "ESV083") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V52-63-0009") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1013368") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025554") ) AND aa.Language = "ru" Продажа автозапчастей типа Преобразователь давления для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTEX 959303 Преобразователь давления, управление ОГ
FISPA 83.947 Преобразователь давления, управление ОГ
HITACHI 139334 Преобразователь давления, управление ОГ
HOFFER 8029280 Преобразователь давления, управление ОГ
IPD 45-8298 Преобразователь давления, управление ОГ
MEAT & DORIA 9280 Преобразователь давления, управление ОГ
METZGER 0892345 Преобразователь давления, управление ОГ
PIERBURG 7.00272.03.0 Преобразователь давления, управление ОГ
SIDAT 83.947 Преобразователь давления, управление ОГ
SMPE LEV075 Преобразователь давления
EV075 Преобразователь давления
14267 Преобразователь давления
ESV083 Преобразователь давления
VEMO V52-63-0009 Преобразователь давления
WILMINK GROUP WG1013368 Преобразователь давления, управление ОГ
WG1025554 Преобразователь давления, управление ОГ
2026 CATCAR.INFO (v 2.0)