#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2Nnx8bW9kZWxfaWQ9PTE3fHxtZGZfaWQ9PTBeMzc3Mnx8c3BhcmVfaWQ9PTEwMTQyMw%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 = "3772" AND ( (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10046" 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 = 4344 AND av.DataSupplierArticleNumber = "LLB382T" AND av.ProductID IN (105)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLB382" AND av.ProductID IN (105)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBL382X2" AND av.ProductID IN (105)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLB382LLPX2" AND av.ProductID IN (105)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBX382" AND av.ProductID IN (105)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLB382PX2" AND av.ProductID IN (105)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBX382SB" AND av.ProductID IN (105)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBL382LLPX2" AND av.ProductID IN (105)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "17218" AND av.ProductID IN (105)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "45690" AND av.ProductID IN (105)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "23284" AND av.ProductID IN (105)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "77049" AND av.ProductID IN (105)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "37894" AND av.ProductID IN (105)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "17131" AND av.ProductID IN (105)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "45348" AND av.ProductID IN (105)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8GA 002 073-121" AND av.ProductID IN (105)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "78-0020SET" AND av.ProductID IN (105)) OR (av.SupplierID = 485 AND av.DataSupplierArticleNumber = "17635" AND av.ProductID IN (105)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PLS25-21" AND av.ProductID IN (105)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12498LLECOB2" AND av.ProductID IN (105)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12498LLECOCP" AND av.ProductID IN (105)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12498B2" AND av.ProductID IN (105)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12498VPB2" AND av.ProductID IN (105)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12498CP" AND av.ProductID IN (105)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "202075" 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 = "2010" AND av.ProductID IN (105)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032106" AND av.ProductID IN (105)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032201" AND av.ProductID IN (105)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032101" 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 = "LID10046") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10047") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10048") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB382T") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB382") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBL382X2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB382LLPX2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBX382") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB382PX2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBX382SB") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBL382LLPX2") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17218") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "45690") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "23284") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "77049") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "37894") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17131") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "45348") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GA 002 073-121") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "78-0020SET") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "17635") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PLS25-21") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12498LLECOB2") 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 = 225 AND aa.DataSupplierArticleNumber = "202075") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL2010") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "2010") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032106") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032201") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032101") ) 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 = "LID10046") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10047") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10048") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB382T") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB382") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBL382X2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB382LLPX2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBX382") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB382PX2") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBX382SB") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBL382LLPX2") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17218") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "45690") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "23284") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "77049") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "37894") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17131") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "45348") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GA 002 073-121") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "78-0020SET") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "17635") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PLS25-21") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12498LLECOB2") 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 = 225 AND aa.DataSupplierArticleNumber = "202075") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL2010") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "2010") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032106") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032201") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032101") ) AND aa.Language = "ru" Продажа автозапчастей типа Лампа накаливания для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DIEDERICHS LID10046 Лампа накаливания, фонарь указателя поворота
LID10047 Лампа накаливания, фонарь указателя поворота
LID10048 Лампа накаливания, фонарь указателя поворота
ELTA AUTOMOTIVE LLB382T Лампа накаливания, фонарь указателя поворота
LLB382 Лампа накаливания, фонарь указателя поворота
ELBL382X2 Лампа накаливания, фонарь указателя поворота
LLB382LLPX2 Лампа накаливания, фонарь указателя поворота
ELBX382 Лампа накаливания, фонарь указателя поворота
LLB382PX2 Лампа накаливания, фонарь указателя поворота
ELBX382SB Лампа накаливания, фонарь указателя поворота
ELBL382LLPX2 Лампа накаливания, фонарь указателя поворота
GE 17218 Лампа накаливания, фонарь указателя поворота
45690 Лампа накаливания, фонарь указателя поворота
23284 Лампа накаливания, фонарь указателя поворота
77049 Лампа накаливания, фонарь указателя поворота
37894 Лампа накаливания, фонарь указателя поворота
17131 Лампа накаливания, фонарь указателя поворота
45348 Лампа накаливания, фонарь указателя поворота
HELLA 8GA 002 073-121 Лампа накаливания, фонарь указателя поворота
MAXGEAR 78-0020SET Лампа накаливания, фонарь указателя поворота
NARVA 17635 Лампа накаливания, фонарь указателя поворота
PATRON PLS25-21 Лампа накаливания, фонарь указателя поворота
PHILIPS 12498LLECOB2 Лампа накаливания, фонарь указателя поворота
12498LLECOCP Лампа накаливания, фонарь указателя поворота
12498B2 Лампа накаливания, фонарь указателя поворота
12498VPB2 Лампа накаливания, фонарь указателя поворота
12498CP Лампа накаливания, фонарь указателя поворота
SCT Germany 202075 Лампа накаливания, фонарь указателя поворота
SPAHN GLÜHLAMPEN BL2010 Лампа накаливания, фонарь указателя поворота
2010 Лампа накаливания, фонарь указателя поворота
VALEO 032106 Лампа накаливания, фонарь указателя поворота
032201 Лампа накаливания, фонарь указателя поворота
032101 Лампа накаливания, фонарь указателя поворота
2026 CATCAR.INFO (v 2.0)