#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTE0NDd8fG1kZl9pZD09MF41MDI2fHxzcGFyZV9pZD09MTAwNzU0&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 = "5026" AND ( (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "AS2101" AND av.ProductID IN (805)) OR (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "AS2102" AND av.ProductID IN (805)) OR (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "AS4610" AND av.ProductID IN (3921)) OR (av.SupplierID = 11 AND av.DataSupplierArticleNumber = "SPR017" AND av.ProductID IN (805)) OR (av.SupplierID = 11 AND av.DataSupplierArticleNumber = "ST115" AND av.ProductID IN (830)) OR (av.SupplierID = 11 AND av.DataSupplierArticleNumber = "SPR004" AND av.ProductID IN (805)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "1 237 011 123" AND av.ProductID IN (3896,834)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 986 344 082" AND av.ProductID IN (805)) OR (av.SupplierID = 211 AND av.DataSupplierArticleNumber = "160903" AND av.ProductID IN (932)) OR (av.SupplierID = 47 AND av.DataSupplierArticleNumber = "16521" AND av.ProductID IN (834)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-840-042" AND av.ProductID IN (805)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-840-040" AND av.ProductID IN (805)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "SW90009" AND av.ProductID IN (805)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TS10245-12B1" AND av.ProductID IN (830)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "SW90030" AND av.ProductID IN (805)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "SW90005" AND av.ProductID IN (805)) OR (av.SupplierID = 4345 AND av.DataSupplierArticleNumber = "1040300002" AND av.ProductID IN (830)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "XOS8226" AND av.ProductID IN (162)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "550207" AND av.ProductID IN (3921)) OR (av.SupplierID = 240 AND av.DataSupplierArticleNumber = "11070" AND av.ProductID IN (805)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "08485" AND av.ProductID IN (805)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "08444" AND av.ProductID IN (805)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "08466" AND av.ProductID IN (805)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "33825" AND av.ProductID IN (829)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "01939" AND av.ProductID IN (830)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "6ZL 003 259-441" AND av.ProductID IN (805)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "70541050" AND av.ProductID IN (805)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "70511509" AND av.ProductID IN (830)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "70541051" AND av.ProductID IN (805)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "70620008" AND av.ProductID IN (3921)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "70541001" AND av.ProductID IN (805)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "70511043" AND av.ProductID IN (830)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "70541065" AND av.ProductID IN (805)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "70541049" AND av.ProductID IN (805)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "70511153" AND av.ProductID IN (830)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1193100600" AND av.ProductID IN (830)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1193501100" AND av.ProductID IN (805)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1191400200" AND av.ProductID IN (834)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1193200700" AND av.ProductID IN (830)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1193500100" AND av.ProductID IN (805)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1193100500" AND av.ProductID IN (830)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1193500400" AND av.ProductID IN (805)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "111002" AND av.ProductID IN (3921)) OR (av.SupplierID = 445 AND av.DataSupplierArticleNumber = "330028" AND av.ProductID IN (3922)) OR (av.SupplierID = 445 AND av.DataSupplierArticleNumber = "330030" AND av.ProductID IN (3922)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "510050010400" AND av.ProductID IN (805)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "88805" AND av.ProductID IN (830)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0910020" AND av.ProductID IN (805)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0910021" AND av.ProductID IN (805)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0905099" AND av.ProductID IN (830)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0910026" AND av.ProductID IN (805)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0910019" AND av.ProductID IN (805)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0907032" AND av.ProductID IN (3921)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 191 0002" AND av.ProductID IN (830)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 919 0015" AND av.ProductID IN (830)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVRP209" AND av.ProductID IN (805)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVIM190" AND av.ProductID IN (932)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVCT327" AND av.ProductID IN (830)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVRP237" AND av.ProductID IN (805)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVRP121" AND av.ProductID IN (805)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVCT421" AND av.ProductID IN (830)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVRP341" AND av.ProductID IN (805)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVRP188" AND av.ProductID IN (805)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVCT423" AND av.ProductID IN (830)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVIM103" AND av.ProductID IN (932)) OR (av.SupplierID = 4683 AND av.DataSupplierArticleNumber = "00393" AND av.ProductID IN (805)) OR (av.SupplierID = 5 AND av.DataSupplierArticleNumber = "7.02604.01.0" AND av.ProductID IN (3922)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XOPS90" AND av.ProductID IN (805)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XTT99" AND av.ProductID IN (830)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XOPS55" AND av.ProductID IN (805)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XEI4" AND av.ProductID IN (932)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XOPS6" AND av.ProductID IN (805)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XTT30" AND av.ProductID IN (830)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XOPS79" AND av.ProductID IN (805)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XTT98" AND av.ProductID IN (830)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XOPS29" AND av.ProductID IN (805)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XEI20" AND av.ProductID IN (932)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "52301" AND av.ProductID IN (830,830)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "WTS018W" AND av.ProductID IN (830,830)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "51030" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "OPS2049" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "SOP014" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "WS1042" AND av.ProductID IN (830,830)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "50970" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LOPS104" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "SOP007" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "STT044" AND av.ProductID IN (830,830)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LOPS042" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "SOP005" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "STT011" AND av.ProductID IN (830,830)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LOPS037" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "OPS2176" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "52310" AND av.ProductID IN (830,830)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "51177" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "IPC005" AND av.ProductID IN (834,834)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "OPS2061" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "52302" AND av.ProductID IN (830,830)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "51031" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "OPS2051" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "SOP019" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "WS1041" AND av.ProductID IN (830,830)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "50950" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LOPS043" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "SOP006" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "STT007" AND av.ProductID IN (830,830)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LOPS035" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "OPS2062" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "14007" AND av.ProductID IN (834,834)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "06-04027-SX" AND av.ProductID IN (830)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "06-08000-SX" AND av.ProductID IN (162)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 23 0004" AND av.ProductID IN (805)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "99 90 1939" AND av.ProductID IN (830)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 3825" AND av.ProductID IN (829)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 23 0001" AND av.ProductID IN (805)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 23 0002" AND av.ProductID IN (805)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "101 508" AND av.ProductID IN (805)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "103 326" AND av.ProductID IN (830)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "101 106" AND av.ProductID IN (805)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "100 684" AND av.ProductID IN (830)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "103 327" AND av.ProductID IN (830)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "101 107" AND av.ProductID IN (805)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "100 685" AND av.ProductID IN (830)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "100 665" AND av.ProductID IN (834)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "101 507" AND av.ProductID IN (805)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "100 853" AND av.ProductID IN (830)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "100 345" AND av.ProductID IN (805)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.42.006" AND av.ProductID IN (830)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.42.007" AND av.ProductID IN (830)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.42.018" AND av.ProductID IN (805)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.42.019" AND av.ProductID IN (805)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "700044" AND av.ProductID IN (830)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "245519" AND av.ProductID IN (932)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "245521" AND av.ProductID IN (932)) OR (av.SupplierID = 83 AND av.DataSupplierArticleNumber = "G855302990800Z" AND av.ProductID IN (3921)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V45-73-0002" AND av.ProductID IN (805)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-99-1992" AND av.ProductID IN (805)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-77-0001" AND av.ProductID IN (830)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-99-1993" AND av.ProductID IN (805)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-99-1989" AND av.ProductID IN (830)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V10-76-0098" AND av.ProductID IN (3922)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-99-1995" AND av.ProductID IN (805)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99190072201" AND av.ProductID IN (805)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99190078101" AND av.ProductID IN (830)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99190072401" AND av.ProductID IN (805)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99190078801" AND av.ProductID IN (830)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99190070701" AND av.ProductID IN (805)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99590377201" AND av.ProductID IN (830)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99190071901" AND av.ProductID IN (805)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1032805" AND av.ProductID IN (3921)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1432721" AND av.ProductID IN (830)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1791563" AND av.ProductID IN (932)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1432812" AND av.ProductID IN (829)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1791565" AND av.ProductID IN (932)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1025954" AND av.ProductID IN (3922)) ) UNION ALL SELECT CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber) as article_id, if (aa.Description = "", aa.DisplayTitle, aa.Description) as crit_designation, aa.DisplayValue as crit_value, "" crit_unit, 1 criteria_art, "articleattributes" as source FROM articleattributes aa WHERE ( (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "AS2101") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "AS2102") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "AS4610") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "SPR017") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "ST115") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "SPR004") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "1 237 011 123") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 986 344 082") OR (aa.SupplierID = 211 AND aa.DataSupplierArticleNumber = "160903") OR (aa.SupplierID = 47 AND aa.DataSupplierArticleNumber = "16521") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-840-042") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-840-040") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "SW90009") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TS10245-12B1") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "SW90030") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "SW90005") OR (aa.SupplierID = 4345 AND aa.DataSupplierArticleNumber = "1040300002") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "XOS8226") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "550207") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "11070") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "08485") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "08444") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "08466") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "33825") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "01939") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZL 003 259-441") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70541050") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70511509") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70541051") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70620008") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70541001") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70511043") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70541065") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70541049") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70511153") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193100600") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193501100") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1191400200") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193200700") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193500100") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193100500") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193500400") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "111002") OR (aa.SupplierID = 445 AND aa.DataSupplierArticleNumber = "330028") OR (aa.SupplierID = 445 AND aa.DataSupplierArticleNumber = "330030") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "510050010400") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "88805") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0910020") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0910021") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0905099") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0910026") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0910019") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0907032") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 191 0002") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 919 0015") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP209") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVIM190") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVCT327") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP237") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP121") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVCT421") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP341") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP188") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVCT423") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVIM103") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "00393") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.02604.01.0") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS90") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XTT99") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS55") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XEI4") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS6") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XTT30") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS79") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XTT98") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS29") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XEI20") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "52301") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "WTS018W") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "51030") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2049") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP014") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "WS1042") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "50970") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS104") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP007") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "STT044") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS042") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP005") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "STT011") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS037") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2176") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "52310") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "51177") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "IPC005") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2061") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "52302") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "51031") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2051") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP019") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "WS1041") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "50950") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS043") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP006") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "STT007") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS035") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2062") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "14007") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "06-04027-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "06-08000-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 23 0004") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "99 90 1939") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 3825") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 23 0001") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 23 0002") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "101 508") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "103 326") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "101 106") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "100 684") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "103 327") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "101 107") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "100 685") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "100 665") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "101 507") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "100 853") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "100 345") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.42.006") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.42.007") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.42.018") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.42.019") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "700044") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "245519") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "245521") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "G855302990800Z") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V45-73-0002") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-99-1992") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-77-0001") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-99-1993") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-99-1989") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-76-0098") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-99-1995") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99190072201") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99190078101") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99190072401") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99190078801") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99190070701") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99590377201") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99190071901") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1032805") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1432721") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1791563") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1432812") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1791565") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025954") ) AND aa.Language = "ru" UNION ALL SELECT CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber) as article_id, if (aa.Description = "", aa.DisplayTitle, aa.Description) as crit_designation, aa.DisplayValue as crit_value, "" crit_unit, 1 criteria_art, "articleattributes_2018_2" as source FROM articleattributes_2018_2 aa WHERE ( (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "AS2101") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "AS2102") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "AS4610") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "SPR017") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "ST115") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "SPR004") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "1 237 011 123") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 986 344 082") OR (aa.SupplierID = 211 AND aa.DataSupplierArticleNumber = "160903") OR (aa.SupplierID = 47 AND aa.DataSupplierArticleNumber = "16521") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-840-042") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-840-040") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "SW90009") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TS10245-12B1") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "SW90030") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "SW90005") OR (aa.SupplierID = 4345 AND aa.DataSupplierArticleNumber = "1040300002") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "XOS8226") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "550207") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "11070") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "08485") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "08444") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "08466") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "33825") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "01939") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZL 003 259-441") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70541050") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70511509") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70541051") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70620008") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70541001") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70511043") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70541065") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70541049") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70511153") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193100600") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193501100") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1191400200") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193200700") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193500100") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193100500") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193500400") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "111002") OR (aa.SupplierID = 445 AND aa.DataSupplierArticleNumber = "330028") OR (aa.SupplierID = 445 AND aa.DataSupplierArticleNumber = "330030") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "510050010400") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "88805") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0910020") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0910021") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0905099") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0910026") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0910019") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0907032") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 191 0002") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 919 0015") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP209") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVIM190") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVCT327") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP237") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP121") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVCT421") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP341") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP188") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVCT423") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVIM103") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "00393") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.02604.01.0") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS90") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XTT99") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS55") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XEI4") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS6") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XTT30") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS79") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XTT98") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS29") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XEI20") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "52301") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "WTS018W") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "51030") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2049") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP014") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "WS1042") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "50970") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS104") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP007") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "STT044") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS042") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP005") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "STT011") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS037") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2176") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "52310") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "51177") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "IPC005") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2061") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "52302") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "51031") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2051") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP019") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "WS1041") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "50950") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS043") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP006") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "STT007") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS035") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2062") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "14007") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "06-04027-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "06-08000-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 23 0004") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "99 90 1939") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 3825") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 23 0001") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 23 0002") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "101 508") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "103 326") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "101 106") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "100 684") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "103 327") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "101 107") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "100 685") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "100 665") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "101 507") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "100 853") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "100 345") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.42.006") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.42.007") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.42.018") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.42.019") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "700044") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "245519") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "245521") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "G855302990800Z") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V45-73-0002") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-99-1992") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-77-0001") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-99-1993") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-99-1989") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-76-0098") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-99-1995") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99190072201") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99190078101") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99190072401") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99190078801") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99190070701") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99590377201") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99190071901") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1032805") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1432721") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1791563") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1432812") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1791565") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025954") ) AND aa.Language = "ru" Продажа автозапчастей типа Электроника двигателя для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTLOG AS2101 Датчик давления масла
AS2102 Датчик давления масла
AS4610 Датчик детонации
BERU SPR017 Датчик давления масла
ST115 Датчик, температура охлаждающей жидкости
SPR004 Датчик давления масла
BOSCH 1 237 011 123 Датчик, импульс зажигания
0 986 344 082 Датчик давления масла
BOUGICORD 160903 Блок управления, система зажигания
BREMI 16521 Датчик, импульс зажигания
BSG BSG 90-840-042 Датчик давления масла
BSG 90-840-040 Датчик давления масла
DELPHI SW90009 Датчик давления масла
TS10245-12B1 Датчик, температура охлаждающей жидкости
SW90030 Датчик давления масла
SW90005 Датчик давления масла
DODA 1040300002 Датчик, температура охлаждающей жидкости
ELTA AUTOMOTIVE XOS8226 Датчик, давление масла
ERA 550207 Датчик детонации
FAE 11070 Датчик давления масла
FEBI BILSTEIN 08485 Датчик давления масла
08444 Датчик давления масла
08466 Датчик давления масла
33825 Датчик, температура масла
01939 Датчик, температура охлаждающей жидкости
HELLA 6ZL 003 259-441 Датчик давления масла
HERTH+BUSS ELPARTS 70541050 Датчик давления масла
70511509 Датчик, температура охлаждающей жидкости
70541051 Датчик давления масла
70620008 Датчик детонации
70541001 Датчик давления масла
70511043 Датчик, температура охлаждающей жидкости
70541065 Датчик давления масла
70541049 Датчик давления масла
70511153 Датчик, температура охлаждающей жидкости
JP GROUP 1193100600 Датчик, температура охлаждающей жидкости
1193501100 Датчик давления масла
1191400200 Датчик, импульс зажигания
1193200700 Датчик, температура охлаждающей жидкости
1193500100 Датчик давления масла
1193100500 Датчик, температура охлаждающей жидкости
1193500400 Датчик давления масла
KAMOKA 111002 Датчик детонации
KLARIUS 330028 Лямбда-зонд
330030 Лямбда-зонд
MAGNETI MARELLI 510050010400 Датчик давления масла
MAPCO 88805 Датчик, температура охлаждающей жидкости
METZGER 0910020 Датчик давления масла
0910021 Датчик давления масла
0905099 Датчик, температура охлаждающей жидкости
0910026 Датчик давления масла
0910019 Датчик давления масла
0907032 Датчик детонации
MEYLE 100 191 0002 Датчик, температура охлаждающей жидкости
100 919 0015 Датчик, температура охлаждающей жидкости
MOTAQUIP LVRP209 Датчик давления масла
LVIM190 Блок управления, система зажигания
LVCT327 Датчик, температура охлаждающей жидкости
LVRP237 Датчик давления масла
LVRP121 Датчик давления масла
LVCT421 Датчик, температура охлаждающей жидкости
LVRP341 Датчик давления масла
LVRP188 Датчик давления масла
LVCT423 Датчик, температура охлаждающей жидкости
LVIM103 Блок управления, система зажигания
OSSCA 00393 Датчик давления масла
PIERBURG 7.02604.01.0 Лямбда-зонд
QUINTON HAZELL XOPS90 Датчик давления масла
XTT99 Датчик, температура охлаждающей жидкости
XOPS55 Датчик давления масла
XEI4 Блок управления, система зажигания
XOPS6 Датчик давления масла
XTT30 Датчик, температура охлаждающей жидкости
XOPS79 Датчик давления масла
XTT98 Датчик, температура охлаждающей жидкости
XOPS29 Датчик давления масла
XEI20 Блок управления, система зажигания
SMPE 52301 Датчик, температура охлаждающей жидкости
WTS018W Датчик, температура охлаждающей жидкости
51030 Датчик давления масла
OPS2049 Датчик давления масла
SOP014 Датчик давления масла
WS1042 Датчик, температура охлаждающей жидкости
50970 Датчик давления масла
LOPS104 Датчик давления масла
SOP007 Датчик давления масла
STT044 Датчик, температура охлаждающей жидкости
LOPS042 Датчик давления масла
SOP005 Датчик давления масла
STT011 Датчик, температура охлаждающей жидкости
LOPS037 Датчик давления масла
OPS2176 Датчик давления масла
52310 Датчик, температура охлаждающей жидкости
51177 Датчик давления масла
IPC005 Датчик, импульс зажигания
OPS2061 Датчик давления масла
52302 Датчик, температура охлаждающей жидкости
51031 Датчик давления масла
OPS2051 Датчик давления масла
SOP019 Датчик давления масла
WS1041 Датчик, температура охлаждающей жидкости
50950 Датчик давления масла
LOPS043 Датчик давления масла
SOP006 Датчик давления масла
STT007 Датчик, температура охлаждающей жидкости
LOPS035 Датчик давления масла
OPS2062 Датчик давления масла
14007 Датчик, импульс зажигания
STELLOX 06-04027-SX Датчик, температура охлаждающей жидкости
06-08000-SX Датчик, давление масла
SWAG 30 23 0004 Датчик давления масла
99 90 1939 Датчик, температура охлаждающей жидкости
30 93 3825 Датчик, температура масла
30 23 0001 Датчик давления масла
30 23 0002 Датчик давления масла
TOPRAN 101 508 Датчик давления масла
103 326 Датчик, температура охлаждающей жидкости
101 106 Датчик давления масла
100 684 Датчик, температура охлаждающей жидкости
103 327 Датчик, температура охлаждающей жидкости
101 107 Датчик давления масла
100 685 Датчик, температура охлаждающей жидкости
100 665 Датчик, импульс зажигания
101 507 Датчик давления масла
100 853 Датчик, температура охлаждающей жидкости
100 345 Датчик давления масла
TRUCKTEC AUTOMOTIVE 07.42.006 Датчик, температура охлаждающей жидкости
07.42.007 Датчик, температура охлаждающей жидкости
07.42.018 Датчик давления масла
07.42.019 Датчик давления масла
VALEO 700044 Датчик, температура охлаждающей жидкости
245519 Блок управления, система зажигания
245521 Блок управления, система зажигания
VDO G855302990800Z Датчик детонации
VEMO V45-73-0002 Датчик давления масла
V15-99-1992 Датчик давления масла
V15-77-0001 Датчик, температура охлаждающей жидкости
V15-99-1993 Датчик давления масла
V15-99-1989 Датчик, температура охлаждающей жидкости
V10-76-0098 Лямбда-зонд
V15-99-1995 Датчик давления масла
vika 99190072201 Датчик давления масла
99190078101 Датчик, температура охлаждающей жидкости
99190072401 Датчик давления масла
99190078801 Датчик, температура охлаждающей жидкости
99190070701 Датчик давления масла
99590377201 Датчик, температура охлаждающей жидкости
99190071901 Датчик давления масла
WILMINK GROUP WG1032805 Датчик детонации
WG1432721 Датчик, температура охлаждающей жидкости
WG1791563 Блок управления, система зажигания
WG1432812 Датчик, температура масла
WG1791565 Блок управления, система зажигания
WG1025954 Лямбда-зонд
2026 CATCAR.INFO (v 2.0)