#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTUxNDN8fG1kZl9pZD09MF4xODA2N3x8c3BhcmVfaWQ9PTEwMDQzMA%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 = "18067" AND ( (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "405013" AND av.ProductID IN (6347)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "405144" AND av.ProductID IN (6347)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "405034" AND av.ProductID IN (6347)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "405035" AND av.ProductID IN (6347)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "405137" AND av.ProductID IN (6347)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9FH 161 097-017" AND av.ProductID IN (489)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2323024" AND av.ProductID IN (6347)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2323015" AND av.ProductID IN (6347)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2323025" AND av.ProductID IN (6347)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2323020" AND av.ProductID IN (6347)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2323011" AND av.ProductID IN (6347)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2323026" AND av.ProductID IN (6347)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2323022" AND av.ProductID IN (6347)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2323012" AND av.ProductID IN (6347)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "405013" AND av.ProductID IN (6347)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "405144" AND av.ProductID IN (6347)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "405034" AND av.ProductID IN (6347)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "405035" AND av.ProductID IN (6347)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "405137" AND av.ProductID IN (6347)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V10-83-0089" AND av.ProductID IN (6347)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V10-83-0090" AND av.ProductID IN (6347)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V10-83-0091" AND av.ProductID IN (6347)) ) 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 = 441 AND aa.DataSupplierArticleNumber = "405013") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "405144") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "405034") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "405035") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "405137") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9FH 161 097-017") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323024") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323015") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323025") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323020") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323011") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323026") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323022") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323012") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405013") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405144") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405034") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405035") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405137") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-83-0089") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-83-0090") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-83-0091") ) 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 = 441 AND aa.DataSupplierArticleNumber = "405013") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "405144") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "405034") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "405035") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "405137") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9FH 161 097-017") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323024") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323015") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323025") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323020") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323011") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323026") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323022") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323012") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405013") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405144") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405034") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405035") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405137") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-83-0089") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-83-0090") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-83-0091") ) AND aa.Language = "ru" Продажа автозапчастей типа Основная фара комплектующие для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FISPA 405013 Ремонтный комплект кабеля, основная фара
405144 Ремонтный комплект кабеля, основная фара
405034 Ремонтный комплект кабеля, основная фара
405035 Ремонтный комплект кабеля, основная фара
405137 Ремонтный комплект кабеля, основная фара
HELLA 9FH 161 097-017 Патрон лампы, основная фара
METZGER 2323024 Ремонтный комплект кабеля, основная фара
2323015 Ремонтный комплект кабеля, основная фара
2323025 Ремонтный комплект кабеля, основная фара
2323020 Ремонтный комплект кабеля, основная фара
2323011 Ремонтный комплект кабеля, основная фара
2323026 Ремонтный комплект кабеля, основная фара
2323022 Ремонтный комплект кабеля, основная фара
2323012 Ремонтный комплект кабеля, основная фара
SIDAT 405013 Ремонтный комплект кабеля, основная фара
405144 Ремонтный комплект кабеля, основная фара
405034 Ремонтный комплект кабеля, основная фара
405035 Ремонтный комплект кабеля, основная фара
405137 Ремонтный комплект кабеля, основная фара
VEMO V10-83-0089 Ремонтный комплект кабеля, основная фара
V10-83-0090 Ремонтный комплект кабеля, основная фара
V10-83-0091 Ремонтный комплект кабеля, основная фара
2026 CATCAR.INFO (v 2.0)