#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTY0MTZ8fG1kZl9pZD09MV4xMTU0MXx8c3BhcmVfaWQ9PTIwMDA4OQ%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 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 = "11541" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49691" AND av.ProductID IN (3248)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49151" AND av.ProductID IN (475)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "48395" AND av.ProductID IN (475)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49164" AND av.ProductID IN (475)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "48400" AND av.ProductID IN (475)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "35157" AND av.ProductID IN (475)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49168" AND av.ProductID IN (475)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49110" AND av.ProductID IN (475)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "46588" AND av.ProductID IN (475)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "12-39 222 0013" AND av.ProductID IN (475)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "12-39 222 0005" AND av.ProductID IN (475)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "12-39 222 0007" AND av.ProductID IN (475)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "12-39 222 0008" AND av.ProductID IN (475)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "021.114" AND av.ProductID IN (475)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "021.457" AND av.ProductID IN (475)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "023.066" AND av.ProductID IN (475)) OR (av.SupplierID = 4614 AND av.DataSupplierArticleNumber = "9700" AND av.ProductID IN (475)) OR (av.SupplierID = 4614 AND av.DataSupplierArticleNumber = "9701" AND av.ProductID IN (475)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "81-11165-SX" AND av.ProductID IN (475)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "81-10151-SX" AND av.ProductID IN (475)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "SI-MA16" AND av.ProductID IN (546)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "SI-MA24" AND av.ProductID IN (475)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "SI-MA20" AND av.ProductID IN (546)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "SI-MA43" AND av.ProductID IN (475)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "SI-MA29" AND av.ProductID IN (546)) ) 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 = 101 AND aa.DataSupplierArticleNumber = "49691") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49151") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "48395") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49164") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "48400") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "35157") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49168") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49110") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "46588") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-39 222 0013") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-39 222 0005") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-39 222 0007") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-39 222 0008") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "021.114") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "021.457") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "023.066") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "9700") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "9701") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-11165-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-10151-SX") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "SI-MA16") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "SI-MA24") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "SI-MA20") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "SI-MA43") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "SI-MA29") ) 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 = 101 AND aa.DataSupplierArticleNumber = "49691") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49151") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "48395") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49164") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "48400") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "35157") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49168") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49110") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "46588") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-39 222 0013") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-39 222 0005") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-39 222 0007") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-39 222 0008") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "021.114") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "021.457") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "023.066") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "9700") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "9701") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-11165-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-10151-SX") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "SI-MA16") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "SI-MA24") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "SI-MA20") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "SI-MA43") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "SI-MA29") ) AND aa.Language = "ru" Продажа автозапчастей типа Соединительные элементы / провода / фланцы для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FEBI BILSTEIN 49691 Прокладка, фланец охлаждающей жидкости
49151 Шланг радиатора
48395 Шланг радиатора
49164 Шланг радиатора
48400 Шланг радиатора
35157 Шланг радиатора
49168 Шланг радиатора
49110 Шланг радиатора
46588 Шланг радиатора
MEYLE 12-39 222 0013 Шланг радиатора
12-39 222 0005 Шланг радиатора
12-39 222 0007 Шланг радиатора
12-39 222 0008 Шланг радиатора
SAMPA 021.114 Шланг радиатора
021.457 Шланг радиатора
023.066 Шланг радиатора
SEM LASTIK 9700 Шланг радиатора
9701 Шланг радиатора
STELLOX 81-11165-SX Шланг радиатора
81-10151-SX Шланг радиатора
THERMOTEC SI-MA16 Трубка охлаждающей жидкости
SI-MA24 Шланг радиатора
SI-MA20 Трубка охлаждающей жидкости
SI-MA43 Шланг радиатора
SI-MA29 Трубка охлаждающей жидкости
2026 CATCAR.INFO (v 2.0)