#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTExNTY1fHxtb2RlbF9pZD09MTI3Mjl8fG1kZl9pZD09Ml4xMDU0OTR8fHNwYXJlX2lkPT0xMDA0MzA%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 articlemotorbikes av JOIN motorbikelinkageattributes_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 = "105494" AND ( (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "405035" AND av.ProductID IN (6347)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "405034" 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 = "2323012" 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)) ) 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 = "405035") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "405034") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323011") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323012") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405034") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405035") ) 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 = "405035") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "405034") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323011") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2323012") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405034") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "405035") ) AND aa.Language = "ru" Продажа автозапчастей типа Основная фара комплектующие для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FISPA 405035 Ремонтный комплект кабеля, основная фара
405034 Ремонтный комплект кабеля, основная фара
METZGER 2323011 Ремонтный комплект кабеля, основная фара
2323012 Ремонтный комплект кабеля, основная фара
SIDAT 405034 Ремонтный комплект кабеля, основная фара
405035 Ремонтный комплект кабеля, основная фара
2026 CATCAR.INFO (v 2.0)