#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTY0MTd8fG1kZl9pZD09MV4xMTIwM3x8c3BhcmVfaWQ9PTIwMDU1Ng%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 = "11203" AND ( (av.SupplierID = 434 AND av.DataSupplierArticleNumber = "DF1853" AND av.ProductID IN (1)) OR (av.SupplierID = 434 AND av.DataSupplierArticleNumber = "DF2353" AND av.ProductID IN (1)) OR (av.SupplierID = 434 AND av.DataSupplierArticleNumber = "DE1853" AND av.ProductID IN (1)) OR (av.SupplierID = 434 AND av.DataSupplierArticleNumber = "DE2253" AND av.ProductID IN (1)) OR (av.SupplierID = 4881 AND av.DataSupplierArticleNumber = "610619" AND av.ProductID IN (1)) OR (av.SupplierID = 24 AND av.DataSupplierArticleNumber = "EE2253" AND av.ProductID IN (1)) OR (av.SupplierID = 24 AND av.DataSupplierArticleNumber = "ED1803" AND av.ProductID IN (1)) OR (av.SupplierID = 24 AND av.DataSupplierArticleNumber = "EF1853" AND av.ProductID IN (1)) OR (av.SupplierID = 24 AND av.DataSupplierArticleNumber = "ED2303" AND av.ProductID IN (1)) OR (av.SupplierID = 24 AND av.DataSupplierArticleNumber = "EF2353" AND av.ProductID IN (1)) OR (av.SupplierID = 24 AND av.DataSupplierArticleNumber = "EE1853" AND av.ProductID IN (1)) OR (av.SupplierID = 4452 AND av.DataSupplierArticleNumber = "GS-629SHD" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "069225115034" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "069180100033" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "065220115020" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "069185110034" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "067100039690" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "069225110033" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "067100039700" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "065160100020" AND av.ProductID IN (1)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1820 0167" AND av.ProductID IN (4063)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1820 0127" AND av.ProductID IN (4063)) OR (av.SupplierID = 212 AND av.DataSupplierArticleNumber = "TF2353" AND av.ProductID IN (1)) OR (av.SupplierID = 212 AND av.DataSupplierArticleNumber = "TE1853" AND av.ProductID IN (1)) OR (av.SupplierID = 212 AND av.DataSupplierArticleNumber = "TE2253" AND av.ProductID IN (1)) OR (av.SupplierID = 212 AND av.DataSupplierArticleNumber = "TF1853" AND av.ProductID IN (1)) OR (av.SupplierID = 26 AND av.DataSupplierArticleNumber = "680500100E652" AND av.ProductID IN (1)) OR (av.SupplierID = 26 AND av.DataSupplierArticleNumber = "690500105E652" AND av.ProductID IN (1)) OR (av.SupplierID = 4963 AND av.DataSupplierArticleNumber = "66514" AND av.ProductID IN (1)) OR (av.SupplierID = 4963 AND av.DataSupplierArticleNumber = "96351" AND av.ProductID IN (1)) OR (av.SupplierID = 4963 AND av.DataSupplierArticleNumber = "64317" AND av.ProductID IN (1)) OR (av.SupplierID = 4451 AND av.DataSupplierArticleNumber = "629SHD" 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 = 434 AND aa.DataSupplierArticleNumber = "DF1853") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DF2353") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DE1853") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DE2253") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "610619") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EE2253") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "ED1803") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EF1853") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "ED2303") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EF2353") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EE1853") OR (aa.SupplierID = 4452 AND aa.DataSupplierArticleNumber = "GS-629SHD") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069225115034") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069180100033") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "065220115020") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069185110034") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "067100039690") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069225110033") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "067100039700") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "065160100020") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0167") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0127") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TF2353") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TE1853") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TE2253") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TF1853") OR (aa.SupplierID = 26 AND aa.DataSupplierArticleNumber = "680500100E652") OR (aa.SupplierID = 26 AND aa.DataSupplierArticleNumber = "690500105E652") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "66514") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "96351") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "64317") OR (aa.SupplierID = 4451 AND aa.DataSupplierArticleNumber = "629SHD") ) 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 = 434 AND aa.DataSupplierArticleNumber = "DF1853") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DF2353") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DE1853") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DE2253") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "610619") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EE2253") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "ED1803") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EF1853") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "ED2303") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EF2353") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EE1853") OR (aa.SupplierID = 4452 AND aa.DataSupplierArticleNumber = "GS-629SHD") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069225115034") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069180100033") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "065220115020") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069185110034") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "067100039690") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069225110033") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "067100039700") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "065160100020") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0167") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0127") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TF2353") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TE1853") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TE2253") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TF1853") OR (aa.SupplierID = 26 AND aa.DataSupplierArticleNumber = "680500100E652") OR (aa.SupplierID = 26 AND aa.DataSupplierArticleNumber = "690500105E652") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "66514") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "96351") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "64317") OR (aa.SupplierID = 4451 AND aa.DataSupplierArticleNumber = "629SHD") ) AND aa.Language = "ru" Продажа автозапчастей типа Батарея для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DETA DF1853 Стартерная аккумуляторная батарея
DF2353 Стартерная аккумуляторная батарея
DE1853 Стартерная аккумуляторная батарея
DE2253 Стартерная аккумуляторная батарея
DYNAMAX 610619 Стартерная аккумуляторная батарея
EXIDE EE2253 Стартерная аккумуляторная батарея
ED1803 Стартерная аккумуляторная батарея
EF1853 Стартерная аккумуляторная батарея
ED2303 Стартерная аккумуляторная батарея
EF2353 Стартерная аккумуляторная батарея
EE1853 Стартерная аккумуляторная батарея
GS GS-629SHD Стартерная аккумуляторная батарея
MAGNETI MARELLI 069225115034 Стартерная аккумуляторная батарея
069180100033 Стартерная аккумуляторная батарея
065220115020 Стартерная аккумуляторная батарея
069185110034 Стартерная аккумуляторная батарея
067100039690 Стартерная аккумуляторная батарея
069225110033 Стартерная аккумуляторная батарея
067100039700 Стартерная аккумуляторная батарея
065160100020 Стартерная аккумуляторная батарея
SAMPA 1820 0167 Крышка, корпус аккумулятора
1820 0127 Крышка, корпус аккумулятора
TUDOR TF2353 Стартерная аккумуляторная батарея
TE1853 Стартерная аккумуляторная батарея
TE2253 Стартерная аккумуляторная батарея
TF1853 Стартерная аккумуляторная батарея
VARTA 680500100E652 Стартерная аккумуляторная батарея
690500105E652 Стартерная аккумуляторная батарея
VMF 66514 Стартерная аккумуляторная батарея
96351 Стартерная аккумуляторная батарея
64317 Стартерная аккумуляторная батарея
YUASA 629SHD Стартерная аккумуляторная батарея
2026 CATCAR.INFO (v 2.0)