#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTgwfHxtZGZfaWQ9PTBeMTIzNDZ8fHNwYXJlX2lkPT0xMDA2MTM%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 = "12346" AND ( (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "661156" AND av.ProductID IN (796)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "661272" AND av.ProductID IN (796)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "9 9397 1" AND av.ProductID IN (796)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "5WG 003 620-081" AND av.ProductID IN (796)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "5WG 003 620-087" AND av.ProductID IN (796)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "75614020" AND av.ProductID IN (796)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "75614012" AND av.ProductID IN (796)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1299200300" AND av.ProductID IN (796)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 830 0014" AND av.ProductID IN (796)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "202 146" AND av.ProductID IN (796)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-71-0026" AND av.ProductID IN (796)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-71-0025" AND av.ProductID IN (796)) ) 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 = "661156") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "661272") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9397 1") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "5WG 003 620-081") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "5WG 003 620-087") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "75614020") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "75614012") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1299200300") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 830 0014") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "202 146") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0026") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0025") ) 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 = "661156") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "661272") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9397 1") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "5WG 003 620-081") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "5WG 003 620-087") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "75614020") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "75614012") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1299200300") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 830 0014") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "202 146") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0026") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0025") ) AND aa.Language = "ru" Продажа автозапчастей типа Выключатель / реле для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ERA 661156 Реле, интервал включения стеклоочистителя
661272 Реле, интервал включения стеклоочистителя
GEBE 9 9397 1 Реле, интервал включения стеклоочистителя
HELLA 5WG 003 620-081 Реле, интервал включения стеклоочистителя
5WG 003 620-087 Реле, интервал включения стеклоочистителя
HERTH+BUSS ELPARTS 75614020 Реле, интервал включения стеклоочистителя
75614012 Реле, интервал включения стеклоочистителя
JP GROUP 1299200300 Реле, интервал включения стеклоочистителя
MEYLE 100 830 0014 Реле, интервал включения стеклоочистителя
TOPRAN 202 146 Реле, интервал включения стеклоочистителя
VEMO V15-71-0026 Реле, интервал включения стеклоочистителя
V15-71-0025 Реле, интервал включения стеклоочистителя
2026 CATCAR.INFO (v 2.0)