#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTUwOTh8fG1kZl9pZD09MF4xOTExNnx8c3BhcmVfaWQ9PTEwMDA1MQ%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 = "19116" AND ( (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "HKT1303" AND av.ProductID IN (479)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "HK2354" AND av.ProductID IN (479)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "962345" AND av.ProductID IN (479)) OR (av.SupplierID = 6 AND av.DataSupplierArticleNumber = "624 3233 19" AND av.ProductID IN (479)) OR (av.SupplierID = 6 AND av.DataSupplierArticleNumber = "624 3233 33" AND av.ProductID IN (479)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QKT4025AF" AND av.ProductID IN (479)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QKT4117AF" AND av.ProductID IN (479)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "3000 951 809" AND av.ProductID IN (479)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "3000 990 174" AND av.ProductID IN (479)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "828020" 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 = 475 AND aa.DataSupplierArticleNumber = "HKT1303") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "HK2354") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "962345") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "624 3233 19") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "624 3233 33") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QKT4025AF") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QKT4117AF") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 951 809") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 990 174") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "828020") ) 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 = 475 AND aa.DataSupplierArticleNumber = "HKT1303") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "HK2354") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "962345") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "624 3233 19") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "624 3233 33") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QKT4025AF") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QKT4117AF") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 951 809") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "3000 990 174") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "828020") ) AND aa.Language = "ru" Продажа автозапчастей типа Комплект сцепления для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BORG & BECK HKT1303 Комплект сцепления
HK2354 Комплект сцепления
KAWE 962345 Комплект сцепления
LuK 624 3233 19 Комплект сцепления
624 3233 33 Комплект сцепления
QUINTON HAZELL QKT4025AF Комплект сцепления
QKT4117AF Комплект сцепления
SACHS 3000 951 809 Комплект сцепления
3000 990 174 Комплект сцепления
VALEO 828020 Комплект сцепления
2026 CATCAR.INFO (v 2.0)