#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTM1NDF8fG1kZl9pZD09MV4yMDU5NXx8c3BhcmVfaWQ9PTIwMDc0MQ%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 articlecommercialvehicles av JOIN commercialvehiclelinkageattributes_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 = "20595" AND ( (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8GA 002 071-271" AND av.ProductID IN (112)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8GA 002 071-251" AND av.ProductID IN (112)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N246" AND av.ProductID IN (112)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "5637-02B" AND av.ProductID IN (112)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "5637TSP" AND av.ProductID IN (112)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "5637" AND av.ProductID IN (112)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "4521" AND av.ProductID IN (112)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "4521HD" AND av.ProductID IN (112)) ) 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 = 2 AND aa.DataSupplierArticleNumber = "8GA 002 071-271") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GA 002 071-251") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N246") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "5637-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "5637TSP") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "5637") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "4521") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "4521HD") ) 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 = 2 AND aa.DataSupplierArticleNumber = "8GA 002 071-271") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GA 002 071-251") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N246") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "5637-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "5637TSP") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "5637") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "4521") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "4521HD") ) AND aa.Language = "ru" Продажа автозапчастей типа Лампа накаливания, фонарь освещения номерного знака для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
HELLA 8GA 002 071-271 Лампа накаливания, фонарь освещения номерного знака
8GA 002 071-251 Лампа накаливания, фонарь освещения номерного знака
NEOLUX® N246 Лампа накаливания, фонарь освещения номерного знака
OSRAM 5637-02B Лампа накаливания, фонарь освещения номерного знака
5637TSP Лампа накаливания, фонарь освещения номерного знака
5637 Лампа накаливания, фонарь освещения номерного знака
SPAHN GLÜHLAMPEN 4521 Лампа накаливания, фонарь освещения номерного знака
4521HD Лампа накаливания, фонарь освещения номерного знака
2026 CATCAR.INFO (v 2.0)