#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTg3NHx8bW9kZWxfaWQ9PTk2MzB8fG1kZl9pZD09MF4xMDQ4NHx8c3BhcmVfaWQ9PTEwMjIwOA%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 = "10484" AND ( (av.SupplierID = 4668 AND av.DataSupplierArticleNumber = "116900" AND av.ProductID IN (3357)) OR (av.SupplierID = 189 AND av.DataSupplierArticleNumber = "5015" AND av.ProductID IN (3357)) OR (av.SupplierID = 189 AND av.DataSupplierArticleNumber = "5038" AND av.ProductID IN (3357)) OR (av.SupplierID = 189 AND av.DataSupplierArticleNumber = "5039" AND av.ProductID IN (3357)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "21754" AND av.ProductID IN (3357)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "26746" AND av.ProductID IN (3357)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "23930" AND av.ProductID IN (3357)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "26748" AND av.ProductID IN (3357)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "23932" AND av.ProductID IN (3357)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "26461" AND av.ProductID IN (3357)) OR (av.SupplierID = 222 AND av.DataSupplierArticleNumber = "P000419" AND av.ProductID IN (3357)) OR (av.SupplierID = 222 AND av.DataSupplierArticleNumber = "P000420" AND av.ProductID IN (3357)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "99 90 0001" AND av.ProductID IN (3357)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 92 6461" AND av.ProductID IN (3357)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "99 90 0004" AND av.ProductID IN (3357)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "32 92 3930" AND av.ProductID IN (3357)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "32 92 3932" AND av.ProductID IN (3357)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 92 1754" AND av.ProductID IN (3357)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0236" AND av.ProductID IN (3357)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0075" AND av.ProductID IN (3357)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0237" AND av.ProductID IN (3357)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0111" AND av.ProductID IN (3357)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0242" AND av.ProductID IN (3357)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0235" AND av.ProductID IN (3357)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0074" AND av.ProductID IN (3357)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V60-0243" AND av.ProductID IN (3357)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "402402" AND av.ProductID IN (3357)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "402403" AND av.ProductID IN (3357)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "402406" AND av.ProductID IN (3357)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "402401" AND av.ProductID IN (3357)) OR (av.SupplierID = 188 AND av.DataSupplierArticleNumber = "5015" AND av.ProductID IN (3357)) OR (av.SupplierID = 188 AND av.DataSupplierArticleNumber = "5038" AND av.ProductID IN (3357)) OR (av.SupplierID = 188 AND av.DataSupplierArticleNumber = "5039" AND av.ProductID IN (3357)) ) 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 = 4668 AND aa.DataSupplierArticleNumber = "116900") OR (aa.SupplierID = 189 AND aa.DataSupplierArticleNumber = "5015") OR (aa.SupplierID = 189 AND aa.DataSupplierArticleNumber = "5038") OR (aa.SupplierID = 189 AND aa.DataSupplierArticleNumber = "5039") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "21754") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26746") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "23930") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26748") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "23932") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26461") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000419") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000420") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "99 90 0001") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 6461") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "99 90 0004") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 3930") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 3932") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 92 1754") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0236") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0075") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0237") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0111") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0242") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0235") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0074") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0243") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402402") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402403") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402406") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402401") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "5015") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "5038") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "5039") ) 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 = 4668 AND aa.DataSupplierArticleNumber = "116900") OR (aa.SupplierID = 189 AND aa.DataSupplierArticleNumber = "5015") OR (aa.SupplierID = 189 AND aa.DataSupplierArticleNumber = "5038") OR (aa.SupplierID = 189 AND aa.DataSupplierArticleNumber = "5039") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "21754") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26746") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "23930") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26748") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "23932") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26461") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000419") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000420") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "99 90 0001") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 6461") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "99 90 0004") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 3930") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 3932") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 92 1754") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0236") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0075") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0237") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0111") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0242") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0235") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0074") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V60-0243") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402402") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402403") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402406") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402401") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "5015") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "5038") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "5039") ) AND aa.Language = "ru" Продажа автозапчастей типа Тормозная жидкость для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
CARLUBE 116900 Тормозная жидкость
CHAMPION LUBRICANTS 5015 Тормозная жидкость
5038 Тормозная жидкость
5039 Тормозная жидкость
FEBI BILSTEIN 21754 Тормозная жидкость
26746 Тормозная жидкость
23930 Тормозная жидкость
26748 Тормозная жидкость
23932 Тормозная жидкость
26461 Тормозная жидкость
LIQUI MOLY P000419 Тормозная жидкость
P000420 Тормозная жидкость
SWAG 99 90 0001 Тормозная жидкость
30 92 6461 Тормозная жидкость
99 90 0004 Тормозная жидкость
32 92 3930 Тормозная жидкость
32 92 3932 Тормозная жидкость
10 92 1754 Тормозная жидкость
VAICO V60-0236 Тормозная жидкость
V60-0075 Тормозная жидкость
V60-0237 Тормозная жидкость
V60-0111 Тормозная жидкость
V60-0242 Тормозная жидкость
V60-0235 Тормозная жидкость
V60-0074 Тормозная жидкость
V60-0243 Тормозная жидкость
VALEO 402402 Тормозная жидкость
402403 Тормозная жидкость
402406 Тормозная жидкость
402401 Тормозная жидкость
WOLF 5015 Тормозная жидкость
5038 Тормозная жидкость
5039 Тормозная жидкость
2026 CATCAR.INFO (v 2.0)