#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0NXx8bW9kZWxfaWQ9PTQ2Mjl8fG1kZl9pZD09MF41MTc5fHxzcGFyZV9pZD09MTAwNDk5&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 = "5179" AND ( (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "77048" AND av.ProductID IN (112)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "41961" AND av.ProductID IN (112)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93011341" AND av.ProductID IN (112)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "70244" AND av.ProductID IN (112)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "17138" AND av.ProductID IN (112)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "76108" AND av.ProductID IN (112)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "27888" AND av.ProductID IN (112)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "0800850" AND av.ProductID IN (112)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N501" AND av.ProductID IN (112)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N501-02B" AND av.ProductID IN (112)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "2825HCBI-02B" AND av.ProductID IN (112)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "2825ULT" AND av.ProductID IN (112)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "2825" AND av.ProductID IN (112)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "2825ULT-02B" AND av.ProductID IN (112)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "2825-02B" 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 = 4612 AND aa.DataSupplierArticleNumber = "77048") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "41961") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93011341") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "70244") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17138") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "76108") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "27888") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "0800850") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N501") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N501-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825HCBI-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825ULT") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825ULT-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825-02B") ) 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 = 4612 AND aa.DataSupplierArticleNumber = "77048") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "41961") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93011341") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "70244") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17138") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "76108") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "27888") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "0800850") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N501") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N501-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825HCBI-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825ULT") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825ULT-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825-02B") ) AND aa.Language = "ru" Продажа автозапчастей типа Лампа накаливания для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
GE 77048 Лампа накаливания, фонарь освещения номерного знака
41961 Лампа накаливания, фонарь освещения номерного знака
93011341 Лампа накаливания, фонарь освещения номерного знака
70244 Лампа накаливания, фонарь освещения номерного знака
17138 Лампа накаливания, фонарь освещения номерного знака
76108 Лампа накаливания, фонарь освещения номерного знака
27888 Лампа накаливания, фонарь освещения номерного знака
KRAFT AUTOMOTIVE 0800850 Лампа накаливания, фонарь освещения номерного знака
NEOLUX® N501 Лампа накаливания, фонарь освещения номерного знака
N501-02B Лампа накаливания, фонарь освещения номерного знака
OSRAM 2825HCBI-02B Лампа накаливания, фонарь освещения номерного знака
2825ULT Лампа накаливания, фонарь освещения номерного знака
2825 Лампа накаливания, фонарь освещения номерного знака
2825ULT-02B Лампа накаливания, фонарь освещения номерного знака
2825-02B Лампа накаливания, фонарь освещения номерного знака
2026 CATCAR.INFO (v 2.0)