#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTEzMDc2fHxtZGZfaWQ9PTBeMTA3NTA1fHxzcGFyZV9pZD09MTAxNzI2&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 = "107505" AND ( (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DB921" AND av.ProductID IN (110)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DB7507" AND av.ProductID IN (110)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8GA 002 073-121" AND av.ProductID IN (110)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "LED" AND av.ProductID IN (110)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N382" AND av.ProductID IN (110)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N382-02B" AND av.ProductID IN (110)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7506ULT-02B" AND av.ProductID IN (110)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7506" AND av.ProductID IN (110)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "LED" AND av.ProductID IN (110)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7506-02B" AND av.ProductID IN (110)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7506ULT" AND av.ProductID IN (110)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12498LLECOCP" AND av.ProductID IN (111)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12498B2" AND av.ProductID IN (111)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12498VPB2" AND av.ProductID IN (111)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12498CP" AND av.ProductID IN (111)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "LED" AND av.ProductID IN (111)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12498LLECOB2" AND av.ProductID IN (111)) ) 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 = "DB921") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB7507") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GA 002 073-121") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N382") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N382-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7506ULT-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7506") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7506-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7506ULT") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12498LLECOCP") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12498B2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12498VPB2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12498CP") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12498LLECOB2") ) 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 = "DB921") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB7507") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GA 002 073-121") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N382") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N382-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7506ULT-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7506") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7506-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7506ULT") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12498LLECOCP") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12498B2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12498VPB2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12498CP") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12498LLECOB2") ) AND aa.Language = "ru" Продажа автозапчастей типа Лампа накаливания для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DYNAMATRIX DB921 Лампа накаливания, фонарь сигнала тормоза/задний габаритный
DB7507 Лампа накаливания, фонарь сигнала тормоза/задний габаритный
HELLA 8GA 002 073-121 Лампа накаливания, фонарь сигнала тормоза/задний габаритный
NEOLUX® LED Лампа накаливания, фонарь сигнала тормоза/задний габаритный
N382 Лампа накаливания, фонарь сигнала тормоза/задний габаритный
N382-02B Лампа накаливания, фонарь сигнала тормоза/задний габаритный
OSRAM 7506ULT-02B Лампа накаливания, фонарь сигнала тормоза/задний габаритный
7506 Лампа накаливания, фонарь сигнала тормоза/задний габаритный
LED Лампа накаливания, фонарь сигнала тормоза/задний габаритный
7506-02B Лампа накаливания, фонарь сигнала тормоза/задний габаритный
7506ULT Лампа накаливания, фонарь сигнала тормоза/задний габаритный
PHILIPS 12498LLECOCP Лампа накаливания, фонарь сигнала тормоза
12498B2 Лампа накаливания, фонарь сигнала тормоза
12498VPB2 Лампа накаливания, фонарь сигнала тормоза
12498CP Лампа накаливания, фонарь сигнала тормоза
LED Лампа накаливания, фонарь сигнала тормоза
12498LLECOB2 Лампа накаливания, фонарь сигнала тормоза
2026 CATCAR.INFO (v 2.0)