#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxNnx8bW9kZWxfaWQ9PTQ5NjZ8fG1kZl9pZD09MV44OTAzfHxzcGFyZV9pZD09MjAwODM4&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 articlecommercialvehicles av JOIN commercialvehiclelinkageattributes_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 = "8903" AND ( (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9446141" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9453144" AND av.ProductID IN (4209)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9441141" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9480144" AND av.ProductID IN (848)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9456141" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9442141" AND av.ProductID IN (847)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9451141" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9456144" AND av.ProductID IN (4209)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9443141" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9413141" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9452141" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9445141" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9416141" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "7413141" AND av.ProductID IN (1915)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9455141" AND av.ProductID IN (1299)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49969" AND av.ProductID IN (1299)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49901" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "100893" AND av.ProductID IN (4209)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49965" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "100909" AND av.ProductID IN (4209)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "100004" AND av.ProductID IN (1299)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49900" AND av.ProductID IN (1915)) OR (av.SupplierID = 4696 AND av.DataSupplierArticleNumber = "DAF-MR-028" AND av.ProductID IN (1915)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "108.082-00A" AND av.ProductID IN (847)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "108.078-00A" AND av.ProductID IN (1915,4210)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "108.083-00A" AND av.ProductID IN (4209)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "108.097-00A" AND av.ProductID IN (1299)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "108.080-00A" AND av.ProductID IN (4210,1915)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "108.079-00A" AND av.ProductID IN (1915,4210)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "108.109-00A" AND av.ProductID IN (1299)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "108.089-00A" AND av.ProductID IN (1299)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "108.081-00A" AND av.ProductID IN (847)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "108.090-00A" AND av.ProductID IN (1299)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "108.011-00A" AND av.ProductID IN (848)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "079.461" AND av.ProductID IN (1915)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "079.455" AND av.ProductID IN (1299)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "032.296" AND av.ProductID IN (4209)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "62013" AND av.ProductID IN (4209)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61194" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61191" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61188" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "62014" AND av.ProductID IN (4209)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61195" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61192" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61189" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "45161" AND av.ProductID IN (1915)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61509" AND av.ProductID IN (847)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61197" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61193" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61190" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61187" AND av.ProductID IN (1299)) ) 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 = 362 AND aa.DataSupplierArticleNumber = "9446141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9453144") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9441141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9480144") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9456141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9442141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9451141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9456144") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9443141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9413141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9452141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9445141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9416141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "7413141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9455141") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49969") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49901") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100893") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49965") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100909") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100004") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49900") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "DAF-MR-028") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.082-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.078-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.083-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.097-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.080-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.079-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.109-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.089-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.081-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.090-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.011-00A") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.461") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.455") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "032.296") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "62013") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61194") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61191") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61188") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "62014") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61195") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61192") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61189") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "45161") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61509") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61197") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61193") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61190") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61187") ) 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 = 362 AND aa.DataSupplierArticleNumber = "9446141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9453144") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9441141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9480144") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9456141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9442141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9451141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9456144") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9443141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9413141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9452141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9445141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9416141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "7413141") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9455141") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49969") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49901") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100893") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49965") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100909") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100004") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49900") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "DAF-MR-028") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.082-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.078-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.083-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.097-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.080-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.079-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.109-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.089-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.081-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.090-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "108.011-00A") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.461") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "079.455") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "032.296") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "62013") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61194") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61191") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61188") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "62014") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61195") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61192") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61189") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "45161") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61509") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61197") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61193") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61190") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61187") ) AND aa.Language = "ru" Продажа автозапчастей типа Зеркало / комплектующие для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ALKAR 9446141 Наружное зеркало, кабина водителя
9453144 Переднее зеркало, кабина водителя
9441141 Наружное зеркало, кабина водителя
9480144 Кронштейн, наружное зеркало
9456141 Наружное зеркало, кабина водителя
9442141 Зеркало рампы
9451141 Наружное зеркало, кабина водителя
9456144 Переднее зеркало, кабина водителя
9443141 Наружное зеркало, кабина водителя
9413141 Наружное зеркало, кабина водителя
9452141 Наружное зеркало, кабина водителя
9445141 Наружное зеркало, кабина водителя
9416141 Наружное зеркало, кабина водителя
7413141 Зеркальное стекло, наружное зеркало
9455141 Наружное зеркало, кабина водителя
FEBI BILSTEIN 49969 Наружное зеркало, кабина водителя
49901 Зеркальное стекло, наружное зеркало
100893 Переднее зеркало, кабина водителя
49965 Зеркальное стекло, наружное зеркало
100909 Переднее зеркало, кабина водителя
100004 Наружное зеркало, кабина водителя
49900 Зеркальное стекло, наружное зеркало
PACOL DAF-MR-028 Зеркальное стекло, наружное зеркало
PE Automotive 108.082-00A Зеркало рампы
108.078-00A Зеркальное стекло, переднее зеркало
108.083-00A Переднее зеркало, кабина водителя
108.097-00A Наружное зеркало, кабина водителя
108.080-00A Зеркальное стекло, наружное зеркало
108.079-00A Зеркальное стекло, переднее зеркало
108.109-00A Наружное зеркало, кабина водителя
108.089-00A Наружное зеркало, кабина водителя
108.081-00A Зеркало рампы
108.090-00A Наружное зеркало, кабина водителя
108.011-00A Кронштейн, наружное зеркало
SAMPA 079.461 Зеркальное стекло, наружное зеркало
079.455 Наружное зеркало, кабина водителя
032.296 Переднее зеркало, кабина водителя
SPILU 62013 Переднее зеркало, кабина водителя
61194 Наружное зеркало, кабина водителя
61191 Наружное зеркало, кабина водителя
61188 Наружное зеркало, кабина водителя
62014 Переднее зеркало, кабина водителя
61195 Наружное зеркало, кабина водителя
61192 Наружное зеркало, кабина водителя
61189 Наружное зеркало, кабина водителя
45161 Зеркальное стекло, наружное зеркало
61509 Зеркало рампы
61197 Наружное зеркало, кабина водителя
61193 Наружное зеркало, кабина водителя
61190 Наружное зеркало, кабина водителя
61187 Наружное зеркало, кабина водителя
2026 CATCAR.INFO (v 2.0)