#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUyNXx8bW9kZWxfaWQ9PTU1NDJ8fG1kZl9pZD09MF4yNDQ2MHx8c3BhcmVfaWQ9PTEwMTk5NA%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 = "24460" AND ( (av.SupplierID = 4866 AND av.DataSupplierArticleNumber = "EcoTronic F 5W-20" AND av.ProductID IN (3224)) OR (av.SupplierID = 4866 AND av.DataSupplierArticleNumber = "HighTronic F 5W-30" AND av.ProductID IN (3224)) OR (av.SupplierID = 189 AND av.DataSupplierArticleNumber = "65612" AND av.ProductID IN (3224)) OR (av.SupplierID = 189 AND av.DataSupplierArticleNumber = "65609" AND av.ProductID IN (3224)) OR (av.SupplierID = 4357 AND av.DataSupplierArticleNumber = "49170" AND av.ProductID IN (3224)) OR (av.SupplierID = 4357 AND av.DataSupplierArticleNumber = "49200" AND av.ProductID IN (3224)) OR (av.SupplierID = 4357 AND av.DataSupplierArticleNumber = "49380" AND av.ProductID IN (3224)) OR (av.SupplierID = 398 AND av.DataSupplierArticleNumber = "E100072" AND av.ProductID IN (3224)) OR (av.SupplierID = 398 AND av.DataSupplierArticleNumber = "E100065" AND av.ProductID IN (3224)) OR (av.SupplierID = 4907 AND av.DataSupplierArticleNumber = "DuranzaECO5W20" AND av.ProductID IN (3224)) OR (av.SupplierID = 222 AND av.DataSupplierArticleNumber = "P000329" AND av.ProductID IN (3224)) OR (av.SupplierID = 222 AND av.DataSupplierArticleNumber = "P000313" AND av.ProductID IN (3224)) OR (av.SupplierID = 222 AND av.DataSupplierArticleNumber = "P000328" AND av.ProductID IN (3224)) OR (av.SupplierID = 4449 AND av.DataSupplierArticleNumber = "2015101010V5" AND av.ProductID IN (3224)) OR (av.SupplierID = 4449 AND av.DataSupplierArticleNumber = "201510107530" 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 = 461 AND av.DataSupplierArticleNumber = "1111115" AND av.ProductID IN (3224)) OR (av.SupplierID = 461 AND av.DataSupplierArticleNumber = "1111123" AND av.ProductID IN (3224)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0192" AND av.ProductID IN (3224)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0193" AND av.ProductID IN (3224)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0109" AND av.ProductID IN (3224)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0194" AND av.ProductID IN (3224)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0110" AND av.ProductID IN (3224)) OR (av.SupplierID = 188 AND av.DataSupplierArticleNumber = "65609" AND av.ProductID IN (3224)) OR (av.SupplierID = 188 AND av.DataSupplierArticleNumber = "65612" 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 = "EcoTronic F 5W-20") OR (aa.SupplierID = 4866 AND aa.DataSupplierArticleNumber = "HighTronic F 5W-30") OR (aa.SupplierID = 189 AND aa.DataSupplierArticleNumber = "65612") OR (aa.SupplierID = 189 AND aa.DataSupplierArticleNumber = "65609") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "49170") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "49200") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "49380") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E100072") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E100065") OR (aa.SupplierID = 4907 AND aa.DataSupplierArticleNumber = "DuranzaECO5W20") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000329") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000313") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000328") OR (aa.SupplierID = 4449 AND aa.DataSupplierArticleNumber = "2015101010V5") OR (aa.SupplierID = 4449 AND aa.DataSupplierArticleNumber = "201510107530") 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 = 461 AND aa.DataSupplierArticleNumber = "1111115") OR (aa.SupplierID = 461 AND aa.DataSupplierArticleNumber = "1111123") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0192") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0193") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0109") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0194") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0110") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "65609") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "65612") ) 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 = "EcoTronic F 5W-20") OR (aa.SupplierID = 4866 AND aa.DataSupplierArticleNumber = "HighTronic F 5W-30") OR (aa.SupplierID = 189 AND aa.DataSupplierArticleNumber = "65612") OR (aa.SupplierID = 189 AND aa.DataSupplierArticleNumber = "65609") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "49170") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "49200") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "49380") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E100072") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E100065") OR (aa.SupplierID = 4907 AND aa.DataSupplierArticleNumber = "DuranzaECO5W20") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000329") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000313") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000328") OR (aa.SupplierID = 4449 AND aa.DataSupplierArticleNumber = "2015101010V5") OR (aa.SupplierID = 4449 AND aa.DataSupplierArticleNumber = "201510107530") 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 = 461 AND aa.DataSupplierArticleNumber = "1111115") OR (aa.SupplierID = 461 AND aa.DataSupplierArticleNumber = "1111123") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0192") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0193") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0109") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0194") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0110") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "65609") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "65612") ) AND aa.Language = "ru" Продажа автозапчастей типа Масла для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ARAL EcoTronic F 5W-20 Моторное масло
HighTronic F 5W-30 Моторное масло
CHAMPION LUBRICANTS 65612 Моторное масло
65609 Моторное масло
DIVINOL 49170 Моторное масло
49200 Моторное масло
49380 Моторное масло
EUROL E100072 Моторное масло
E100065 Моторное масло
KROON OIL DuranzaECO5W20 Моторное масло
LIQUI MOLY P000329 Моторное масло
P000313 Моторное масло
P000328 Моторное масло
MOBIL 2015101010V5 Моторное масло
201510107530 Моторное масло
OPEN PARTS EOS1040.01 Моторное масло
EOS0531.04 Моторное масло
EOS0530.01 Моторное масло
EOS1040.04 Моторное масло
EOS0540.01 Моторное масло
EOS0530.04 Моторное масло
EOS0540.04 Моторное масло
EOS0531.01 Моторное масло
RAVENOL 1111115 Моторное масло
1111123 Моторное масло
VAICO V60-0192 Моторное масло
V60-0193 Моторное масло
V60-0109 Моторное масло
V60-0194 Моторное масло
V60-0110 Моторное масло
WOLF 65609 Моторное масло
65612 Моторное масло
2026 CATCAR.INFO (v 2.0)