#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUyNXx8bW9kZWxfaWQ9PTI2MHx8bWRmX2lkPT0wXjE1NDR8fHNwYXJlX2lkPT0xMDAxMzM%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 = "1544" AND ( (av.SupplierID = 257 AND av.DataSupplierArticleNumber = "SA-X50C" AND av.ProductID IN (298)) OR (av.SupplierID = 257 AND av.DataSupplierArticleNumber = "SA-F35" AND av.ProductID IN (298)) OR (av.SupplierID = 257 AND av.DataSupplierArticleNumber = "SA-X50S" AND av.ProductID IN (298)) OR (av.SupplierID = 257 AND av.DataSupplierArticleNumber = "SA-F50" AND av.ProductID IN (298)) OR (av.SupplierID = 257 AND av.DataSupplierArticleNumber = "SA-X35C" AND av.ProductID IN (298)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "WAF20" AND av.ProductID IN (298)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "WA013" AND av.ProductID IN (298)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "WA020" AND av.ProductID IN (298)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "WA020S" AND av.ProductID IN (298)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "WBC500" AND av.ProductID IN (298)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "WBF330" AND av.ProductID IN (298)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "WBX600" AND av.ProductID IN (299)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "WBH350" AND av.ProductID IN (298)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "WBC330" AND av.ProductID IN (298)) OR (av.SupplierID = 4943 AND av.DataSupplierArticleNumber = "AW2010050" AND av.ProductID IN (298)) OR (av.SupplierID = 4943 AND av.DataSupplierArticleNumber = "AW2020050" AND av.ProductID IN (298)) OR (av.SupplierID = 4943 AND av.DataSupplierArticleNumber = "AW2040050" AND av.ProductID IN (298)) OR (av.SupplierID = 4943 AND av.DataSupplierArticleNumber = "AW2010033" AND av.ProductID IN (298)) OR (av.SupplierID = 11 AND av.DataSupplierArticleNumber = "WB15" AND av.ProductID IN (298)) OR (av.SupplierID = 11 AND av.DataSupplierArticleNumber = "WB1" AND av.ProductID IN (298)) OR (av.SupplierID = 11 AND av.DataSupplierArticleNumber = "WB7" AND av.ProductID IN (298)) OR (av.SupplierID = 11 AND av.DataSupplierArticleNumber = "WB105" AND av.ProductID IN (298)) OR (av.SupplierID = 11 AND av.DataSupplierArticleNumber = "WB111" AND av.ProductID IN (298)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BW20C" AND av.ProductID IN (298)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BW20S" AND av.ProductID IN (298)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 397 005 161" AND av.ProductID IN (298)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 397 118 560" AND av.ProductID IN (298)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 397 118 561" AND av.ProductID IN (298)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 397 004 670" AND av.ProductID IN (298)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 15-992-001" AND av.ProductID IN (298)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "79040051" AND av.ProductID IN (299)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "E51/B01" AND av.ProductID IN (298)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "A51/B01" AND av.ProductID IN (298)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "AS51/B01" AND av.ProductID IN (298)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "E33/B01" AND av.ProductID IN (298)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "A33/B01" AND av.ProductID IN (298)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DU-035L" AND av.ProductID IN (298)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DM-550" AND av.ProductID IN (298)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DU-035R" AND av.ProductID IN (298)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DMC-550" AND av.ProductID IN (298)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DMS-550" AND av.ProductID IN (298)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DM-035" AND av.ProductID IN (298)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "B330" AND av.ProductID IN (298)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "B500" AND av.ProductID IN (298)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "OF50A" AND av.ProductID IN (298)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "500DH" AND av.ProductID IN (298)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "500DC" AND av.ProductID IN (298)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "500DF" AND av.ProductID IN (298)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LWFB20" AND av.ProductID IN (298)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLWEB20" AND av.ProductID IN (298)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLWFB20" AND av.ProductID IN (298)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "EWCB20" AND av.ProductID IN (298)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LWCB20" AND av.ProductID IN (298)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "EWFB20" AND av.ProductID IN (298)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT93231" AND av.ProductID IN (298)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT93247" AND av.ProductID IN (298)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FW330E" AND av.ProductID IN (298)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FW500E" AND av.ProductID IN (298)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FW500M" AND av.ProductID IN (298)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9XW 178 878-141" AND av.ProductID IN (298)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9XW 860 660-801" AND av.ProductID IN (298)) OR (av.SupplierID = 156 AND av.DataSupplierArticleNumber = "SS-X50S" AND av.ProductID IN (298)) OR (av.SupplierID = 156 AND av.DataSupplierArticleNumber = "SS-F50" AND av.ProductID IN (298)) OR (av.SupplierID = 156 AND av.DataSupplierArticleNumber = "SS-X35C" AND av.ProductID IN (298)) OR (av.SupplierID = 156 AND av.DataSupplierArticleNumber = "SS-X50C" AND av.ProductID IN (298)) OR (av.SupplierID = 156 AND av.DataSupplierArticleNumber = "SS-F35" AND av.ProductID IN (298)) OR (av.SupplierID = 481 AND av.DataSupplierArticleNumber = "SJX50C" AND av.ProductID IN (298)) OR (av.SupplierID = 481 AND av.DataSupplierArticleNumber = "SJF35" AND av.ProductID IN (298)) OR (av.SupplierID = 481 AND av.DataSupplierArticleNumber = "SJX50S" AND av.ProductID IN (298)) OR (av.SupplierID = 481 AND av.DataSupplierArticleNumber = "SJF50" AND av.ProductID IN (298)) OR (av.SupplierID = 481 AND av.DataSupplierArticleNumber = "SJX35C" AND av.ProductID IN (298)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "27500U" AND av.ProductID IN (298)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "26500" AND av.ProductID IN (298)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "27500" AND av.ProductID IN (298)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "KS51" AND av.ProductID IN (298)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "K51" AND av.ProductID IN (298)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "K5151" AND av.ProductID IN (298)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "330L" AND av.ProductID IN (298)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "LW500" AND av.ProductID IN (298)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "500L" AND av.ProductID IN (298)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "LX500" AND av.ProductID IN (298)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "500LS" AND av.ProductID IN (298)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "XF500" AND av.ProductID IN (298)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "LW330" AND av.ProductID IN (298)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "000723111019" AND av.ProductID IN (298)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "000723112400" AND av.ProductID IN (298)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "000723133300" AND av.ProductID IN (298)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "000723110500" AND av.ProductID IN (298)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "104500HPS" AND av.ProductID IN (298)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "104500/2HPS" AND av.ProductID IN (298)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "13-SET/2/-MS" AND av.ProductID IN (298)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "39-0129" AND av.ProductID IN (298)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "39-0304" AND av.ProductID IN (298)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "39-0310" AND av.ProductID IN (298)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "39-0077" AND av.ProductID IN (298)) OR (av.SupplierID = 4773 AND av.DataSupplierArticleNumber = "MWL-8350" AND av.ProductID IN (298)) OR (av.SupplierID = 4773 AND av.DataSupplierArticleNumber = "MWL-8500" AND av.ProductID IN (298)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVWB1020" AND av.ProductID IN (298)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVWB9119" AND av.ProductID IN (298)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DM-035" AND av.ProductID IN (298)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DMS-550" AND av.ProductID IN (298)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DM-550" AND av.ProductID IN (298)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DU-035L" AND av.ProductID IN (298)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DM-560" AND av.ProductID IN (298)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DU-035R" AND av.ProductID IN (298)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DMC-550" AND av.ProductID IN (298)) OR (av.SupplierID = 145 AND av.DataSupplierArticleNumber = "27-020V" AND av.ProductID IN (298)) OR (av.SupplierID = 145 AND av.DataSupplierArticleNumber = "EUS-520" AND av.ProductID IN (298)) OR (av.SupplierID = 145 AND av.DataSupplierArticleNumber = "27-015" AND av.ProductID IN (298)) OR (av.SupplierID = 145 AND av.DataSupplierArticleNumber = "27-020" AND av.ProductID IN (298)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "WBS0020.00" AND av.ProductID IN (298)) OR (av.SupplierID = 4520 AND av.DataSupplierArticleNumber = "PR-33" AND av.ProductID IN (298)) OR (av.SupplierID = 4520 AND av.DataSupplierArticleNumber = "PR-50S" AND av.ProductID IN (298)) OR (av.SupplierID = 4520 AND av.DataSupplierArticleNumber = "PR-50" AND av.ProductID IN (298)) OR (av.SupplierID = 4520 AND av.DataSupplierArticleNumber = "PR-50F" AND av.ProductID IN (298)) OR (av.SupplierID = 4520 AND av.DataSupplierArticleNumber = "PR-50H" AND av.ProductID IN (298)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QAW020" AND av.ProductID IN (298)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "ESTOCADA 9409" AND av.ProductID IN (298)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "ESTOCADA 9410" AND av.ProductID IN (298)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "9409-9409" AND av.ProductID IN (298)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "9410-9410" AND av.ProductID IN (298)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "101 500-SX" AND av.ProductID IN (298)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "102 500-SX" AND av.ProductID IN (298)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "103 500-SX" AND av.ProductID IN (298)) OR (av.SupplierID = 19 AND av.DataSupplierArticleNumber = "116220" AND av.ProductID IN (298)) OR (av.SupplierID = 19 AND av.DataSupplierArticleNumber = "116604" AND av.ProductID IN (298)) OR (av.SupplierID = 19 AND av.DataSupplierArticleNumber = "119850" AND av.ProductID IN (298)) OR (av.SupplierID = 19 AND av.DataSupplierArticleNumber = "116112" AND av.ProductID IN (298)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "300 054" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "TF500R" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "T330" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "ES500R" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "EF330" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "T500" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "FX500" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "EF500" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "TF500L" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "NF500" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "ES500L" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "35-200" AND av.ProductID IN (298)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "4910 610" AND av.ProductID IN (299)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.58.429" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "574107" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "675535" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "576001" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "575551" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "575535" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "574116" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "675550" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "576007" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "575785" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "575536" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "574171" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "576075" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "575795" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "575550" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "574189" AND av.ProductID IN (298)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1482017" AND av.ProductID IN (298)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1482021" AND av.ProductID IN (298)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1482014" AND av.ProductID IN (298)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "BW-500" AND av.ProductID IN (298)) ) 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 = 257 AND aa.DataSupplierArticleNumber = "SA-X50C") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "SA-F35") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "SA-X50S") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "SA-F50") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "SA-X35C") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "WAF20") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "WA013") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "WA020") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "WA020S") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "WBC500") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "WBF330") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "WBX600") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "WBH350") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "WBC330") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW2010050") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW2020050") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW2040050") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW2010033") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "WB15") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "WB1") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "WB7") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "WB105") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "WB111") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BW20C") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BW20S") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 005 161") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 118 560") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 118 561") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 004 670") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 15-992-001") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79040051") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "E51/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "A51/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "AS51/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "E33/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "A33/B01") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DU-035L") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DM-550") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DU-035R") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DMC-550") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DMS-550") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DM-035") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "B330") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "B500") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "OF50A") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "500DH") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "500DC") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "500DF") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LWFB20") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLWEB20") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLWFB20") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "EWCB20") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LWCB20") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "EWFB20") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT93231") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT93247") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FW330E") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FW500E") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FW500M") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XW 178 878-141") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XW 860 660-801") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "SS-X50S") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "SS-F50") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "SS-X35C") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "SS-X50C") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "SS-F35") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "SJX50C") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "SJF35") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "SJX50S") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "SJF50") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "SJX35C") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "27500U") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "26500") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "27500") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "KS51") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "K51") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "K5151") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "330L") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "LW500") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "500L") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "LX500") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "500LS") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "XF500") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "LW330") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "000723111019") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "000723112400") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "000723133300") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "000723110500") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "104500HPS") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "104500/2HPS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "13-SET/2/-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "39-0129") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "39-0304") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "39-0310") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "39-0077") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MWL-8350") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MWL-8500") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVWB1020") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVWB9119") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DM-035") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DMS-550") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DM-550") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DU-035L") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DM-560") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DU-035R") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DMC-550") OR (aa.SupplierID = 145 AND aa.DataSupplierArticleNumber = "27-020V") OR (aa.SupplierID = 145 AND aa.DataSupplierArticleNumber = "EUS-520") OR (aa.SupplierID = 145 AND aa.DataSupplierArticleNumber = "27-015") OR (aa.SupplierID = 145 AND aa.DataSupplierArticleNumber = "27-020") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "WBS0020.00") OR (aa.SupplierID = 4520 AND aa.DataSupplierArticleNumber = "PR-33") OR (aa.SupplierID = 4520 AND aa.DataSupplierArticleNumber = "PR-50S") OR (aa.SupplierID = 4520 AND aa.DataSupplierArticleNumber = "PR-50") OR (aa.SupplierID = 4520 AND aa.DataSupplierArticleNumber = "PR-50F") OR (aa.SupplierID = 4520 AND aa.DataSupplierArticleNumber = "PR-50H") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QAW020") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "ESTOCADA 9409") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "ESTOCADA 9410") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "9409-9409") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "9410-9410") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "101 500-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "102 500-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "103 500-SX") OR (aa.SupplierID = 19 AND aa.DataSupplierArticleNumber = "116220") OR (aa.SupplierID = 19 AND aa.DataSupplierArticleNumber = "116604") OR (aa.SupplierID = 19 AND aa.DataSupplierArticleNumber = "119850") OR (aa.SupplierID = 19 AND aa.DataSupplierArticleNumber = "116112") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "300 054") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TF500R") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "T330") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "ES500R") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "EF330") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "T500") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "FX500") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "EF500") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TF500L") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "NF500") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "ES500L") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "35-200") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "4910 610") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.58.429") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "574107") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "675535") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "576001") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "575551") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "575535") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "574116") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "675550") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "576007") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "575785") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "575536") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "574171") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "576075") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "575795") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "575550") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "574189") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1482017") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1482021") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1482014") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "BW-500") ) 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 = 257 AND aa.DataSupplierArticleNumber = "SA-X50C") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "SA-F35") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "SA-X50S") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "SA-F50") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "SA-X35C") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "WAF20") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "WA013") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "WA020") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "WA020S") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "WBC500") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "WBF330") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "WBX600") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "WBH350") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "WBC330") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW2010050") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW2020050") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW2040050") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW2010033") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "WB15") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "WB1") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "WB7") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "WB105") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "WB111") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BW20C") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BW20S") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 005 161") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 118 560") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 118 561") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 004 670") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 15-992-001") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79040051") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "E51/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "A51/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "AS51/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "E33/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "A33/B01") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DU-035L") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DM-550") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DU-035R") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DMC-550") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DMS-550") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DM-035") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "B330") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "B500") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "OF50A") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "500DH") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "500DC") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "500DF") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LWFB20") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLWEB20") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLWFB20") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "EWCB20") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LWCB20") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "EWFB20") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT93231") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT93247") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FW330E") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FW500E") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FW500M") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XW 178 878-141") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XW 860 660-801") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "SS-X50S") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "SS-F50") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "SS-X35C") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "SS-X50C") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "SS-F35") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "SJX50C") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "SJF35") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "SJX50S") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "SJF50") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "SJX35C") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "27500U") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "26500") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "27500") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "KS51") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "K51") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "K5151") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "330L") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "LW500") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "500L") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "LX500") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "500LS") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "XF500") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "LW330") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "000723111019") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "000723112400") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "000723133300") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "000723110500") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "104500HPS") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "104500/2HPS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "13-SET/2/-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "39-0129") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "39-0304") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "39-0310") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "39-0077") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MWL-8350") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MWL-8500") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVWB1020") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVWB9119") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DM-035") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DMS-550") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DM-550") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DU-035L") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DM-560") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DU-035R") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DMC-550") OR (aa.SupplierID = 145 AND aa.DataSupplierArticleNumber = "27-020V") OR (aa.SupplierID = 145 AND aa.DataSupplierArticleNumber = "EUS-520") OR (aa.SupplierID = 145 AND aa.DataSupplierArticleNumber = "27-015") OR (aa.SupplierID = 145 AND aa.DataSupplierArticleNumber = "27-020") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "WBS0020.00") OR (aa.SupplierID = 4520 AND aa.DataSupplierArticleNumber = "PR-33") OR (aa.SupplierID = 4520 AND aa.DataSupplierArticleNumber = "PR-50S") OR (aa.SupplierID = 4520 AND aa.DataSupplierArticleNumber = "PR-50") OR (aa.SupplierID = 4520 AND aa.DataSupplierArticleNumber = "PR-50F") OR (aa.SupplierID = 4520 AND aa.DataSupplierArticleNumber = "PR-50H") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QAW020") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "ESTOCADA 9409") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "ESTOCADA 9410") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "9409-9409") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "9410-9410") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "101 500-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "102 500-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "103 500-SX") OR (aa.SupplierID = 19 AND aa.DataSupplierArticleNumber = "116220") OR (aa.SupplierID = 19 AND aa.DataSupplierArticleNumber = "116604") OR (aa.SupplierID = 19 AND aa.DataSupplierArticleNumber = "119850") OR (aa.SupplierID = 19 AND aa.DataSupplierArticleNumber = "116112") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "300 054") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TF500R") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "T330") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "ES500R") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "EF330") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "T500") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "FX500") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "EF500") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TF500L") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "NF500") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "ES500L") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "35-200") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "4910 610") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.58.429") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "574107") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "675535") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "576001") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "575551") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "575535") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "574116") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "675550") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "576007") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "575785") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "575536") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "574171") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "576075") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "575795") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "575550") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "574189") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1482017") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1482021") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1482014") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "BW-500") ) AND aa.Language = "ru" Продажа автозапчастей типа Стеклоочиститель / резина для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ASHIKA SA-X50C Щетка стеклоочистителя
SA-F35 Щетка стеклоочистителя
SA-X50S Щетка стеклоочистителя
SA-F50 Щетка стеклоочистителя
SA-X35C Щетка стеклоочистителя
ASHUKI WAF20 Щетка стеклоочистителя
WA013 Щетка стеклоочистителя
WA020 Щетка стеклоочистителя
WA020S Щетка стеклоочистителя
AUTOTEAM WBC500 Щетка стеклоочистителя
WBF330 Щетка стеклоочистителя
WBX600 Резинка стеклоочистителя
WBH350 Щетка стеклоочистителя
WBC330 Щетка стеклоочистителя
AYWIPARTS AW2010050 Щетка стеклоочистителя
AW2020050 Щетка стеклоочистителя
AW2040050 Щетка стеклоочистителя
AW2010033 Щетка стеклоочистителя
BERU WB15 Щетка стеклоочистителя
WB1 Щетка стеклоочистителя
WB7 Щетка стеклоочистителя
WB105 Щетка стеклоочистителя
WB111 Щетка стеклоочистителя
BORG & BECK BW20C Щетка стеклоочистителя
BW20S Щетка стеклоочистителя
BOSCH 3 397 005 161 Щетка стеклоочистителя
3 397 118 560 Щетка стеклоочистителя
3 397 118 561 Щетка стеклоочистителя
3 397 004 670 Щетка стеклоочистителя
BSG BSG 15-992-001 Щетка стеклоочистителя
CARPRISS 79040051 Резинка стеклоочистителя
CHAMPION E51/B01 Щетка стеклоочистителя
A51/B01 Щетка стеклоочистителя
AS51/B01 Щетка стеклоочистителя
E33/B01 Щетка стеклоочистителя
A33/B01 Щетка стеклоочистителя
DENSO DU-035L Щетка стеклоочистителя
DM-550 Щетка стеклоочистителя
DU-035R Щетка стеклоочистителя
DMC-550 Щетка стеклоочистителя
DMS-550 Щетка стеклоочистителя
DM-035 Щетка стеклоочистителя
DOGA B330 Щетка стеклоочистителя
B500 Щетка стеклоочистителя
OF50A Щетка стеклоочистителя
DYNAMATRIX 500DH Щетка стеклоочистителя
500DC Щетка стеклоочистителя
500DF Щетка стеклоочистителя
ELTA AUTOMOTIVE LWFB20 Щетка стеклоочистителя
LLWEB20 Щетка стеклоочистителя
LLWFB20 Щетка стеклоочистителя
EWCB20 Щетка стеклоочистителя
LWCB20 Щетка стеклоочистителя
EWFB20 Щетка стеклоочистителя
FAST FT93231 Щетка стеклоочистителя
FT93247 Щетка стеклоочистителя
FLENNOR FW330E Щетка стеклоочистителя
FW500E Щетка стеклоочистителя
FW500M Щетка стеклоочистителя
HELLA 9XW 178 878-141 Щетка стеклоочистителя
9XW 860 660-801 Щетка стеклоочистителя
JAPANPARTS SS-X50S Щетка стеклоочистителя
SS-F50 Щетка стеклоочистителя
SS-X35C Щетка стеклоочистителя
SS-X50C Щетка стеклоочистителя
SS-F35 Щетка стеклоочистителя
JAPKO SJX50C Щетка стеклоочистителя
SJF35 Щетка стеклоочистителя
SJX50S Щетка стеклоочистителя
SJF50 Щетка стеклоочистителя
SJX35C Щетка стеклоочистителя
KAMOKA 27500U Щетка стеклоочистителя
26500 Щетка стеклоочистителя
27500 Щетка стеклоочистителя
KRAFT AUTOMOTIVE KS51 Щетка стеклоочистителя
K51 Щетка стеклоочистителя
K5151 Щетка стеклоочистителя
LYNXauto 330L Щетка стеклоочистителя
LW500 Щетка стеклоочистителя
500L Щетка стеклоочистителя
LX500 Щетка стеклоочистителя
500LS Щетка стеклоочистителя
XF500 Щетка стеклоочистителя
LW330 Щетка стеклоочистителя
MAGNETI MARELLI 000723111019 Щетка стеклоочистителя
000723112400 Щетка стеклоочистителя
000723133300 Щетка стеклоочистителя
000723110500 Щетка стеклоочистителя
MAPCO 104500HPS Щетка стеклоочистителя
104500/2HPS Щетка стеклоочистителя
MASTER-SPORT 13-SET/2/-MS Щетка стеклоочистителя
MAXGEAR 39-0129 Щетка стеклоочистителя
39-0304 Щетка стеклоочистителя
39-0310 Щетка стеклоочистителя
39-0077 Щетка стеклоочистителя
MDR MWL-8350 Щетка стеклоочистителя
MWL-8500 Щетка стеклоочистителя
MOTAQUIP LVWB1020 Щетка стеклоочистителя
LVWB9119 Щетка стеклоочистителя
NPS DM-035 Щетка стеклоочистителя
DMS-550 Щетка стеклоочистителя
DM-550 Щетка стеклоочистителя
DU-035L Щетка стеклоочистителя
DM-560 Щетка стеклоочистителя
DU-035R Щетка стеклоочистителя
DMC-550 Щетка стеклоочистителя
NWB 27-020V Щетка стеклоочистителя
EUS-520 Щетка стеклоочистителя
27-015 Щетка стеклоочистителя
27-020 Щетка стеклоочистителя
OPEN PARTS WBS0020.00 Щетка стеклоочистителя
PROTECHNIC PR-33 Щетка стеклоочистителя
PR-50S Щетка стеклоочистителя
PR-50 Щетка стеклоочистителя
PR-50F Щетка стеклоочистителя
PR-50H Щетка стеклоочистителя
QUINTON HAZELL QAW020 Щетка стеклоочистителя
SCT Germany ESTOCADA 9409 Щетка стеклоочистителя
ESTOCADA 9410 Щетка стеклоочистителя
9409-9409 Щетка стеклоочистителя
9410-9410 Щетка стеклоочистителя
STELLOX 101 500-SX Щетка стеклоочистителя
102 500-SX Щетка стеклоочистителя
103 500-SX Щетка стеклоочистителя
SWF 116220 Щетка стеклоочистителя
116604 Щетка стеклоочистителя
119850 Щетка стеклоочистителя
116112 Щетка стеклоочистителя
TOPRAN 300 054 Щетка стеклоочистителя
TRICO TF500R Щетка стеклоочистителя
T330 Щетка стеклоочистителя
ES500R Щетка стеклоочистителя
EF330 Щетка стеклоочистителя
T500 Щетка стеклоочистителя
FX500 Щетка стеклоочистителя
EF500 Щетка стеклоочистителя
TF500L Щетка стеклоочистителя
NF500 Щетка стеклоочистителя
ES500L Щетка стеклоочистителя
35-200 Щетка стеклоочистителя
TRISCAN 4910 610 Резинка стеклоочистителя
TRUCKTEC AUTOMOTIVE 02.58.429 Щетка стеклоочистителя
VALEO 574107 Щетка стеклоочистителя
675535 Щетка стеклоочистителя
576001 Щетка стеклоочистителя
575551 Щетка стеклоочистителя
575535 Щетка стеклоочистителя
574116 Щетка стеклоочистителя
675550 Щетка стеклоочистителя
576007 Щетка стеклоочистителя
575785 Щетка стеклоочистителя
575536 Щетка стеклоочистителя
574171 Щетка стеклоочистителя
576075 Щетка стеклоочистителя
575795 Щетка стеклоочистителя
575550 Щетка стеклоочистителя
574189 Щетка стеклоочистителя
WILMINK GROUP WG1482017 Щетка стеклоочистителя
WG1482021 Щетка стеклоочистителя
WG1482014 Щетка стеклоочистителя
ZEKKERT BW-500 Щетка стеклоочистителя
2026 CATCAR.INFO (v 2.0)