#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1NXx8bW9kZWxfaWQ9PTUwNzZ8fG1kZl9pZD09MF4xODIxMnx8c3BhcmVfaWQ9PTEwMTY5OQ%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 = "18212" AND ( (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DB7515" AND av.ProductID IN (2797)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DB921" AND av.ProductID IN (2797)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DB2825" AND av.ProductID IN (2797)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DB2827" AND av.ProductID IN (2797)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "LED" AND av.ProductID IN (2797)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7505-02B" AND av.ProductID IN (2797)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "LED" AND av.ProductID IN (2797)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7505" AND av.ProductID IN (2797)) ) 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 = 4318 AND aa.DataSupplierArticleNumber = "DB7515") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB921") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB2825") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB2827") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7505-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7505") ) 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 = 4318 AND aa.DataSupplierArticleNumber = "DB7515") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB921") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB2825") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB2827") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7505-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7505") ) AND aa.Language = "ru" Продажа автозапчастей типа Дополнительный стоп-сигнал для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DYNAMATRIX DB7515 Лампа накаливания, дополнительный фонарь сигнала торможения
DB921 Лампа накаливания, дополнительный фонарь сигнала торможения
DB2825 Лампа накаливания, дополнительный фонарь сигнала торможения
DB2827 Лампа накаливания, дополнительный фонарь сигнала торможения
NEOLUX® LED Лампа накаливания, дополнительный фонарь сигнала торможения
OSRAM 7505-02B Лампа накаливания, дополнительный фонарь сигнала торможения
LED Лампа накаливания, дополнительный фонарь сигнала торможения
7505 Лампа накаливания, дополнительный фонарь сигнала торможения
2026 CATCAR.INFO (v 2.0)