#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2M3x8bW9kZWxfaWQ9PTU2Mzl8fG1kZl9pZD09MF4yMDAyN3x8c3BhcmVfaWQ9PTEwMDU3OQ%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 = "20027" AND ( (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "200404" AND av.ProductID IN (654)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "17338" AND av.ProductID IN (82)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "201120" AND av.ProductID IN (654)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "17893C" AND av.ProductID IN (82)) OR (av.SupplierID = 4533 AND av.DataSupplierArticleNumber = "192551" AND av.ProductID IN (654)) OR (av.SupplierID = 4631 AND av.DataSupplierArticleNumber = "DACM42820036" AND av.ProductID IN (655)) OR (av.SupplierID = 4631 AND av.DataSupplierArticleNumber = "DAC30620048" AND av.ProductID IN (655)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "843045" AND av.ProductID IN (82)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "804081" AND av.ProductID IN (654)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "805053" AND av.ProductID IN (654)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "843007" AND av.ProductID IN (82)) OR (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "RS1237" AND av.ProductID IN (654)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "01.97675D" AND av.ProductID IN (82)) OR (av.SupplierID = 4579 AND av.DataSupplierArticleNumber = "ABK1757" AND av.ProductID IN (654)) OR (av.SupplierID = 4579 AND av.DataSupplierArticleNumber = "ABK532" AND av.ProductID IN (654)) OR (av.SupplierID = 4579 AND av.DataSupplierArticleNumber = "ABK1597" AND av.ProductID IN (654)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "RA3076" AND av.ProductID IN (654)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "RA4048" AND av.ProductID IN (654)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "050074B" AND av.ProductID IN (654)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "050175B" AND av.ProductID IN (654)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "051421B" AND av.ProductID IN (654)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BWK1072" AND av.ProductID IN (654)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BWK1076" AND av.ProductID IN (654)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BWK893" AND av.ProductID IN (654)) OR (av.SupplierID = 4993 AND av.DataSupplierArticleNumber = "AE0008" AND av.ProductID IN (82)) OR (av.SupplierID = 4993 AND av.DataSupplierArticleNumber = "AE0055" AND av.ProductID IN (82)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "DFM0009" AND av.ProductID IN (82)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "KRT2297" AND av.ProductID IN (654)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "KRT2907" AND av.ProductID IN (654)) OR (av.SupplierID = 4578 AND av.DataSupplierArticleNumber = "PWK1597" AND av.ProductID IN (654)) OR (av.SupplierID = 4578 AND av.DataSupplierArticleNumber = "PWK1757" AND av.ProductID IN (654)) OR (av.SupplierID = 4578 AND av.DataSupplierArticleNumber = "PWK0532" AND av.ProductID IN (654)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 70-605-005" AND av.ProductID IN (654)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "H2C025BTA" AND av.ProductID IN (654)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "H1C015BTA" AND av.ProductID IN (654)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "H1C019BTA" AND av.ProductID IN (654)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "RC4048" AND av.ProductID IN (654)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "RC3076" AND av.ProductID IN (654)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CBK017" AND av.ProductID IN (654)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "BK1303" AND av.ProductID IN (654)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "BK1558" AND av.ProductID IN (654)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "W413107" AND av.ProductID IN (654)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "W413270" AND av.ProductID IN (654)) OR (av.SupplierID = 4948 AND av.DataSupplierArticleNumber = "DP2010.10.0009" AND av.ProductID IN (654)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DWB3584" AND av.ProductID IN (654)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DWB6544" AND av.ProductID IN (654)) OR (av.SupplierID = 4770 AND av.DataSupplierArticleNumber = "5401761925" AND av.ProductID IN (654)) OR (av.SupplierID = 4770 AND av.DataSupplierArticleNumber = "5401751913" AND av.ProductID IN (654)) OR (av.SupplierID = 192 AND av.DataSupplierArticleNumber = "713 6404 80" AND av.ProductID IN (654)) OR (av.SupplierID = 192 AND av.DataSupplierArticleNumber = "713 5406 00" AND av.ProductID IN (82)) OR (av.SupplierID = 192 AND av.DataSupplierArticleNumber = "713 6307 60" AND av.ProductID IN (654)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "13536" AND av.ProductID IN (654)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "13549" AND av.ProductID IN (654)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT22093" AND av.ProductID IN (654)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "40014" AND av.ProductID IN (654)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "19574" AND av.ProductID IN (654)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "WKB40114" AND av.ProductID IN (654)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "WKB70112" AND av.ProductID IN (654)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FBK893" AND av.ProductID IN (654)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FBK1072" AND av.ProductID IN (654)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FBK1076" AND av.ProductID IN (654)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "460089" AND av.ProductID IN (654)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FR691772" AND av.ProductID IN (654)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FR690842" AND av.ProductID IN (654)) OR (av.SupplierID = 409 AND av.DataSupplierArticleNumber = "FWB-0146" AND av.ProductID IN (654)) OR (av.SupplierID = 409 AND av.DataSupplierArticleNumber = "FWB-0194" AND av.ProductID IN (654)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "GK6544" AND av.ProductID IN (654)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "9230145K" AND av.ProductID IN (654)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "GK3584" AND av.ProductID IN (654)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "10-1332" AND av.ProductID IN (654)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "10-1114R" AND av.ProductID IN (655)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "10-1332R" AND av.ProductID IN (655)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "10-1114" AND av.ProductID IN (654)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "34-2040" AND av.ProductID IN (82)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "30-3076" AND av.ProductID IN (654)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "30-4048" AND av.ProductID IN (654)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "34-2002" AND av.ProductID IN (82)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "4163202109" AND av.ProductID IN (82)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "5600087" AND av.ProductID IN (654)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "5600092" AND av.ProductID IN (654)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "Q 9825K" AND av.ProductID IN (1655)) OR (av.SupplierID = 4879 AND av.DataSupplierArticleNumber = "KWB893" AND av.ProductID IN (654)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "RK3076" AND av.ProductID IN (654)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "RK4048" AND av.ProductID IN (654)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4105681" AND av.ProductID IN (654)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4106200" AND av.ProductID IN (654)) OR (av.SupplierID = 424 AND av.DataSupplierArticleNumber = "LKBA62072" AND av.ProductID IN (654)) OR (av.SupplierID = 424 AND av.DataSupplierArticleNumber = "LKBA62116" AND av.ProductID IN (654)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "WB-1185" AND av.ProductID IN (654)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "WB-1285" AND av.ProductID IN (654)) OR (av.SupplierID = 4658 AND av.DataSupplierArticleNumber = "OBD313009" AND av.ProductID IN (82)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "26366" AND av.ProductID IN (654)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "26326" AND av.ProductID IN (654)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "26327" AND av.ProductID IN (654)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "26365" AND av.ProductID IN (654)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "6544-SET-MS" AND av.ProductID IN (654)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "3584-SET-MS" AND av.ProductID IN (654)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "74113" AND av.ProductID IN (654)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "74078" AND av.ProductID IN (654)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "WM 2051" AND av.ProductID IN (654)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "WM 6544" AND av.ProductID IN (654)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "PE-WB-11413D1" AND av.ProductID IN (654)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "PE-WB-11370" AND av.ProductID IN (654)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "PE-WB-11413" AND av.ProductID IN (654)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "VBK1004" AND av.ProductID IN (654)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "VBK1331" AND av.ProductID IN (654)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVBW1004" AND av.ProductID IN (654)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVBW1331" AND av.ProductID IN (654)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "763724" AND av.ProductID IN (654)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "751913" AND av.ProductID IN (654)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "761925" AND av.ProductID IN (654)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "602883BS1" AND av.ProductID IN (82)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "BS-6030" AND av.ProductID IN (82)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "601953" AND av.ProductID IN (654)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "602883" AND av.ProductID IN (654)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PBK6544" AND av.ProductID IN (654)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PBK3584" AND av.ProductID IN (654)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2501-3584" AND av.ProductID IN (654)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "BDC5771" AND av.ProductID IN (82)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QWB1367" AND av.ProductID IN (654)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "MWB1265" AND av.ProductID IN (654)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "BDC5241" AND av.ProductID IN (82)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QWB1265" AND av.ProductID IN (654)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKB2270D" AND av.ProductID IN (82)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "5944" AND av.ProductID IN (654)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "6644BD" AND av.ProductID IN (82)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "5950" AND av.ProductID IN (654)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "1401763724" AND av.ProductID IN (654)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "1401751913" AND av.ProductID IN (654)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "1401761925" AND av.ProductID IN (654)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "460089" AND av.ProductID IN (654)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKBA 6544" AND av.ProductID IN (654)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKBD 1012" AND av.ProductID IN (82)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKBA 3584" AND av.ProductID IN (654)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "R159.44" AND av.ProductID IN (654)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "R159.53" AND av.ProductID IN (654)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "KF159.53U" AND av.ProductID IN (82)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "KF159.57U" AND av.ProductID IN (82)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T474078" AND av.ProductID IN (654)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T474113" AND av.ProductID IN (654)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "43-28088-SX" AND av.ProductID IN (654)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "43-28599-SX" AND av.ProductID IN (654)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "62 91 9574" AND av.ProductID IN (654)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "62 94 0014" AND av.ProductID IN (654)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "722 152" AND av.ProductID IN (654)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "723 074" AND av.ProductID IN (654)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8530 10269" AND av.ProductID IN (654)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8530 28108" AND av.ProductID IN (654)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V22-1021" AND av.ProductID IN (654)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V22-1054" AND av.ProductID IN (654)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "186693" AND av.ProductID IN (82)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "197002" AND av.ProductID IN (82)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "RL-1034" AND av.ProductID IN (654)) ) 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 = 206 AND aa.DataSupplierArticleNumber = "200404") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "17338") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "201120") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "17893C") OR (aa.SupplierID = 4533 AND aa.DataSupplierArticleNumber = "192551") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "DACM42820036") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "DAC30620048") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "843045") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "804081") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "805053") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "843007") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "RS1237") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "01.97675D") OR (aa.SupplierID = 4579 AND aa.DataSupplierArticleNumber = "ABK1757") OR (aa.SupplierID = 4579 AND aa.DataSupplierArticleNumber = "ABK532") OR (aa.SupplierID = 4579 AND aa.DataSupplierArticleNumber = "ABK1597") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "RA3076") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "RA4048") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "050074B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "050175B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "051421B") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BWK1072") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BWK1076") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BWK893") OR (aa.SupplierID = 4993 AND aa.DataSupplierArticleNumber = "AE0008") OR (aa.SupplierID = 4993 AND aa.DataSupplierArticleNumber = "AE0055") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "DFM0009") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "KRT2297") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "KRT2907") OR (aa.SupplierID = 4578 AND aa.DataSupplierArticleNumber = "PWK1597") OR (aa.SupplierID = 4578 AND aa.DataSupplierArticleNumber = "PWK1757") OR (aa.SupplierID = 4578 AND aa.DataSupplierArticleNumber = "PWK0532") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 70-605-005") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H2C025BTA") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H1C015BTA") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H1C019BTA") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "RC4048") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "RC3076") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CBK017") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "BK1303") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "BK1558") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "W413107") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "W413270") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP2010.10.0009") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DWB3584") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DWB6544") OR (aa.SupplierID = 4770 AND aa.DataSupplierArticleNumber = "5401761925") OR (aa.SupplierID = 4770 AND aa.DataSupplierArticleNumber = "5401751913") OR (aa.SupplierID = 192 AND aa.DataSupplierArticleNumber = "713 6404 80") OR (aa.SupplierID = 192 AND aa.DataSupplierArticleNumber = "713 5406 00") OR (aa.SupplierID = 192 AND aa.DataSupplierArticleNumber = "713 6307 60") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13536") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13549") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT22093") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "40014") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "19574") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "WKB40114") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "WKB70112") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FBK893") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FBK1072") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FBK1076") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "460089") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FR691772") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FR690842") OR (aa.SupplierID = 409 AND aa.DataSupplierArticleNumber = "FWB-0146") OR (aa.SupplierID = 409 AND aa.DataSupplierArticleNumber = "FWB-0194") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "GK6544") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "9230145K") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "GK3584") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-1332") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-1114R") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-1332R") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-1114") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "34-2040") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "30-3076") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "30-4048") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "34-2002") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "4163202109") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "5600087") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "5600092") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "Q 9825K") OR (aa.SupplierID = 4879 AND aa.DataSupplierArticleNumber = "KWB893") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "RK3076") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "RK4048") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4105681") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4106200") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LKBA62072") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LKBA62116") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "WB-1185") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "WB-1285") OR (aa.SupplierID = 4658 AND aa.DataSupplierArticleNumber = "OBD313009") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "26366") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "26326") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "26327") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "26365") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "6544-SET-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "3584-SET-MS") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "74113") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "74078") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "WM 2051") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "WM 6544") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "PE-WB-11413D1") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "PE-WB-11370") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "PE-WB-11413") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VBK1004") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VBK1331") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVBW1004") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVBW1331") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "763724") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "751913") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "761925") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "602883BS1") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "BS-6030") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "601953") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "602883") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PBK6544") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PBK3584") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2501-3584") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "BDC5771") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QWB1367") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "MWB1265") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "BDC5241") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QWB1265") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKB2270D") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "5944") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "6644BD") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "5950") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "1401763724") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "1401751913") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "1401761925") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "460089") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKBA 6544") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKBD 1012") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKBA 3584") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "R159.44") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "R159.53") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "KF159.53U") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "KF159.57U") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T474078") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T474113") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "43-28088-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "43-28599-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "62 91 9574") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "62 94 0014") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "722 152") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "723 074") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8530 10269") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8530 28108") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V22-1021") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V22-1054") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "186693") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "197002") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "RL-1034") ) 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 = 206 AND aa.DataSupplierArticleNumber = "200404") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "17338") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "201120") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "17893C") OR (aa.SupplierID = 4533 AND aa.DataSupplierArticleNumber = "192551") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "DACM42820036") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "DAC30620048") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "843045") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "804081") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "805053") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "843007") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "RS1237") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "01.97675D") OR (aa.SupplierID = 4579 AND aa.DataSupplierArticleNumber = "ABK1757") OR (aa.SupplierID = 4579 AND aa.DataSupplierArticleNumber = "ABK532") OR (aa.SupplierID = 4579 AND aa.DataSupplierArticleNumber = "ABK1597") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "RA3076") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "RA4048") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "050074B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "050175B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "051421B") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BWK1072") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BWK1076") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BWK893") OR (aa.SupplierID = 4993 AND aa.DataSupplierArticleNumber = "AE0008") OR (aa.SupplierID = 4993 AND aa.DataSupplierArticleNumber = "AE0055") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "DFM0009") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "KRT2297") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "KRT2907") OR (aa.SupplierID = 4578 AND aa.DataSupplierArticleNumber = "PWK1597") OR (aa.SupplierID = 4578 AND aa.DataSupplierArticleNumber = "PWK1757") OR (aa.SupplierID = 4578 AND aa.DataSupplierArticleNumber = "PWK0532") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 70-605-005") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H2C025BTA") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H1C015BTA") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H1C019BTA") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "RC4048") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "RC3076") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CBK017") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "BK1303") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "BK1558") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "W413107") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "W413270") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP2010.10.0009") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DWB3584") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DWB6544") OR (aa.SupplierID = 4770 AND aa.DataSupplierArticleNumber = "5401761925") OR (aa.SupplierID = 4770 AND aa.DataSupplierArticleNumber = "5401751913") OR (aa.SupplierID = 192 AND aa.DataSupplierArticleNumber = "713 6404 80") OR (aa.SupplierID = 192 AND aa.DataSupplierArticleNumber = "713 5406 00") OR (aa.SupplierID = 192 AND aa.DataSupplierArticleNumber = "713 6307 60") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13536") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13549") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT22093") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "40014") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "19574") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "WKB40114") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "WKB70112") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FBK893") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FBK1072") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FBK1076") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "460089") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FR691772") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FR690842") OR (aa.SupplierID = 409 AND aa.DataSupplierArticleNumber = "FWB-0146") OR (aa.SupplierID = 409 AND aa.DataSupplierArticleNumber = "FWB-0194") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "GK6544") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "9230145K") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "GK3584") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-1332") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-1114R") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-1332R") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-1114") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "34-2040") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "30-3076") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "30-4048") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "34-2002") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "4163202109") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "5600087") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "5600092") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "Q 9825K") OR (aa.SupplierID = 4879 AND aa.DataSupplierArticleNumber = "KWB893") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "RK3076") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "RK4048") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4105681") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4106200") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LKBA62072") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LKBA62116") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "WB-1185") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "WB-1285") OR (aa.SupplierID = 4658 AND aa.DataSupplierArticleNumber = "OBD313009") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "26366") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "26326") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "26327") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "26365") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "6544-SET-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "3584-SET-MS") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "74113") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "74078") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "WM 2051") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "WM 6544") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "PE-WB-11413D1") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "PE-WB-11370") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "PE-WB-11413") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VBK1004") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VBK1331") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVBW1004") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVBW1331") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "763724") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "751913") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "761925") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "602883BS1") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "BS-6030") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "601953") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "602883") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PBK6544") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PBK3584") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2501-3584") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "BDC5771") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QWB1367") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "MWB1265") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "BDC5241") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QWB1265") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKB2270D") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "5944") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "6644BD") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "5950") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "1401763724") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "1401751913") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "1401761925") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "460089") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKBA 6544") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKBD 1012") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKBA 3584") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "R159.44") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "R159.53") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "KF159.53U") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "KF159.57U") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T474078") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T474113") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "43-28088-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "43-28599-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "62 91 9574") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "62 94 0014") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "722 152") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "723 074") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8530 10269") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8530 28108") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V22-1021") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V22-1054") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "186693") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "197002") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "RL-1034") ) AND aa.Language = "ru" Продажа автозапчастей типа Подшипник ступицы колеса для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
A.B.S. 200404 Комплект подшипника ступицы колеса
17338 Тормозной диск
201120 Комплект подшипника ступицы колеса
17893C Тормозной диск
ACEMARK 192551 Комплект подшипника ступицы колеса
ASVA DACM42820036 Подшипник ступицы колеса
DAC30620048 Подшипник ступицы колеса
AUTEX 843045 Тормозной диск
804081 Комплект подшипника ступицы колеса
805053 Комплект подшипника ступицы колеса
843007 Тормозной диск
AUTLOG RS1237 Комплект подшипника ступицы колеса
AUTOKIT 01.97675D Тормозной диск
Automotive Bearings ABK1757 Комплект подшипника ступицы колеса
ABK532 Комплект подшипника ступицы колеса
ABK1597 Комплект подшипника ступицы колеса
AUTOTEAM RA3076 Комплект подшипника ступицы колеса
RA4048 Комплект подшипника ступицы колеса
BENDIX 050074B Комплект подшипника ступицы колеса
050175B Комплект подшипника ступицы колеса
051421B Комплект подшипника ступицы колеса
BORG & BECK BWK1072 Комплект подшипника ступицы колеса
BWK1076 Комплект подшипника ступицы колеса
BWK893 Комплект подшипника ступицы колеса
BRAXIS AE0008 Тормозной диск
AE0055 Тормозной диск
BREDA LORETT DFM0009 Тормозной диск
KRT2297 Комплект подшипника ступицы колеса
KRT2907 Комплект подшипника ступицы колеса
BRT Bearings PWK1597 Комплект подшипника ступицы колеса
PWK1757 Комплект подшипника ступицы колеса
PWK0532 Комплект подшипника ступицы колеса
BSG BSG 70-605-005 Комплект подшипника ступицы колеса
BTA H2C025BTA Комплект подшипника ступицы колеса
H1C015BTA Комплект подшипника ступицы колеса
H1C019BTA Комплект подшипника ступицы колеса
CALIBER RC4048 Комплект подшипника ступицы колеса
RC3076 Комплект подшипника ступицы колеса
COMLINE CBK017 Комплект подшипника ступицы колеса
DELPHI BK1303 Комплект подшипника ступицы колеса
BK1558 Комплект подшипника ступицы колеса
DENCKERMANN W413107 Комплект подшипника ступицы колеса
W413270 Комплект подшипника ступицы колеса
Dr!ve+ DP2010.10.0009 Комплект подшипника ступицы колеса
DYNAMATRIX DWB3584 Комплект подшипника ступицы колеса
DWB6544 Комплект подшипника ступицы колеса
EUROBRAKE 5401761925 Комплект подшипника ступицы колеса
5401751913 Комплект подшипника ступицы колеса
FAG 713 6404 80 Комплект подшипника ступицы колеса
713 5406 00 Тормозной диск
713 6307 60 Комплект подшипника ступицы колеса
FARE SA 13536 Комплект подшипника ступицы колеса
13549 Комплект подшипника ступицы колеса
FAST FT22093 Комплект подшипника ступицы колеса
FEBI BILSTEIN 40014 Комплект подшипника ступицы колеса
19574 Комплект подшипника ступицы колеса
FENOX WKB40114 Комплект подшипника ступицы колеса
WKB70112 Комплект подшипника ступицы колеса
FIRST LINE FBK893 Комплект подшипника ступицы колеса
FBK1072 Комплект подшипника ступицы колеса
FBK1076 Комплект подшипника ступицы колеса
FISPA 460089 Комплект подшипника ступицы колеса
FLENNOR FR691772 Комплект подшипника ступицы колеса
FR690842 Комплект подшипника ступицы колеса
FREMAX FWB-0146 Комплект подшипника ступицы колеса
FWB-0194 Комплект подшипника ступицы колеса
GSP GK6544 Комплект подшипника ступицы колеса
9230145K Комплект подшипника ступицы колеса
GK3584 Комплект подшипника ступицы колеса
IJS GROUP 10-1332 Комплект подшипника ступицы колеса
10-1114R Подшипник ступицы колеса
10-1332R Подшипник ступицы колеса
10-1114 Комплект подшипника ступицы колеса
IPD 34-2040 Тормозной диск
30-3076 Комплект подшипника ступицы колеса
30-4048 Комплект подшипника ступицы колеса
34-2002 Тормозной диск
JP GROUP 4163202109 Тормозной диск
KAMOKA 5600087 Комплект подшипника ступицы колеса
5600092 Комплект подшипника ступицы колеса
KAWE Q 9825K Крышка, подшипник ступицы колеса
KEY PARTS KWB893 Комплект подшипника ступицы колеса
KM International RK3076 Комплект подшипника ступицы колеса
RK4048 Комплект подшипника ступицы колеса
KRAFT AUTOMOTIVE 4105681 Комплект подшипника ступицы колеса
4106200 Комплект подшипника ступицы колеса
LUCAS ENGINE DRIVE LKBA62072 Комплект подшипника ступицы колеса
LKBA62116 Комплект подшипника ступицы колеса
LYNXauto WB-1185 Комплект подшипника ступицы колеса
WB-1285 Комплект подшипника ступицы колеса
MABYPARTS OBD313009 Тормозной диск
MAPCO 26366 Комплект подшипника ступицы колеса
26326 Комплект подшипника ступицы колеса
26327 Комплект подшипника ступицы колеса
26365 Комплект подшипника ступицы колеса
MASTER-SPORT 6544-SET-MS Комплект подшипника ступицы колеса
3584-SET-MS Комплект подшипника ступицы колеса
Metalcaucho 74113 Комплект подшипника ступицы колеса
74078 Комплект подшипника ступицы колеса
METZGER WM 2051 Комплект подшипника ступицы колеса
WM 6544 Комплект подшипника ступицы колеса
MOOG PE-WB-11413D1 Комплект подшипника ступицы колеса
PE-WB-11370 Комплект подшипника ступицы колеса
PE-WB-11413 Комплект подшипника ступицы колеса
MOTAQUIP VBK1004 Комплект подшипника ступицы колеса
VBK1331 Комплект подшипника ступицы колеса
LVBW1004 Комплект подшипника ступицы колеса
LVBW1331 Комплект подшипника ступицы колеса
NK 763724 Комплект подшипника ступицы колеса
751913 Комплект подшипника ступицы колеса
761925 Комплект подшипника ступицы колеса
OPTIMAL 602883BS1 Тормозной диск
BS-6030 Тормозной диск
601953 Комплект подшипника ступицы колеса
602883 Комплект подшипника ступицы колеса
PATRON PBK6544 Комплект подшипника ступицы колеса
PBK3584 Комплект подшипника ступицы колеса
PROFIT 2501-3584 Комплект подшипника ступицы колеса
QUINTON HAZELL BDC5771 Тормозной диск
QWB1367 Комплект подшипника ступицы колеса
MWB1265 Комплект подшипника ступицы колеса
BDC5241 Тормозной диск
QWB1265 Комплект подшипника ступицы колеса
REPKIT RKB2270D Тормозной диск
RUVILLE 5944 Комплект подшипника ступицы колеса
6644BD Тормозной диск
5950 Комплект подшипника ступицы колеса
sbs 1401763724 Комплект подшипника ступицы колеса
1401751913 Комплект подшипника ступицы колеса
1401761925 Комплект подшипника ступицы колеса
SIDAT 460089 Комплект подшипника ступицы колеса
SKF VKBA 6544 Комплект подшипника ступицы колеса
VKBD 1012 Тормозной диск
VKBA 3584 Комплект подшипника ступицы колеса
SNR R159.44 Комплект подшипника ступицы колеса
R159.53 Комплект подшипника ступицы колеса
KF159.53U Тормозной диск
KF159.57U Тормозной диск
STC T474078 Комплект подшипника ступицы колеса
T474113 Комплект подшипника ступицы колеса
STELLOX 43-28088-SX Комплект подшипника ступицы колеса
43-28599-SX Комплект подшипника ступицы колеса
SWAG 62 91 9574 Комплект подшипника ступицы колеса
62 94 0014 Комплект подшипника ступицы колеса
TOPRAN 722 152 Комплект подшипника ступицы колеса
723 074 Комплект подшипника ступицы колеса
TRISCAN 8530 10269 Комплект подшипника ступицы колеса
8530 28108 Комплект подшипника ступицы колеса
VAICO V22-1021 Комплект подшипника ступицы колеса
V22-1054 Комплект подшипника ступицы колеса
VALEO 186693 Тормозной диск
197002 Тормозной диск
ZEKKERT RL-1034 Комплект подшипника ступицы колеса
2026 CATCAR.INFO (v 2.0)