#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTgwMjV8fG1kZl9pZD09MF4xMDU3MTd8fHNwYXJlX2lkPT0xMDA0OTg%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 = "105717" AND ( (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10055" AND av.ProductID IN (105)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10054" AND av.ProductID IN (105)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DB921" 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 = "DB6411" AND av.ProductID IN (105)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DB7507" 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 = 4671 AND av.DataSupplierArticleNumber = "N581" AND av.ProductID IN (105)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "8888" 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 = "N382" 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 = "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 = "9999" 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 = "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 = "7504" 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 = 75 AND av.DataSupplierArticleNumber = "12496SVS2" AND av.ProductID IN (105)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12496NAB2" AND av.ProductID IN (105)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12496NACP" AND av.ProductID IN (105)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12188NAC1" AND av.ProductID IN (105)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12496SVB2" AND av.ProductID IN (105)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12496LLECOCP" AND av.ProductID IN (105)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "2020" AND av.ProductID IN (105)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "BL2011" AND av.ProductID IN (105)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "2011" AND av.ProductID IN (105)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "2019" AND av.ProductID IN (105)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032108" AND av.ProductID IN (105)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1121" AND av.ProductID IN (105)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1065" AND av.ProductID IN (105)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1150" 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-1090" AND av.ProductID IN (105)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1064" 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 = "LID10055") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10054") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB921") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB2825") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB6411") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB7507") 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 = 4671 AND aa.DataSupplierArticleNumber = "N581") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "8888") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N581-02B") 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 = "9999") 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 = "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 = "7504") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507ULT-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507DC-02B") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12496SVS2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12496NAB2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12496NACP") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12188NAC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12496SVB2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12496LLECOCP") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "2020") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL2011") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "2011") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "2019") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032108") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1121") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1065") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1150") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1071") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1090") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1064") ) 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 = "LID10055") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10054") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB921") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB2825") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB6411") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB7507") 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 = 4671 AND aa.DataSupplierArticleNumber = "N581") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "8888") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N581-02B") 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 = "9999") 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 = "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 = "7504") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507ULT-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "7507DC-02B") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12496SVS2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12496NAB2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12496NACP") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12188NAC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12496SVB2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12496LLECOCP") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "2020") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL2011") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "2011") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "2019") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032108") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1121") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1065") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1150") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1071") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1090") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1064") ) AND aa.Language = "ru" Продажа автозапчастей типа Лампа накаливания для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DIEDERICHS LID10055 Лампа накаливания, фонарь указателя поворота
LID10054 Лампа накаливания, фонарь указателя поворота
DYNAMATRIX DB921 Лампа накаливания, фонарь указателя поворота
DB2825 Лампа накаливания, фонарь указателя поворота
DB6411 Лампа накаливания, фонарь указателя поворота
DB7507 Лампа накаливания, фонарь указателя поворота
HELLA 8GA 002 073-121 Лампа накаливания, фонарь указателя поворота
8GA 006 841-121 Лампа накаливания, фонарь указателя поворота
NEOLUX® N581 Лампа накаливания, фонарь указателя поворота
8888 Лампа накаливания, фонарь указателя поворота
N581-02B Лампа накаливания, фонарь указателя поворота
N382 Лампа накаливания, фонарь указателя поворота
N382-02B Лампа накаливания, фонарь указателя поворота
OSRAM 7506ULT-02B Лампа накаливания, фонарь указателя поворота
7506 Лампа накаливания, фонарь указателя поворота
9999 Лампа накаливания, фонарь указателя поворота
7507LDA-02B Лампа накаливания, фонарь указателя поворота
7507 Лампа накаливания, фонарь указателя поворота
7506-02B Лампа накаливания, фонарь указателя поворота
7507ULT Лампа накаливания, фонарь указателя поворота
7507-02B Лампа накаливания, фонарь указателя поворота
7506ULT Лампа накаливания, фонарь указателя поворота
7504 Лампа накаливания, фонарь указателя поворота
7507ULT-02B Лампа накаливания, фонарь указателя поворота
7507DC-02B Лампа накаливания, фонарь указателя поворота
PHILIPS 12496SVS2 Лампа накаливания, фонарь указателя поворота
12496NAB2 Лампа накаливания, фонарь указателя поворота
12496NACP Лампа накаливания, фонарь указателя поворота
12188NAC1 Лампа накаливания, фонарь указателя поворота
12496SVB2 Лампа накаливания, фонарь указателя поворота
12496LLECOCP Лампа накаливания, фонарь указателя поворота
SPAHN GLÜHLAMPEN 2020 Лампа накаливания, фонарь указателя поворота
BL2011 Лампа накаливания, фонарь указателя поворота
2011 Лампа накаливания, фонарь указателя поворота
2019 Лампа накаливания, фонарь указателя поворота
VALEO 032108 Лампа накаливания, фонарь указателя поворота
ZEKKERT LP-1121 Лампа накаливания, фонарь указателя поворота
LP-1065 Лампа накаливания, фонарь указателя поворота
LP-1150 Лампа накаливания, фонарь указателя поворота
LP-1071 Лампа накаливания, фонарь указателя поворота
LP-1090 Лампа накаливания, фонарь указателя поворота
LP-1064 Лампа накаливания, фонарь указателя поворота
2026 CATCAR.INFO (v 2.0)