#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTQ5NTd8fG1kZl9pZD09MF4yMzg2Nnx8c3BhcmVfaWQ9PTEwMDM3MQ%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 = "23866" AND ( (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "FT1952" AND av.ProductID IN (1626)) OR (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "FT1951" AND av.ProductID IN (1180)) OR (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "FT1963" AND av.ProductID IN (1632)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "043670B" AND av.ProductID IN (1180)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "043715B" AND av.ProductID IN (1180)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "043480B" AND av.ProductID IN (1180)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "043469B" AND av.ProductID IN (1626)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "047045B" AND av.ProductID IN (1180)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "043491B" AND av.ProductID IN (1180)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "59131" AND av.ProductID IN (1632)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "6320" AND av.ProductID IN (1626)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "5673" AND av.ProductID IN (1180)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "59011" AND av.ProductID IN (1632)) OR (av.SupplierID = 14 AND av.DataSupplierArticleNumber = "87-398-L" AND av.ProductID IN (1626)) OR (av.SupplierID = 14 AND av.DataSupplierArticleNumber = "87-393-A" AND av.ProductID IN (1180)) OR (av.SupplierID = 14 AND av.DataSupplierArticleNumber = "87-393-R" AND av.ProductID IN (1632)) OR (av.SupplierID = 14 AND av.DataSupplierArticleNumber = "88-561-A" AND av.ProductID IN (1180)) OR (av.SupplierID = 14 AND av.DataSupplierArticleNumber = "84-031-A" AND av.ProductID IN (1180)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BSM5011" AND av.ProductID IN (1180)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BSM5218" AND av.ProductID IN (1180)) OR (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B18402" AND av.ProductID IN (1180)) OR (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B18401" AND av.ProductID IN (1626)) OR (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B16172" AND av.ProductID IN (1180)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-700-044" AND av.ProductID IN (1180)) OR (av.SupplierID = 157 AND av.DataSupplierArticleNumber = "BSP20146" AND av.ProductID IN (1180)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "460182" AND av.ProductID IN (1180)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "010913" AND av.ProductID IN (1626)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "460219" AND av.ProductID IN (1632)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CTSM9011" AND av.ProductID IN (1180)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS7546" AND av.ProductID IN (1180)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS3058" AND av.ProductID IN (1180)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "2564" AND av.ProductID IN (1180)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "12086" AND av.ProductID IN (1626)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "09227" AND av.ProductID IN (1180)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "01111" AND av.ProductID IN (1626)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "09228" AND av.ProductID IN (1632)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "19274" AND av.ProductID IN (1180)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "37896" AND av.ProductID IN (1632)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FSM5011" AND av.ProductID IN (1180)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FSM5218" AND av.ProductID IN (1180)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FL2928-J" AND av.ProductID IN (1626)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FL3956-J" AND av.ProductID IN (1180)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FL4279-J" AND av.ProductID IN (1180)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FL5939-J" AND av.ProductID IN (1180)) OR (av.SupplierID = 71 AND av.DataSupplierArticleNumber = "GK160" AND av.ProductID IN (1180)) OR (av.SupplierID = 71 AND av.DataSupplierArticleNumber = "GK382" AND av.ProductID IN (1180)) OR (av.SupplierID = 71 AND av.DataSupplierArticleNumber = "GK302" AND av.ProductID IN (1632)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "510070" AND av.ProductID IN (1180)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "510213S" AND av.ProductID IN (1632)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "510069" AND av.ProductID IN (1626)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "590009" AND av.ProductID IN (1180)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "KS 29" AND av.ProductID IN (1632)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "597136" AND av.ProductID IN (1180)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "KS 135" AND av.ProductID IN (1632)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "KS 136" AND av.ProductID IN (1632)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1142400410" AND av.ProductID IN (1180)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1152300600" AND av.ProductID IN (1180)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1142450102" AND av.ProductID IN (1626)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1142400400" AND av.ProductID IN (1180)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1152300609" AND av.ProductID IN (1180)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1142450109" AND av.ProductID IN (1626)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1142400409" AND av.ProductID IN (1180)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1152300700" AND av.ProductID IN (1180)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1142450200" AND av.ProductID IN (1626)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "209033" AND av.ProductID IN (1632)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "209146" AND av.ProductID IN (1180)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "209135" AND av.ProductID IN (1632)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4090002" AND av.ProductID IN (1632)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4090280" AND av.ProductID IN (1626)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4090330" AND av.ProductID IN (1180)) OR (av.SupplierID = 85 AND av.DataSupplierArticleNumber = "SM9703" AND av.ProductID IN (1180)) OR (av.SupplierID = 85 AND av.DataSupplierArticleNumber = "SM1708" AND av.ProductID IN (1632)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "35269 01" AND av.ProductID IN (1180)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "25346 01" AND av.ProductID IN (1632)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "21793 02" AND av.ProductID IN (1180)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "17636 02" AND av.ProductID IN (1626)) OR (av.SupplierID = 4427 AND av.DataSupplierArticleNumber = "A7W012MT" AND av.ProductID IN (1180)) OR (av.SupplierID = 4427 AND av.DataSupplierArticleNumber = "A7A017MT" AND av.ProductID IN (1632)) OR (av.SupplierID = 4427 AND av.DataSupplierArticleNumber = "A7W006MT" AND av.ProductID IN (1180)) OR (av.SupplierID = 4427 AND av.DataSupplierArticleNumber = "A7W010MT" AND av.ProductID IN (1626)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "17727" AND av.ProductID IN (1180)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "17728" AND av.ProductID IN (1180)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "33856" AND av.ProductID IN (1626)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "34853" AND av.ProductID IN (1632)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "33961" AND av.ProductID IN (1180)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "34853/2" AND av.ProductID IN (1632)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "33969" AND av.ProductID IN (1180)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "72-1082" AND av.ProductID IN (1632,1180)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "72-0325" AND av.ProductID IN (1180)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "04177" AND av.ProductID IN (1180)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 412 1019/S" AND av.ProductID IN (1180)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 513 0001" AND av.ProductID IN (1180)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 412 0019" AND av.ProductID IN (1180)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 641 0024" AND av.ProductID IN (1626)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 513 0005" AND av.ProductID IN (1180)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 412 0019/S" AND av.ProductID IN (1180)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "MK077" AND av.ProductID IN (1180)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "L10912" AND av.ProductID IN (1626)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "MK118" AND av.ProductID IN (1180)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "L29905" AND av.ProductID IN (1180)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "MK344" AND av.ProductID IN (1626)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "L29914" AND av.ProductID IN (1180)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "VO-SB-10053" AND av.ProductID IN (1632)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "VO-SB-10063" AND av.ProductID IN (1632)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVSM1005" AND av.ProductID IN (1632)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "674704" AND av.ProductID IN (1180)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-4067" AND av.ProductID IN (1180)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-7133" AND av.ProductID IN (1180)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-5380" AND av.ProductID IN (1180)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-6040" AND av.ProductID IN (1180)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-3039" AND av.ProductID IN (1626)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-6280" AND av.ProductID IN (1180)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "37638/2" AND av.ProductID IN (1632)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "37638" AND av.ProductID IN (1180)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2314-0515" AND av.ProductID IN (1626)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2314-0294" AND av.ProductID IN (950)) OR (av.SupplierID = 273 AND av.DataSupplierArticleNumber = "924070" AND av.ProductID IN (1180)) OR (av.SupplierID = 273 AND av.DataSupplierArticleNumber = "924967" AND av.ProductID IN (1626)) OR (av.SupplierID = 273 AND av.DataSupplierArticleNumber = "925964" AND av.ProductID IN (1180)) OR (av.SupplierID = 4708 AND av.DataSupplierArticleNumber = "VW12061" AND av.ProductID IN (1180)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "865430" AND av.ProductID IN (1626)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "825402S" AND av.ProductID IN (1632)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "825402" AND av.ProductID IN (1180)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "802 070" AND av.ProductID IN (1180)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "802 535" AND av.ProductID IN (1180)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "801 016" AND av.ProductID IN (1626)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "802 270" AND av.ProductID IN (1632)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "863402" AND av.ProductID IN (1180)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "863417" AND av.ProductID IN (1626)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "863420 KIT" AND av.ProductID IN (1632)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "KB957.03" AND av.ProductID IN (1632)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "M254.01" AND av.ProductID IN (1180)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "KB657.08" AND av.ProductID IN (1632)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T404177" AND av.ProductID IN (1180)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 55 0008" AND av.ProductID IN (1632)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 54 0001" AND av.ProductID IN (1626)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 54 0012" AND av.ProductID IN (1180)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 7896" AND av.ProductID IN (1632)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "32 91 9274" AND av.ProductID IN (1180)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "63-02166" AND av.ProductID IN (1180)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "63-04981" AND av.ProductID IN (1180)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "63-01785" AND av.ProductID IN (1180)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "63-02160" AND av.ProductID IN (1180)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "108 561" AND av.ProductID IN (1180)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "109 878" AND av.ProductID IN (1180)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "103 486" AND av.ProductID IN (1626)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "110 714" AND av.ProductID IN (1180)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "108 241" AND av.ProductID IN (1180)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "784599" AND av.ProductID IN (1626)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "783569" AND av.ProductID IN (1180)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "783723" AND av.ProductID IN (1180)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "783727" AND av.ProductID IN (1180)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "783406" AND av.ProductID IN (1180)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 29914" AND av.ProductID IN (1180)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 10912" AND av.ProductID IN (1626)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 29905" AND av.ProductID IN (1180)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JSB141" AND av.ProductID IN (1180)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JSL149" AND av.ProductID IN (1180)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JSL241" AND av.ProductID IN (1632)) OR (av.SupplierID = 4730 AND av.DataSupplierArticleNumber = "391810CU" AND av.ProductID IN (1626)) OR (av.SupplierID = 4730 AND av.DataSupplierArticleNumber = "391882" AND av.ProductID IN (1180)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-8222" AND av.ProductID IN (1180)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-1405" AND av.ProductID IN (1626)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-1001" AND av.ProductID IN (1180)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-3062" AND av.ProductID IN (1180)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-1003" AND av.ProductID IN (1632)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "K41484401" AND av.ProductID IN (1180)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "44120025901" AND av.ProductID IN (1180)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "K41491301" AND av.ProductID IN (1180)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "44120026301" AND av.ProductID IN (1180)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "44120069601" AND av.ProductID IN (1626)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "K41484301" AND av.ProductID IN (1180)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "44120023501" AND av.ProductID IN (1180)) ) 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 = 4737 AND aa.DataSupplierArticleNumber = "FT1952") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "FT1951") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "FT1963") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "043670B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "043715B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "043480B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "043469B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "047045B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "043491B") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "59131") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "6320") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "5673") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "59011") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "87-398-L") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "87-393-A") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "87-393-R") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "88-561-A") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "84-031-A") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSM5011") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSM5218") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B18402") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B18401") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B16172") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-700-044") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP20146") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "460182") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "010913") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "460219") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CTSM9011") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS7546") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS3058") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "2564") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "12086") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09227") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "01111") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09228") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "19274") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "37896") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSM5011") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSM5218") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL2928-J") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL3956-J") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL4279-J") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL5939-J") OR (aa.SupplierID = 71 AND aa.DataSupplierArticleNumber = "GK160") OR (aa.SupplierID = 71 AND aa.DataSupplierArticleNumber = "GK382") OR (aa.SupplierID = 71 AND aa.DataSupplierArticleNumber = "GK302") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "510070") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "510213S") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "510069") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "590009") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "KS 29") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "597136") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "KS 135") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "KS 136") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1142400410") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1152300600") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1142450102") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1142400400") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1152300609") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1142450109") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1142400409") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1152300700") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1142450200") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "209033") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "209146") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "209135") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4090002") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4090280") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4090330") OR (aa.SupplierID = 85 AND aa.DataSupplierArticleNumber = "SM9703") OR (aa.SupplierID = 85 AND aa.DataSupplierArticleNumber = "SM1708") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "35269 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "25346 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "21793 02") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "17636 02") OR (aa.SupplierID = 4427 AND aa.DataSupplierArticleNumber = "A7W012MT") OR (aa.SupplierID = 4427 AND aa.DataSupplierArticleNumber = "A7A017MT") OR (aa.SupplierID = 4427 AND aa.DataSupplierArticleNumber = "A7W006MT") OR (aa.SupplierID = 4427 AND aa.DataSupplierArticleNumber = "A7W010MT") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "17727") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "17728") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "33856") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "34853") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "33961") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "34853/2") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "33969") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-1082") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-0325") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "04177") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 412 1019/S") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 513 0001") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 412 0019") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 641 0024") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 513 0005") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 412 0019/S") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "MK077") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L10912") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "MK118") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L29905") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "MK344") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L29914") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-10053") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-10063") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVSM1005") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "674704") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-4067") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-7133") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-5380") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-6040") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-3039") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-6280") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "37638/2") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "37638") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2314-0515") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2314-0294") OR (aa.SupplierID = 273 AND aa.DataSupplierArticleNumber = "924070") OR (aa.SupplierID = 273 AND aa.DataSupplierArticleNumber = "924967") OR (aa.SupplierID = 273 AND aa.DataSupplierArticleNumber = "925964") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "VW12061") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "865430") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "825402S") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "825402") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "802 070") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "802 535") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "801 016") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "802 270") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "863402") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "863417") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "863420 KIT") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "KB957.03") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "M254.01") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "KB657.08") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T404177") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 55 0008") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 54 0001") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 54 0012") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 7896") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 91 9274") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "63-02166") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "63-04981") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "63-01785") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "63-02160") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "108 561") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "109 878") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "103 486") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "110 714") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "108 241") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "784599") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783569") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783723") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783727") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783406") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 29914") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 10912") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 29905") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JSB141") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JSL149") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JSL241") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "391810CU") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "391882") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-8222") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1405") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1001") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3062") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1003") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "K41484401") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "44120025901") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "K41491301") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "44120026301") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "44120069601") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "K41484301") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "44120023501") ) 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 = 4737 AND aa.DataSupplierArticleNumber = "FT1952") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "FT1951") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "FT1963") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "043670B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "043715B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "043480B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "043469B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "047045B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "043491B") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "59131") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "6320") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "5673") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "59011") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "87-398-L") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "87-393-A") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "87-393-R") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "88-561-A") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "84-031-A") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSM5011") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSM5218") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B18402") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B18401") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B16172") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-700-044") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP20146") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "460182") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "010913") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "460219") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CTSM9011") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS7546") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS3058") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "2564") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "12086") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09227") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "01111") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09228") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "19274") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "37896") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSM5011") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSM5218") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL2928-J") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL3956-J") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL4279-J") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL5939-J") OR (aa.SupplierID = 71 AND aa.DataSupplierArticleNumber = "GK160") OR (aa.SupplierID = 71 AND aa.DataSupplierArticleNumber = "GK382") OR (aa.SupplierID = 71 AND aa.DataSupplierArticleNumber = "GK302") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "510070") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "510213S") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "510069") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "590009") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "KS 29") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "597136") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "KS 135") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "KS 136") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1142400410") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1152300600") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1142450102") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1142400400") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1152300609") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1142450109") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1142400409") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1152300700") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1142450200") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "209033") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "209146") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "209135") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4090002") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4090280") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4090330") OR (aa.SupplierID = 85 AND aa.DataSupplierArticleNumber = "SM9703") OR (aa.SupplierID = 85 AND aa.DataSupplierArticleNumber = "SM1708") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "35269 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "25346 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "21793 02") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "17636 02") OR (aa.SupplierID = 4427 AND aa.DataSupplierArticleNumber = "A7W012MT") OR (aa.SupplierID = 4427 AND aa.DataSupplierArticleNumber = "A7A017MT") OR (aa.SupplierID = 4427 AND aa.DataSupplierArticleNumber = "A7W006MT") OR (aa.SupplierID = 4427 AND aa.DataSupplierArticleNumber = "A7W010MT") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "17727") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "17728") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "33856") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "34853") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "33961") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "34853/2") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "33969") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-1082") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-0325") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "04177") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 412 1019/S") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 513 0001") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 412 0019") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 641 0024") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 513 0005") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 412 0019/S") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "MK077") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L10912") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "MK118") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L29905") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "MK344") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L29914") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-10053") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-10063") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVSM1005") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "674704") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-4067") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-7133") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-5380") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-6040") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-3039") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-6280") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "37638/2") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "37638") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2314-0515") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2314-0294") OR (aa.SupplierID = 273 AND aa.DataSupplierArticleNumber = "924070") OR (aa.SupplierID = 273 AND aa.DataSupplierArticleNumber = "924967") OR (aa.SupplierID = 273 AND aa.DataSupplierArticleNumber = "925964") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "VW12061") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "865430") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "825402S") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "825402") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "802 070") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "802 535") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "801 016") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "802 270") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "863402") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "863417") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "863420 KIT") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "KB957.03") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "M254.01") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "KB657.08") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T404177") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 55 0008") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 54 0001") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 54 0012") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 7896") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 91 9274") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "63-02166") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "63-04981") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "63-01785") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "63-02160") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "108 561") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "109 878") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "103 486") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "110 714") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "108 241") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "784599") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783569") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783723") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783727") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783406") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 29914") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 10912") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 29905") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JSB141") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JSL149") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JSL241") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "391810CU") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "391882") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-8222") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1405") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1001") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3062") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1003") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "K41484401") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "44120025901") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "K41491301") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "44120026301") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "44120069601") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "K41484301") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "44120023501") ) AND aa.Language = "ru" Продажа автозапчастей типа Подвеска амортизатора/стойка амортизатора для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTLOG FT1952 Подшипник качения, опора стойки амортизатора
FT1951 Опора стойки амортизатора
FT1963 Ремкомплект, опора стойки амортизатора
BENDIX 043670B Опора стойки амортизатора
043715B Опора стойки амортизатора
043480B Опора стойки амортизатора
043469B Подшипник качения, опора стойки амортизатора
047045B Опора стойки амортизатора
043491B Опора стойки амортизатора
BIRTH 59131 Ремкомплект, опора стойки амортизатора
6320 Подшипник качения, опора стойки амортизатора
5673 Опора стойки амортизатора
59011 Ремкомплект, опора стойки амортизатора
BOGE 87-398-L Подшипник качения, опора стойки амортизатора
87-393-A Опора стойки амортизатора
87-393-R Ремкомплект, опора стойки амортизатора
88-561-A Опора стойки амортизатора
84-031-A Опора стойки амортизатора
BORG & BECK BSM5011 Опора стойки амортизатора
BSM5218 Опора стойки амортизатора
Borsehung B18402 Опора стойки амортизатора
B18401 Подшипник качения, опора стойки амортизатора
B16172 Опора стойки амортизатора
BSG BSG 90-700-044 Опора стойки амортизатора
BUGIAD BSP20146 Опора стойки амортизатора
CAUTEX 460182 Опора стойки амортизатора
010913 Подшипник качения, опора стойки амортизатора
460219 Ремкомплект, опора стойки амортизатора
COMLINE CTSM9011 Опора стойки амортизатора
FAI AutoParts SS7546 Опора стойки амортизатора
SS3058 Опора стойки амортизатора
FARE SA 2564 Опора стойки амортизатора
12086 Подшипник качения, опора стойки амортизатора
FEBI BILSTEIN 09227 Опора стойки амортизатора
01111 Подшипник качения, опора стойки амортизатора
09228 Ремкомплект, опора стойки амортизатора
19274 Опора стойки амортизатора
37896 Ремкомплект, опора стойки амортизатора
FIRST LINE FSM5011 Опора стойки амортизатора
FSM5218 Опора стойки амортизатора
FLENNOR FL2928-J Подшипник качения, опора стойки амортизатора
FL3956-J Опора стойки амортизатора
FL4279-J Опора стойки амортизатора
FL5939-J Опора стойки амортизатора
GABRIEL GK160 Опора стойки амортизатора
GK382 Опора стойки амортизатора
GK302 Ремкомплект, опора стойки амортизатора
GSP 510070 Опора стойки амортизатора
510213S Ремкомплект, опора стойки амортизатора
510069 Подшипник качения, опора стойки амортизатора
HUTCHINSON 590009 Опора стойки амортизатора
KS 29 Ремкомплект, опора стойки амортизатора
597136 Опора стойки амортизатора
KS 135 Ремкомплект, опора стойки амортизатора
KS 136 Ремкомплект, опора стойки амортизатора
JP GROUP 1142400410 Опора стойки амортизатора
1152300600 Опора стойки амортизатора
1142450102 Подшипник качения, опора стойки амортизатора
1142400400 Опора стойки амортизатора
1152300609 Опора стойки амортизатора
1142450109 Подшипник качения, опора стойки амортизатора
1142400409 Опора стойки амортизатора
1152300700 Опора стойки амортизатора
1142450200 Подшипник качения, опора стойки амортизатора
KAMOKA 209033 Ремкомплект, опора стойки амортизатора
209146 Опора стойки амортизатора
209135 Ремкомплект, опора стойки амортизатора
KRAFT AUTOMOTIVE 4090002 Ремкомплект, опора стойки амортизатора
4090280 Подшипник качения, опора стойки амортизатора
4090330 Опора стойки амортизатора
KYB SM9703 Опора стойки амортизатора
SM1708 Ремкомплект, опора стойки амортизатора
LEMFÖRDER 35269 01 Опора стойки амортизатора
25346 01 Ремкомплект, опора стойки амортизатора
21793 02 Опора стойки амортизатора
17636 02 Подшипник качения, опора стойки амортизатора
Magnum Technology A7W012MT Опора стойки амортизатора
A7A017MT Ремкомплект, опора стойки амортизатора
A7W006MT Опора стойки амортизатора
A7W010MT Подшипник качения, опора стойки амортизатора
MALÒ 17727 Опора стойки амортизатора
17728 Опора стойки амортизатора
MAPCO 33856 Подшипник качения, опора стойки амортизатора
34853 Ремкомплект, опора стойки амортизатора
33961 Опора стойки амортизатора
34853/2 Ремкомплект, опора стойки амортизатора
33969 Опора стойки амортизатора
MAXGEAR 72-1082 Опора стойки амортизатора
72-0325 Опора стойки амортизатора
Metalcaucho 04177 Опора стойки амортизатора
MEYLE 100 412 1019/S Опора стойки амортизатора
100 513 0001 Опора стойки амортизатора
100 412 0019 Опора стойки амортизатора
100 641 0024 Подшипник качения, опора стойки амортизатора
100 513 0005 Опора стойки амортизатора
100 412 0019/S Опора стойки амортизатора
MONROE MK077 Опора стойки амортизатора
L10912 Подшипник качения, опора стойки амортизатора
MK118 Опора стойки амортизатора
L29905 Опора стойки амортизатора
MK344 Подшипник качения, опора стойки амортизатора
L29914 Опора стойки амортизатора
MOOG VO-SB-10053 Ремкомплект, опора стойки амортизатора
VO-SB-10063 Ремкомплект, опора стойки амортизатора
MOTAQUIP LVSM1005 Ремкомплект, опора стойки амортизатора
NK 674704 Опора стойки амортизатора
OPTIMAL F8-4067 Опора стойки амортизатора
F8-7133 Опора стойки амортизатора
F8-5380 Опора стойки амортизатора
F8-6040 Опора стойки амортизатора
F8-3039 Подшипник качения, опора стойки амортизатора
F8-6280 Опора стойки амортизатора
ORIGINAL IMPERIUM 37638/2 Ремкомплект, опора стойки амортизатора
37638 Опора стойки амортизатора
PROFIT 2314-0515 Подшипник качения, опора стойки амортизатора
2314-0294 Подвеска, амортизатор
RECORD FRANCE 924070 Опора стойки амортизатора
924967 Подшипник качения, опора стойки амортизатора
925964 Опора стойки амортизатора
RIW VW12061 Опора стойки амортизатора
RUVILLE 865430 Подшипник качения, опора стойки амортизатора
825402S Ремкомплект, опора стойки амортизатора
825402 Опора стойки амортизатора
SACHS 802 070 Опора стойки амортизатора
802 535 Опора стойки амортизатора
801 016 Подшипник качения, опора стойки амортизатора
802 270 Ремкомплект, опора стойки амортизатора
SIDEM 863402 Опора стойки амортизатора
863417 Подшипник качения, опора стойки амортизатора
863420 KIT Ремкомплект, опора стойки амортизатора
SNR KB957.03 Ремкомплект, опора стойки амортизатора
M254.01 Опора стойки амортизатора
KB657.08 Ремкомплект, опора стойки амортизатора
STC T404177 Опора стойки амортизатора
SWAG 30 55 0008 Ремкомплект, опора стойки амортизатора
30 54 0001 Подшипник качения, опора стойки амортизатора
30 54 0012 Опора стойки амортизатора
30 93 7896 Ремкомплект, опора стойки амортизатора
32 91 9274 Опора стойки амортизатора
TALOSA 63-02166 Опора стойки амортизатора
63-04981 Опора стойки амортизатора
63-01785 Опора стойки амортизатора
63-02160 Опора стойки амортизатора
TOPRAN 108 561 Опора стойки амортизатора
109 878 Опора стойки амортизатора
103 486 Подшипник качения, опора стойки амортизатора
110 714 Опора стойки амортизатора
108 241 Опора стойки амортизатора
TRICLO 784599 Подшипник качения, опора стойки амортизатора
783569 Опора стойки амортизатора
783723 Опора стойки амортизатора
783727 Опора стойки амортизатора
783406 Опора стойки амортизатора
TRISCAN 8500 29914 Опора стойки амортизатора
8500 10912 Подшипник качения, опора стойки амортизатора
8500 29905 Опора стойки амортизатора
TRW JSB141 Опора стойки амортизатора
JSL149 Опора стойки амортизатора
JSL241 Ремкомплект, опора стойки амортизатора
UNIGOM 391810CU Подшипник качения, опора стойки амортизатора
391882 Опора стойки амортизатора
VAICO V10-8222 Опора стойки амортизатора
V10-1405 Подшипник качения, опора стойки амортизатора
V10-1001 Опора стойки амортизатора
V10-3062 Опора стойки амортизатора
V10-1003 Ремкомплект, опора стойки амортизатора
vika K41484401 Опора стойки амортизатора
44120025901 Опора стойки амортизатора
K41491301 Опора стойки амортизатора
44120026301 Опора стойки амортизатора
44120069601 Подшипник качения, опора стойки амортизатора
K41484301 Опора стойки амортизатора
44120023501 Опора стойки амортизатора
2026 CATCAR.INFO (v 2.0)