#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUyNXx8bW9kZWxfaWQ9PTYyMzh8fG1kZl9pZD09MF42OTc5fHxzcGFyZV9pZD09MTAwNDA0&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 = "6979" AND ( (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "1 987 949 666" AND av.ProductID IN (306)) OR (av.SupplierID = 31 AND av.DataSupplierArticleNumber = "CT1162" AND av.ProductID IN (306)) OR (av.SupplierID = 42 AND av.DataSupplierArticleNumber = "941048" AND av.ProductID IN (306)) OR (av.SupplierID = 154 AND av.DataSupplierArticleNumber = "05KD059" AND av.ProductID IN (306)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "14125" AND av.ProductID IN (306)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "37285" AND av.ProductID IN (306)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "4545V" AND av.ProductID IN (306)) OR (av.SupplierID = 33 AND av.DataSupplierArticleNumber = "5656XS" AND av.ProductID IN (306)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "141 HTDP/T 25" AND av.ProductID IN (306)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "M112A39" AND av.ProductID IN (306)) OR (av.SupplierID = 64 AND av.DataSupplierArticleNumber = "ZRK 1764" AND av.ProductID IN (306)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QTB762" AND av.ProductID IN (306)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "1760024" AND av.ProductID IN (306)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "62 93 7285" AND av.ProductID IN (306)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "304 462" AND av.ProductID IN (306)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8645 5656xs" AND av.ProductID IN (306)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1431308" AND av.ProductID IN (306)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1151252" AND av.ProductID IN (306)) ) 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 = 30 AND aa.DataSupplierArticleNumber = "1 987 949 666") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "CT1162") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "941048") OR (aa.SupplierID = 154 AND aa.DataSupplierArticleNumber = "05KD059") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "14125") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "37285") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "4545V") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "5656XS") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "141 HTDP/T 25") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "M112A39") OR (aa.SupplierID = 64 AND aa.DataSupplierArticleNumber = "ZRK 1764") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTB762") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "1760024") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "62 93 7285") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "304 462") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8645 5656xs") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1431308") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1151252") ) 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 = 30 AND aa.DataSupplierArticleNumber = "1 987 949 666") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "CT1162") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "941048") OR (aa.SupplierID = 154 AND aa.DataSupplierArticleNumber = "05KD059") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "14125") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "37285") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "4545V") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "5656XS") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "141 HTDP/T 25") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "M112A39") OR (aa.SupplierID = 64 AND aa.DataSupplierArticleNumber = "ZRK 1764") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTB762") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "1760024") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "62 93 7285") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "304 462") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8645 5656xs") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1431308") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1151252") ) AND aa.Language = "ru" Продажа автозапчастей типа Ремень ГРМ для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BOSCH 1 987 949 666 Ремень ГРМ
CONTITECH CT1162 Ремень ГРМ
DAYCO 941048 Ремень ГРМ
DOLZ 05KD059 Ремень ГРМ
FAI AutoParts 14125 Ремень ГРМ
FEBI BILSTEIN 37285 Ремень ГРМ
FLENNOR 4545V Ремень ГРМ
GATES 5656XS Ремень ГРМ
HUTCHINSON 141 HTDP/T 25 Ремень ГРМ
NPS M112A39 Ремень ГРМ
OPTIBELT ZRK 1764 Ремень ГРМ
QUINTON HAZELL QTB762 Ремень ГРМ
SASIC 1760024 Ремень ГРМ
SWAG 62 93 7285 Ремень ГРМ
TOPRAN 304 462 Ремень ГРМ
TRISCAN 8645 5656xs Ремень ГРМ
WILMINK GROUP WG1431308 Ремень ГРМ
WG1151252 Ремень ГРМ
2026 CATCAR.INFO (v 2.0)