#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTkxNTR8fG1kZl9pZD09MF4yNTY5MHx8c3BhcmVfaWQ9PTEwMTY2Nw%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 = "25690" AND ( (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBXD3S" AND av.ProductID IN (106)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLB715" AND av.ProductID IN (106)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLD3S" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "84491" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "35752" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "98717" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "19686" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "98264" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "12904" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93768" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93012861" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "90902" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "74154" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "19759" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "98282" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "17123" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "95397" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93013272" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93012270" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "79299" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "35017" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "98715" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "17463" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "97131" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93013293" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93012303" AND av.ProductID IN (106)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8GJ 168 119-001" AND av.ProductID IN (106)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "89901313" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64176" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64176CBI" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403WHV2S1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "0815" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403WHV2C1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "LED" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403XV2S2" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403VIS1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403XV2S1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403VIC1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403XV2C1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12580C1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12410C1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "60167" AND av.ProductID IN (106)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-84-0027" AND av.ProductID IN (106)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-84-0028" AND av.ProductID IN (106)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-84-0029" AND av.ProductID IN (106)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-84-0026" AND av.ProductID IN (106)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-84-0030" AND av.ProductID IN (106)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1047" AND av.ProductID IN (106)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1019" AND av.ProductID IN (106)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1039" AND av.ProductID IN (106)) ) 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 = "ELBXD3S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB715") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLD3S") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "84491") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "35752") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98717") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "19686") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98264") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "12904") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93768") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012861") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "90902") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "74154") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "19759") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98282") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17123") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "95397") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93013272") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012270") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "79299") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "35017") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98715") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17463") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "97131") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93013293") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012303") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GJ 168 119-001") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "89901313") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64176") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64176CBI") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403WHV2S1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "0815") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403WHV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIS1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12580C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12410C1") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "60167") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0027") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0028") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0029") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0026") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0030") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1047") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1019") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1039") ) 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 = "ELBXD3S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB715") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLD3S") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "84491") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "35752") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98717") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "19686") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98264") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "12904") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93768") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012861") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "90902") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "74154") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "19759") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98282") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17123") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "95397") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93013272") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012270") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "79299") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "35017") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98715") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17463") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "97131") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93013293") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012303") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GJ 168 119-001") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "89901313") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64176") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64176CBI") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403WHV2S1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "0815") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403WHV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIS1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12580C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12410C1") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "60167") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0027") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0028") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0029") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0026") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0030") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1047") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1019") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1039") ) AND aa.Language = "ru" Продажа автозапчастей типа Лампа накаливания фара дальнего света для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ELTA AUTOMOTIVE ELBXD3S Лампа накаливания, фара дальнего света
LLB715 Лампа накаливания, фара дальнего света
LLD3S Лампа накаливания, фара дальнего света
GE 84491 Лампа накаливания, фара дальнего света
35752 Лампа накаливания, фара дальнего света
98717 Лампа накаливания, фара дальнего света
19686 Лампа накаливания, фара дальнего света
98264 Лампа накаливания, фара дальнего света
12904 Лампа накаливания, фара дальнего света
93768 Лампа накаливания, фара дальнего света
93012861 Лампа накаливания, фара дальнего света
90902 Лампа накаливания, фара дальнего света
74154 Лампа накаливания, фара дальнего света
19759 Лампа накаливания, фара дальнего света
98282 Лампа накаливания, фара дальнего света
17123 Лампа накаливания, фара дальнего света
95397 Лампа накаливания, фара дальнего света
93013272 Лампа накаливания, фара дальнего света
93012270 Лампа накаливания, фара дальнего света
79299 Лампа накаливания, фара дальнего света
35017 Лампа накаливания, фара дальнего света
98715 Лампа накаливания, фара дальнего света
17463 Лампа накаливания, фара дальнего света
97131 Лампа накаливания, фара дальнего света
93013293 Лампа накаливания, фара дальнего света
93012303 Лампа накаливания, фара дальнего света
HELLA 8GJ 168 119-001 Лампа накаливания, фара дальнего света
HERTH+BUSS ELPARTS 89901313 Лампа накаливания, фара дальнего света
OSRAM 64176 Лампа накаливания, фара дальнего света
64176CBI Лампа накаливания, фара дальнего света
PHILIPS 42403WHV2S1 Лампа накаливания, фара дальнего света
0815 Лампа накаливания, фара дальнего света
42403WHV2C1 Лампа накаливания, фара дальнего света
LED Лампа накаливания, фара дальнего света
42403XV2S2 Лампа накаливания, фара дальнего света
42403VIS1 Лампа накаливания, фара дальнего света
42403XV2S1 Лампа накаливания, фара дальнего света
42403VIC1 Лампа накаливания, фара дальнего света
42403XV2C1 Лампа накаливания, фара дальнего света
12580C1 Лампа накаливания, фара дальнего света
12410C1 Лампа накаливания, фара дальнего света
SPAHN GLÜHLAMPEN 60167 Лампа накаливания, фара дальнего света
VEMO V99-84-0027 Лампа накаливания, фара дальнего света
V99-84-0028 Лампа накаливания, фара дальнего света
V99-84-0029 Лампа накаливания, фара дальнего света
V99-84-0026 Лампа накаливания, фара дальнего света
V99-84-0030 Лампа накаливания, фара дальнего света
ZEKKERT LP-1047 Лампа накаливания, фара дальнего света
LP-1019 Лампа накаливания, фара дальнего света
LP-1039 Лампа накаливания, фара дальнего света
2026 CATCAR.INFO (v 2.0)