#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTQ4NzR8fG1kZl9pZD09MF4xNjk5MXx8c3BhcmVfaWQ9PTEwMDA1MQ%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 = "16991" AND ( (av.SupplierID = 487 AND av.DataSupplierArticleNumber = "KT90117" AND av.ProductID IN (479)) OR (av.SupplierID = 4576 AND av.DataSupplierArticleNumber = "80165" AND av.ProductID IN (479)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "HKT1130" AND av.ProductID IN (479)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "HK2021" AND av.ProductID IN (479)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "HKT1131" AND av.ProductID IN (479)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "HK2028" AND av.ProductID IN (479)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "HKT1126" AND av.ProductID IN (479)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1330403619" AND av.ProductID IN (479)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1330405719" AND av.ProductID IN (479)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1330406419" AND av.ProductID IN (479)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "961848" AND av.ProductID IN (479)) OR (av.SupplierID = 6 AND av.DataSupplierArticleNumber = "623 3079 35" AND av.ProductID IN (479)) OR (av.SupplierID = 6 AND av.DataSupplierArticleNumber = "624 3241 09" AND av.ProductID IN (479)) OR (av.SupplierID = 6 AND av.DataSupplierArticleNumber = "623 3079 09" AND av.ProductID IN (479)) OR (av.SupplierID = 6 AND av.DataSupplierArticleNumber = "624 3241 33" AND av.ProductID IN (479)) OR (av.SupplierID = 6 AND av.DataSupplierArticleNumber = "623 3079 34" AND av.ProductID IN (479)) OR (av.SupplierID = 4559 AND av.DataSupplierArticleNumber = "MK10111D" AND av.ProductID IN (479)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "133358" AND av.ProductID IN (479)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QKT2289AF" AND av.ProductID IN (479)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QKT2579AF" AND av.ProductID IN (479)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QKT2285AF" AND av.ProductID IN (479)) OR (av.SupplierID = 400 AND av.DataSupplierArticleNumber = "RC90117" AND av.ProductID IN (479)) OR (av.SupplierID = 4828 AND av.DataSupplierArticleNumber = "JT1162019" AND av.ProductID IN (479)) OR (av.SupplierID = 4828 AND av.DataSupplierArticleNumber = "JT1210" AND av.ProductID IN (479)) OR (av.SupplierID = 4828 AND av.DataSupplierArticleNumber = "JT1162" AND av.ProductID IN (479)) OR (av.SupplierID = 4828 AND av.DataSupplierArticleNumber = "JT1210019" AND av.ProductID IN (479)) OR (av.SupplierID = 4828 AND av.DataSupplierArticleNumber = "JT1162018" AND av.ProductID IN (479)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "3000 990 054" AND av.ProductID IN (479)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "3000 990 155" AND av.ProductID IN (479)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "3000 856 401" AND av.ProductID IN (479)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "3000 990 179" AND av.ProductID IN (479)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "3000 970 021" AND av.ProductID IN (479)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "1201133358" AND av.ProductID IN (479)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "826941" AND av.ProductID IN (479)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "826653" AND av.ProductID IN (479)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "826655" AND av.ProductID IN (479)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "826656" 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 = "KT90117") OR (aa.SupplierID = 4576 AND aa.DataSupplierArticleNumber = "80165") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "HKT1130") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "HK2021") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "HKT1131") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "HK2028") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "HKT1126") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1330403619") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1330405719") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1330406419") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "961848") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "623 3079 35") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "624 3241 09") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "623 3079 09") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "624 3241 33") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "623 3079 34") OR (aa.SupplierID = 4559 AND aa.DataSupplierArticleNumber = "MK10111D") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "133358") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QKT2289AF") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QKT2579AF") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QKT2285AF") OR (aa.SupplierID = 400 AND aa.DataSupplierArticleNumber = "RC90117") OR (aa.SupplierID = 4828 AND aa.DataSupplierArticleNumber = "JT1162019") OR (aa.SupplierID = 4828 AND aa.DataSupplierArticleNumber = "JT1210") OR (aa.SupplierID = 4828 AND aa.DataSupplierArticleNumber = "JT1162") OR (aa.SupplierID = 4828 AND aa.DataSupplierArticleNumber = "JT1210019") OR (aa.SupplierID = 4828 AND aa.DataSupplierArticleNumber = "JT1162018") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 990 054") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 990 155") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 856 401") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 990 179") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 970 021") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "1201133358") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "826941") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "826653") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "826655") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "826656") ) 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 = "KT90117") OR (aa.SupplierID = 4576 AND aa.DataSupplierArticleNumber = "80165") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "HKT1130") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "HK2021") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "HKT1131") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "HK2028") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "HKT1126") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1330403619") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1330405719") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1330406419") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "961848") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "623 3079 35") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "624 3241 09") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "623 3079 09") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "624 3241 33") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "623 3079 34") OR (aa.SupplierID = 4559 AND aa.DataSupplierArticleNumber = "MK10111D") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "133358") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QKT2289AF") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QKT2579AF") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QKT2285AF") OR (aa.SupplierID = 400 AND aa.DataSupplierArticleNumber = "RC90117") OR (aa.SupplierID = 4828 AND aa.DataSupplierArticleNumber = "JT1162019") OR (aa.SupplierID = 4828 AND aa.DataSupplierArticleNumber = "JT1210") OR (aa.SupplierID = 4828 AND aa.DataSupplierArticleNumber = "JT1162") OR (aa.SupplierID = 4828 AND aa.DataSupplierArticleNumber = "JT1210019") OR (aa.SupplierID = 4828 AND aa.DataSupplierArticleNumber = "JT1162018") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 990 054") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 990 155") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 856 401") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 990 179") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 970 021") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "1201133358") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "826941") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "826653") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "826655") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "826656") ) AND aa.Language = "ru" Продажа автозапчастей типа Комплект сцепления для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AP Automotive Prod. KT90117 Комплект сцепления
ASAM 80165 Комплект сцепления
BORG & BECK HKT1130 Комплект сцепления
HK2021 Комплект сцепления
HKT1131 Комплект сцепления
HK2028 Комплект сцепления
HKT1126 Комплект сцепления
JP GROUP 1330403619 Комплект сцепления
1330405719 Комплект сцепления
1330406419 Комплект сцепления
KAWE 961848 Комплект сцепления
LuK 623 3079 35 Комплект сцепления
624 3241 09 Комплект сцепления
623 3079 09 Комплект сцепления
624 3241 33 Комплект сцепления
623 3079 34 Комплект сцепления
MECARM MK10111D Комплект сцепления
NK 133358 Комплект сцепления
QUINTON HAZELL QKT2289AF Комплект сцепления
QKT2579AF Комплект сцепления
QKT2285AF Комплект сцепления
RAICAM RC90117 Комплект сцепления
RYMEC JT1162019 Комплект сцепления
JT1210 Комплект сцепления
JT1162 Комплект сцепления
JT1210019 Комплект сцепления
JT1162018 Комплект сцепления
SACHS 3000 990 054 Комплект сцепления
3000 990 155 Комплект сцепления
3000 856 401 Комплект сцепления
3000 990 179 Комплект сцепления
3000 970 021 Комплект сцепления
sbs 1201133358 Комплект сцепления
VALEO 826941 Комплект сцепления
826653 Комплект сцепления
826655 Комплект сцепления
826656 Комплект сцепления
2026 CATCAR.INFO (v 2.0)