#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3NXx8bW9kZWxfaWQ9PTM3MTY0fHxtZGZfaWQ9PTBeMTIzNDI2fHxzcGFyZV9pZD09MTAxOTk0&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 = "123426" AND ( (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 = "EOS1040.99" 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)) ) 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 = 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 = "EOS1040.99") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0540.04") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0531.01") ) 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 = 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 = "EOS1040.99") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0540.04") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EOS0531.01") ) AND aa.Language = "ru" Продажа автозапчастей типа Масла для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
OPEN PARTS EOS1040.01 Моторное масло
EOS0531.04 Моторное масло
EOS0530.01 Моторное масло
EOS1040.04 Моторное масло
EOS0540.01 Моторное масло
EOS0530.04 Моторное масло
EOS1040.99 Моторное масло
EOS0540.04 Моторное масло
EOS0531.01 Моторное масло
2026 CATCAR.INFO (v 2.0)