#216.73.216.140 catcar.info/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTQ4MDR8fG1kZl9pZD09MF4xNjMwMHx8c3BhcmVfaWQ9PTEwMDcyNw%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 = "16300" AND ( (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B18183" AND av.ProductID IN (1432)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "DAB428" AND av.ProductID IN (932)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "9 9376 1" AND av.ProductID IN (1385)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "75614267" AND av.ProductID IN (1385)) OR (av.SupplierID = 4606 AND av.DataSupplierArticleNumber = "MEC/8-12" AND av.ProductID IN (1441)) OR (av.SupplierID = 4606 AND av.DataSupplierArticleNumber = "MCV/10-12" AND av.ProductID IN (1441)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1726542" AND av.ProductID IN (5763)) ) 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 = 4815 AND aa.DataSupplierArticleNumber = "B18183") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "DAB428") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9376 1") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "75614267") OR (aa.SupplierID = 4606 AND aa.DataSupplierArticleNumber = "MEC/8-12") OR (aa.SupplierID = 4606 AND aa.DataSupplierArticleNumber = "MCV/10-12") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1726542") ) 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 = 4815 AND aa.DataSupplierArticleNumber = "B18183") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "DAB428") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9376 1") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "75614267") OR (aa.SupplierID = 4606 AND aa.DataSupplierArticleNumber = "MEC/8-12") OR (aa.SupplierID = 4606 AND aa.DataSupplierArticleNumber = "MCV/10-12") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1726542") ) AND aa.Language = "ru" Продажа автозапчастей типа Приборы управления для автомобилей - Catcar.info
Каталог автозапчастей
Catcar Aftermarket
Каталог автозапчастей
Catcar Aftermarket
Уже продаёте автозапчасти? Подключите каталоги на свой сайт, чтобы повысить продажи
Подключить каталоги

Автозапчасти


Производители Артикул Наименование Сведения Полная информация
Borsehung B18183 Блок управления, регулировка угла наклона фар
ELTA AUTOMOTIVE DAB428 Блок управления, система зажигания
GEBE 9 9376 1 Блок управления, отопление / вентиляция
HERTH+BUSS ELPARTS 75614267 Блок управления, отопление / вентиляция
NAGARES MEC/8-12 Блок управления, кондиционер
MCV/10-12 Блок управления, кондиционер
WILMINK GROUP WG1726542 Управляющий прибор, топливный насос
2026 CATCAR.INFO (v 2.0)