#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTY0MTd8fG1kZl9pZD09MV45Mjk3fHxzcGFyZV9pZD09MjAwNjQ4&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 = "9297" AND ( (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9ES 354 984-061" AND av.ProductID IN (14)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9ES 354 987-091" AND av.ProductID IN (14)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9ES 354 987-101" AND av.ProductID IN (14)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9ES 354 984-051" AND av.ProductID IN (14)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "81658154" AND av.ProductID IN (14)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "81658155" AND av.ProductID IN (14)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "81658302" AND av.ProductID IN (14)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "81658303" AND av.ProductID IN (14)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "47#449-1101LEND" AND av.ProductID IN (14)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "47#449-1101REND" AND av.ProductID IN (14)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "022.350" AND av.ProductID IN (3499)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "022.043" AND av.ProductID IN (3499)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1820 0222" AND av.ProductID IN (101)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "022.044" AND av.ProductID IN (3499)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1820 0206" AND av.ProductID IN (703)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "022.349" AND av.ProductID IN (3499)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1820 0207" AND av.ProductID IN (703)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1820 0217" AND av.ProductID IN (101)) ) 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 = 2 AND aa.DataSupplierArticleNumber = "9ES 354 984-061") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9ES 354 987-091") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9ES 354 987-101") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9ES 354 984-051") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "81658154") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "81658155") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "81658302") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "81658303") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "47#449-1101LEND") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "47#449-1101REND") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.350") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.043") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0222") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.044") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0206") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.349") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0207") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0217") ) 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 = 2 AND aa.DataSupplierArticleNumber = "9ES 354 984-061") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9ES 354 987-091") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9ES 354 987-101") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9ES 354 984-051") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "81658154") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "81658155") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "81658302") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "81658303") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "47#449-1101LEND") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "47#449-1101REND") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.350") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.043") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0222") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.044") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0206") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.349") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0207") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0217") ) AND aa.Language = "ru" Продажа автозапчастей типа Комплектующие для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
HELLA 9ES 354 984-061 Рассеиватель, основная фара
9ES 354 987-091 Рассеиватель, основная фара
9ES 354 987-101 Рассеиватель, основная фара
9ES 354 984-051 Рассеиватель, основная фара
HERTH+BUSS ELPARTS 81658154 Рассеиватель, основная фара
81658155 Рассеиватель, основная фара
81658302 Рассеиватель, основная фара
81658303 Рассеиватель, основная фара
LORO 47#449-1101LEND Рассеиватель, основная фара
47#449-1101REND Рассеиватель, основная фара
SAMPA 022.350 Рассеиватель, основная фара
022.043 Рассеиватель, основная фара
1820 0222 Кронштейн, основная фара
022.044 Рассеиватель, основная фара
1820 0206 Рамка, основная фара
022.349 Рассеиватель, основная фара
1820 0207 Рамка, основная фара
1820 0217 Кронштейн, основная фара
2026 CATCAR.INFO (v 2.0)