#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0N3x8bW9kZWxfaWQ9PTQ1OTd8fG1kZl9pZD09MF4xNjU5MHx8c3BhcmVfaWQ9PTEwMTk5Mw%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 = "16590" AND ( (av.SupplierID = 189 AND av.DataSupplierArticleNumber = "2306" AND av.ProductID IN (3225)) OR (av.SupplierID = 4357 AND av.DataSupplierArticleNumber = "52070" AND av.ProductID IN (3225)) OR (av.SupplierID = 4357 AND av.DataSupplierArticleNumber = "52010" AND av.ProductID IN (3225)) OR (av.SupplierID = 4881 AND av.DataSupplierArticleNumber = "501623" AND av.ProductID IN (3225)) OR (av.SupplierID = 4881 AND av.DataSupplierArticleNumber = "501939" AND av.ProductID IN (3225)) OR (av.SupplierID = 4881 AND av.DataSupplierArticleNumber = "502034" AND av.ProductID IN (3225)) OR (av.SupplierID = 4881 AND av.DataSupplierArticleNumber = "502496" AND av.ProductID IN (3225)) OR (av.SupplierID = 398 AND av.DataSupplierArticleNumber = "E110075" AND av.ProductID IN (3225)) OR (av.SupplierID = 398 AND av.DataSupplierArticleNumber = "E110076" AND av.ProductID IN (3225)) OR (av.SupplierID = 4907 AND av.DataSupplierArticleNumber = "Syngear75W90" AND av.ProductID IN (3225)) OR (av.SupplierID = 4449 AND av.DataSupplierArticleNumber = "201520501010" AND av.ProductID IN (3225)) OR (av.SupplierID = 4449 AND av.DataSupplierArticleNumber = "201530102710" AND av.ProductID IN (3225)) OR (av.SupplierID = 461 AND av.DataSupplierArticleNumber = "1221101" AND av.ProductID IN (3225)) OR (av.SupplierID = 461 AND av.DataSupplierArticleNumber = "1222101" AND av.ProductID IN (3225)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "Basic Plus 75W-90" AND av.ProductID IN (3225)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0043" AND av.ProductID IN (3225)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0040" AND av.ProductID IN (3225)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0041" AND av.ProductID IN (3225)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0042" AND av.ProductID IN (3225)) OR (av.SupplierID = 188 AND av.DataSupplierArticleNumber = "2306" AND av.ProductID IN (3225)) ) 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 = 189 AND aa.DataSupplierArticleNumber = "2306") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "52070") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "52010") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "501623") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "501939") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "502034") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "502496") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E110075") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E110076") OR (aa.SupplierID = 4907 AND aa.DataSupplierArticleNumber = "Syngear75W90") OR (aa.SupplierID = 4449 AND aa.DataSupplierArticleNumber = "201520501010") OR (aa.SupplierID = 4449 AND aa.DataSupplierArticleNumber = "201530102710") OR (aa.SupplierID = 461 AND aa.DataSupplierArticleNumber = "1221101") OR (aa.SupplierID = 461 AND aa.DataSupplierArticleNumber = "1222101") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "Basic Plus 75W-90") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0043") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0040") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0041") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0042") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "2306") ) 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 = 189 AND aa.DataSupplierArticleNumber = "2306") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "52070") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "52010") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "501623") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "501939") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "502034") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "502496") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E110075") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E110076") OR (aa.SupplierID = 4907 AND aa.DataSupplierArticleNumber = "Syngear75W90") OR (aa.SupplierID = 4449 AND aa.DataSupplierArticleNumber = "201520501010") OR (aa.SupplierID = 4449 AND aa.DataSupplierArticleNumber = "201530102710") OR (aa.SupplierID = 461 AND aa.DataSupplierArticleNumber = "1221101") OR (aa.SupplierID = 461 AND aa.DataSupplierArticleNumber = "1222101") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "Basic Plus 75W-90") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0043") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0040") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0041") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0042") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "2306") ) AND aa.Language = "ru" Продажа автозапчастей типа Масла для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
CHAMPION LUBRICANTS 2306 Масло ступенчатой коробки передач
DIVINOL 52070 Масло ступенчатой коробки передач
52010 Масло ступенчатой коробки передач
DYNAMAX 501623 Масло ступенчатой коробки передач
501939 Масло ступенчатой коробки передач
502034 Масло ступенчатой коробки передач
502496 Масло ступенчатой коробки передач
EUROL E110075 Масло ступенчатой коробки передач
E110076 Масло ступенчатой коробки передач
KROON OIL Syngear75W90 Масло ступенчатой коробки передач
MOBIL 201520501010 Масло ступенчатой коробки передач
201530102710 Масло ступенчатой коробки передач
RAVENOL 1221101 Масло ступенчатой коробки передач
1222101 Масло ступенчатой коробки передач
SCT Germany Basic Plus 75W-90 Масло ступенчатой коробки передач
VAICO V60-0043 Масло ступенчатой коробки передач
V60-0040 Масло ступенчатой коробки передач
V60-0041 Масло ступенчатой коробки передач
V60-0042 Масло ступенчатой коробки передач
WOLF 2306 Масло ступенчатой коробки передач
2026 CATCAR.INFO (v 2.0)