#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3M3x8bW9kZWxfaWQ9PTQ4NzB8fG1kZl9pZD09MF4xOTIxOXx8c3BhcmVfaWQ9PTEwMDc4NQ%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 articlepassengercars av JOIN passengercarlinkageattributes_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 = "19219" AND ( (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "661065" AND av.ProductID IN (1291)) OR (av.SupplierID = 4969 AND av.DataSupplierArticleNumber = "96SKV005" AND av.ProductID IN (1111)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "39740" AND av.ProductID IN (1111)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "3.240145" AND av.ProductID IN (1291)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "9 9033 1" AND av.ProductID IN (1291)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "9 9403 1" AND av.ProductID IN (803)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "9 9133 1" AND av.ProductID IN (1111)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "4RA 007 507-021" AND av.ProductID IN (1750)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "4RP 008 189-151" AND av.ProductID IN (1111)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "75613186" AND av.ProductID IN (1111)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "75898967" AND av.ProductID IN (1291)) OR (av.SupplierID = 449 AND av.DataSupplierArticleNumber = "132218" AND av.ProductID IN (1291)) OR (av.SupplierID = 449 AND av.DataSupplierArticleNumber = "2502218" AND av.ProductID IN (1291)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "H73240145" AND av.ProductID IN (1291)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1199208200" AND av.ProductID IN (1750)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1199206900" AND av.ProductID IN (1111)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "50-0226" AND av.ProductID IN (1750)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "73240145" AND av.ProductID IN (1291)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVFU102" AND av.ProductID IN (61)) OR (av.SupplierID = 4606 AND av.DataSupplierArticleNumber = "RBC/21-12" AND av.ProductID IN (1111)) OR (av.SupplierID = 4606 AND av.DataSupplierArticleNumber = "RBC/17-12" AND av.ProductID IN (1111)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "P27-0002" AND av.ProductID IN (1750)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XFL115" AND av.ProductID IN (61)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "3.240145" AND av.ProductID IN (1291)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "58901" AND av.ProductID IN (61,61)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "FLA003" AND av.ProductID IN (61,61)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 9740" AND av.ProductID IN (1111)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "107 258" AND av.ProductID IN (1750)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.42.053" AND av.ProductID IN (1111)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-71-0005" AND av.ProductID IN (1111)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-71-0019" AND av.ProductID IN (1111)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-71-0035" AND av.ProductID IN (1291)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-71-0004" AND av.ProductID IN (1750)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99110119801" AND av.ProductID IN (1750)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99060093601" AND av.ProductID IN (1111)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99510019401" AND av.ProductID IN (1291)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1795411" AND av.ProductID IN (1111)) ) 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 = 234 AND aa.DataSupplierArticleNumber = "661065") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "96SKV005") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39740") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "3.240145") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9033 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9403 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9133 1") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "4RA 007 507-021") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "4RP 008 189-151") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "75613186") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "75898967") OR (aa.SupplierID = 449 AND aa.DataSupplierArticleNumber = "132218") OR (aa.SupplierID = 449 AND aa.DataSupplierArticleNumber = "2502218") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "H73240145") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1199208200") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1199206900") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "50-0226") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "73240145") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVFU102") OR (aa.SupplierID = 4606 AND aa.DataSupplierArticleNumber = "RBC/21-12") OR (aa.SupplierID = 4606 AND aa.DataSupplierArticleNumber = "RBC/17-12") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P27-0002") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XFL115") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "3.240145") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "58901") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "FLA003") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 9740") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "107 258") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.42.053") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0005") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0019") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0035") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0004") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99110119801") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99060093601") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99510019401") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1795411") ) 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 = 234 AND aa.DataSupplierArticleNumber = "661065") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "96SKV005") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39740") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "3.240145") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9033 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9403 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9133 1") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "4RA 007 507-021") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "4RP 008 189-151") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "75613186") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "75898967") OR (aa.SupplierID = 449 AND aa.DataSupplierArticleNumber = "132218") OR (aa.SupplierID = 449 AND aa.DataSupplierArticleNumber = "2502218") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "H73240145") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1199208200") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1199206900") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "50-0226") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "73240145") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVFU102") OR (aa.SupplierID = 4606 AND aa.DataSupplierArticleNumber = "RBC/21-12") OR (aa.SupplierID = 4606 AND aa.DataSupplierArticleNumber = "RBC/17-12") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P27-0002") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XFL115") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "3.240145") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "58901") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "FLA003") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 9740") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "107 258") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.42.053") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0005") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0019") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0035") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0004") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99110119801") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99060093601") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99510019401") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1795411") ) AND aa.Language = "ru" Продажа автозапчастей типа Реле для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ERA 661065 Реле, продольный наклон шкворня вентилятора
ESEN SKV 96SKV005 Реле, топливный насос
FEBI BILSTEIN 39740 Реле, топливный насос
FISPA 3.240145 Реле, продольный наклон шкворня вентилятора
GEBE 9 9033 1 Реле, продольный наклон шкворня вентилятора
9 9403 1 Реле, кондиционер
9 9133 1 Реле, топливный насос
HELLA 4RA 007 507-021 Реле, система накаливания
4RP 008 189-151 Реле, топливный насос
HERTH+BUSS ELPARTS 75613186 Реле, топливный насос
75898967 Реле, продольный наклон шкворня вентилятора
HITACHI 132218 Реле, продольный наклон шкворня вентилятора
2502218 Реле, продольный наклон шкворня вентилятора
HOFFER H73240145 Реле, продольный наклон шкворня вентилятора
JP GROUP 1199208200 Реле, система накаливания
1199206900 Реле, топливный насос
MAXGEAR 50-0226 Реле, система накаливания
MEAT & DORIA 73240145 Реле, продольный наклон шкворня вентилятора
MOTAQUIP LVFU102 Прерыватель указателей поворота
NAGARES RBC/21-12 Реле, топливный насос
RBC/17-12 Реле, топливный насос
PATRON P27-0002 Реле, система накаливания
QUINTON HAZELL XFL115 Прерыватель указателей поворота
SIDAT 3.240145 Реле, продольный наклон шкворня вентилятора
SMPE 58901 Прерыватель указателей поворота
FLA003 Прерыватель указателей поворота
SWAG 30 93 9740 Реле, топливный насос
TOPRAN 107 258 Реле, система накаливания
TRUCKTEC AUTOMOTIVE 07.42.053 Реле, топливный насос
VEMO V15-71-0005 Реле, топливный насос
V15-71-0019 Реле, топливный насос
V15-71-0035 Реле, продольный наклон шкворня вентилятора
V15-71-0004 Реле, система накаливания
vika 99110119801 Реле, система накаливания
99060093601 Реле, топливный насос
99510019401 Реле, продольный наклон шкворня вентилятора
WILMINK GROUP WG1795411 Реле, топливный насос
2026 CATCAR.INFO (v 2.0)