#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1OHx8bW9kZWxfaWQ9PTQ5NzF8fG1kZl9pZD09MF4yMDA4MHx8c3BhcmVfaWQ9PTEwMDU3OQ%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 = "20080" AND ( (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "200004" AND av.ProductID IN (654)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "200425" AND av.ProductID IN (654)) OR (av.SupplierID = 4533 AND av.DataSupplierArticleNumber = "192601" AND av.ProductID IN (654)) OR (av.SupplierID = 4533 AND av.DataSupplierArticleNumber = "192597" AND av.ProductID IN (654)) OR (av.SupplierID = 257 AND av.DataSupplierArticleNumber = "44-11042" AND av.ProductID IN (654)) OR (av.SupplierID = 257 AND av.DataSupplierArticleNumber = "44-21071" AND av.ProductID IN (654)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "1410-7301" AND av.ProductID IN (654)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "1413-5501" AND av.ProductID IN (654)) OR (av.SupplierID = 4631 AND av.DataSupplierArticleNumber = "DACM37720037" AND av.ProductID IN (655)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "804035" AND av.ProductID IN (654)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "804089" AND av.ProductID IN (654)) OR (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "RS1042" AND av.ProductID IN (654)) OR (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "RS1285" AND av.ProductID IN (654)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "01.97502" AND av.ProductID IN (654)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "01.125" AND av.ProductID IN (654)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "01.97188" AND av.ProductID IN (654)) OR (av.SupplierID = 4579 AND av.DataSupplierArticleNumber = "ABK1122" AND av.ProductID IN (654)) OR (av.SupplierID = 4579 AND av.DataSupplierArticleNumber = "ABK858" AND av.ProductID IN (654)) OR (av.SupplierID = 4579 AND av.DataSupplierArticleNumber = "ABK894" AND av.ProductID IN (654)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "RA3030" AND av.ProductID IN (654)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "RA3084" AND av.ProductID IN (654)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "050030B" AND av.ProductID IN (654)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "051192B" AND av.ProductID IN (654)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "050006B" AND av.ProductID IN (654)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADN18346" AND av.ProductID IN (654)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADN18249" AND av.ProductID IN (654)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BWK795" AND av.ProductID IN (654)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BWK913" AND av.ProductID IN (654)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "KRT2347" AND av.ProductID IN (654)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "KRT2665" AND av.ProductID IN (654)) OR (av.SupplierID = 4578 AND av.DataSupplierArticleNumber = "PWK0662" AND av.ProductID IN (654)) OR (av.SupplierID = 4578 AND av.DataSupplierArticleNumber = "BRT1122" AND av.ProductID IN (654)) OR (av.SupplierID = 4578 AND av.DataSupplierArticleNumber = "PWK0332" AND av.ProductID IN (654)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "H2R002BTA" AND av.ProductID IN (654)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "H1R023BTA" AND av.ProductID IN (654)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "H21071BTA" AND av.ProductID IN (654)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "RC3084" AND av.ProductID IN (654)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "RC3030" AND av.ProductID IN (654)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CBK002" AND av.ProductID IN (654)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CBK072" AND av.ProductID IN (654)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "BK1424" AND av.ProductID IN (654)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "BK365" AND av.ProductID IN (654)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "BK1186" AND av.ProductID IN (654)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "W413272" AND av.ProductID IN (654)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "W413092" AND av.ProductID IN (654)) OR (av.SupplierID = 4948 AND av.DataSupplierArticleNumber = "DP2010.10.0049" AND av.ProductID IN (654)) OR (av.SupplierID = 4948 AND av.DataSupplierArticleNumber = "DP2010.10.0001" AND av.ProductID IN (654)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DWB3525" AND av.ProductID IN (654)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DWB3637" AND av.ProductID IN (654)) OR (av.SupplierID = 4770 AND av.DataSupplierArticleNumber = "5401763938" AND av.ProductID IN (654)) OR (av.SupplierID = 192 AND av.DataSupplierArticleNumber = "713 6303 00" AND av.ProductID IN (654)) OR (av.SupplierID = 192 AND av.DataSupplierArticleNumber = "713 6308 40" AND av.ProductID IN (654)) OR (av.SupplierID = 192 AND av.DataSupplierArticleNumber = "713 8015 10" AND av.ProductID IN (654)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "13555" AND av.ProductID IN (654)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "13562" AND av.ProductID IN (654)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT22110" AND av.ProductID IN (654)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT22112" AND av.ProductID IN (654)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "DAC25520037-KIT" AND av.ProductID IN (654)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "DAC37720037M-KIT" AND av.ProductID IN (654)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "05538" AND av.ProductID IN (654)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "24315" AND av.ProductID IN (654)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "WKB60171" AND av.ProductID IN (654)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "WKB70122" AND av.ProductID IN (654)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FBK913" AND av.ProductID IN (654)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FBK795" AND av.ProductID IN (654)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "460077" AND av.ProductID IN (654)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "460234" AND av.ProductID IN (654)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FR791201L" AND av.ProductID IN (654)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FR790866" AND av.ProductID IN (654)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FR791201" AND av.ProductID IN (654)) OR (av.SupplierID = 409 AND av.DataSupplierArticleNumber = "BD-6328" AND av.ProductID IN (82)) OR (av.SupplierID = 409 AND av.DataSupplierArticleNumber = "BD-7829" AND av.ProductID IN (82)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "GK3525" AND av.ProductID IN (654)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "GK3637" AND av.ProductID IN (654)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "9499032K" AND av.ProductID IN (654)) OR (av.SupplierID = 55 AND av.DataSupplierArticleNumber = "J4701037" AND av.ProductID IN (654)) OR (av.SupplierID = 55 AND av.DataSupplierArticleNumber = "J4711061" AND av.ProductID IN (654)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "10-1298" AND av.ProductID IN (654)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "10-1298R" AND av.ProductID IN (655)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "10-1141" AND av.ProductID IN (654)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "30-3030" AND av.ProductID IN (654)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "30-3084" AND av.ProductID IN (654)) OR (av.SupplierID = 459 AND av.DataSupplierArticleNumber = "IUB-10139" AND av.ProductID IN (654)) OR (av.SupplierID = 459 AND av.DataSupplierArticleNumber = "IUB-10149" AND av.ProductID IN (654)) OR (av.SupplierID = 156 AND av.DataSupplierArticleNumber = "KK-11042" AND av.ProductID IN (654)) OR (av.SupplierID = 156 AND av.DataSupplierArticleNumber = "KK-21071" AND av.ProductID IN (654)) OR (av.SupplierID = 481 AND av.DataSupplierArticleNumber = "421071" AND av.ProductID IN (654)) OR (av.SupplierID = 481 AND av.DataSupplierArticleNumber = "411042" AND av.ProductID IN (654)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "4351301519" AND av.ProductID IN (654)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "5600011" AND av.ProductID IN (654)) OR (av.SupplierID = 201 AND av.DataSupplierArticleNumber = "WBK-6509" AND av.ProductID IN (654)) OR (av.SupplierID = 201 AND av.DataSupplierArticleNumber = "WBK-6505" AND av.ProductID IN (654)) OR (av.SupplierID = 4879 AND av.DataSupplierArticleNumber = "KWB795" AND av.ProductID IN (654)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "RK3030" AND av.ProductID IN (654)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "RK3084" AND av.ProductID IN (654)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4105010" AND av.ProductID IN (654)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4105185" AND av.ProductID IN (654)) OR (av.SupplierID = 424 AND av.DataSupplierArticleNumber = "LKBA69012" AND av.ProductID IN (654)) OR (av.SupplierID = 424 AND av.DataSupplierArticleNumber = "LKBA69063" AND av.ProductID IN (654)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "WB-1202" AND av.ProductID IN (654)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "WB-1173" AND av.ProductID IN (654)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "26126" AND av.ProductID IN (654)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "26102" AND av.ProductID IN (654)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "3525-SET-MS" AND av.ProductID IN (654)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "3637-SET-MS" AND av.ProductID IN (654)) OR (av.SupplierID = 4773 AND av.DataSupplierArticleNumber = "MWB-F1042" AND av.ProductID IN (654)) OR (av.SupplierID = 4773 AND av.DataSupplierArticleNumber = "MWB-R1071" AND av.ProductID IN (654)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "74128" AND av.ProductID IN (654)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "74001" AND av.ProductID IN (654)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "74097" AND av.ProductID IN (654)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "WM 2044" AND av.ProductID IN (654)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "16-14 650 0001" AND av.ProductID IN (654)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "RE-WB-11475" AND av.ProductID IN (654)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "RE-WB-11479" AND av.ProductID IN (654)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "VBK15" AND av.ProductID IN (654)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVBW1226" AND av.ProductID IN (654)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVBW15" AND av.ProductID IN (654)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "VBK1226" AND av.ProductID IN (654)) OR (av.SupplierID = 248 AND av.DataSupplierArticleNumber = "N4701045" AND av.ProductID IN (654)) OR (av.SupplierID = 248 AND av.DataSupplierArticleNumber = "N4711064" AND av.ProductID IN (654)) OR (av.SupplierID = 248 AND av.DataSupplierArticleNumber = "J4701037" AND av.ProductID IN (654)) OR (av.SupplierID = 248 AND av.DataSupplierArticleNumber = "J4711055" AND av.ProductID IN (654)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "753926" AND av.ProductID IN (654)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "763938" AND av.ProductID IN (654)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "N471N50" AND av.ProductID IN (654)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "N470N48" AND av.ProductID IN (654)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "702312" AND av.ProductID IN (654)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "702312L" AND av.ProductID IN (654)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "702312S" AND av.ProductID IN (654)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "701977" AND av.ProductID IN (654)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PBK3525" AND av.ProductID IN (654)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PBK3637" AND av.ProductID IN (654)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PBK869" AND av.ProductID IN (654)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2501-3525" AND av.ProductID IN (654)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2501-0869" AND av.ProductID IN (654)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKB1026" AND av.ProductID IN (654)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKB1783" AND av.ProductID IN (654)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKB2097" AND av.ProductID IN (654)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "5563" AND av.ProductID IN (654)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "5563D" AND av.ProductID IN (654)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "5575" AND av.ProductID IN (654)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "1401763938" AND av.ProductID IN (654)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "1401753926" AND av.ProductID IN (654)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "SCP 3525" AND av.ProductID IN (654)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "460077" AND av.ProductID IN (654)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "460234" AND av.ProductID IN (654)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKBA 3637" AND av.ProductID IN (654)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKBA 3525" AND av.ProductID IN (654)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "R155.63" AND av.ProductID IN (654)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "R155.75" AND av.ProductID IN (654)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T474128" AND av.ProductID IN (654)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T474001" AND av.ProductID IN (654)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T474097" AND av.ProductID IN (654)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "43-28020-SX" AND av.ProductID IN (654)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "40-30121-SX" AND av.ProductID IN (655)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "43-28217-SX" AND av.ProductID IN (654)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "60 90 5538" AND av.ProductID IN (654)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "60 92 4315" AND av.ProductID IN (654)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "700 179" AND av.ProductID IN (654)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "700 638" AND av.ProductID IN (654)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8530 25239" AND av.ProductID IN (654)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8530 10145" AND av.ProductID IN (654)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V46-0049" AND av.ProductID IN (654)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V38-0092" AND av.ProductID IN (654)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "RL-1135" AND av.ProductID IN (654)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "RL-1258" 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 = "200004") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "200425") OR (aa.SupplierID = 4533 AND aa.DataSupplierArticleNumber = "192601") OR (aa.SupplierID = 4533 AND aa.DataSupplierArticleNumber = "192597") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "44-11042") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "44-21071") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "1410-7301") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "1413-5501") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "DACM37720037") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "804035") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "804089") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "RS1042") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "RS1285") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "01.97502") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "01.125") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "01.97188") OR (aa.SupplierID = 4579 AND aa.DataSupplierArticleNumber = "ABK1122") OR (aa.SupplierID = 4579 AND aa.DataSupplierArticleNumber = "ABK858") OR (aa.SupplierID = 4579 AND aa.DataSupplierArticleNumber = "ABK894") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "RA3030") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "RA3084") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "050030B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "051192B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "050006B") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADN18346") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADN18249") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BWK795") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BWK913") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "KRT2347") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "KRT2665") OR (aa.SupplierID = 4578 AND aa.DataSupplierArticleNumber = "PWK0662") OR (aa.SupplierID = 4578 AND aa.DataSupplierArticleNumber = "BRT1122") OR (aa.SupplierID = 4578 AND aa.DataSupplierArticleNumber = "PWK0332") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H2R002BTA") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H1R023BTA") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H21071BTA") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "RC3084") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "RC3030") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CBK002") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CBK072") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "BK1424") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "BK365") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "BK1186") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "W413272") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "W413092") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP2010.10.0049") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP2010.10.0001") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DWB3525") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DWB3637") OR (aa.SupplierID = 4770 AND aa.DataSupplierArticleNumber = "5401763938") OR (aa.SupplierID = 192 AND aa.DataSupplierArticleNumber = "713 6303 00") OR (aa.SupplierID = 192 AND aa.DataSupplierArticleNumber = "713 6308 40") OR (aa.SupplierID = 192 AND aa.DataSupplierArticleNumber = "713 8015 10") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13555") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13562") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT22110") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT22112") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "DAC25520037-KIT") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "DAC37720037M-KIT") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "05538") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "24315") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "WKB60171") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "WKB70122") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FBK913") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FBK795") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "460077") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "460234") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FR791201L") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FR790866") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FR791201") OR (aa.SupplierID = 409 AND aa.DataSupplierArticleNumber = "BD-6328") OR (aa.SupplierID = 409 AND aa.DataSupplierArticleNumber = "BD-7829") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "GK3525") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "GK3637") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "9499032K") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J4701037") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J4711061") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-1298") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-1298R") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-1141") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "30-3030") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "30-3084") OR (aa.SupplierID = 459 AND aa.DataSupplierArticleNumber = "IUB-10139") OR (aa.SupplierID = 459 AND aa.DataSupplierArticleNumber = "IUB-10149") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "KK-11042") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "KK-21071") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "421071") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "411042") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "4351301519") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "5600011") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "WBK-6509") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "WBK-6505") OR (aa.SupplierID = 4879 AND aa.DataSupplierArticleNumber = "KWB795") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "RK3030") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "RK3084") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4105010") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4105185") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LKBA69012") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LKBA69063") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "WB-1202") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "WB-1173") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "26126") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "26102") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "3525-SET-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "3637-SET-MS") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MWB-F1042") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MWB-R1071") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "74128") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "74001") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "74097") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "WM 2044") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "16-14 650 0001") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "RE-WB-11475") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "RE-WB-11479") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VBK15") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVBW1226") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVBW15") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VBK1226") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "N4701045") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "N4711064") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "J4701037") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "J4711055") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "753926") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "763938") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "N471N50") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "N470N48") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "702312") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "702312L") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "702312S") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "701977") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PBK3525") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PBK3637") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PBK869") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2501-3525") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2501-0869") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKB1026") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKB1783") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKB2097") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "5563") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "5563D") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "5575") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "1401763938") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "1401753926") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SCP 3525") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "460077") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "460234") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKBA 3637") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKBA 3525") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "R155.63") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "R155.75") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T474128") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T474001") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T474097") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "43-28020-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "40-30121-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "43-28217-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "60 90 5538") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "60 92 4315") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "700 179") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "700 638") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8530 25239") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8530 10145") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V46-0049") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V38-0092") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "RL-1135") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "RL-1258") ) 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 = "200004") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "200425") OR (aa.SupplierID = 4533 AND aa.DataSupplierArticleNumber = "192601") OR (aa.SupplierID = 4533 AND aa.DataSupplierArticleNumber = "192597") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "44-11042") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "44-21071") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "1410-7301") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "1413-5501") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "DACM37720037") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "804035") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "804089") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "RS1042") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "RS1285") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "01.97502") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "01.125") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "01.97188") OR (aa.SupplierID = 4579 AND aa.DataSupplierArticleNumber = "ABK1122") OR (aa.SupplierID = 4579 AND aa.DataSupplierArticleNumber = "ABK858") OR (aa.SupplierID = 4579 AND aa.DataSupplierArticleNumber = "ABK894") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "RA3030") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "RA3084") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "050030B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "051192B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "050006B") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADN18346") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADN18249") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BWK795") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BWK913") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "KRT2347") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "KRT2665") OR (aa.SupplierID = 4578 AND aa.DataSupplierArticleNumber = "PWK0662") OR (aa.SupplierID = 4578 AND aa.DataSupplierArticleNumber = "BRT1122") OR (aa.SupplierID = 4578 AND aa.DataSupplierArticleNumber = "PWK0332") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H2R002BTA") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H1R023BTA") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "H21071BTA") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "RC3084") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "RC3030") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CBK002") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CBK072") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "BK1424") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "BK365") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "BK1186") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "W413272") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "W413092") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP2010.10.0049") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP2010.10.0001") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DWB3525") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DWB3637") OR (aa.SupplierID = 4770 AND aa.DataSupplierArticleNumber = "5401763938") OR (aa.SupplierID = 192 AND aa.DataSupplierArticleNumber = "713 6303 00") OR (aa.SupplierID = 192 AND aa.DataSupplierArticleNumber = "713 6308 40") OR (aa.SupplierID = 192 AND aa.DataSupplierArticleNumber = "713 8015 10") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13555") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13562") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT22110") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT22112") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "DAC25520037-KIT") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "DAC37720037M-KIT") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "05538") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "24315") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "WKB60171") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "WKB70122") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FBK913") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FBK795") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "460077") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "460234") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FR791201L") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FR790866") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FR791201") OR (aa.SupplierID = 409 AND aa.DataSupplierArticleNumber = "BD-6328") OR (aa.SupplierID = 409 AND aa.DataSupplierArticleNumber = "BD-7829") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "GK3525") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "GK3637") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "9499032K") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J4701037") OR (aa.SupplierID = 55 AND aa.DataSupplierArticleNumber = "J4711061") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-1298") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-1298R") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "10-1141") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "30-3030") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "30-3084") OR (aa.SupplierID = 459 AND aa.DataSupplierArticleNumber = "IUB-10139") OR (aa.SupplierID = 459 AND aa.DataSupplierArticleNumber = "IUB-10149") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "KK-11042") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "KK-21071") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "421071") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "411042") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "4351301519") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "5600011") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "WBK-6509") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "WBK-6505") OR (aa.SupplierID = 4879 AND aa.DataSupplierArticleNumber = "KWB795") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "RK3030") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "RK3084") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4105010") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4105185") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LKBA69012") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LKBA69063") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "WB-1202") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "WB-1173") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "26126") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "26102") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "3525-SET-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "3637-SET-MS") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MWB-F1042") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MWB-R1071") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "74128") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "74001") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "74097") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "WM 2044") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "16-14 650 0001") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "RE-WB-11475") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "RE-WB-11479") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VBK15") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVBW1226") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVBW15") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VBK1226") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "N4701045") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "N4711064") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "J4701037") OR (aa.SupplierID = 248 AND aa.DataSupplierArticleNumber = "J4711055") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "753926") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "763938") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "N471N50") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "N470N48") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "702312") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "702312L") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "702312S") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "701977") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PBK3525") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PBK3637") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PBK869") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2501-3525") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2501-0869") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKB1026") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKB1783") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKB2097") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "5563") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "5563D") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "5575") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "1401763938") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "1401753926") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SCP 3525") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "460077") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "460234") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKBA 3637") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKBA 3525") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "R155.63") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "R155.75") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T474128") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T474001") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T474097") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "43-28020-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "40-30121-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "43-28217-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "60 90 5538") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "60 92 4315") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "700 179") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "700 638") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8530 25239") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8530 10145") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V46-0049") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V38-0092") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "RL-1135") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "RL-1258") ) AND aa.Language = "ru" Продажа автозапчастей типа Подшипник ступицы колеса для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
A.B.S. 200004 Комплект подшипника ступицы колеса
200425 Комплект подшипника ступицы колеса
ACEMARK 192601 Комплект подшипника ступицы колеса
192597 Комплект подшипника ступицы колеса
ASHIKA 44-11042 Комплект подшипника ступицы колеса
44-21071 Комплект подшипника ступицы колеса
ASHUKI 1410-7301 Комплект подшипника ступицы колеса
1413-5501 Комплект подшипника ступицы колеса
ASVA DACM37720037 Подшипник ступицы колеса
AUTEX 804035 Комплект подшипника ступицы колеса
804089 Комплект подшипника ступицы колеса
AUTLOG RS1042 Комплект подшипника ступицы колеса
RS1285 Комплект подшипника ступицы колеса
AUTOKIT 01.97502 Комплект подшипника ступицы колеса
01.125 Комплект подшипника ступицы колеса
01.97188 Комплект подшипника ступицы колеса
Automotive Bearings ABK1122 Комплект подшипника ступицы колеса
ABK858 Комплект подшипника ступицы колеса
ABK894 Комплект подшипника ступицы колеса
AUTOTEAM RA3030 Комплект подшипника ступицы колеса
RA3084 Комплект подшипника ступицы колеса
BENDIX 050030B Комплект подшипника ступицы колеса
051192B Комплект подшипника ступицы колеса
050006B Комплект подшипника ступицы колеса
BLUE PRINT ADN18346 Комплект подшипника ступицы колеса
ADN18249 Комплект подшипника ступицы колеса
BORG & BECK BWK795 Комплект подшипника ступицы колеса
BWK913 Комплект подшипника ступицы колеса
BREDA LORETT KRT2347 Комплект подшипника ступицы колеса
KRT2665 Комплект подшипника ступицы колеса
BRT Bearings PWK0662 Комплект подшипника ступицы колеса
BRT1122 Комплект подшипника ступицы колеса
PWK0332 Комплект подшипника ступицы колеса
BTA H2R002BTA Комплект подшипника ступицы колеса
H1R023BTA Комплект подшипника ступицы колеса
H21071BTA Комплект подшипника ступицы колеса
CALIBER RC3084 Комплект подшипника ступицы колеса
RC3030 Комплект подшипника ступицы колеса
COMLINE CBK002 Комплект подшипника ступицы колеса
CBK072 Комплект подшипника ступицы колеса
DELPHI BK1424 Комплект подшипника ступицы колеса
BK365 Комплект подшипника ступицы колеса
BK1186 Комплект подшипника ступицы колеса
DENCKERMANN W413272 Комплект подшипника ступицы колеса
W413092 Комплект подшипника ступицы колеса
Dr!ve+ DP2010.10.0049 Комплект подшипника ступицы колеса
DP2010.10.0001 Комплект подшипника ступицы колеса
DYNAMATRIX DWB3525 Комплект подшипника ступицы колеса
DWB3637 Комплект подшипника ступицы колеса
EUROBRAKE 5401763938 Комплект подшипника ступицы колеса
FAG 713 6303 00 Комплект подшипника ступицы колеса
713 6308 40 Комплект подшипника ступицы колеса
713 8015 10 Комплект подшипника ступицы колеса
FARE SA 13555 Комплект подшипника ступицы колеса
13562 Комплект подшипника ступицы колеса
FAST FT22110 Комплект подшипника ступицы колеса
FT22112 Комплект подшипника ступицы колеса
FEBEST DAC25520037-KIT Комплект подшипника ступицы колеса
DAC37720037M-KIT Комплект подшипника ступицы колеса
FEBI BILSTEIN 05538 Комплект подшипника ступицы колеса
24315 Комплект подшипника ступицы колеса
FENOX WKB60171 Комплект подшипника ступицы колеса
WKB70122 Комплект подшипника ступицы колеса
FIRST LINE FBK913 Комплект подшипника ступицы колеса
FBK795 Комплект подшипника ступицы колеса
FISPA 460077 Комплект подшипника ступицы колеса
460234 Комплект подшипника ступицы колеса
FLENNOR FR791201L Комплект подшипника ступицы колеса
FR790866 Комплект подшипника ступицы колеса
FR791201 Комплект подшипника ступицы колеса
FREMAX BD-6328 Тормозной диск
BD-7829 Тормозной диск
GSP GK3525 Комплект подшипника ступицы колеса
GK3637 Комплект подшипника ступицы колеса
9499032K Комплект подшипника ступицы колеса
HERTH+BUSS JAKOPARTS J4701037 Комплект подшипника ступицы колеса
J4711061 Комплект подшипника ступицы колеса
IJS GROUP 10-1298 Комплект подшипника ступицы колеса
10-1298R Подшипник ступицы колеса
10-1141 Комплект подшипника ступицы колеса
IPD 30-3030 Комплект подшипника ступицы колеса
30-3084 Комплект подшипника ступицы колеса
IPS Parts IUB-10139 Комплект подшипника ступицы колеса
IUB-10149 Комплект подшипника ступицы колеса
JAPANPARTS KK-11042 Комплект подшипника ступицы колеса
KK-21071 Комплект подшипника ступицы колеса
JAPKO 421071 Комплект подшипника ступицы колеса
411042 Комплект подшипника ступицы колеса
JP GROUP 4351301519 Комплект подшипника ступицы колеса
KAMOKA 5600011 Комплект подшипника ступицы колеса
KAVO PARTS WBK-6509 Комплект подшипника ступицы колеса
WBK-6505 Комплект подшипника ступицы колеса
KEY PARTS KWB795 Комплект подшипника ступицы колеса
KM International RK3030 Комплект подшипника ступицы колеса
RK3084 Комплект подшипника ступицы колеса
KRAFT AUTOMOTIVE 4105010 Комплект подшипника ступицы колеса
4105185 Комплект подшипника ступицы колеса
LUCAS ENGINE DRIVE LKBA69012 Комплект подшипника ступицы колеса
LKBA69063 Комплект подшипника ступицы колеса
LYNXauto WB-1202 Комплект подшипника ступицы колеса
WB-1173 Комплект подшипника ступицы колеса
MAPCO 26126 Комплект подшипника ступицы колеса
26102 Комплект подшипника ступицы колеса
MASTER-SPORT 3525-SET-MS Комплект подшипника ступицы колеса
3637-SET-MS Комплект подшипника ступицы колеса
MDR MWB-F1042 Комплект подшипника ступицы колеса
MWB-R1071 Комплект подшипника ступицы колеса
Metalcaucho 74128 Комплект подшипника ступицы колеса
74001 Комплект подшипника ступицы колеса
74097 Комплект подшипника ступицы колеса
METZGER WM 2044 Комплект подшипника ступицы колеса
MEYLE 16-14 650 0001 Комплект подшипника ступицы колеса
MOOG RE-WB-11475 Комплект подшипника ступицы колеса
RE-WB-11479 Комплект подшипника ступицы колеса
MOTAQUIP VBK15 Комплект подшипника ступицы колеса
LVBW1226 Комплект подшипника ступицы колеса
LVBW15 Комплект подшипника ступицы колеса
VBK1226 Комплект подшипника ступицы колеса
NIPPARTS N4701045 Комплект подшипника ступицы колеса
N4711064 Комплект подшипника ступицы колеса
J4701037 Комплект подшипника ступицы колеса
J4711055 Комплект подшипника ступицы колеса
NK 753926 Комплект подшипника ступицы колеса
763938 Комплект подшипника ступицы колеса
NPS N471N50 Комплект подшипника ступицы колеса
N470N48 Комплект подшипника ступицы колеса
OPTIMAL 702312 Комплект подшипника ступицы колеса
702312L Комплект подшипника ступицы колеса
702312S Комплект подшипника ступицы колеса
701977 Комплект подшипника ступицы колеса
PATRON PBK3525 Комплект подшипника ступицы колеса
PBK3637 Комплект подшипника ступицы колеса
PBK869 Комплект подшипника ступицы колеса
PROFIT 2501-3525 Комплект подшипника ступицы колеса
2501-0869 Комплект подшипника ступицы колеса
REPKIT RKB1026 Комплект подшипника ступицы колеса
RKB1783 Комплект подшипника ступицы колеса
RKB2097 Комплект подшипника ступицы колеса
RUVILLE 5563 Комплект подшипника ступицы колеса
5563D Комплект подшипника ступицы колеса
5575 Комплект подшипника ступицы колеса
sbs 1401763938 Комплект подшипника ступицы колеса
1401753926 Комплект подшипника ступицы колеса
SCT Germany SCP 3525 Комплект подшипника ступицы колеса
SIDAT 460077 Комплект подшипника ступицы колеса
460234 Комплект подшипника ступицы колеса
SKF VKBA 3637 Комплект подшипника ступицы колеса
VKBA 3525 Комплект подшипника ступицы колеса
SNR R155.63 Комплект подшипника ступицы колеса
R155.75 Комплект подшипника ступицы колеса
STC T474128 Комплект подшипника ступицы колеса
T474001 Комплект подшипника ступицы колеса
T474097 Комплект подшипника ступицы колеса
STELLOX 43-28020-SX Комплект подшипника ступицы колеса
40-30121-SX Подшипник ступицы колеса
43-28217-SX Комплект подшипника ступицы колеса
SWAG 60 90 5538 Комплект подшипника ступицы колеса
60 92 4315 Комплект подшипника ступицы колеса
TOPRAN 700 179 Комплект подшипника ступицы колеса
700 638 Комплект подшипника ступицы колеса
TRISCAN 8530 25239 Комплект подшипника ступицы колеса
8530 10145 Комплект подшипника ступицы колеса
VAICO V46-0049 Комплект подшипника ступицы колеса
V38-0092 Комплект подшипника ступицы колеса
ZEKKERT RL-1135 Комплект подшипника ступицы колеса
RL-1258 Комплект подшипника ступицы колеса
2026 CATCAR.INFO (v 2.0)