#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTM5MDh8fG1kZl9pZD09MV43OTY3fHxzcGFyZV9pZD09MjAwMDQ0&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 articlecommercialvehicles av JOIN commercialvehiclelinkageattributes_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 = "7967" AND ( (av.SupplierID = 385 AND av.DataSupplierArticleNumber = "08-179300-20" AND av.ProductID IN (444)) OR (av.SupplierID = 385 AND av.DataSupplierArticleNumber = "08-179300-10" AND av.ProductID IN (444)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "99973961" AND av.ProductID IN (4668)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "800019512000" AND av.ProductID IN (444)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "94512960" AND av.ProductID IN (4668)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "90220963" AND av.ProductID IN (4668)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "99973600" AND av.ProductID IN (443)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "90220602" AND av.ProductID IN (443)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "99979960" AND av.ProductID IN (4668)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "800019513000" AND av.ProductID IN (444)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "94512961" AND av.ProductID IN (4668)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "800019510000" AND av.ProductID IN (444)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "91630960" AND av.ProductID IN (4668)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "99979600" AND av.ProductID IN (443)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "91630600" AND av.ProductID IN (443)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "99979961" AND av.ProductID IN (4668)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "99973960" AND av.ProductID IN (4668)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "800019511000" AND av.ProductID IN (444)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "91630961" AND av.ProductID IN (4668)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "90220962" AND av.ProductID IN (4668)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "94512600" AND av.ProductID IN (443)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "003 76 80" AND av.ProductID IN (4668)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "003 76 10" AND av.ProductID IN (443)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "003 76 V0" AND av.ProductID IN (444)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "003 76 93" AND av.ProductID IN (4668)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "003 76 83" AND av.ProductID IN (4668)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "003 76 V1" AND av.ProductID IN (444)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "003 76 94" AND av.ProductID IN (4668)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "003 66 V0" AND av.ProductID IN (444)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "003 76 84" AND av.ProductID IN (4668)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "003 76 00" AND av.ProductID IN (443)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "003 76 N0" AND av.ProductID IN (444)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "003 76 90" AND av.ProductID IN (4668)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "89-179300-86" AND av.ProductID IN (4668)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "87-179300-87" AND av.ProductID IN (443)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "89-179300-80" AND av.ProductID IN (4668)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "87-179300-67" AND av.ProductID IN (443)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "89-179300-18" AND av.ProductID IN (4668)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "89-179300-90" AND av.ProductID IN (4668)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "87-179300-90" AND av.ProductID IN (443)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "89-179300-81" AND av.ProductID IN (4668)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "87-179300-80" AND av.ProductID IN (443)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "89-179300-65" AND av.ProductID IN (4668)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "87-179300-10" AND av.ProductID IN (443)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "89-179300-91" AND av.ProductID IN (4668)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "89-179300-85" AND av.ProductID IN (4668)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "87-179300-85" AND av.ProductID IN (443)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "89-179300-66" AND av.ProductID IN (4668)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "87-179300-65" AND av.ProductID IN (443)) OR (av.SupplierID = 216 AND av.DataSupplierArticleNumber = "88-179300-10" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1200800" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1096562" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1021932" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1175418" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1024388" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1422870" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1422866" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1023823" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1023822" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1022310" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1200803" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1023212" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1200801" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1104125" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1021933" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1175419" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1024389" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1422871" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1422867" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1094106" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1023824" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1023211" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1200804" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1023213" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1187025" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1022311" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1175421" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1024390" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1024387" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1422868" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1175406" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1023825" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1023820" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1023821" AND av.ProductID IN (4668)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1021931" AND av.ProductID IN (443)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1200802" AND av.ProductID IN (444)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1022312" AND av.ProductID IN (4668)) ) 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 = 385 AND aa.DataSupplierArticleNumber = "08-179300-20") OR (aa.SupplierID = 385 AND aa.DataSupplierArticleNumber = "08-179300-10") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "99973961") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "800019512000") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "94512960") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "90220963") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "99973600") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "90220602") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "99979960") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "800019513000") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "94512961") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "800019510000") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "91630960") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "99979600") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "91630600") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "99979961") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "99973960") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "800019511000") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "91630961") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "90220962") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "94512600") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 80") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 10") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 V0") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 93") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 83") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 V1") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 94") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 66 V0") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 84") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 00") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 N0") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 90") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-86") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-179300-87") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-80") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-179300-67") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-18") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-90") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-179300-90") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-81") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-179300-80") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-65") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-179300-10") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-91") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-85") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-179300-85") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-66") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-179300-65") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "88-179300-10") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1200800") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1096562") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1021932") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1175418") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1024388") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1422870") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1422866") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023823") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023822") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1022310") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1200803") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023212") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1200801") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104125") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1021933") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1175419") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1024389") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1422871") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1422867") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1094106") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023824") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023211") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1200804") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023213") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1187025") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1022311") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1175421") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1024390") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1024387") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1422868") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1175406") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023825") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023820") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023821") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1021931") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1200802") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1022312") ) 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 = 385 AND aa.DataSupplierArticleNumber = "08-179300-20") OR (aa.SupplierID = 385 AND aa.DataSupplierArticleNumber = "08-179300-10") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "99973961") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "800019512000") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "94512960") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "90220963") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "99973600") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "90220602") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "99979960") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "800019513000") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "94512961") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "800019510000") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "91630960") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "99979600") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "91630600") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "99979961") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "99973960") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "800019511000") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "91630961") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "90220962") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "94512600") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 80") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 10") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 V0") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 93") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 83") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 V1") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 94") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 66 V0") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 84") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 00") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 N0") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "003 76 90") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-86") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-179300-87") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-80") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-179300-67") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-18") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-90") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-179300-90") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-81") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-179300-80") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-65") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-179300-10") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-91") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-85") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-179300-85") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "89-179300-66") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "87-179300-65") OR (aa.SupplierID = 216 AND aa.DataSupplierArticleNumber = "88-179300-10") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1200800") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1096562") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1021932") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1175418") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1024388") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1422870") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1422866") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023823") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023822") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1022310") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1200803") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023212") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1200801") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104125") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1021933") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1175419") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1024389") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1422871") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1422867") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1094106") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023824") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023211") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1200804") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023213") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1187025") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1022311") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1175421") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1024390") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1024387") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1422868") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1175406") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023825") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023820") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1023821") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1021931") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1200802") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1022312") ) AND aa.Language = "ru" Продажа автозапчастей типа Поршень / комплектующие для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
GOETZE ENGINE 08-179300-20 Комплект поршневых колец
08-179300-10 Комплект поршневых колец
KOLBENSCHMIDT 99973961 Ремонтный комплект, поршень / гильза цилиндра
800019512000 Комплект поршневых колец
94512960 Ремонтный комплект, поршень / гильза цилиндра
90220963 Ремонтный комплект, поршень / гильза цилиндра
99973600 Поршень
90220602 Поршень
99979960 Ремонтный комплект, поршень / гильза цилиндра
800019513000 Комплект поршневых колец
94512961 Ремонтный комплект, поршень / гильза цилиндра
800019510000 Комплект поршневых колец
91630960 Ремонтный комплект, поршень / гильза цилиндра
99979600 Поршень
91630600 Поршень
99979961 Ремонтный комплект, поршень / гильза цилиндра
99973960 Ремонтный комплект, поршень / гильза цилиндра
800019511000 Комплект поршневых колец
91630961 Ремонтный комплект, поршень / гильза цилиндра
90220962 Ремонтный комплект, поршень / гильза цилиндра
94512600 Поршень
MAHLE ORIGINAL 003 76 80 Ремонтный комплект, поршень / гильза цилиндра
003 76 10 Поршень
003 76 V0 Комплект поршневых колец
003 76 93 Ремонтный комплект, поршень / гильза цилиндра
003 76 83 Ремонтный комплект, поршень / гильза цилиндра
003 76 V1 Комплект поршневых колец
003 76 94 Ремонтный комплект, поршень / гильза цилиндра
003 66 V0 Комплект поршневых колец
003 76 84 Ремонтный комплект, поршень / гильза цилиндра
003 76 00 Поршень
003 76 N0 Комплект поршневых колец
003 76 90 Ремонтный комплект, поршень / гильза цилиндра
NÜRAL 89-179300-86 Ремонтный комплект, поршень / гильза цилиндра
87-179300-87 Поршень
89-179300-80 Ремонтный комплект, поршень / гильза цилиндра
87-179300-67 Поршень
89-179300-18 Ремонтный комплект, поршень / гильза цилиндра
89-179300-90 Ремонтный комплект, поршень / гильза цилиндра
87-179300-90 Поршень
89-179300-81 Ремонтный комплект, поршень / гильза цилиндра
87-179300-80 Поршень
89-179300-65 Ремонтный комплект, поршень / гильза цилиндра
87-179300-10 Поршень
89-179300-91 Ремонтный комплект, поршень / гильза цилиндра
89-179300-85 Ремонтный комплект, поршень / гильза цилиндра
87-179300-85 Поршень
89-179300-66 Ремонтный комплект, поршень / гильза цилиндра
87-179300-65 Поршень
88-179300-10 Ремонтный комплект, поршень / гильза цилиндра
WILMINK GROUP WG1200800 Поршень
WG1096562 Комплект поршневых колец
WG1021932 Ремонтный комплект, поршень / гильза цилиндра
WG1175418 Поршень
WG1024388 Комплект поршневых колец
WG1422870 Ремонтный комплект, поршень / гильза цилиндра
WG1422866 Ремонтный комплект, поршень / гильза цилиндра
WG1023823 Поршень
WG1023822 Ремонтный комплект, поршень / гильза цилиндра
WG1022310 Поршень
WG1200803 Комплект поршневых колец
WG1023212 Ремонтный комплект, поршень / гильза цилиндра
WG1200801 Поршень
WG1104125 Комплект поршневых колец
WG1021933 Ремонтный комплект, поршень / гильза цилиндра
WG1175419 Поршень
WG1024389 Комплект поршневых колец
WG1422871 Ремонтный комплект, поршень / гильза цилиндра
WG1422867 Ремонтный комплект, поршень / гильза цилиндра
WG1094106 Поршень
WG1023824 Ремонтный комплект, поршень / гильза цилиндра
WG1023211 Поршень
WG1200804 Комплект поршневых колец
WG1023213 Ремонтный комплект, поршень / гильза цилиндра
WG1187025 Комплект поршневых колец
WG1022311 Ремонтный комплект, поршень / гильза цилиндра
WG1175421 Поршень
WG1024390 Комплект поршневых колец
WG1024387 Комплект поршневых колец
WG1422868 Ремонтный комплект, поршень / гильза цилиндра
WG1175406 Поршень
WG1023825 Ремонтный комплект, поршень / гильза цилиндра
WG1023820 Поршень
WG1023821 Ремонтный комплект, поршень / гильза цилиндра
WG1021931 Поршень
WG1200802 Комплект поршневых колец
WG1022312 Ремонтный комплект, поршень / гильза цилиндра
2026 CATCAR.INFO (v 2.0)