#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTE1ODd8fG1kZl9pZD09MV41NTE4fHxzcGFyZV9pZD09MjAwNzI2&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 = "5518" AND ( (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLB241P" AND av.ProductID IN (111)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBX241SB" AND av.ProductID IN (111)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBL241" AND av.ProductID IN (111)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLB241T" AND av.ProductID IN (111)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLB241" AND av.ProductID IN (111)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBL241LLPX2" AND av.ProductID IN (111)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLB241LLPX2" AND av.ProductID IN (111)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBX241" AND av.ProductID IN (111)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "37895" AND av.ProductID IN (111)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "77095" AND av.ProductID IN (111)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "17221" AND av.ProductID IN (111)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "99604" AND av.ProductID IN (111)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "17222" AND av.ProductID IN (111)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8GA 002 073-241" AND av.ProductID IN (111)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8GA 002 073-251" AND av.ProductID IN (111)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "0813150" AND av.ProductID IN (111)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "78-0055SET" AND av.ProductID IN (111)) OR (av.SupplierID = 485 AND av.DataSupplierArticleNumber = "17644" AND av.ProductID IN (111)) OR (av.SupplierID = 485 AND av.DataSupplierArticleNumber = "17643" AND av.ProductID IN (111)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N241" AND av.ProductID IN (111)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7511" AND av.ProductID IN (111)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7511-02B" AND av.ProductID IN (111)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7511TSP" AND av.ProductID IN (111)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PLS25-24/21" AND av.ProductID IN (111)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "13498MLCP" AND av.ProductID IN (111)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "13498B2" AND av.ProductID IN (111)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "13498CP" AND av.ProductID IN (111)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "13498MDCP" 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 = 4344 AND aa.DataSupplierArticleNumber = "LLB241P") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBX241SB") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBL241") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB241T") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB241") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBL241LLPX2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB241LLPX2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBX241") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "37895") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "77095") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17221") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "99604") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17222") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GA 002 073-241") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GA 002 073-251") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "0813150") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "78-0055SET") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "17644") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "17643") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N241") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7511") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7511-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7511TSP") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PLS25-24/21") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "13498MLCP") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "13498B2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "13498CP") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "13498MDCP") ) 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 = 4344 AND aa.DataSupplierArticleNumber = "LLB241P") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBX241SB") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBL241") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB241T") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB241") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBL241LLPX2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB241LLPX2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBX241") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "37895") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "77095") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17221") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "99604") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17222") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GA 002 073-241") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GA 002 073-251") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "0813150") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "78-0055SET") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "17644") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "17643") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N241") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7511") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7511-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7511TSP") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PLS25-24/21") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "13498MLCP") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "13498B2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "13498CP") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "13498MDCP") ) AND aa.Language = "ru" Продажа автозапчастей типа Лампа накаливания для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ELTA AUTOMOTIVE LLB241P Лампа накаливания, фонарь сигнала тормоза
ELBX241SB Лампа накаливания, фонарь сигнала тормоза
ELBL241 Лампа накаливания, фонарь сигнала тормоза
LLB241T Лампа накаливания, фонарь сигнала тормоза
LLB241 Лампа накаливания, фонарь сигнала тормоза
ELBL241LLPX2 Лампа накаливания, фонарь сигнала тормоза
LLB241LLPX2 Лампа накаливания, фонарь сигнала тормоза
ELBX241 Лампа накаливания, фонарь сигнала тормоза
GE 37895 Лампа накаливания, фонарь сигнала тормоза
77095 Лампа накаливания, фонарь сигнала тормоза
17221 Лампа накаливания, фонарь сигнала тормоза
99604 Лампа накаливания, фонарь сигнала тормоза
17222 Лампа накаливания, фонарь сигнала тормоза
HELLA 8GA 002 073-241 Лампа накаливания, фонарь сигнала тормоза
8GA 002 073-251 Лампа накаливания, фонарь сигнала тормоза
KRAFT AUTOMOTIVE 0813150 Лампа накаливания, фонарь сигнала тормоза
MAXGEAR 78-0055SET Лампа накаливания, фонарь сигнала тормоза
NARVA 17644 Лампа накаливания, фонарь сигнала тормоза
17643 Лампа накаливания, фонарь сигнала тормоза
NEOLUX® N241 Лампа накаливания, фонарь сигнала тормоза
OSRAM 7511 Лампа накаливания, фонарь сигнала тормоза
7511-02B Лампа накаливания, фонарь сигнала тормоза
7511TSP Лампа накаливания, фонарь сигнала тормоза
PATRON PLS25-24/21 Лампа накаливания, фонарь сигнала тормоза
PHILIPS 13498MLCP Лампа накаливания, фонарь сигнала тормоза
13498B2 Лампа накаливания, фонарь сигнала тормоза
13498CP Лампа накаливания, фонарь сигнала тормоза
13498MDCP Лампа накаливания, фонарь сигнала тормоза
2026 CATCAR.INFO (v 2.0)