#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxMXx8bW9kZWxfaWQ9PTI5MHx8bWRmX2lkPT0wXjM2fHxzcGFyZV9pZD09MTAwNDA1&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 = "36" AND ( (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "702012" AND av.ProductID IN (307)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "KAT1183" AND av.ProductID IN (307)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "1 987 948 612" AND av.ProductID IN (307)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "KCD0709" AND av.ProductID IN (307)) OR (av.SupplierID = 4578 AND av.DataSupplierArticleNumber = "PBTK231" AND av.ProductID IN (307)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "0110KB" AND av.ProductID IN (307)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CTBK204" AND av.ProductID IN (307)) OR (av.SupplierID = 31 AND av.DataSupplierArticleNumber = "CT520K1" AND av.ProductID IN (307)) OR (av.SupplierID = 42 AND av.DataSupplierArticleNumber = "KTB216" AND av.ProductID IN (307)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "KDB216" AND av.ProductID IN (307)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "11028" AND av.ProductID IN (307)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "F904966" AND av.ProductID IN (307)) OR (av.SupplierID = 33 AND av.DataSupplierArticleNumber = "K015077" AND av.ProductID IN (307)) OR (av.SupplierID = 178 AND av.DataSupplierArticleNumber = "20-1007" AND av.ProductID IN (307)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "KH 107" AND av.ProductID IN (307)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "530 0006 10" AND av.ProductID IN (307)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "20-1007" AND av.ProductID IN (307)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1412100419" AND av.ProductID IN (307)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "KFI110" AND av.ProductID IN (307)) OR (av.SupplierID = 424 AND av.DataSupplierArticleNumber = "LDK0204" AND av.ProductID IN (307)) OR (av.SupplierID = 424 AND av.DataSupplierArticleNumber = "LDK0107" AND av.ProductID IN (307)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "341314391101" AND av.ProductID IN (307)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "23600" AND av.ProductID IN (307)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "WM-Z 101" AND av.ProductID IN (307)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "10115003" AND av.ProductID IN (307)) OR (av.SupplierID = 64 AND av.DataSupplierArticleNumber = "KT 1007" AND av.ProductID IN (307)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QBK175" AND av.ProductID IN (307)) OR (av.SupplierID = 100 AND av.DataSupplierArticleNumber = "RR1439K1" AND av.ProductID IN (307)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "5500070" AND av.ProductID IN (307)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKMA 08110" AND av.ProductID IN (307)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "KD450.00" AND av.ProductID IN (307)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "20 02 0009" AND av.ProductID IN (307)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8647 11001" AND av.ProductID IN (307)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V20-7356" AND av.ProductID IN (307)) OR (av.SupplierID = 179 AND av.DataSupplierArticleNumber = "K1G1206" AND av.ProductID IN (307)) OR (av.SupplierID = 179 AND av.DataSupplierArticleNumber = "K1G1199" AND av.ProductID IN (307)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1141993" AND av.ProductID IN (307)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1464117" AND av.ProductID IN (307,307,307,307)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1251114" AND av.ProductID IN (307)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1054319" AND av.ProductID IN (307)) ) 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 = 300 AND aa.DataSupplierArticleNumber = "702012") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "KAT1183") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "1 987 948 612") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "KCD0709") OR (aa.SupplierID = 4578 AND aa.DataSupplierArticleNumber = "PBTK231") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "0110KB") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CTBK204") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "CT520K1") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "KTB216") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "KDB216") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "11028") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "F904966") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "K015077") OR (aa.SupplierID = 178 AND aa.DataSupplierArticleNumber = "20-1007") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "KH 107") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "530 0006 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "20-1007") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1412100419") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "KFI110") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LDK0204") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LDK0107") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "341314391101") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "23600") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "WM-Z 101") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "10115003") OR (aa.SupplierID = 64 AND aa.DataSupplierArticleNumber = "KT 1007") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QBK175") OR (aa.SupplierID = 100 AND aa.DataSupplierArticleNumber = "RR1439K1") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "5500070") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKMA 08110") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "KD450.00") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "20 02 0009") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8647 11001") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V20-7356") OR (aa.SupplierID = 179 AND aa.DataSupplierArticleNumber = "K1G1206") OR (aa.SupplierID = 179 AND aa.DataSupplierArticleNumber = "K1G1199") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1141993") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1464117") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1251114") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1054319") ) 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 = 300 AND aa.DataSupplierArticleNumber = "702012") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "KAT1183") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "1 987 948 612") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "KCD0709") OR (aa.SupplierID = 4578 AND aa.DataSupplierArticleNumber = "PBTK231") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "0110KB") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CTBK204") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "CT520K1") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "KTB216") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "KDB216") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "11028") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "F904966") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "K015077") OR (aa.SupplierID = 178 AND aa.DataSupplierArticleNumber = "20-1007") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "KH 107") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "530 0006 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "20-1007") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1412100419") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "KFI110") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LDK0204") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LDK0107") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "341314391101") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "23600") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "WM-Z 101") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "10115003") OR (aa.SupplierID = 64 AND aa.DataSupplierArticleNumber = "KT 1007") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QBK175") OR (aa.SupplierID = 100 AND aa.DataSupplierArticleNumber = "RR1439K1") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "5500070") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKMA 08110") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "KD450.00") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "20 02 0009") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8647 11001") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V20-7356") OR (aa.SupplierID = 179 AND aa.DataSupplierArticleNumber = "K1G1206") OR (aa.SupplierID = 179 AND aa.DataSupplierArticleNumber = "K1G1199") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1141993") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1464117") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1251114") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1054319") ) AND aa.Language = "ru" Продажа автозапчастей типа Комплект ремней ГРМ для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTEX 702012 Комплект ремня ГРМ
AUTOTEAM KAT1183 Комплект ремня ГРМ
BOSCH 1 987 948 612 Комплект ремня ГРМ
BREDA LORETT KCD0709 Комплект ремня ГРМ
BRT Bearings PBTK231 Комплект ремня ГРМ
CALIBER 0110KB Комплект ремня ГРМ
COMLINE CTBK204 Комплект ремня ГРМ
CONTITECH CT520K1 Комплект ремня ГРМ
DAYCO KTB216 Комплект ремня ГРМ
DELPHI KDB216 Комплект ремня ГРМ
FEBI BILSTEIN 11028 Комплект ремня ГРМ
FLENNOR F904966 Комплект ремня ГРМ
GATES K015077 Комплект ремня ГРМ
HEPU 20-1007 Комплект ремня ГРМ
HUTCHINSON KH 107 Комплект ремня ГРМ
INA 530 0006 10 Комплект ремня ГРМ
IPD 20-1007 Комплект ремня ГРМ
JP GROUP 1412100419 Комплект ремня ГРМ
KM International KFI110 Комплект ремня ГРМ
LUCAS ENGINE DRIVE LDK0204 Комплект ремня ГРМ
LDK0107 Комплект ремня ГРМ
MAGNETI MARELLI 341314391101 Комплект ремня ГРМ
MAPCO 23600 Комплект ремня ГРМ
METZGER WM-Z 101 Комплект ремня ГРМ
NK 10115003 Комплект ремня ГРМ
OPTIBELT KT 1007 Комплект ремня ГРМ
QUINTON HAZELL QBK175 Комплект ремня ГРМ
ROULUNDS RUBBER RR1439K1 Комплект ремня ГРМ
RUVILLE 5500070 Комплект ремня ГРМ
SKF VKMA 08110 Комплект ремня ГРМ
SNR KD450.00 Комплект ремня ГРМ
SWAG 20 02 0009 Комплект ремня ГРМ
TRISCAN 8647 11001 Комплект ремня ГРМ
VAICO V20-7356 Комплект ремня ГРМ
VEYANCE K1G1206 Комплект ремня ГРМ
K1G1199 Комплект ремня ГРМ
WILMINK GROUP WG1141993 Комплект ремня ГРМ
WG1464117 Комплект ремня ГРМ
WG1251114 Комплект ремня ГРМ
WG1054319 Комплект ремня ГРМ
2026 CATCAR.INFO (v 2.0)