#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0N3x8bW9kZWxfaWQ9PTQ3ODl8fG1kZl9pZD09MF4xNjIxMnx8c3BhcmVfaWQ9PTEwMDQ1NQ%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 = "16212" AND ( (av.SupplierID = 4997 AND av.DataSupplierArticleNumber = "YM320150" AND av.ProductID IN (308)) OR (av.SupplierID = 4533 AND av.DataSupplierArticleNumber = "143396" AND av.ProductID IN (308,308)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "I130-35" AND av.ProductID IN (308)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "0342-3050" AND av.ProductID IN (308)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "641727" AND av.ProductID IN (308)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "654871" AND av.ProductID IN (308)) OR (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "RT1837" AND av.ProductID IN (308)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.502" AND av.ProductID IN (308)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.81439" AND av.ProductID IN (308)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "A02200" AND av.ProductID IN (308)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADG07689" AND av.ProductID IN (308)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADG07611" AND av.ProductID IN (308)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "TDI5119" AND av.ProductID IN (308)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "TDI5527" AND av.ProductID IN (308)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 40-615-003" AND av.ProductID IN (308)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "56063" AND av.ProductID IN (308)) OR (av.SupplierID = 42 AND av.DataSupplierArticleNumber = "ATB2458" AND av.ProductID IN (308)) OR (av.SupplierID = 42 AND av.DataSupplierArticleNumber = "ATB2599" AND av.ProductID IN (308)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DT75629" AND av.ProductID IN (308)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DT75636" AND av.ProductID IN (308)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "T9569" AND av.ProductID IN (308)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "1287-SON" AND av.ProductID IN (308)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "24544" AND av.ProductID IN (308)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "33186" AND av.ProductID IN (308)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "R12111" AND av.ProductID IN (308)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FS99034" AND av.ProductID IN (308)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FS99077" AND av.ProductID IN (308)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FS99710" AND av.ProductID IN (308)) OR (av.SupplierID = 33 AND av.DataSupplierArticleNumber = "T43135" AND av.ProductID IN (308)) OR (av.SupplierID = 55 AND av.DataSupplierArticleNumber = "J1140503" AND av.ProductID IN (308)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "HTG 328" AND av.ProductID IN (308)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "HTG 397" AND av.ProductID IN (308)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "531 0528 10" AND av.ProductID IN (308)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "531 0532 10" AND av.ProductID IN (308)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "14-0722" AND av.ProductID IN (308)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "15-3866" AND av.ProductID IN (308)) OR (av.SupplierID = 201 AND av.DataSupplierArticleNumber = "DTE-3003" AND av.ProductID IN (308)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "FI5500" AND av.ProductID IN (308)) OR (av.SupplierID = 197 AND av.DataSupplierArticleNumber = "AA10259" AND av.ProductID IN (308)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "PB-1024" AND av.ProductID IN (308)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "PB-1187" AND av.ProductID IN (308)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "23596" AND av.ProductID IN (308)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "54-1131" AND av.ProductID IN (308)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "37-51 902 1001" AND av.ProductID IN (308)) OR (av.SupplierID = 248 AND av.DataSupplierArticleNumber = "J1140503" AND av.ProductID IN (308)) OR (av.SupplierID = 64 AND av.DataSupplierArticleNumber = "185UT" AND av.ProductID IN (308)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "0-N1561" AND av.ProductID IN (308)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "0-N1619" AND av.ProductID IN (308)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PT75629" AND av.ProductID IN (308)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PT75636" AND av.ProductID IN (308)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "1014-2228" AND av.ProductID IN (308)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "1014-5312" AND av.ProductID IN (308)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QTT1019" AND av.ProductID IN (308)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT1511" AND av.ProductID IN (308)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT3155" AND av.ProductID IN (308)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "58402" AND av.ProductID IN (308)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "58428" AND av.ProductID IN (308)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 75629" AND av.ProductID IN (308)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 75636" AND av.ProductID IN (308)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "GT384.01" AND av.ProductID IN (308)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "GT384.06" AND av.ProductID IN (308)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "03-40180-SX" AND av.ProductID IN (308)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "90 92 4544" AND av.ProductID IN (308)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "90 93 3186" AND av.ProductID IN (308)) OR (av.SupplierID = 4896 AND av.DataSupplierArticleNumber = "KR5034" AND av.ProductID IN (308)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "426504" AND av.ProductID IN (308)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8646 43106" AND av.ProductID IN (308)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8646 43103" AND av.ProductID IN (308)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V52-0158" AND av.ProductID IN (308)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1252390" AND av.ProductID IN (308)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1252394" AND av.ProductID IN (308)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1432279" AND av.ProductID IN (308)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1432344" AND av.ProductID IN (308)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "SR-1296" AND av.ProductID IN (308)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "SR-1491" AND av.ProductID IN (308)) ) 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 = 4997 AND aa.DataSupplierArticleNumber = "YM320150") OR (aa.SupplierID = 4533 AND aa.DataSupplierArticleNumber = "143396") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "I130-35") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "0342-3050") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "641727") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654871") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "RT1837") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.502") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81439") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A02200") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADG07689") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADG07611") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "TDI5119") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "TDI5527") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 40-615-003") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "56063") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "ATB2458") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "ATB2599") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DT75629") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DT75636") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "T9569") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "1287-SON") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "24544") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "33186") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "R12111") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FS99034") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FS99077") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FS99710") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "T43135") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J1140503") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "HTG 328") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "HTG 397") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "531 0528 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "531 0532 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "14-0722") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3866") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "DTE-3003") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI5500") OR (aa.SupplierID = 197 AND aa.DataSupplierArticleNumber = "AA10259") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PB-1024") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PB-1187") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "23596") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "54-1131") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "37-51 902 1001") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "J1140503") OR (aa.SupplierID = 64 AND aa.DataSupplierArticleNumber = "185UT") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N1561") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N1619") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PT75629") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PT75636") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "1014-2228") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "1014-5312") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTT1019") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT1511") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3155") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "58402") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "58428") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 75629") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 75636") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GT384.01") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GT384.06") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "03-40180-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "90 92 4544") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "90 93 3186") OR (aa.SupplierID = 4896 AND aa.DataSupplierArticleNumber = "KR5034") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "426504") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8646 43106") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8646 43103") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V52-0158") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1252390") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1252394") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1432279") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1432344") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "SR-1296") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "SR-1491") ) 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 = 4997 AND aa.DataSupplierArticleNumber = "YM320150") OR (aa.SupplierID = 4533 AND aa.DataSupplierArticleNumber = "143396") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "I130-35") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "0342-3050") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "641727") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654871") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "RT1837") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.502") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81439") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A02200") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADG07689") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADG07611") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "TDI5119") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "TDI5527") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 40-615-003") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "56063") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "ATB2458") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "ATB2599") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DT75629") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DT75636") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "T9569") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "1287-SON") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "24544") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "33186") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "R12111") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FS99034") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FS99077") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FS99710") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "T43135") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J1140503") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "HTG 328") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "HTG 397") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "531 0528 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "531 0532 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "14-0722") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3866") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "DTE-3003") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI5500") OR (aa.SupplierID = 197 AND aa.DataSupplierArticleNumber = "AA10259") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PB-1024") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PB-1187") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "23596") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "54-1131") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "37-51 902 1001") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "J1140503") OR (aa.SupplierID = 64 AND aa.DataSupplierArticleNumber = "185UT") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N1561") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N1619") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PT75629") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PT75636") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "1014-2228") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "1014-5312") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTT1019") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT1511") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3155") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "58402") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "58428") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 75629") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 75636") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GT384.01") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GT384.06") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "03-40180-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "90 92 4544") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "90 93 3186") OR (aa.SupplierID = 4896 AND aa.DataSupplierArticleNumber = "KR5034") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "426504") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8646 43106") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8646 43103") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V52-0158") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1252390") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1252394") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1432279") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1432344") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "SR-1296") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "SR-1491") ) AND aa.Language = "ru" Продажа автозапчастей типа Ролик натяжителя для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
A.B.A YM320150 Натяжной ролик, ремень ГРМ
ACEMARK 143396 Натяжной ролик, ремень ГРМ
ASHUKI I130-35 Натяжной ролик, ремень ГРМ
0342-3050 Натяжной ролик, ремень ГРМ
AUTEX 641727 Натяжной ролик, ремень ГРМ
654871 Натяжной ролик, ремень ГРМ
AUTLOG RT1837 Натяжной ролик, ремень ГРМ
AUTOKIT 03.502 Натяжной ролик, ремень ГРМ
03.81439 Натяжной ролик, ремень ГРМ
AUTOTEAM A02200 Натяжной ролик, ремень ГРМ
BLUE PRINT ADG07689 Натяжной ролик, ремень ГРМ
ADG07611 Натяжной ролик, ремень ГРМ
BREDA LORETT TDI5119 Натяжной ролик, ремень ГРМ
TDI5527 Натяжной ролик, ремень ГРМ
BSG BSG 40-615-003 Натяжной ролик, ремень ГРМ
CALIBER 56063 Натяжной ролик, ремень ГРМ
DAYCO ATB2458 Натяжной ролик, ремень ГРМ
ATB2599 Натяжной ролик, ремень ГРМ
DYNAMATRIX DT75629 Натяжной ролик, ремень ГРМ
DT75636 Натяжной ролик, ремень ГРМ
FAI AutoParts T9569 Натяжной ролик, ремень ГРМ
FEBEST 1287-SON Натяжной ролик, ремень ГРМ
FEBI BILSTEIN 24544 Натяжной ролик, ремень ГРМ
33186 Натяжной ролик, ремень ГРМ
FENOX R12111 Натяжной ролик, ремень ГРМ
FLENNOR FS99034 Натяжной ролик, ремень ГРМ
FS99077 Натяжной ролик, ремень ГРМ
FS99710 Натяжной ролик, ремень ГРМ
GATES T43135 Натяжной ролик, ремень ГРМ
HERTH+BUSS JAKOPARTS J1140503 Натяжной ролик, ремень ГРМ
HUTCHINSON HTG 328 Натяжной ролик, ремень ГРМ
HTG 397 Натяжной ролик, ремень ГРМ
INA 531 0528 10 Натяжной ролик, ремень ГРМ
531 0532 10 Натяжной ролик, ремень ГРМ
IPD 14-0722 Натяжной ролик, ремень ГРМ
15-3866 Натяжной ролик, ремень ГРМ
KAVO PARTS DTE-3003 Натяжной ролик, ремень ГРМ
KM International FI5500 Натяжной ролик, ремень ГРМ
LPR AA10259 Натяжной ролик, ремень ГРМ
LYNXauto PB-1024 Натяжной ролик, ремень ГРМ
PB-1187 Натяжной ролик, ремень ГРМ
MAPCO 23596 Натяжной ролик, ремень ГРМ
MAXGEAR 54-1131 Натяжной ролик, ремень ГРМ
MEYLE 37-51 902 1001 Натяжной ролик, ремень ГРМ
NIPPARTS J1140503 Натяжной ролик, ремень ГРМ
OPTIBELT 185UT Натяжной ролик, ремень ГРМ
OPTIMAL 0-N1561 Натяжной ролик, ремень ГРМ
0-N1619 Натяжной ролик, ремень ГРМ
PATRON PT75629 Натяжной ролик, ремень ГРМ
PT75636 Натяжной ролик, ремень ГРМ
PROFIT 1014-2228 Натяжной ролик, ремень ГРМ
1014-5312 Натяжной ролик, ремень ГРМ
QUINTON HAZELL QTT1019 Натяжной ролик, ремень ГРМ
REPKIT RKT1511 Натяжной ролик, ремень ГРМ
RKT3155 Натяжной ролик, ремень ГРМ
RUVILLE 58402 Натяжной ролик, ремень ГРМ
58428 Натяжной ролик, ремень ГРМ
SKF VKM 75629 Натяжной ролик, ремень ГРМ
VKM 75636 Натяжной ролик, ремень ГРМ
SNR GT384.01 Натяжной ролик, ремень ГРМ
GT384.06 Натяжной ролик, ремень ГРМ
STELLOX 03-40180-SX Натяжной ролик, ремень ГРМ
SWAG 90 92 4544 Натяжной ролик, ремень ГРМ
90 93 3186 Натяжной ролик, ремень ГРМ
TORQUE KR5034 Натяжной ролик, ремень ГРМ
TRICLO 426504 Натяжной ролик, ремень ГРМ
TRISCAN 8646 43106 Натяжной ролик, ремень ГРМ
8646 43103 Натяжной ролик, ремень ГРМ
VAICO V52-0158 Натяжной ролик, ремень ГРМ
WILMINK GROUP WG1252390 Натяжной ролик, ремень ГРМ
WG1252394 Натяжной ролик, ремень ГРМ
WG1432279 Натяжной ролик, ремень ГРМ
WG1432344 Натяжной ролик, ремень ГРМ
ZEKKERT SR-1296 Натяжной ролик, ремень ГРМ
SR-1491 Натяжной ролик, ремень ГРМ
2026 CATCAR.INFO (v 2.0)