#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4Nnx8bW9kZWxfaWQ9PTE1MTN8fG1kZl9pZD09MF4xNDk1Nnx8c3BhcmVfaWQ9PTEwMDA0Mg%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 = "14956" AND ( (av.SupplierID = 143 AND av.DataSupplierArticleNumber = "5741040687902" AND av.ProductID IN (1)) OR (av.SupplierID = 143 AND av.DataSupplierArticleNumber = "5774000787502" AND av.ProductID IN (1)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 092 S30 080" AND av.ProductID IN (1)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 092 S40 080" AND av.ProductID IN (1)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 092 S50 080" AND av.ProductID IN (1)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 092 S5A 080" AND av.ProductID IN (1)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CB096PR" AND av.ProductID IN (1)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CB096CL" AND av.ProductID IN (1)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CB096PL" AND av.ProductID IN (1)) OR (av.SupplierID = 434 AND av.DataSupplierArticleNumber = "DC700" AND av.ProductID IN (1)) OR (av.SupplierID = 434 AND av.DataSupplierArticleNumber = "DA770" AND av.ProductID IN (1)) OR (av.SupplierID = 434 AND av.DataSupplierArticleNumber = "DB740" AND av.ProductID IN (1)) OR (av.SupplierID = 4881 AND av.DataSupplierArticleNumber = "610616" AND av.ProductID IN (1)) OR (av.SupplierID = 443 AND av.DataSupplierArticleNumber = "EA70-L3" AND av.ProductID IN (1)) OR (av.SupplierID = 443 AND av.DataSupplierArticleNumber = "EM77-L3" AND av.ProductID IN (1)) OR (av.SupplierID = 443 AND av.DataSupplierArticleNumber = "EP74-L3" AND av.ProductID IN (1)) OR (av.SupplierID = 24 AND av.DataSupplierArticleNumber = "EA770" AND av.ProductID IN (1)) OR (av.SupplierID = 24 AND av.DataSupplierArticleNumber = "EB740" AND av.ProductID IN (1)) OR (av.SupplierID = 24 AND av.DataSupplierArticleNumber = "EC700" AND av.ProductID IN (1)) OR (av.SupplierID = 238 AND av.DataSupplierArticleNumber = "TME65" AND av.ProductID IN (1)) OR (av.SupplierID = 238 AND av.DataSupplierArticleNumber = "TM70" AND av.ProductID IN (1)) OR (av.SupplierID = 238 AND av.DataSupplierArticleNumber = "TM75P" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "068077073010" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "067147610003" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "068072072010" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "068074068010" AND av.ProductID IN (1)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "780727002" AND av.ProductID IN (1)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "790706500" AND av.ProductID IN (1)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "VBZA96" AND av.ProductID IN (1)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "VBY31" AND av.ProductID IN (1)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "VBY67" AND av.ProductID IN (1)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "U540L40B" AND av.ProductID IN (1)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "U540L51B" AND av.ProductID IN (1)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "BT074L3.00" AND av.ProductID IN (1)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "BT073L3B.00" AND av.ProductID IN (1)) OR (av.SupplierID = 4338 AND av.DataSupplierArticleNumber = "110E" AND av.ProductID IN (1)) OR (av.SupplierID = 4596 AND av.DataSupplierArticleNumber = "SP77-L3" AND av.ProductID IN (1)) OR (av.SupplierID = 4596 AND av.DataSupplierArticleNumber = "S74-L3" AND av.ProductID IN (1)) OR (av.SupplierID = 4596 AND av.DataSupplierArticleNumber = "SA70-L3" AND av.ProductID IN (1)) OR (av.SupplierID = 4547 AND av.DataSupplierArticleNumber = "74680S02" AND av.ProductID IN (1)) OR (av.SupplierID = 212 AND av.DataSupplierArticleNumber = "TB740" AND av.ProductID IN (1)) OR (av.SupplierID = 212 AND av.DataSupplierArticleNumber = "TA770" AND av.ProductID IN (1)) OR (av.SupplierID = 26 AND av.DataSupplierArticleNumber = "570901076D852" AND av.ProductID IN (1)) OR (av.SupplierID = 26 AND av.DataSupplierArticleNumber = "5740120683132" AND av.ProductID IN (1)) OR (av.SupplierID = 26 AND av.DataSupplierArticleNumber = "5774000783162" AND av.ProductID IN (1)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-17-0015" AND av.ProductID IN (1)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-17-0022" AND av.ProductID IN (1)) OR (av.SupplierID = 4963 AND av.DataSupplierArticleNumber = "AGM570760" AND av.ProductID IN (1)) OR (av.SupplierID = 4963 AND av.DataSupplierArticleNumber = "57412" AND av.ProductID IN (1)) OR (av.SupplierID = 4451 AND av.DataSupplierArticleNumber = "YBX1096" AND av.ProductID IN (1)) OR (av.SupplierID = 4451 AND av.DataSupplierArticleNumber = "YBX3096" AND av.ProductID IN (1)) OR (av.SupplierID = 4451 AND av.DataSupplierArticleNumber = "YBX5096" AND av.ProductID IN (1)) ) 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 = 143 AND aa.DataSupplierArticleNumber = "5741040687902") OR (aa.SupplierID = 143 AND aa.DataSupplierArticleNumber = "5774000787502") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 092 S30 080") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 092 S40 080") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 092 S50 080") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 092 S5A 080") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CB096PR") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CB096CL") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CB096PL") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DC700") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DA770") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DB740") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "610616") OR (aa.SupplierID = 443 AND aa.DataSupplierArticleNumber = "EA70-L3") OR (aa.SupplierID = 443 AND aa.DataSupplierArticleNumber = "EM77-L3") OR (aa.SupplierID = 443 AND aa.DataSupplierArticleNumber = "EP74-L3") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EA770") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EB740") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EC700") OR (aa.SupplierID = 238 AND aa.DataSupplierArticleNumber = "TME65") OR (aa.SupplierID = 238 AND aa.DataSupplierArticleNumber = "TM70") OR (aa.SupplierID = 238 AND aa.DataSupplierArticleNumber = "TM75P") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "068077073010") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "067147610003") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "068072072010") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "068074068010") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "780727002") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "790706500") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VBZA96") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VBY31") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VBY67") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "U540L40B") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "U540L51B") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "BT074L3.00") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "BT073L3B.00") OR (aa.SupplierID = 4338 AND aa.DataSupplierArticleNumber = "110E") OR (aa.SupplierID = 4596 AND aa.DataSupplierArticleNumber = "SP77-L3") OR (aa.SupplierID = 4596 AND aa.DataSupplierArticleNumber = "S74-L3") OR (aa.SupplierID = 4596 AND aa.DataSupplierArticleNumber = "SA70-L3") OR (aa.SupplierID = 4547 AND aa.DataSupplierArticleNumber = "74680S02") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TB740") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TA770") OR (aa.SupplierID = 26 AND aa.DataSupplierArticleNumber = "570901076D852") OR (aa.SupplierID = 26 AND aa.DataSupplierArticleNumber = "5740120683132") OR (aa.SupplierID = 26 AND aa.DataSupplierArticleNumber = "5774000783162") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-17-0015") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-17-0022") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "AGM570760") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "57412") OR (aa.SupplierID = 4451 AND aa.DataSupplierArticleNumber = "YBX1096") OR (aa.SupplierID = 4451 AND aa.DataSupplierArticleNumber = "YBX3096") OR (aa.SupplierID = 4451 AND aa.DataSupplierArticleNumber = "YBX5096") ) 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 = 143 AND aa.DataSupplierArticleNumber = "5741040687902") OR (aa.SupplierID = 143 AND aa.DataSupplierArticleNumber = "5774000787502") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 092 S30 080") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 092 S40 080") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 092 S50 080") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 092 S5A 080") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CB096PR") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CB096CL") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CB096PL") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DC700") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DA770") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DB740") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "610616") OR (aa.SupplierID = 443 AND aa.DataSupplierArticleNumber = "EA70-L3") OR (aa.SupplierID = 443 AND aa.DataSupplierArticleNumber = "EM77-L3") OR (aa.SupplierID = 443 AND aa.DataSupplierArticleNumber = "EP74-L3") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EA770") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EB740") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EC700") OR (aa.SupplierID = 238 AND aa.DataSupplierArticleNumber = "TME65") OR (aa.SupplierID = 238 AND aa.DataSupplierArticleNumber = "TM70") OR (aa.SupplierID = 238 AND aa.DataSupplierArticleNumber = "TM75P") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "068077073010") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "067147610003") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "068072072010") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "068074068010") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "780727002") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "790706500") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VBZA96") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VBY31") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VBY67") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "U540L40B") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "U540L51B") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "BT074L3.00") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "BT073L3B.00") OR (aa.SupplierID = 4338 AND aa.DataSupplierArticleNumber = "110E") OR (aa.SupplierID = 4596 AND aa.DataSupplierArticleNumber = "SP77-L3") OR (aa.SupplierID = 4596 AND aa.DataSupplierArticleNumber = "S74-L3") OR (aa.SupplierID = 4596 AND aa.DataSupplierArticleNumber = "SA70-L3") OR (aa.SupplierID = 4547 AND aa.DataSupplierArticleNumber = "74680S02") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TB740") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TA770") OR (aa.SupplierID = 26 AND aa.DataSupplierArticleNumber = "570901076D852") OR (aa.SupplierID = 26 AND aa.DataSupplierArticleNumber = "5740120683132") OR (aa.SupplierID = 26 AND aa.DataSupplierArticleNumber = "5774000783162") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-17-0015") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-17-0022") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "AGM570760") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "57412") OR (aa.SupplierID = 4451 AND aa.DataSupplierArticleNumber = "YBX1096") OR (aa.SupplierID = 4451 AND aa.DataSupplierArticleNumber = "YBX3096") OR (aa.SupplierID = 4451 AND aa.DataSupplierArticleNumber = "YBX5096") ) AND aa.Language = "ru" Продажа автозапчастей типа Батарея для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BERGA 5741040687902 Стартерная аккумуляторная батарея
5774000787502 Стартерная аккумуляторная батарея
BOSCH 0 092 S30 080 Стартерная аккумуляторная батарея
0 092 S40 080 Стартерная аккумуляторная батарея
0 092 S50 080 Стартерная аккумуляторная батарея
0 092 S5A 080 Стартерная аккумуляторная батарея
COMLINE CB096PR Стартерная аккумуляторная батарея
CB096CL Стартерная аккумуляторная батарея
CB096PL Стартерная аккумуляторная батарея
DETA DC700 Стартерная аккумуляторная батарея
DA770 Стартерная аккумуляторная батарея
DB740 Стартерная аккумуляторная батарея
DYNAMAX 610616 Стартерная аккумуляторная батарея
ENERGIZER EA70-L3 Стартерная аккумуляторная батарея
EM77-L3 Стартерная аккумуляторная батарея
EP74-L3 Стартерная аккумуляторная батарея
EXIDE EA770 Стартерная аккумуляторная батарея
EB740 Стартерная аккумуляторная батарея
EC700 Стартерная аккумуляторная батарея
IPSA TME65 Стартерная аккумуляторная батарея
TM70 Стартерная аккумуляторная батарея
TM75P Стартерная аккумуляторная батарея
MAGNETI MARELLI 068077073010 Стартерная аккумуляторная батарея
067147610003 Стартерная аккумуляторная батарея
068072072010 Стартерная аккумуляторная батарея
068074068010 Стартерная аккумуляторная батарея
MASTER-SPORT 780727002 Стартерная аккумуляторная батарея
790706500 Стартерная аккумуляторная батарея
MOTAQUIP VBZA96 Стартерная аккумуляторная батарея
VBY31 Стартерная аккумуляторная батарея
VBY67 Стартерная аккумуляторная батарея
NPS U540L40B Стартерная аккумуляторная батарея
U540L51B Стартерная аккумуляторная батарея
OPEN PARTS BT074L3.00 Стартерная аккумуляторная батарея
BT073L3B.00 Стартерная аккумуляторная батарея
PLATINUM 110E Стартерная аккумуляторная батарея
SAFA SP77-L3 Стартерная аккумуляторная батарея
S74-L3 Стартерная аккумуляторная батарея
SA70-L3 Стартерная аккумуляторная батарея
SAKURA 74680S02 Стартерная аккумуляторная батарея
TUDOR TB740 Стартерная аккумуляторная батарея
TA770 Стартерная аккумуляторная батарея
VARTA 570901076D852 Стартерная аккумуляторная батарея
5740120683132 Стартерная аккумуляторная батарея
5774000783162 Стартерная аккумуляторная батарея
VEMO V99-17-0015 Стартерная аккумуляторная батарея
V99-17-0022 Стартерная аккумуляторная батарея
VMF AGM570760 Стартерная аккумуляторная батарея
57412 Стартерная аккумуляторная батарея
YUASA YBX1096 Стартерная аккумуляторная батарея
YBX3096 Стартерная аккумуляторная батарея
YBX5096 Стартерная аккумуляторная батарея
2026 CATCAR.INFO (v 2.0)