#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxMXx8bW9kZWxfaWQ9PTExOTAwfHxtZGZfaWQ9PTBeMTE4MTg5fHxzcGFyZV9pZD09MTAxMzQz&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 = "118189" AND ( (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10034" AND av.ProductID IN (108)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8GH 008 356-121" AND av.ProductID IN (108)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N708" AND av.ProductID IN (108)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64212NBU-HCB" AND av.ProductID IN (108)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64212" AND av.ProductID IN (108)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64212NR1-01B" AND av.ProductID IN (108)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64212-01B" AND av.ProductID IN (108)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64212XR-01B" AND av.ProductID IN (108)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64212CBI-HCB" AND av.ProductID IN (108)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12360B1" AND av.ProductID IN (108)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12360C1" AND av.ProductID IN (108)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12360WHVB1" AND av.ProductID IN (108)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "586001" AND av.ProductID IN (108)) ) 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 = "LID10034") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GH 008 356-121") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N708") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64212NBU-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64212") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64212NR1-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64212-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64212XR-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64212CBI-HCB") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12360B1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12360C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12360WHVB1") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "586001") ) 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 = "LID10034") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GH 008 356-121") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N708") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64212NBU-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64212") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64212NR1-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64212-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64212XR-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64212CBI-HCB") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12360B1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12360C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12360WHVB1") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "586001") ) AND aa.Language = "ru" Продажа автозапчастей типа Противотуманная фара лампа накаливания для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DIEDERICHS LID10034 Лампа накаливания, противотуманная фара
HELLA 8GH 008 356-121 Лампа накаливания, противотуманная фара
NEOLUX® N708 Лампа накаливания, противотуманная фара
OSRAM 64212NBU-HCB Лампа накаливания, противотуманная фара
64212 Лампа накаливания, противотуманная фара
64212NR1-01B Лампа накаливания, противотуманная фара
64212-01B Лампа накаливания, противотуманная фара
64212XR-01B Лампа накаливания, противотуманная фара
64212CBI-HCB Лампа накаливания, противотуманная фара
PHILIPS 12360B1 Лампа накаливания, противотуманная фара
12360C1 Лампа накаливания, противотуманная фара
12360WHVB1 Лампа накаливания, противотуманная фара
SPAHN GLÜHLAMPEN 586001 Лампа накаливания, противотуманная фара
2026 CATCAR.INFO (v 2.0)