#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3M3x8bW9kZWxfaWQ9PTExMjc5fHxtZGZfaWQ9PTBeNTk2MDF8fHNwYXJlX2lkPT0xMDE2Njc%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 = "59601" AND ( (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10063" AND av.ProductID IN (106)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10018" AND av.ProductID IN (106)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10066" AND av.ProductID IN (106)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10019" AND av.ProductID IN (106)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10020" AND av.ProductID IN (106)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8GH 007 157-121" AND av.ProductID IN (106)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N499-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N499B" AND av.ProductID IN (106)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N499EL-HCB" AND av.ProductID IN (106)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N499" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210NBU-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210CBI-HCB" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210ULT-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210SV2-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210NR5-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210NBU-HCB" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210L" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210CBI" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210ULT-HCB" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210SV2-HCB" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210SUP" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210NR1-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210NBU" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210CBI-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210XR-02B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210ULT" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210SV2" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210NR1-02B" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972PRB1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972LLECOB1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972XV+S2" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972WHVB1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972PRC1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972LLECOC1" 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 = "12972WHVSM" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972VPB1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972LLECOS2" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972XV+B1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972VPS2" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "57186" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "57180" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "57080" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "BL57162" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "57183" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "57162" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "57185" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "57162L" AND av.ProductID IN (106)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032520" AND av.ProductID IN (106)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032009" AND av.ProductID IN (106)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032516" AND av.ProductID IN (106)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032518" AND av.ProductID IN (106)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032008" AND av.ProductID IN (106)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-84-0002" AND av.ProductID IN (106)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1110" AND av.ProductID IN (106)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1047" 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 = 253 AND aa.DataSupplierArticleNumber = "LID10063") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10018") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10066") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10019") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10020") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GH 007 157-121") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499-01B") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499B") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499EL-HCB") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NBU-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210CBI-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210ULT-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SV2-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NR5-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NBU-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210L") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210CBI") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210ULT-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SV2-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SUP") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NR1-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NBU") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210CBI-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210XR-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210ULT") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SV2") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NR1-02B") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972PRB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972LLECOB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972XV+S2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972WHVB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972PRC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972LLECOC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972WHVSM") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972VPB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972LLECOS2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972XV+B1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972VPS2") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57186") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57180") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57080") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL57162") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57183") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57162") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57185") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57162L") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032520") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032009") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032516") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032518") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032008") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0002") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1110") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1047") ) 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 = "LID10063") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10018") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10066") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10019") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10020") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GH 007 157-121") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499-01B") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499B") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499EL-HCB") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NBU-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210CBI-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210ULT-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SV2-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NR5-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NBU-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210L") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210CBI") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210ULT-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SV2-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SUP") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NR1-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NBU") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210CBI-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210XR-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210ULT") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SV2") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NR1-02B") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972PRB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972LLECOB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972XV+S2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972WHVB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972PRC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972LLECOC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972WHVSM") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972VPB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972LLECOS2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972XV+B1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972VPS2") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57186") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57180") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57080") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL57162") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57183") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57162") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57185") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57162L") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032520") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032009") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032516") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032518") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032008") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0002") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1110") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1047") ) AND aa.Language = "ru" Продажа автозапчастей типа Лампа накаливания фара дальнего света для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DIEDERICHS LID10063 Лампа накаливания, фара дальнего света
LID10018 Лампа накаливания, фара дальнего света
LID10066 Лампа накаливания, фара дальнего света
LID10019 Лампа накаливания, фара дальнего света
LID10020 Лампа накаливания, фара дальнего света
HELLA 8GH 007 157-121 Лампа накаливания, фара дальнего света
NEOLUX® N499-01B Лампа накаливания, фара дальнего света
N499B Лампа накаливания, фара дальнего света
N499EL-HCB Лампа накаливания, фара дальнего света
N499 Лампа накаливания, фара дальнего света
OSRAM 64210NBU-01B Лампа накаливания, фара дальнего света
64210CBI-HCB Лампа накаливания, фара дальнего света
64210ULT-01B Лампа накаливания, фара дальнего света
64210-01B Лампа накаливания, фара дальнего света
64210SV2-01B Лампа накаливания, фара дальнего света
64210NR5-01B Лампа накаливания, фара дальнего света
64210NBU-HCB Лампа накаливания, фара дальнего света
64210L Лампа накаливания, фара дальнего света
64210CBI Лампа накаливания, фара дальнего света
64210ULT-HCB Лампа накаливания, фара дальнего света
64210SV2-HCB Лампа накаливания, фара дальнего света
64210SUP Лампа накаливания, фара дальнего света
64210NR1-01B Лампа накаливания, фара дальнего света
64210NBU Лампа накаливания, фара дальнего света
64210CBI-01B Лампа накаливания, фара дальнего света
64210XR-02B Лампа накаливания, фара дальнего света
64210ULT Лампа накаливания, фара дальнего света
64210 Лампа накаливания, фара дальнего света
64210SV2 Лампа накаливания, фара дальнего света
64210NR1-02B Лампа накаливания, фара дальнего света
PHILIPS 12972PRB1 Лампа накаливания, фара дальнего света
12972LLECOB1 Лампа накаливания, фара дальнего света
12972XV+S2 Лампа накаливания, фара дальнего света
12972WHVB1 Лампа накаливания, фара дальнего света
12972PRC1 Лампа накаливания, фара дальнего света
12972LLECOC1 Лампа накаливания, фара дальнего света
LED Лампа накаливания, фара дальнего света
12972WHVSM Лампа накаливания, фара дальнего света
12972VPB1 Лампа накаливания, фара дальнего света
12972LLECOS2 Лампа накаливания, фара дальнего света
12972XV+B1 Лампа накаливания, фара дальнего света
12972VPS2 Лампа накаливания, фара дальнего света
SPAHN GLÜHLAMPEN 57186 Лампа накаливания, фара дальнего света
57180 Лампа накаливания, фара дальнего света
57080 Лампа накаливания, фара дальнего света
BL57162 Лампа накаливания, фара дальнего света
57183 Лампа накаливания, фара дальнего света
57162 Лампа накаливания, фара дальнего света
57185 Лампа накаливания, фара дальнего света
57162L Лампа накаливания, фара дальнего света
VALEO 032520 Лампа накаливания, фара дальнего света
032009 Лампа накаливания, фара дальнего света
032516 Лампа накаливания, фара дальнего света
032518 Лампа накаливания, фара дальнего света
032008 Лампа накаливания, фара дальнего света
VEMO V99-84-0002 Лампа накаливания, фара дальнего света
ZEKKERT LP-1110 Лампа накаливания, фара дальнего света
LP-1047 Лампа накаливания, фара дальнего света
2026 CATCAR.INFO (v 2.0)