#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTExNjExfHxtZGZfaWQ9PTBeMTA2MjIzfHxzcGFyZV9pZD09MTAxNjY3&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 = "106223" AND ( (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "79780242" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "79780230" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721057" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721021" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "79780232" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721061" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721024" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721012" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "79780240" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721063" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721055" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721014" AND av.ProductID IN (106)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLD3S" AND av.ProductID IN (106)) OR (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 = 2 AND av.DataSupplierArticleNumber = "8GH 008 356-121" 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 = "42403WHV2C1" 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 = "12580C1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403XV2S1" 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 = "42403VIC1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "LED" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403VIS1" 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 = 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 = 4894 AND av.DataSupplierArticleNumber = "LP-1039" 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-1110" 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 = 363 AND aa.DataSupplierArticleNumber = "79780242") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780230") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721057") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721021") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780232") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721061") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721024") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721012") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780240") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721063") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721055") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721014") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLD3S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBXD3S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB715") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GH 008 356-121") 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 = "42403WHV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12580C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIS1") 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 = 183 AND aa.DataSupplierArticleNumber = "V99-84-0027") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0028") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1039") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1047") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1110") ) 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 = 363 AND aa.DataSupplierArticleNumber = "79780242") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780230") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721057") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721021") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780232") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721061") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721024") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721012") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780240") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721063") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721055") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721014") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLD3S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBXD3S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB715") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GH 008 356-121") 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 = "42403WHV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12580C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIS1") 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 = 183 AND aa.DataSupplierArticleNumber = "V99-84-0027") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0028") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1039") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1047") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1110") ) AND aa.Language = "ru" Продажа автозапчастей типа Лампа накаливания фара дальнего света для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
CARPRISS 79780242 Лампа накаливания, фара дальнего света
79780230 Лампа накаливания, фара дальнего света
70721057 Лампа накаливания, фара дальнего света
70721021 Лампа накаливания, фара дальнего света
79780232 Лампа накаливания, фара дальнего света
70721061 Лампа накаливания, фара дальнего света
70721024 Лампа накаливания, фара дальнего света
70721012 Лампа накаливания, фара дальнего света
79780240 Лампа накаливания, фара дальнего света
70721063 Лампа накаливания, фара дальнего света
70721055 Лампа накаливания, фара дальнего света
70721014 Лампа накаливания, фара дальнего света
ELTA AUTOMOTIVE LLD3S Лампа накаливания, фара дальнего света
ELBXD3S Лампа накаливания, фара дальнего света
LLB715 Лампа накаливания, фара дальнего света
HELLA 8GH 008 356-121 Лампа накаливания, фара дальнего света
8GJ 168 119-001 Лампа накаливания, фара дальнего света
HERTH+BUSS ELPARTS 89901313 Лампа накаливания, фара дальнего света
OSRAM 64176 Лампа накаливания, фара дальнего света
64176CBI Лампа накаливания, фара дальнего света
PHILIPS 42403WHV2S1 Лампа накаливания, фара дальнего света
42403WHV2C1 Лампа накаливания, фара дальнего света
42403XV2S2 Лампа накаливания, фара дальнего света
12580C1 Лампа накаливания, фара дальнего света
42403XV2S1 Лампа накаливания, фара дальнего света
42403XV2C1 Лампа накаливания, фара дальнего света
42403VIC1 Лампа накаливания, фара дальнего света
LED Лампа накаливания, фара дальнего света
42403VIS1 Лампа накаливания, фара дальнего света
VEMO V99-84-0029 Лампа накаливания, фара дальнего света
V99-84-0026 Лампа накаливания, фара дальнего света
V99-84-0030 Лампа накаливания, фара дальнего света
V99-84-0027 Лампа накаливания, фара дальнего света
V99-84-0028 Лампа накаливания, фара дальнего света
ZEKKERT LP-1039 Лампа накаливания, фара дальнего света
LP-1047 Лампа накаливания, фара дальнего света
LP-1110 Лампа накаливания, фара дальнего света
2026 CATCAR.INFO (v 2.0)