#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0OXx8bW9kZWxfaWQ9PTM0MTN8fG1kZl9pZD09MF4xODYyOXx8c3BhcmVfaWQ9PTEwMTQyMw%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 = "18629" AND ( (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10079" AND av.ProductID IN (105)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10047" AND av.ProductID IN (105)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10048" AND av.ProductID IN (105)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10078" AND av.ProductID IN (105)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10046" AND av.ProductID IN (105)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DB7528" AND av.ProductID IN (105)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DB2825" AND av.ProductID IN (105)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DB7507" AND av.ProductID IN (105)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLB581LLPX2" AND av.ProductID IN (105)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBX581" AND av.ProductID IN (105)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLB581PX2" AND av.ProductID IN (105)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBX581SB" AND av.ProductID IN (105)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBL581LLPX2" AND av.ProductID IN (105)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLB581T" AND av.ProductID IN (105)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLB581" AND av.ProductID IN (105)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBL581X2" AND av.ProductID IN (105)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "06882" AND av.ProductID IN (105)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8GA 002 073-121" AND av.ProductID IN (105)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8GA 006 841-121" AND av.ProductID IN (105)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8GP 003 594-121" AND av.ProductID IN (105)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "89901190" AND av.ProductID IN (105)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "89901102" AND av.ProductID IN (105)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "89901175" AND av.ProductID IN (105)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "0803150" AND av.ProductID IN (105)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "0800850" AND av.ProductID IN (105)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N581-02B" AND av.ProductID IN (105)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N501" AND av.ProductID IN (105)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N501-02B" AND av.ProductID IN (105)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N382" AND av.ProductID IN (105)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N581" AND av.ProductID IN (105)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N382-02B" AND av.ProductID IN (105)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "2825" AND av.ProductID IN (105)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7507ULT-02B" AND av.ProductID IN (105)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7507DC-02B" AND av.ProductID IN (105)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7506ULT-02B" AND av.ProductID IN (105)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7506" AND av.ProductID IN (105)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "2825-02B" AND av.ProductID IN (105)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7507LDA-02B" AND av.ProductID IN (105)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7507" AND av.ProductID IN (105)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7506-02B" AND av.ProductID IN (105)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "2825ULT" AND av.ProductID IN (105)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7507ULT" AND av.ProductID IN (105)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7507-02B" AND av.ProductID IN (105)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "7506ULT" AND av.ProductID IN (105)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "2825ULT-02B" AND av.ProductID IN (105)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "5224" AND av.ProductID IN (105)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "2010" AND av.ProductID IN (105)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "BL2010" AND av.ProductID IN (105)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "5221" AND av.ProductID IN (105)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "BL5221" AND av.ProductID IN (105)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "5221L" AND av.ProductID IN (105)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "99 90 6882" AND av.ProductID IN (105)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1071" AND av.ProductID IN (105)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1064" AND av.ProductID IN (105)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1065" AND av.ProductID IN (105)) ) 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 = 253 AND aa.DataSupplierArticleNumber = "LID10079") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10047") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10048") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10078") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10046") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB7528") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB2825") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB7507") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB581LLPX2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBX581") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB581PX2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBX581SB") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBL581LLPX2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB581T") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB581") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBL581X2") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "06882") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GA 002 073-121") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GA 006 841-121") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GP 003 594-121") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "89901190") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "89901102") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "89901175") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "0803150") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "0800850") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N581-02B") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N501") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N501-02B") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N382") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N581") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N382-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507ULT-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507DC-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 = "2825-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507LDA-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7506-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825ULT") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507ULT") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7506ULT") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825ULT-02B") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "5224") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "2010") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL2010") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "5221") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL5221") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "5221L") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "99 90 6882") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1071") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1064") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1065") ) 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 = 253 AND aa.DataSupplierArticleNumber = "LID10079") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10047") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10048") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10078") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10046") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB7528") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB2825") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB7507") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB581LLPX2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBX581") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB581PX2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBX581SB") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBL581LLPX2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB581T") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB581") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBL581X2") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "06882") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GA 002 073-121") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GA 006 841-121") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GP 003 594-121") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "89901190") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "89901102") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "89901175") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "0803150") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "0800850") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N581-02B") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N501") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N501-02B") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N382") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N581") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N382-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507ULT-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507DC-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 = "2825-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507LDA-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7506-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825ULT") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507ULT") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7506ULT") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "2825ULT-02B") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "5224") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "2010") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL2010") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "5221") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL5221") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "5221L") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "99 90 6882") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1071") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1064") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1065") ) AND aa.Language = "ru" Продажа автозапчастей типа Лампа накаливания для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DIEDERICHS LID10079 Лампа накаливания, фонарь указателя поворота
LID10047 Лампа накаливания, фонарь указателя поворота
LID10048 Лампа накаливания, фонарь указателя поворота
LID10078 Лампа накаливания, фонарь указателя поворота
LID10046 Лампа накаливания, фонарь указателя поворота
DYNAMATRIX DB7528 Лампа накаливания, фонарь указателя поворота
DB2825 Лампа накаливания, фонарь указателя поворота
DB7507 Лампа накаливания, фонарь указателя поворота
ELTA AUTOMOTIVE LLB581LLPX2 Лампа накаливания, фонарь указателя поворота
ELBX581 Лампа накаливания, фонарь указателя поворота
LLB581PX2 Лампа накаливания, фонарь указателя поворота
ELBX581SB Лампа накаливания, фонарь указателя поворота
ELBL581LLPX2 Лампа накаливания, фонарь указателя поворота
LLB581T Лампа накаливания, фонарь указателя поворота
LLB581 Лампа накаливания, фонарь указателя поворота
ELBL581X2 Лампа накаливания, фонарь указателя поворота
FEBI BILSTEIN 06882 Лампа накаливания, фонарь указателя поворота
HELLA 8GA 002 073-121 Лампа накаливания, фонарь указателя поворота
8GA 006 841-121 Лампа накаливания, фонарь указателя поворота
8GP 003 594-121 Лампа накаливания, фонарь указателя поворота
HERTH+BUSS ELPARTS 89901190 Лампа накаливания, фонарь указателя поворота
89901102 Лампа накаливания, фонарь указателя поворота
89901175 Лампа накаливания, фонарь указателя поворота
KRAFT AUTOMOTIVE 0803150 Лампа накаливания, фонарь указателя поворота
0800850 Лампа накаливания, фонарь указателя поворота
NEOLUX® N581-02B Лампа накаливания, фонарь указателя поворота
N501 Лампа накаливания, фонарь указателя поворота
N501-02B Лампа накаливания, фонарь указателя поворота
N382 Лампа накаливания, фонарь указателя поворота
N581 Лампа накаливания, фонарь указателя поворота
N382-02B Лампа накаливания, фонарь указателя поворота
OSRAM 2825 Лампа накаливания, фонарь указателя поворота
7507ULT-02B Лампа накаливания, фонарь указателя поворота
7507DC-02B Лампа накаливания, фонарь указателя поворота
7506ULT-02B Лампа накаливания, фонарь указателя поворота
7506 Лампа накаливания, фонарь указателя поворота
2825-02B Лампа накаливания, фонарь указателя поворота
7507LDA-02B Лампа накаливания, фонарь указателя поворота
7507 Лампа накаливания, фонарь указателя поворота
7506-02B Лампа накаливания, фонарь указателя поворота
2825ULT Лампа накаливания, фонарь указателя поворота
7507ULT Лампа накаливания, фонарь указателя поворота
7507-02B Лампа накаливания, фонарь указателя поворота
7506ULT Лампа накаливания, фонарь указателя поворота
2825ULT-02B Лампа накаливания, фонарь указателя поворота
SPAHN GLÜHLAMPEN 5224 Лампа накаливания, фонарь указателя поворота
2010 Лампа накаливания, фонарь указателя поворота
BL2010 Лампа накаливания, фонарь указателя поворота
5221 Лампа накаливания, фонарь указателя поворота
BL5221 Лампа накаливания, фонарь указателя поворота
5221L Лампа накаливания, фонарь указателя поворота
SWAG 99 90 6882 Лампа накаливания, фонарь указателя поворота
ZEKKERT LP-1071 Лампа накаливания, фонарь указателя поворота
LP-1064 Лампа накаливания, фонарь указателя поворота
LP-1065 Лампа накаливания, фонарь указателя поворота
2026 CATCAR.INFO (v 2.0)