exclusion scripts

// get voters
select * from TxAccountWitnessVotes where witness in ('goodguy24', 'aheadofslow', 'night11pm', 'hunger365', 'waitforyou1', 'cloudysun', 'jumphigh', 'coronashallgo', 'paintingclub', 'bostonawesome', 'toke2049', 'flyingfly1', 'agirl10000', 'eastooowest', 'car2001', 'nicetry001', 'high46', 'respect888')

// Get proxies
select * from TxAccountWitnessProxies where proxy in ('', 'coininstant','honusurf','twirllinks','sampraise','cwcost','dev365','foreveraverage','friendlystranger','pippo84','juanmolina','javirid','bidesign','m-yasir','rakkasan84','vidafitnessfeliz','smallpusher','farm-mom','mfblack','nardiazst','razer7','stevoperon','lichtblick','thebigsweed','antonio.vlasov','lotusfleur','travelwithus','martbarras','freedomteam2019','skeenee','hone.heke','thettinaung','wisekricket','bible.facts','bible.study','jaydih','begood2me','ityp','dftba','virus707','rynow','scottcbusiness','greece-lover','juancar347','lesmann','nachomolina','electrodo','oldstone','we-together','photoholic','slowwalker','wisdomandjustice','malia.mancianti','mauialohabella','kdtkaren','robinmmthompson','firealien','firealiean','me-we','cristo','team-mexico','kiwisteem','teamxpro','dhanagc','tailcock','tfq86','hermeticgenetics','numberofthingz','dzoji','boyacun123','amayphin','alexaventuria','dominikboecker','dappinvestor','kapitanrosomak','itsonursezer','karega','walktoheaven','julisavio','fadetoblack','cool191','goodnewworld','coinchaos','btcmillennial','happyworkingmom','davemccoy','hugo1954','eps','asimpleman','footballfacts','footballpedia','jieshao','uplus','brewcitygardener','john371911','devsup','epscu','tshering-tamang','freedompoint','akiroq','infidel1258','proffit','brent1042','don-thomas','don-t','luke-barth','ayogom','kaonashi6686','steemian258','glory7','relaxkim','islamkhan','mehta','muru','cultus-forex','deusjudo','tovaga75','proxy.token','steemchiller','yinyangboobookat','project7','ilovemylife','dmitri13','remlaps','in2itiveart','starworld','cpt-sparrow','bdlatif','coml','instructor2121','killuminatic','wendyth16','dr-frankenstein','karbon','truce','lifeskills-tv','jayplayco','joe.public','ravenkim','rosepac','labradorpuppies','tyramisoux','emiliomorles','yanirauseche','loganxart','ricko66','bukio','maiyude','carlosluistoro','spinbunny','trevonjb','ricky.gold','test45','gustavomonraz','tuckerjtruman','balticbadger','mdosev','awasthih','soufiani','stimialiti','zzan.witnesses','enjoykarma','scarletreaper','stimp1024','stimp-bank','kirbyjr1977','oac','daudimitch','ale.dri','edgarare1','lupafilotaxia','yasien','brutledge','brokendreams','cryptotracer','lightroom','bayron','justinsunsteemy','kaz2305') order by timestamp desc

// get vests
select name from Accounts where name in (  'abduhawab','abdullar','abitbi','acostaeladio','aellly','ai1love','aidasfg7','akinome','akiroq','al-kong','albertoi','ale.dri','alexaventuria','alexs1320','alicom','allbit','allying','alvin0617','amayphin','amirdayyan','amryksr','andrewnoel','angelina6688','angelslake','annzhao','anroja','anroja.sports','anroja.zzan','antonio.vlasov','arthurwh','asimpleman','astros','atomy1','autorent','autoway','auzifalevi','auziflv','awasthih','awie','ayjoe','ayogom','babypangpang','backdm','badguy825','bakhasatang','balticbadger','banguri','banjjakism','bayron','bdlatif','begood2me','ben','bencana0523','bible.facts','bible.study','bidesign','bien','big.pool','biglotto','bigman70','bigpool','bigwave','bitdev100','bizventurer','blacklux','bluelightning','bongje','book.club','bookguy','boyacun123','braham','brent1042','brewcitygardener','brokendreams','brooklyn-nets','brutledge','btcmillennial','buk-translate','bukdb','bukio','bulsik','cancerdoctor','carlosluistoro','carmencandy','chapchop','cherrylp147','chetanpadliya','cheva','cjh','cjsdns','classical-music','classical.music','cmp2020','cmp2020-pb','cn-malaysia','cnfund','code-entropy','coinchaos','coininstant','coldsiksu','coml','cool191','coreabeforekorea','corn113','cplusplus','cristo','cryptocurrencyhk','cryptotracer','cub1','cub2','cwcost','cyberrn','dailychina','dailyfortune','dailyke20','dailystats','dakeshi','daldalpapa','dappinvestor','dappstore','daudimitch','davemccoy','davidber','daydayup','ddang2ja','deago','deer3','deusjudo','dev365','devsup','devyleona','dftba','dhanagc','dj-on-steem','djusti','dmitri13','dmsqlc0303','dobartim','docker','dodoim','don-t','don-thomas','donekim','dongsuh','dorian-dev','dorian-lee','double-u','doveyan','dr-frankenstein','dzoji','edgarare1','ediya','eduardog','electrodo','elihao','elleny','emiliomorles','enjoykarma','eokkae','epitt925','eps','epscu','ewq','ezraswish','f21steem','fadetoblack','faizarfatria','fallrain','fam.steemzzang','farm-mom','feelsogood','fenrir78','firatuz','firealiean','floridasnail','flxlove','flxsupport','flydayhk','flysky','footballfacts','footballpedia','foreveraverage','foruni73','francium','free.zzan','freedompoint','freedomteam2019','freegon','freevoter','friendlystranger','funtraveller','fur2002ks','furkani','gallop','gameguide','garamee21','gawz69','geekwho','geos','gfriend96','glory7','gmarket','godssohot','goku1','golddeck','gomster','goodhello','goodnewworld','goplayer','gosainkund','grandlisboa','greece-lover','grexx','gustavomonraz','gyotaejeon','hanwoo','hanwoo.aaa','happybelly','happyberrysboy','happyukgo','happyworkingmom','hbbear.report','hemohim','hermeticgenetics','hf20test','hhusaini','hhusaini1','hktraveler','hmeto','hodolbak','hogu','holic7','holmesian','hone.heke','honeybeerbear','honusurf','hooo','huangzuomin','hugo1954','hyokhyok','ibk','iieeiieeii','ilmice','ilovecoding','ilovemylife','imadev','inchonbitcoin','infidel1258','insidenature','ioioioioi','isaaclab','ishare','isi3','islamkhan','itmp','itsonursezer','ityp','j-car','jack8831','jacobyu','jademont','jangteo','jataka','javirid','jaydih','jaydihjaydih','jaykayw','jayplayco','jewel-lover','jianan','jieshao','jimjim','jjm13','jjy','joe.public','joe767676','john371911','jsg','jstory','juancar347','juanmolina','julisavio','jungch98','jungjunghoon','justinsunsteemy','justsoso','justyy','jutinsun','kaka-aaa','kaka-monsters','kakakk','kanadaramagi123','kaonashi6686','kapitanrosomak','karbon','karega','kaz2305','kbaek81','kcc','kdtkaren','kemal13','kgbinternational','kibaek','kibumh','kimseun','kimxinfo','kingbit','kirbyjr1977','kiwisteem','knight4sky','kopasi','kopasi.sct','koyuh8','krartfund','ksc','ksheva1','kstop1','kungdel','kwonjs77','kyj','labradorpuppies','ladyceleste','learn-er','leems','leesunmoo','leeyoungkwang','lenient0506','lesmann','levycore','lhy','li-li','lichtblick','lifeskills-tv','lighthil','lightroom','lisa.palmer','lisboa','lisianthusxvx','ljyxxzj','lnakuma','loganxart','lonose','lotusfleur','loveecho','lovelyyeon','lovethis','lovethiscomment','lovethispost','ltcih','ltcij','ltcil','lucky2','lucky2015','lucky222','luke-barth','lupafilotaxia','m-yasir','machellin','maikuraki','maiyude','malia.mancianti','marshallmustang','martbarras','matildah','matthewguo','mauialohabella','mdosev','me-we','mehta','menerva','mfblack','mfxqaq','mia-cc','mimistar','mini.pay','miniu','minutebuddhism','misterdelegation','mohamedsahbi','mooninwater','mrnicepost','mrpointp','mrspointm','muru','mustard-seed','mydicebot','mylord1992','mysteem3','nachomolina','naha','nardiazst','new-jersey','newbijohn','newcastle-united','newiz','newmacho','newtech-adopter','nexgen','nieloagranca','norwegiansteem','oac','occ','omin','omit','onespringday','onlyforyou','opixer','oscarpark','osj','p3d1','pacemaker','pager','palja','parisfoodhunter','peanut77','peterpa','peterpa.cur','pharm.steemit','photocircle','photoholic','pippo84','pizzafamily','poloniex','powerade','ppomppu','prinzessin','proffit','project7','proxy.token','rainingfall','rakkasan84','ramires','raramanis','ravenkim','razer7','rbaggo','rcaine','realmankwon','realmankwon.cur','realmankwon.scot','redpanda787','relaxkim','remain','remlaps','remlaps-lite','remlaps1','remlaps2','reportup','rgkmb','rgkmb-unofficial','rhodium','richwings','ricko66','ricky.gold','ringit','risentwor','robertdo','robinmmthompson','rosecreek','rosepac','royaleagle','ryanhkr','rynow','sailei1','sally5528','sampraise','sandisk','sasaadrian','scarletreaper','schuyler','scienceangel','scottcbusiness','scripture-union','sct','sct.bank','sct.biz','sct.curator','sct.krwp','sct.kwn','sct.min','sct.tom','sct.voter','sct.wallet','seo-boss','seraphim502','sergionatera','sevenusdchain','sgbonus','shenchensucc','shimsing','shle','shoken','shyuk3655','sigizzang','sindoja','sindong','sj-jeong','sjgod4018','sjw1229','skeenee','sklara','skt1','skuld2000','skylaa','skymin','skyoi','sleepcat','smallpusher','smongo','smonkstop1','smy','snailsong','snuff12','softmetal','solnamu','sonamoo','songa0906','sonki999','sonyeye','soohyeongk','soosoo','soufiani','spinbunny','spoke','sportscurator','ssc-token','ssonagee','stablewon','starworld','steem','steem.miner','steemchiller','steemersbot','steemex','steemflower','steemfuckeos','steemhunt','steemian258','steemit','steemitvenezuela','steemnara','steemzzang','steeply','stefnie','stepbie','stevoperon','stimialiti','stimp1024','storysharing','stylegold','sun510','sunny1124','superbing','sw-test','swan1','swc','sweetpapa','syh7758520','tabris','tailcock','talkative-bk','team-mexico','test45','teukurival','thaiculture','thally','thebigsweed','thegreatgatsby','thettinaung','think-ing','tiamo1','tigerhan','timothy2020','tinker-bell','tkdgjs79','totopapa','tovaga75','toxicskunky','tradingideas','trailbase','travelnepal','travelwithus','trendhk','trevonjb','trevorlp97','trevormomo','triplea.bot','triplea.cur','triplea.reviews','truce','trueimagine','tshering-tamang','tuckerjtruman','turtlegraphics','twinpapa','twirllinks','tworld','tyramisoux','ultranew','under.dog','uplus','uzgo','venti','veronicalee','vidafitnessfeliz','vingroup','vip','virus707','walktoheaven','wanglizhuifeng','waterzeong','we-together','we1','weekly7','wendyth16','windowglass','winnie1998','wira8788','wisdomandjustice','wisekricket','witnesstools','wjs','wondumyungga','wongshiying','wonsama','wordit','wpdnrl123','wyp','xiaoguai','xiaoshancun','xiaoyaosilang','yang543611595','yangyang','yanirauseche','yanis01','yann03','yasien','ybc','yellowbird','ygs','yinyangboobookat','yjs3694','yoon','ys1302','yunaremaia','zhengkai','zhishufei','ziq','zr1','zsilence','zvz','zzan','zzan-m','zzan.admin','zzan.adv','zzan.atomy','zzan.biz','zzan.blue','zzan.hmy','zzan.puzzle','zzan.sct','zzan.witnesses','zzan1004','zzanbank','zzangu','zzanmarket','zzings','zzrhi73') and vesting_shares > 2116111 order by vesting_shares desc


var data = JSON.parse(fs.readFileSync('voters').toString());

    let voters = []


    for (let i = 0; i < data.length; i++) {
        if (data[i].approve === true) {

            voters.push({account : data[i].account, witness : data[i].witness})
        }
        else if (data[i].approve === false) {
            if (new Date(data[i].timestamp).getTime() < new Date("2020-03-17 23:39:39").getTime()) {
                voters.splice(voters.indexOf({account : data[i].account, witness : data[i].witness}), 1)
            }
        }
    }

    let finalvoters = [];

    for (let i = 0; i< voters.length; i++) {
        for (let k = 0; k < voters.length; k++) {
            if (voters[i].account === voters[k].account && voters[i].witness !== voters[k].witness) {
                finalvoters.push(voters[i].account)
                break;
            }
        }
    }

    finalvoters = [...new Set(finalvoters)];


    let proxies = JSON.parse(fs.readFileSync('proxies').toString());

    let final_proxy_voters = [];
    let cleared_proxies = [];



    for (let i = 0; i < proxies.length; i++) {
        if (proxies[i].Proxy === "" && final_proxy_voters.indexOf(proxies[i].account) === -1) {
            cleared_proxies.push(proxies[i].account);
        }
        if (cleared_proxies.indexOf(proxies[i].account) === -1)
            final_proxy_voters.push(proxies[i].account);
    }


    let final  = [... new Set(finalvoters.concat(final_proxy_voters))].sort()

    console.log(final)