#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTM0NjZ8fG1kZl9pZD09MF4xMzY0N3x8c3BhcmVfaWQ9PTEwMDU3Mg%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 = "13647" AND ( (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "50422" AND av.ProductID IN (251)) OR (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "50421" AND av.ProductID IN (251)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "270238" AND av.ProductID IN (251)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "270240" AND av.ProductID IN (251)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "270241" AND av.ProductID IN (251)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "270227" AND av.ProductID IN (251)) OR (av.SupplierID = 4943 AND av.DataSupplierArticleNumber = "AW1420401" AND av.ProductID IN (251)) OR (av.SupplierID = 4943 AND av.DataSupplierArticleNumber = "AW1420962" AND av.ProductID IN (251)) OR (av.SupplierID = 4943 AND av.DataSupplierArticleNumber = "AW1420999" AND av.ProductID IN (251)) OR (av.SupplierID = 4995 AND av.DataSupplierArticleNumber = "001-10-20714" AND av.ProductID IN (251)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "045388B" AND av.ProductID IN (251)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "040069B" AND av.ProductID IN (251)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "045345B" AND av.ProductID IN (251)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "045369B" AND av.ProductID IN (251)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "040068B" AND av.ProductID IN (251)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "2281" AND av.ProductID IN (251)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "2282" AND av.ProductID IN (251)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "2347" AND av.ProductID IN (251)) OR (av.SupplierID = 14 AND av.DataSupplierArticleNumber = "87-042-A" AND av.ProductID IN (251)) OR (av.SupplierID = 14 AND av.DataSupplierArticleNumber = "87-426-A" AND av.ProductID IN (251)) OR (av.SupplierID = 14 AND av.DataSupplierArticleNumber = "87-895-A" AND av.ProductID IN (251)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BSK6226" AND av.ProductID IN (251)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BSK6227" AND av.ProductID IN (251)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BSK6003" AND av.ProductID IN (251)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BSK6004" AND av.ProductID IN (251)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 65-700-065" AND av.ProductID IN (251)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 65-700-085" AND av.ProductID IN (251)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 65-700-086" AND av.ProductID IN (251)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 65-700-064" AND av.ProductID IN (251)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "480516" AND av.ProductID IN (3245)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "480517" AND av.ProductID IN (3245)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "480528" AND av.ProductID IN (3245)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "21652930" AND av.ProductID IN (251)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "21652937" AND av.ProductID IN (251)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "21652929" AND av.ProductID IN (251)) OR (av.SupplierID = 4880 AND av.DataSupplierArticleNumber = "CBH15007" AND av.ProductID IN (251)) OR (av.SupplierID = 4880 AND av.DataSupplierArticleNumber = "CBH15008" AND av.ProductID IN (251)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TD769W" AND av.ProductID IN (251)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TD310W" AND av.ProductID IN (251)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TD311W" AND av.ProductID IN (251)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TD541W" AND av.ProductID IN (251)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "D300055" AND av.ProductID IN (251)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "D300056" AND av.ProductID IN (251)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1184402" AND av.ProductID IN (251)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS4341" AND av.ProductID IN (251)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "2854" AND av.ProductID IN (251)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "2847" AND av.ProductID IN (251)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "04402" AND av.ProductID IN (251)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "02183" AND av.ProductID IN (251)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "02263" AND av.ProductID IN (251)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "04390" AND av.ProductID IN (251)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FSK6226" AND av.ProductID IN (251)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FSK6227" AND av.ProductID IN (251)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FSK6003" AND av.ProductID IN (251)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FSK6004" AND av.ProductID IN (251)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FL3988-J" AND av.ProductID IN (251)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FL4097-J" AND av.ProductID IN (251)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FL4098-J" AND av.ProductID IN (251)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FL4226-J" AND av.ProductID IN (251)) OR (av.SupplierID = 4727 AND av.DataSupplierArticleNumber = "2000012" AND av.ProductID IN (251)) OR (av.SupplierID = 4727 AND av.DataSupplierArticleNumber = "2000013" AND av.ProductID IN (251)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ9442" AND av.ProductID IN (251)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ9444" AND av.ProductID IN (251)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "510904" AND av.ProductID IN (251)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "512462" AND av.ProductID IN (251)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "510842" AND av.ProductID IN (3245)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "590037" AND av.ProductID IN (251)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "590047" AND av.ProductID IN (251)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "590097" AND av.ProductID IN (251)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1250300900" AND av.ProductID IN (251)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1240201600" AND av.ProductID IN (251)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1250300909" AND av.ProductID IN (251)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1240201609" AND av.ProductID IN (251)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1240202209" AND av.ProductID IN (251)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1240201500" AND av.ProductID IN (251)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "8800267" AND av.ProductID IN (251)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "8800086" AND av.ProductID IN (251)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "8800087" AND av.ProductID IN (251)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "8800266" AND av.ProductID IN (251)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4231680" AND av.ProductID IN (251)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4231685" AND av.ProductID IN (251)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4231586" AND av.ProductID IN (251)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4231588" AND av.ProductID IN (251)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "22116 01" AND av.ProductID IN (251)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "26096 01" AND av.ProductID IN (251)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "21776 02" AND av.ProductID IN (251)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "C8544" AND av.ProductID IN (251)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "C8545" AND av.ProductID IN (251)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "C8541" AND av.ProductID IN (251)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "C8543" AND av.ProductID IN (251)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "237921" AND av.ProductID IN (251)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "237931" AND av.ProductID IN (251)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "33895" AND av.ProductID IN (251)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "33848" AND av.ProductID IN (251)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "33849" AND av.ProductID IN (251)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "16063-PCS-MS" AND av.ProductID IN (251)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "21776-PCS-MS" AND av.ProductID IN (251)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "72-1250" AND av.ProductID IN (251)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "72-1176" AND av.ProductID IN (251)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "52001708" AND av.ProductID IN (251)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "52001808" AND av.ProductID IN (251)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "614 042 0003" AND av.ProductID IN (3245)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "614 042 0004" AND av.ProductID IN (3245)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "614 035 0010" AND av.ProductID IN (3245)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "614 035 0016" AND av.ProductID IN (3245)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "L24818" AND av.ProductID IN (251)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "L24823" AND av.ProductID IN (251)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "L24817" AND av.ProductID IN (251)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "OP-SB-3779" AND av.ProductID IN (251)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "OP-SB-3813" AND av.ProductID IN (251)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "OP-SB-1380" AND av.ProductID IN (251)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "OP-SB-1382" AND av.ProductID IN (251)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "5103615" AND av.ProductID IN (251)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "5103616" AND av.ProductID IN (251)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "1215522" AND av.ProductID IN (251)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "1215523" AND av.ProductID IN (251)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-5722" AND av.ProductID IN (251)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-5108" AND av.ProductID IN (251)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-5109" AND av.ProductID IN (251)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-5337" AND av.ProductID IN (251)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-4099" AND av.ProductID IN (251)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "1840" AND av.ProductID IN (251)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PSE1082" AND av.ProductID IN (251)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2307-0072" AND av.ProductID IN (251)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2307-0204" AND av.ProductID IN (251)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2307-0236" AND av.ProductID IN (251)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2307-0067" AND av.ProductID IN (251)) OR (av.SupplierID = 4368 AND av.DataSupplierArticleNumber = "SB7501" AND av.ProductID IN (251)) OR (av.SupplierID = 4368 AND av.DataSupplierArticleNumber = "SB7452" AND av.ProductID IN (251)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "EMS1988" AND av.ProductID IN (251)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "EMS8033" AND av.ProductID IN (251)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "EMS8127" AND av.ProductID IN (251)) OR (av.SupplierID = 4708 AND av.DataSupplierArticleNumber = "OP11011" AND av.ProductID IN (251)) OR (av.SupplierID = 4708 AND av.DataSupplierArticleNumber = "OP11010" AND av.ProductID IN (251)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "985329" AND av.ProductID IN (251)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "985357" AND av.ProductID IN (251)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "985335" AND av.ProductID IN (251)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "985360" AND av.ProductID IN (251)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "985353" AND av.ProductID IN (251)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "985356" AND av.ProductID IN (251)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "19125103616" AND av.ProductID IN (251)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "19125103615" AND av.ProductID IN (251)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "809624" AND av.ProductID IN (251)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "809625" AND av.ProductID IN (251)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "809626" AND av.ProductID IN (251)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "809622" AND av.ProductID IN (251)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "74-21742-SX" AND av.ProductID IN (251)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "74-22025-SX" AND av.ProductID IN (251)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "40 60 0014" AND av.ProductID IN (251)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "40 79 0011" AND av.ProductID IN (251)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "40 79 0012" AND av.ProductID IN (251)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "40 60 0009" AND av.ProductID IN (251)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "57-05768" AND av.ProductID IN (251)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "57-00403" AND av.ProductID IN (251)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "57-06495" AND av.ProductID IN (251)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "57-02633" AND av.ProductID IN (251)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "57-02634" AND av.ProductID IN (251)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "200 769" AND av.ProductID IN (251)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "200 502" AND av.ProductID IN (251)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "200 503" AND av.ProductID IN (251)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "200 768" AND av.ProductID IN (251)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "781101" AND av.ProductID IN (251)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 24823" AND av.ProductID IN (251)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 24817" AND av.ProductID IN (251)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 24818" AND av.ProductID IN (251)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JBU254" AND av.ProductID IN (251)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JBU380" AND av.ProductID IN (251)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JBU546" AND av.ProductID IN (251)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-1303" AND av.ProductID IN (251)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-0321" AND av.ProductID IN (251)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-0322" AND av.ProductID IN (251)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-1279" AND av.ProductID IN (251)) OR (av.SupplierID = 4425 AND av.DataSupplierArticleNumber = "20858" AND av.ProductID IN (251,251)) OR (av.SupplierID = 4425 AND av.DataSupplierArticleNumber = "20857" AND av.ProductID IN (251,251)) ) 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 = 4598 AND aa.DataSupplierArticleNumber = "50422") OR (aa.SupplierID = 4598 AND aa.DataSupplierArticleNumber = "50421") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270238") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270240") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270241") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270227") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1420401") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1420962") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1420999") OR (aa.SupplierID = 4995 AND aa.DataSupplierArticleNumber = "001-10-20714") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "045388B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "040069B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "045345B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "045369B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "040068B") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "2281") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "2282") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "2347") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "87-042-A") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "87-426-A") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "87-895-A") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK6226") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK6227") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK6003") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK6004") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-065") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-085") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-086") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-064") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "480516") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "480517") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "480528") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "21652930") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "21652937") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "21652929") OR (aa.SupplierID = 4880 AND aa.DataSupplierArticleNumber = "CBH15007") OR (aa.SupplierID = 4880 AND aa.DataSupplierArticleNumber = "CBH15008") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD769W") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD310W") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD311W") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD541W") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "D300055") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "D300056") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1184402") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS4341") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "2854") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "2847") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "04402") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "02183") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "02263") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "04390") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSK6226") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSK6227") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSK6003") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSK6004") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL3988-J") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL4097-J") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL4098-J") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL4226-J") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "2000012") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "2000013") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ9442") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ9444") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "510904") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "512462") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "510842") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "590037") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "590047") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "590097") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1250300900") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240201600") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1250300909") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240201609") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240202209") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240201500") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800267") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800086") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800087") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800266") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4231680") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4231685") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4231586") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4231588") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "22116 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "26096 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "21776 02") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8544") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8545") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8541") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8543") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "237921") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "237931") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "33895") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "33848") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "33849") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "16063-PCS-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "21776-PCS-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-1250") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-1176") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52001708") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52001808") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 042 0003") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 042 0004") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 035 0010") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 035 0016") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L24818") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L24823") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L24817") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "OP-SB-3779") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "OP-SB-3813") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "OP-SB-1380") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "OP-SB-1382") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5103615") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5103616") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1215522") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1215523") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-5722") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-5108") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-5109") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-5337") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-4099") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "1840") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PSE1082") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2307-0072") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2307-0204") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2307-0236") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2307-0067") OR (aa.SupplierID = 4368 AND aa.DataSupplierArticleNumber = "SB7501") OR (aa.SupplierID = 4368 AND aa.DataSupplierArticleNumber = "SB7452") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMS1988") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMS8033") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMS8127") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "OP11011") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "OP11010") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985329") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985357") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985335") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985360") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985353") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985356") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19125103616") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19125103615") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "809624") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "809625") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "809626") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "809622") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "74-21742-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "74-22025-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 60 0014") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 79 0011") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 79 0012") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 60 0009") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "57-05768") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "57-00403") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "57-06495") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "57-02633") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "57-02634") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "200 769") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "200 502") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "200 503") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "200 768") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "781101") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 24823") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 24817") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 24818") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JBU254") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JBU380") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JBU546") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1303") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0321") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0322") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1279") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "20858") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "20857") ) 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 = 4598 AND aa.DataSupplierArticleNumber = "50422") OR (aa.SupplierID = 4598 AND aa.DataSupplierArticleNumber = "50421") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270238") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270240") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270241") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270227") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1420401") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1420962") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1420999") OR (aa.SupplierID = 4995 AND aa.DataSupplierArticleNumber = "001-10-20714") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "045388B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "040069B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "045345B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "045369B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "040068B") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "2281") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "2282") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "2347") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "87-042-A") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "87-426-A") OR (aa.SupplierID = 14 AND aa.DataSupplierArticleNumber = "87-895-A") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK6226") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK6227") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK6003") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK6004") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-065") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-085") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-086") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-064") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "480516") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "480517") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "480528") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "21652930") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "21652937") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "21652929") OR (aa.SupplierID = 4880 AND aa.DataSupplierArticleNumber = "CBH15007") OR (aa.SupplierID = 4880 AND aa.DataSupplierArticleNumber = "CBH15008") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD769W") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD310W") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD311W") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD541W") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "D300055") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "D300056") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1184402") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS4341") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "2854") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "2847") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "04402") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "02183") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "02263") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "04390") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSK6226") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSK6227") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSK6003") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSK6004") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL3988-J") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL4097-J") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL4098-J") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL4226-J") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "2000012") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "2000013") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ9442") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ9444") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "510904") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "512462") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "510842") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "590037") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "590047") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "590097") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1250300900") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240201600") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1250300909") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240201609") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240202209") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240201500") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800267") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800086") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800087") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800266") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4231680") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4231685") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4231586") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4231588") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "22116 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "26096 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "21776 02") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8544") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8545") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8541") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8543") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "237921") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "237931") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "33895") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "33848") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "33849") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "16063-PCS-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "21776-PCS-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-1250") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-1176") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52001708") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52001808") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 042 0003") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 042 0004") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 035 0010") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 035 0016") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L24818") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L24823") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L24817") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "OP-SB-3779") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "OP-SB-3813") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "OP-SB-1380") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "OP-SB-1382") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5103615") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5103616") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1215522") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1215523") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-5722") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-5108") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-5109") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-5337") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-4099") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "1840") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PSE1082") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2307-0072") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2307-0204") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2307-0236") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2307-0067") OR (aa.SupplierID = 4368 AND aa.DataSupplierArticleNumber = "SB7501") OR (aa.SupplierID = 4368 AND aa.DataSupplierArticleNumber = "SB7452") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMS1988") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMS8033") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMS8127") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "OP11011") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "OP11010") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985329") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985357") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985335") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985360") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985353") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985356") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19125103616") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19125103615") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "809624") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "809625") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "809626") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "809622") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "74-21742-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "74-22025-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 60 0014") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 79 0011") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 79 0012") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 60 0009") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "57-05768") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "57-00403") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "57-06495") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "57-02633") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "57-02634") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "200 769") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "200 502") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "200 503") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "200 768") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "781101") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 24823") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 24817") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 24818") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JBU254") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JBU380") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JBU546") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1303") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0321") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0322") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1279") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "20858") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "20857") ) AND aa.Language = "ru" Продажа автозапчастей типа Подвеска / крепление ходовой части для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
3RG 50422 Подвеска, рычаг независимой подвески колеса
50421 Подвеска, рычаг независимой подвески колеса
A.B.S. 270238 Подвеска, рычаг независимой подвески колеса
270240 Подвеска, рычаг независимой подвески колеса
270241 Подвеска, рычаг независимой подвески колеса
270227 Подвеска, рычаг независимой подвески колеса
AYWIPARTS AW1420401 Подвеска, рычаг независимой подвески колеса
AW1420962 Подвеска, рычаг независимой подвески колеса
AW1420999 Подвеска, рычаг независимой подвески колеса
BBR Automotive 001-10-20714 Подвеска, рычаг независимой подвески колеса
BENDIX 045388B Подвеска, рычаг независимой подвески колеса
040069B Подвеска, рычаг независимой подвески колеса
045345B Подвеска, рычаг независимой подвески колеса
045369B Подвеска, рычаг независимой подвески колеса
040068B Подвеска, рычаг независимой подвески колеса
BIRTH 2281 Подвеска, рычаг независимой подвески колеса
2282 Подвеска, рычаг независимой подвески колеса
2347 Подвеска, рычаг независимой подвески колеса
BOGE 87-042-A Подвеска, рычаг независимой подвески колеса
87-426-A Подвеска, рычаг независимой подвески колеса
87-895-A Подвеска, рычаг независимой подвески колеса
BORG & BECK BSK6226 Подвеска, рычаг независимой подвески колеса
BSK6227 Подвеска, рычаг независимой подвески колеса
BSK6003 Подвеска, рычаг независимой подвески колеса
BSK6004 Подвеска, рычаг независимой подвески колеса
BSG BSG 65-700-065 Подвеска, рычаг независимой подвески колеса
BSG 65-700-085 Подвеска, рычаг независимой подвески колеса
BSG 65-700-086 Подвеска, рычаг независимой подвески колеса
BSG 65-700-064 Подвеска, рычаг независимой подвески колеса
CAUTEX 480516 Втулка, рычаг колесной подвески
480517 Втулка, рычаг колесной подвески
480528 Втулка, рычаг колесной подвески
CORTECO 21652930 Подвеска, рычаг независимой подвески колеса
21652937 Подвеска, рычаг независимой подвески колеса
21652929 Подвеска, рычаг независимой подвески колеса
CTE CBH15007 Подвеска, рычаг независимой подвески колеса
CBH15008 Подвеска, рычаг независимой подвески колеса
DELPHI TD769W Подвеска, рычаг независимой подвески колеса
TD310W Подвеска, рычаг независимой подвески колеса
TD311W Подвеска, рычаг независимой подвески колеса
TD541W Подвеска, рычаг независимой подвески колеса
DENCKERMANN D300055 Подвеска, рычаг независимой подвески колеса
D300056 Подвеска, рычаг независимой подвески колеса
DIEDERICHS 1184402 Подвеска, рычаг независимой подвески колеса
FAI AutoParts SS4341 Подвеска, рычаг независимой подвески колеса
FARE SA 2854 Подвеска, рычаг независимой подвески колеса
2847 Подвеска, рычаг независимой подвески колеса
FEBI BILSTEIN 04402 Подвеска, рычаг независимой подвески колеса
02183 Подвеска, рычаг независимой подвески колеса
02263 Подвеска, рычаг независимой подвески колеса
04390 Подвеска, рычаг независимой подвески колеса
FIRST LINE FSK6226 Подвеска, рычаг независимой подвески колеса
FSK6227 Подвеска, рычаг независимой подвески колеса
FSK6003 Подвеска, рычаг независимой подвески колеса
FSK6004 Подвеска, рычаг независимой подвески колеса
FLENNOR FL3988-J Подвеска, рычаг независимой подвески колеса
FL4097-J Подвеска, рычаг независимой подвески колеса
FL4098-J Подвеска, рычаг независимой подвески колеса
FL4226-J Подвеска, рычаг независимой подвески колеса
FORMPART 2000012 Подвеска, рычаг независимой подвески колеса
2000013 Подвеска, рычаг независимой подвески колеса
FORTUNE LINE FZ9442 Подвеска, рычаг независимой подвески колеса
FZ9444 Подвеска, рычаг независимой подвески колеса
GSP 510904 Подвеска, рычаг независимой подвески колеса
512462 Подвеска, рычаг независимой подвески колеса
510842 Втулка, рычаг колесной подвески
HUTCHINSON 590037 Подвеска, рычаг независимой подвески колеса
590047 Подвеска, рычаг независимой подвески колеса
590097 Подвеска, рычаг независимой подвески колеса
JP GROUP 1250300900 Подвеска, рычаг независимой подвески колеса
1240201600 Подвеска, рычаг независимой подвески колеса
1250300909 Подвеска, рычаг независимой подвески колеса
1240201609 Подвеска, рычаг независимой подвески колеса
1240202209 Подвеска, рычаг независимой подвески колеса
1240201500 Подвеска, рычаг независимой подвески колеса
KAMOKA 8800267 Подвеска, рычаг независимой подвески колеса
8800086 Подвеска, рычаг независимой подвески колеса
8800087 Подвеска, рычаг независимой подвески колеса
8800266 Подвеска, рычаг независимой подвески колеса
KRAFT AUTOMOTIVE 4231680 Подвеска, рычаг независимой подвески колеса
4231685 Подвеска, рычаг независимой подвески колеса
4231586 Подвеска, рычаг независимой подвески колеса
4231588 Подвеска, рычаг независимой подвески колеса
LEMFÖRDER 22116 01 Подвеска, рычаг независимой подвески колеса
26096 01 Подвеска, рычаг независимой подвески колеса
21776 02 Подвеска, рычаг независимой подвески колеса
LYNXauto C8544 Подвеска, рычаг независимой подвески колеса
C8545 Подвеска, рычаг независимой подвески колеса
C8541 Подвеска, рычаг независимой подвески колеса
C8543 Подвеска, рычаг независимой подвески колеса
MALÒ 237921 Подвеска, рычаг независимой подвески колеса
237931 Подвеска, рычаг независимой подвески колеса
MAPCO 33895 Подвеска, рычаг независимой подвески колеса
33848 Подвеска, рычаг независимой подвески колеса
33849 Подвеска, рычаг независимой подвески колеса
MASTER-SPORT 16063-PCS-MS Подвеска, рычаг независимой подвески колеса
21776-PCS-MS Подвеска, рычаг независимой подвески колеса
MAXGEAR 72-1250 Подвеска, рычаг независимой подвески колеса
72-1176 Подвеска, рычаг независимой подвески колеса
METZGER 52001708 Подвеска, рычаг независимой подвески колеса
52001808 Подвеска, рычаг независимой подвески колеса
MEYLE 614 042 0003 Втулка, рычаг колесной подвески
614 042 0004 Втулка, рычаг колесной подвески
614 035 0010 Втулка, рычаг колесной подвески
614 035 0016 Втулка, рычаг колесной подвески
MONROE L24818 Подвеска, рычаг независимой подвески колеса
L24823 Подвеска, рычаг независимой подвески колеса
L24817 Подвеска, рычаг независимой подвески колеса
MOOG OP-SB-3779 Подвеска, рычаг независимой подвески колеса
OP-SB-3813 Подвеска, рычаг независимой подвески колеса
OP-SB-1380 Подвеска, рычаг независимой подвески колеса
OP-SB-1382 Подвеска, рычаг независимой подвески колеса
NK 5103615 Подвеска, рычаг независимой подвески колеса
5103616 Подвеска, рычаг независимой подвески колеса
OCAP 1215522 Подвеска, рычаг независимой подвески колеса
1215523 Подвеска, рычаг независимой подвески колеса
OPTIMAL F8-5722 Подвеска, рычаг независимой подвески колеса
F8-5108 Подвеска, рычаг независимой подвески колеса
F8-5109 Подвеска, рычаг независимой подвески колеса
F8-5337 Подвеска, рычаг независимой подвески колеса
F8-4099 Подвеска, рычаг независимой подвески колеса
ORIGINAL IMPERIUM 1840 Подвеска, рычаг независимой подвески колеса
PATRON PSE1082 Подвеска, рычаг независимой подвески колеса
PROFIT 2307-0072 Подвеска, рычаг независимой подвески колеса
2307-0204 Подвеска, рычаг независимой подвески колеса
2307-0236 Подвеска, рычаг независимой подвески колеса
2307-0067 Подвеска, рычаг независимой подвески колеса
QUICK STEER SB7501 Подвеска, рычаг независимой подвески колеса
SB7452 Подвеска, рычаг независимой подвески колеса
QUINTON HAZELL EMS1988 Подвеска, рычаг независимой подвески колеса
EMS8033 Подвеска, рычаг независимой подвески колеса
EMS8127 Подвеска, рычаг независимой подвески колеса
RIW OP11011 Подвеска, рычаг независимой подвески колеса
OP11010 Подвеска, рычаг независимой подвески колеса
RUVILLE 985329 Подвеска, рычаг независимой подвески колеса
985357 Подвеска, рычаг независимой подвески колеса
985335 Подвеска, рычаг независимой подвески колеса
985360 Подвеска, рычаг независимой подвески колеса
985353 Подвеска, рычаг независимой подвески колеса
985356 Подвеска, рычаг независимой подвески колеса
sbs 19125103616 Подвеска, рычаг независимой подвески колеса
19125103615 Подвеска, рычаг независимой подвески колеса
SIDEM 809624 Подвеска, рычаг независимой подвески колеса
809625 Подвеска, рычаг независимой подвески колеса
809626 Подвеска, рычаг независимой подвески колеса
809622 Подвеска, рычаг независимой подвески колеса
STELLOX 74-21742-SX Подвеска, рычаг независимой подвески колеса
74-22025-SX Подвеска, рычаг независимой подвески колеса
SWAG 40 60 0014 Подвеска, рычаг независимой подвески колеса
40 79 0011 Подвеска, рычаг независимой подвески колеса
40 79 0012 Подвеска, рычаг независимой подвески колеса
40 60 0009 Подвеска, рычаг независимой подвески колеса
TALOSA 57-05768 Подвеска, рычаг независимой подвески колеса
57-00403 Подвеска, рычаг независимой подвески колеса
57-06495 Подвеска, рычаг независимой подвески колеса
57-02633 Подвеска, рычаг независимой подвески колеса
57-02634 Подвеска, рычаг независимой подвески колеса
TOPRAN 200 769 Подвеска, рычаг независимой подвески колеса
200 502 Подвеска, рычаг независимой подвески колеса
200 503 Подвеска, рычаг независимой подвески колеса
200 768 Подвеска, рычаг независимой подвески колеса
TRICLO 781101 Подвеска, рычаг независимой подвески колеса
TRISCAN 8500 24823 Подвеска, рычаг независимой подвески колеса
8500 24817 Подвеска, рычаг независимой подвески колеса
8500 24818 Подвеска, рычаг независимой подвески колеса
TRW JBU254 Подвеска, рычаг независимой подвески колеса
JBU380 Подвеска, рычаг независимой подвески колеса
JBU546 Подвеска, рычаг независимой подвески колеса
VAICO V40-1303 Подвеска, рычаг независимой подвески колеса
V40-0321 Подвеска, рычаг независимой подвески колеса
V40-0322 Подвеска, рычаг независимой подвески колеса
V40-1279 Подвеска, рычаг независимой подвески колеса
VEMA 20858 Подвеска, рычаг независимой подвески колеса
20857 Подвеска, рычаг независимой подвески колеса
2026 CATCAR.INFO (v 2.0)