#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxNHx8bW9kZWxfaWQ9PTUzOTB8fG1kZl9pZD09MF4xODQ1NHx8c3BhcmVfaWQ9PTEwMDA1MQ%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 = "18454" AND ( (av.SupplierID = 487 AND av.DataSupplierArticleNumber = "KT90044" AND av.ProductID IN (479)) OR (av.SupplierID = 487 AND av.DataSupplierArticleNumber = "KT90453" AND av.ProductID IN (479)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "HK7625" AND av.ProductID IN (479)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "ECK081" AND av.ProductID IN (479)) OR (av.SupplierID = 399 AND av.DataSupplierArticleNumber = "PGK2069" AND av.ProductID IN (479)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "CK63041" AND av.ProductID IN (479)) OR (av.SupplierID = 4461 AND av.DataSupplierArticleNumber = "EC025" AND av.ProductID IN (479)) OR (av.SupplierID = 4461 AND av.DataSupplierArticleNumber = "KS121-K" AND av.ProductID IN (479)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "KC003" AND av.ProductID IN (479)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "962248" AND av.ProductID IN (479)) OR (av.SupplierID = 4879 AND av.DataSupplierArticleNumber = "KC7625" AND av.ProductID IN (479)) OR (av.SupplierID = 4428 AND av.DataSupplierArticleNumber = "069 2224" AND av.ProductID IN (479)) OR (av.SupplierID = 4718 AND av.DataSupplierArticleNumber = "W00228J" AND av.ProductID IN (479)) OR (av.SupplierID = 6 AND av.DataSupplierArticleNumber = "623 3043 21" AND av.ProductID IN (479)) OR (av.SupplierID = 6 AND av.DataSupplierArticleNumber = "623 3141 00" AND av.ProductID IN (479)) OR (av.SupplierID = 6 AND av.DataSupplierArticleNumber = "623 3043 00" AND av.ProductID IN (479)) OR (av.SupplierID = 470 AND av.DataSupplierArticleNumber = "000228900" AND av.ProductID IN (479)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "10314" AND av.ProductID IN (479)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "61-5129" AND av.ProductID IN (479)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "61-5182" AND av.ProductID IN (479)) OR (av.SupplierID = 4559 AND av.DataSupplierArticleNumber = "MK9674" AND av.ProductID IN (479)) OR (av.SupplierID = 4559 AND av.DataSupplierArticleNumber = "MK9648" AND av.ProductID IN (479)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "VCU314" AND av.ProductID IN (479)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "VCU459" AND av.ProductID IN (479)) OR (av.SupplierID = 190 AND av.DataSupplierArticleNumber = "CK9549" AND av.ProductID IN (479)) OR (av.SupplierID = 190 AND av.DataSupplierArticleNumber = "CK9549T" AND av.ProductID IN (479)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "131938" AND av.ProductID IN (479)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "S200I70" AND av.ProductID IN (479)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "CLK9004.03" AND av.ProductID IN (479)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QKT4181AF" AND av.ProductID IN (479)) OR (av.SupplierID = 400 AND av.DataSupplierArticleNumber = "RC90453" AND av.ProductID IN (479)) OR (av.SupplierID = 400 AND av.DataSupplierArticleNumber = "RC90044" AND av.ProductID IN (479)) OR (av.SupplierID = 4828 AND av.DataSupplierArticleNumber = "JT7625" AND av.ProductID IN (479)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "3000 950 061" AND av.ProductID IN (479)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "3000 951 288" AND av.ProductID IN (479)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "SCL0526" AND av.ProductID IN (479)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "1201131938" AND av.ProductID IN (479)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "07-01102-SX" AND av.ProductID IN (479)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "832066" AND av.ProductID IN (479)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "826345" AND av.ProductID IN (479)) ) 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 = 487 AND aa.DataSupplierArticleNumber = "KT90044") OR (aa.SupplierID = 487 AND aa.DataSupplierArticleNumber = "KT90453") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "HK7625") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "ECK081") OR (aa.SupplierID = 399 AND aa.DataSupplierArticleNumber = "PGK2069") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "CK63041") OR (aa.SupplierID = 4461 AND aa.DataSupplierArticleNumber = "EC025") OR (aa.SupplierID = 4461 AND aa.DataSupplierArticleNumber = "KS121-K") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "KC003") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "962248") OR (aa.SupplierID = 4879 AND aa.DataSupplierArticleNumber = "KC7625") OR (aa.SupplierID = 4428 AND aa.DataSupplierArticleNumber = "069 2224") OR (aa.SupplierID = 4718 AND aa.DataSupplierArticleNumber = "W00228J") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "623 3043 21") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "623 3141 00") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "623 3043 00") OR (aa.SupplierID = 470 AND aa.DataSupplierArticleNumber = "000228900") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "10314") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "61-5129") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "61-5182") OR (aa.SupplierID = 4559 AND aa.DataSupplierArticleNumber = "MK9674") OR (aa.SupplierID = 4559 AND aa.DataSupplierArticleNumber = "MK9648") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VCU314") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VCU459") OR (aa.SupplierID = 190 AND aa.DataSupplierArticleNumber = "CK9549") OR (aa.SupplierID = 190 AND aa.DataSupplierArticleNumber = "CK9549T") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "131938") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "S200I70") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "CLK9004.03") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QKT4181AF") OR (aa.SupplierID = 400 AND aa.DataSupplierArticleNumber = "RC90453") OR (aa.SupplierID = 400 AND aa.DataSupplierArticleNumber = "RC90044") OR (aa.SupplierID = 4828 AND aa.DataSupplierArticleNumber = "JT7625") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 950 061") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 951 288") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "SCL0526") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "1201131938") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "07-01102-SX") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "832066") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "826345") ) 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 = 487 AND aa.DataSupplierArticleNumber = "KT90044") OR (aa.SupplierID = 487 AND aa.DataSupplierArticleNumber = "KT90453") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "HK7625") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "ECK081") OR (aa.SupplierID = 399 AND aa.DataSupplierArticleNumber = "PGK2069") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "CK63041") OR (aa.SupplierID = 4461 AND aa.DataSupplierArticleNumber = "EC025") OR (aa.SupplierID = 4461 AND aa.DataSupplierArticleNumber = "KS121-K") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "KC003") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "962248") OR (aa.SupplierID = 4879 AND aa.DataSupplierArticleNumber = "KC7625") OR (aa.SupplierID = 4428 AND aa.DataSupplierArticleNumber = "069 2224") OR (aa.SupplierID = 4718 AND aa.DataSupplierArticleNumber = "W00228J") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "623 3043 21") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "623 3141 00") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "623 3043 00") OR (aa.SupplierID = 470 AND aa.DataSupplierArticleNumber = "000228900") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "10314") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "61-5129") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "61-5182") OR (aa.SupplierID = 4559 AND aa.DataSupplierArticleNumber = "MK9674") OR (aa.SupplierID = 4559 AND aa.DataSupplierArticleNumber = "MK9648") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VCU314") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VCU459") OR (aa.SupplierID = 190 AND aa.DataSupplierArticleNumber = "CK9549") OR (aa.SupplierID = 190 AND aa.DataSupplierArticleNumber = "CK9549T") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "131938") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "S200I70") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "CLK9004.03") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QKT4181AF") OR (aa.SupplierID = 400 AND aa.DataSupplierArticleNumber = "RC90453") OR (aa.SupplierID = 400 AND aa.DataSupplierArticleNumber = "RC90044") OR (aa.SupplierID = 4828 AND aa.DataSupplierArticleNumber = "JT7625") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 950 061") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 951 288") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "SCL0526") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "1201131938") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "07-01102-SX") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "832066") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "826345") ) AND aa.Language = "ru" Продажа автозапчастей типа Комплект сцепления для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AP Automotive Prod. KT90044 Комплект сцепления
KT90453 Комплект сцепления
BORG & BECK HK7625 Комплект сцепления
COMLINE ECK081 Комплект сцепления
EXEDY PGK2069 Комплект сцепления
FENOX CK63041 Комплект сцепления
KAISHIN EC025 Комплект сцепления
KS121-K Комплект сцепления
KAMOKA KC003 Комплект сцепления
KAWE 962248 Комплект сцепления
KEY PARTS KC7625 Комплект сцепления
KM Germany 069 2224 Комплект сцепления
KRAFTTECH W00228J Комплект сцепления
LuK 623 3043 21 Комплект сцепления
623 3141 00 Комплект сцепления
623 3043 00 Комплект сцепления
MAPA 000228900 Комплект сцепления
MAPCO 10314 Комплект сцепления
MAXGEAR 61-5129 Комплект сцепления
61-5182 Комплект сцепления
MECARM MK9674 Комплект сцепления
MK9648 Комплект сцепления
MOTAQUIP VCU314 Комплект сцепления
VCU459 Комплект сцепления
NATIONAL CK9549 Комплект сцепления
CK9549T Комплект сцепления
NK 131938 Комплект сцепления
NPS S200I70 Комплект сцепления
OPEN PARTS CLK9004.03 Комплект сцепления
QUINTON HAZELL QKT4181AF Комплект сцепления
RAICAM RC90453 Комплект сцепления
RC90044 Комплект сцепления
RYMEC JT7625 Комплект сцепления
SACHS 3000 950 061 Комплект сцепления
3000 951 288 Комплект сцепления
SASIC SCL0526 Комплект сцепления
sbs 1201131938 Комплект сцепления
STELLOX 07-01102-SX Комплект сцепления
VALEO 832066 Комплект сцепления
826345 Комплект сцепления
2026 CATCAR.INFO (v 2.0)