#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1NXx8bW9kZWxfaWQ9PTM5NzV8fG1kZl9pZD09MF4xMDM1OXx8c3BhcmVfaWQ9PTEwMTk5NA%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 = "10359" AND ( (av.SupplierID = 4866 AND av.DataSupplierArticleNumber = "SuperTronic 0W-40" AND av.ProductID IN (3224)) OR (av.SupplierID = 4357 AND av.DataSupplierArticleNumber = "49610" AND av.ProductID IN (3224)) OR (av.SupplierID = 398 AND av.DataSupplierArticleNumber = "E100094" AND av.ProductID IN (3224)) OR (av.SupplierID = 398 AND av.DataSupplierArticleNumber = "E100091" AND av.ProductID IN (3224)) OR (av.SupplierID = 4907 AND av.DataSupplierArticleNumber = "Asyntho5W30" AND av.ProductID IN (3224)) OR (av.SupplierID = 222 AND av.DataSupplierArticleNumber = "P000327" AND av.ProductID IN (3224)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "EOS1040.01" AND av.ProductID IN (3224)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "EOS0531.04" AND av.ProductID IN (3224)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "EOS0530.01" AND av.ProductID IN (3224)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "EOS1040.04" AND av.ProductID IN (3224)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "EOS0540.01" AND av.ProductID IN (3224)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "EOS0530.04" AND av.ProductID IN (3224)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "EOS0540.04" AND av.ProductID IN (3224)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "EOS0531.01" AND av.ProductID IN (3224)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0281" AND av.ProductID IN (3224)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0277" AND av.ProductID IN (3224)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0282" AND av.ProductID IN (3224)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0279" AND av.ProductID IN (3224)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0283" AND av.ProductID IN (3224)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0280" AND av.ProductID IN (3224)) ) 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 = 4866 AND aa.DataSupplierArticleNumber = "SuperTronic 0W-40") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "49610") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E100094") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E100091") OR (aa.SupplierID = 4907 AND aa.DataSupplierArticleNumber = "Asyntho5W30") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000327") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS1040.01") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0531.04") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0530.01") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS1040.04") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0540.01") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0530.04") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0540.04") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0531.01") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0281") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0277") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0282") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0279") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0283") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0280") ) 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 = 4866 AND aa.DataSupplierArticleNumber = "SuperTronic 0W-40") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "49610") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E100094") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E100091") OR (aa.SupplierID = 4907 AND aa.DataSupplierArticleNumber = "Asyntho5W30") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000327") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS1040.01") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0531.04") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0530.01") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS1040.04") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0540.01") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0530.04") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0540.04") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0531.01") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0281") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0277") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0282") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0279") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0283") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0280") ) AND aa.Language = "ru" Продажа автозапчастей типа Масла для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ARAL SuperTronic 0W-40 Моторное масло
DIVINOL 49610 Моторное масло
EUROL E100094 Моторное масло
E100091 Моторное масло
KROON OIL Asyntho5W30 Моторное масло
LIQUI MOLY P000327 Моторное масло
OPEN PARTS EOS1040.01 Моторное масло
EOS0531.04 Моторное масло
EOS0530.01 Моторное масло
EOS1040.04 Моторное масло
EOS0540.01 Моторное масло
EOS0530.04 Моторное масло
EOS0540.04 Моторное масло
EOS0531.01 Моторное масло
VAICO V60-0281 Моторное масло
V60-0277 Моторное масло
V60-0282 Моторное масло
V60-0279 Моторное масло
V60-0283 Моторное масло
V60-0280 Моторное масло
2026 CATCAR.INFO (v 2.0)