#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTUwODJ8fG1kZl9pZD09MV45MTc1fHxzcGFyZV9pZD09MjAwODM4&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 = "9175" AND ( (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9479274" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9471274" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9426272" AND av.ProductID IN (847)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9472274" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "7461274" AND av.ProductID IN (1915)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9478274" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "7462274" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49929" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49921" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49930" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49923" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "101382" AND av.ProductID IN (4210)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "100023" AND av.ProductID IN (4209)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "100115" AND av.ProductID IN (1299)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49924" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "38148" AND av.ProductID IN (848)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "100020" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "100116" AND av.ProductID IN (1299)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8SB 507 050-001" AND av.ProductID IN (4209)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9MX 564 234-001" AND av.ProductID IN (1915)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8SB 507 049-001" AND av.ProductID IN (847)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9MX 564 246-001" AND av.ProductID IN (4210)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9MX 564 234-011" AND av.ProductID IN (1915)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "T02-03-004" AND av.ProductID IN (1299)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "T02-03-015" AND av.ProductID IN (1299)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "T02-03-003" AND av.ProductID IN (1299)) OR (av.SupplierID = 4696 AND av.DataSupplierArticleNumber = "MER-MR-026" AND av.ProductID IN (848)) OR (av.SupplierID = 4696 AND av.DataSupplierArticleNumber = "MER-MR-027" AND av.ProductID IN (848)) OR (av.SupplierID = 4696 AND av.DataSupplierArticleNumber = "MER-MR-052" AND av.ProductID IN (1915)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.158-00A" AND av.ProductID IN (4210)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.119-00A" AND av.ProductID IN (848)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.092-00A" AND av.ProductID IN (1915)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.134-00A" AND av.ProductID IN (847)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.097-10A" AND av.ProductID IN (1299)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.761-00A" AND av.ProductID IN (848)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.092-10A" AND av.ProductID IN (1915)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.118-00A" AND av.ProductID IN (848)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.095-00A" AND av.ProductID IN (847)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.097-00A" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61690" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "914839" AND av.ProductID IN (1915)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61681" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "914840" AND av.ProductID IN (1915)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61682" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61549" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61687" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "19051" AND av.ProductID IN (1915)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61569" AND av.ProductID IN (1299)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-41522-SX" AND av.ProductID IN (848)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-29055-SX" AND av.ProductID IN (1299)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-30208-SX" AND av.ProductID IN (1915)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-29071-SX" AND av.ProductID IN (1299)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-29045-SX" AND av.ProductID IN (1299)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-30230-SX" AND av.ProductID IN (1915)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-29046-SX" 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 = "9479274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9471274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9426272") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9472274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "7461274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9478274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "7462274") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49929") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49921") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49930") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49923") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "101382") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100023") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100115") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49924") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "38148") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100020") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100116") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8SB 507 050-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9MX 564 234-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8SB 507 049-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9MX 564 246-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9MX 564 234-011") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "T02-03-004") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "T02-03-015") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "T02-03-003") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "MER-MR-026") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "MER-MR-027") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "MER-MR-052") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.158-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.119-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.092-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.134-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.097-10A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.761-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.092-10A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.118-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.095-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.097-00A") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61690") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "914839") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61681") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "914840") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61682") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61549") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61687") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "19051") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61569") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-41522-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29055-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-30208-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29071-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29045-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-30230-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29046-SX") ) 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 = "9479274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9471274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9426272") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9472274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "7461274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9478274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "7462274") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49929") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49921") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49930") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49923") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "101382") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100023") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100115") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49924") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "38148") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100020") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100116") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8SB 507 050-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9MX 564 234-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8SB 507 049-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9MX 564 246-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9MX 564 234-011") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "T02-03-004") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "T02-03-015") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "T02-03-003") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "MER-MR-026") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "MER-MR-027") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "MER-MR-052") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.158-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.119-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.092-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.134-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.097-10A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.761-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.092-10A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.118-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.095-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.097-00A") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61690") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "914839") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61681") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "914840") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61682") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61549") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61687") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "19051") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61569") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-41522-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29055-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-30208-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29071-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29045-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-30230-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29046-SX") ) AND aa.Language = "ru" Продажа автозапчастей типа Зеркало / комплектующие для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ALKAR 9479274 Наружное зеркало, кабина водителя
9471274 Наружное зеркало, кабина водителя
9426272 Зеркало рампы
9472274 Наружное зеркало, кабина водителя
7461274 Зеркальное стекло, наружное зеркало
9478274 Наружное зеркало, кабина водителя
7462274 Зеркальное стекло, наружное зеркало
FEBI BILSTEIN 49929 Зеркальное стекло, наружное зеркало
49921 Зеркальное стекло, наружное зеркало
49930 Зеркальное стекло, наружное зеркало
49923 Зеркальное стекло, наружное зеркало
101382 Зеркальное стекло, переднее зеркало
100023 Переднее зеркало, кабина водителя
100115 Наружное зеркало, кабина водителя
49924 Зеркальное стекло, наружное зеркало
38148 Кронштейн, наружное зеркало
100020 Зеркальное стекло, наружное зеркало
100116 Наружное зеркало, кабина водителя
HELLA 8SB 507 050-001 Переднее зеркало, кабина водителя
9MX 564 234-001 Зеркальное стекло, наружное зеркало
8SB 507 049-001 Зеркало рампы
9MX 564 246-001 Зеркальное стекло, переднее зеркало
9MX 564 234-011 Зеркальное стекло, наружное зеркало
LORO T02-03-004 Наружное зеркало, кабина водителя
T02-03-015 Наружное зеркало, кабина водителя
T02-03-003 Наружное зеркало, кабина водителя
PACOL MER-MR-026 Кронштейн, наружное зеркало
MER-MR-027 Кронштейн, наружное зеркало
MER-MR-052 Зеркальное стекло, наружное зеркало
PE Automotive 018.158-00A Зеркальное стекло, переднее зеркало
018.119-00A Кронштейн, наружное зеркало
018.092-00A Зеркальное стекло, наружное зеркало
018.134-00A Зеркало рампы
018.097-10A Наружное зеркало, кабина водителя
018.761-00A Кронштейн, наружное зеркало
018.092-10A Зеркальное стекло, наружное зеркало
018.118-00A Кронштейн, наружное зеркало
018.095-00A Зеркало рампы
018.097-00A Наружное зеркало, кабина водителя
SPILU 61690 Наружное зеркало, кабина водителя
914839 Зеркальное стекло, наружное зеркало
61681 Наружное зеркало, кабина водителя
914840 Зеркальное стекло, наружное зеркало
61682 Наружное зеркало, кабина водителя
61549 Наружное зеркало, кабина водителя
61687 Наружное зеркало, кабина водителя
19051 Зеркальное стекло, наружное зеркало
61569 Наружное зеркало, кабина водителя
STELLOX 87-41522-SX Кронштейн, наружное зеркало
87-29055-SX Наружное зеркало, кабина водителя
87-30208-SX Зеркальное стекло, наружное зеркало
87-29071-SX Наружное зеркало, кабина водителя
87-29045-SX Наружное зеркало, кабина водителя
87-30230-SX Зеркальное стекло, наружное зеркало
87-29046-SX Наружное зеркало, кабина водителя
2026 CATCAR.INFO (v 2.0)