#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTE2MzF8fG1kZl9pZD09MF4yNzc4Mnx8c3BhcmVfaWQ9PTEwMTgxNQ%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 = "27782" AND ( (av.SupplierID = 166 AND av.DataSupplierArticleNumber = "ATF-92005" AND av.ProductID IN (3069)) OR (av.SupplierID = 166 AND av.DataSupplierArticleNumber = "ATF-92001" AND av.ProductID IN (3069)) OR (av.SupplierID = 4668 AND av.DataSupplierArticleNumber = "004915" AND av.ProductID IN (3069)) OR (av.SupplierID = 189 AND av.DataSupplierArticleNumber = "3010" AND av.ProductID IN (3069)) OR (av.SupplierID = 4357 AND av.DataSupplierArticleNumber = "51800" AND av.ProductID IN (3069)) OR (av.SupplierID = 4357 AND av.DataSupplierArticleNumber = "51810" AND av.ProductID IN (3069)) OR (av.SupplierID = 4948 AND av.DataSupplierArticleNumber = "DP3310.10.071" AND av.ProductID IN (3069)) OR (av.SupplierID = 398 AND av.DataSupplierArticleNumber = "E113661" AND av.ProductID IN (3069)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "14738" AND av.ProductID IN (3069)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "29738" AND av.ProductID IN (3069)) OR (av.SupplierID = 222 AND av.DataSupplierArticleNumber = "P000242" AND av.ProductID IN (3069)) OR (av.SupplierID = 461 AND av.DataSupplierArticleNumber = "1221101" AND av.ProductID IN (3069)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "AG52 Automatic Special" AND av.ProductID IN (3069)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "ATF Multivehicle" AND av.ProductID IN (3069)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 92 9738" AND av.ProductID IN (3069)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 91 4738" AND av.ProductID IN (3069)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0066" AND av.ProductID IN (3069)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0207" AND av.ProductID IN (3069)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0050" AND av.ProductID IN (3069)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0065" AND av.ProductID IN (3069)) OR (av.SupplierID = 188 AND av.DataSupplierArticleNumber = "3010" AND av.ProductID IN (3069)) ) 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 = 166 AND aa.DataSupplierArticleNumber = "ATF-92005") OR (aa.SupplierID = 166 AND aa.DataSupplierArticleNumber = "ATF-92001") OR (aa.SupplierID = 4668 AND aa.DataSupplierArticleNumber = "004915") OR (aa.SupplierID = 189 AND aa.DataSupplierArticleNumber = "3010") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "51800") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "51810") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP3310.10.071") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E113661") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "14738") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29738") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000242") OR (aa.SupplierID = 461 AND aa.DataSupplierArticleNumber = "1221101") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "AG52 Automatic Special") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "ATF Multivehicle") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 9738") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 91 4738") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0066") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0207") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0050") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0065") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "3010") ) 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 = 166 AND aa.DataSupplierArticleNumber = "ATF-92005") OR (aa.SupplierID = 166 AND aa.DataSupplierArticleNumber = "ATF-92001") OR (aa.SupplierID = 4668 AND aa.DataSupplierArticleNumber = "004915") OR (aa.SupplierID = 189 AND aa.DataSupplierArticleNumber = "3010") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "51800") OR (aa.SupplierID = 4357 AND aa.DataSupplierArticleNumber = "51810") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP3310.10.071") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E113661") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "14738") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29738") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000242") OR (aa.SupplierID = 461 AND aa.DataSupplierArticleNumber = "1221101") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "AG52 Automatic Special") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "ATF Multivehicle") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 9738") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 91 4738") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0066") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0207") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0050") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0065") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "3010") ) AND aa.Language = "ru" Продажа автозапчастей типа Масла для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AISIN ATF-92005 Масло автоматической коробки передач
ATF-92001 Масло автоматической коробки передач
CARLUBE 004915 Масло автоматической коробки передач
CHAMPION LUBRICANTS 3010 Масло автоматической коробки передач
DIVINOL 51800 Масло автоматической коробки передач
51810 Масло автоматической коробки передач
Dr!ve+ DP3310.10.071 Масло автоматической коробки передач
EUROL E113661 Масло автоматической коробки передач
FEBI BILSTEIN 14738 Масло автоматической коробки передач
29738 Масло автоматической коробки передач
LIQUI MOLY P000242 Масло автоматической коробки передач
RAVENOL 1221101 Масло автоматической коробки передач
SCT Germany AG52 Automatic Special Масло автоматической коробки передач
ATF Multivehicle Масло автоматической коробки передач
SWAG 30 92 9738 Масло автоматической коробки передач
30 91 4738 Масло автоматической коробки передач
VAICO V60-0066 Масло автоматической коробки передач
V60-0207 Масло автоматической коробки передач
V60-0050 Масло автоматической коробки передач
V60-0065 Масло автоматической коробки передач
WOLF 3010 Масло автоматической коробки передач
2026 CATCAR.INFO (v 2.0)