#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4Nnx8bW9kZWxfaWQ9PTYzOTB8fG1kZl9pZD09MF4yNzYyNXx8c3BhcmVfaWQ9PTEwMjIwOA%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 = "27625" AND ( (av.SupplierID = 189 AND av.DataSupplierArticleNumber = "5039" AND av.ProductID IN (3357)) OR (av.SupplierID = 398 AND av.DataSupplierArticleNumber = "E801410" AND av.ProductID IN (3357)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "26461" 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 = 222 AND av.DataSupplierArticleNumber = "P000418" AND av.ProductID IN (3357)) OR (av.SupplierID = 222 AND av.DataSupplierArticleNumber = "P000421" AND av.ProductID IN (3357)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "BFE1000.10" AND av.ProductID IN (3357)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "BFE1000.05" AND av.ProductID IN (3357)) OR (av.SupplierID = 461 AND av.DataSupplierArticleNumber = "1350601" 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-0243" 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 = 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 = 21 AND av.DataSupplierArticleNumber = "402407" 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 = "402408" AND av.ProductID IN (3357)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "402403" AND av.ProductID IN (3357)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1054608" AND av.ProductID IN (3357)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1306544" 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 = "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 = 189 AND aa.DataSupplierArticleNumber = "5039") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E801410") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26461") 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 = 222 AND aa.DataSupplierArticleNumber = "P000418") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000421") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "BFE1000.10") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "BFE1000.05") OR (aa.SupplierID = 461 AND aa.DataSupplierArticleNumber = "1350601") 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-0243") 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 = 21 AND aa.DataSupplierArticleNumber = "402406") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402401") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402407") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402402") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402408") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402403") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1054608") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1306544") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "5015") 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 = 189 AND aa.DataSupplierArticleNumber = "5039") OR (aa.SupplierID = 398 AND aa.DataSupplierArticleNumber = "E801410") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26461") 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 = 222 AND aa.DataSupplierArticleNumber = "P000418") OR (aa.SupplierID = 222 AND aa.DataSupplierArticleNumber = "P000421") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "BFE1000.10") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "BFE1000.05") OR (aa.SupplierID = 461 AND aa.DataSupplierArticleNumber = "1350601") 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-0243") 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 = 21 AND aa.DataSupplierArticleNumber = "402406") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402401") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402407") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402402") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402408") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402403") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1054608") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1306544") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "5015") OR (aa.SupplierID = 188 AND aa.DataSupplierArticleNumber = "5039") ) AND aa.Language = "ru" Продажа автозапчастей типа Тормозная жидкость для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
CHAMPION LUBRICANTS 5039 Тормозная жидкость
EUROL E801410 Тормозная жидкость
FEBI BILSTEIN 26461 Тормозная жидкость
21754 Тормозная жидкость
26746 Тормозная жидкость
23930 Тормозная жидкость
26748 Тормозная жидкость
23932 Тормозная жидкость
LIQUI MOLY P000418 Тормозная жидкость
P000421 Тормозная жидкость
OPEN PARTS BFE1000.10 Тормозная жидкость
BFE1000.05 Тормозная жидкость
RAVENOL 1350601 Тормозная жидкость
SWAG 99 90 0001 Тормозная жидкость
30 92 6461 Тормозная жидкость
99 90 0004 Тормозная жидкость
32 92 3930 Тормозная жидкость
32 92 3932 Тормозная жидкость
10 92 1754 Тормозная жидкость
VAICO V60-0243 Тормозная жидкость
V60-0236 Тормозная жидкость
V60-0075 Тормозная жидкость
V60-0237 Тормозная жидкость
V60-0111 Тормозная жидкость
V60-0242 Тормозная жидкость
V60-0235 Тормозная жидкость
V60-0074 Тормозная жидкость
VALEO 402406 Тормозная жидкость
402401 Тормозная жидкость
402407 Тормозная жидкость
402402 Тормозная жидкость
402408 Тормозная жидкость
402403 Тормозная жидкость
WILMINK GROUP WG1054608 Тормозная жидкость
WG1306544 Тормозная жидкость
WOLF 5015 Тормозная жидкость
5039 Тормозная жидкость
2026 CATCAR.INFO (v 2.0)