#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUyNXx8bW9kZWxfaWQ9PTUyMTB8fG1kZl9pZD09MF4xODMwNXx8c3BhcmVfaWQ9PTEwMDM2Mg%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 = "18305" AND ( (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "227031" AND av.ProductID IN (682)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "227865" AND av.ProductID IN (682)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "6646104" AND av.ProductID IN (682)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "6646043" AND av.ProductID IN (682)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "46043" AND av.ProductID IN (682)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "46104" AND av.ProductID IN (682)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1748248" AND av.ProductID IN (682)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1748309" AND av.ProductID IN (682)) ) 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 = 234 AND aa.DataSupplierArticleNumber = "227031") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "227865") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "6646104") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "6646043") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "46043") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "46104") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1748248") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1748309") ) 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 = 234 AND aa.DataSupplierArticleNumber = "227031") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "227865") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "6646104") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "6646043") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "46043") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "46104") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1748248") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1748309") ) AND aa.Language = "ru" Продажа автозапчастей типа Тяговое реле стартера для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ERA 227031 Тяговое реле, стартер
227865 Тяговое реле, стартер
HOFFER 6646104 Тяговое реле, стартер
6646043 Тяговое реле, стартер
MEAT & DORIA 46043 Тяговое реле, стартер
46104 Тяговое реле, стартер
WILMINK GROUP WG1748248 Тяговое реле, стартер
WG1748309 Тяговое реле, стартер
2026 CATCAR.INFO (v 2.0)