#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTEzfHxtZGZfaWQ9PTBeMTMzNnx8c3BhcmVfaWQ9PTEwMDcwOA%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 = "1336" AND ( (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "405130" AND av.ProductID IN (6348)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "405128" AND av.ProductID IN (6348)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2323017" AND av.ProductID IN (6348)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2323018" AND av.ProductID IN (6348)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "405130" AND av.ProductID IN (6348)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "405128" AND av.ProductID IN (6348)) ) 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 = 441 AND aa.DataSupplierArticleNumber = "405130") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "405128") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323017") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323018") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405130") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405128") ) 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 = 441 AND aa.DataSupplierArticleNumber = "405130") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "405128") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323017") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323018") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405130") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405128") ) AND aa.Language = "ru" Продажа автозапчастей типа Центральное электрооборудования для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FISPA 405130 Ремонтный комплект кабеля, центральное электрооборудование
405128 Ремонтный комплект кабеля, центральное электрооборудование
METZGER 2323017 Ремонтный комплект кабеля, центральное электрооборудование
2323018 Ремонтный комплект кабеля, центральное электрооборудование
SIDAT 405130 Ремонтный комплект кабеля, центральное электрооборудование
405128 Ремонтный комплект кабеля, центральное электрооборудование
2026 CATCAR.INFO (v 2.0)