Bitcoin Forum
July 20, 2019, 12:13:57 AM *
News: Latest Bitcoin Core release: 0.18.0 [Torrent] (New!)
 
   Home   Help Search Login Register More  
Pages: [1] 2 »  All
  Print  
Author Topic: [Merit Analysis] Users ranked Sr. Member & up that have not earned any merit  (Read 777 times)
vlad230
Sr. Member
****
Offline Offline

Activity: 518
Merit: 276



View Profile
October 01, 2018, 02:59:47 PM
Last edit: October 02, 2018, 07:42:30 AM by vlad230
Merited by TMAN (10), LoyceV (1), iasenko (1), cryptovigi (1), Alizaind (1)
 #1

I was challenged by a user yesterday, in my [Merit Analysis] "Self Made" Jr. & Member users that have earned merit thread and promised I would deliver by today. Since I'm a big fan of challenges, I couldn't refuse  Cheesy

Here's what user cryptovigi asked me to deliver:

I like your analysis and have another challenge for you ;-)

Ranked Members - Member and above who was given merit airdrop (while introducing merit system) according to their ranks and didn't earn even one "by themself" this one maybe interesting!!!
So, let's see how this looks like in our forum.

The questions I will find answers to are:

1. How many Sr. Member & up users exist that have not earned any merit?
Code:
1078 Sr. Members
476 Hero Members
224 Legendary Members
There are 1778 users ranked Sr. Member & up that have not earned any merit, they just got "airdropped" merit from when the merit system was implemented.
I was caught a bit off guard by this number, as I didn't think there could be so many users that have not earned any merit. This could signal some problems with the distribution of merit as these users should be knowledgeable enough to produce quality posts & get merited.

Another possible explanation could be that some of the users here might not be active anymore, thus didn't come in contact with the merit system at all. Sadly, I do not have access to more information about the users like "last date active" to be able to produce more accurate data, yet.

Since there are a lot of users and decided to limit myself to the post max size, I have analyzed Sr. Members & up. Let me know if someone would be interested in seeing the rest of the user categories and I will created another thread.

2. Who are the Sr. Member users that have not earned any merit?
Code:
UserName Rank
$Darkloard$ Sr. Member
$anounimus$ Sr. Member
-Joni- Sr. Member
19Nov16 Sr. Member
232drialf Sr. Member
24core Sr. Member
2tang Sr. Member
320hz Sr. Member
4rzun4 Sr. Member
8rch7 Sr. Member
93_didan Sr. Member
@boutiuqe Sr. Member
AK47- Sr. Member
ATAK T-129 Sr. Member
Aceeakell Sr. Member
Acguy Sr. Member
Adbitco Sr. Member
Adya Sr. Member
Adykingcity Sr. Member
Affilate User Sr. Member
AiloveYouks21 Sr. Member
AjithBtc Sr. Member
Aleator Sr. Member
Aleya Sr. Member
Alns Sr. Member
AltsBoom Sr. Member
AmXProX Sr. Member
Amalker Sr. Member
AmericanBit Sr. Member
AmunRa Sr. Member
AncilVTwo Sr. Member
Andergriff Sr. Member
Andrey Smirnov Sr. Member
Anegg Sr. Member
Apes Sr. Member
Ariess Sr. Member
Arksun Sr. Member
Arsenyo Sr. Member
Arumi.Bilqis Sr. Member
Ashong Salonga Sr. Member
Asi4btc Sr. Member
Asimmo Sr. Member
Atdhe Sr. Member
Aura689 Sr. Member
Autto Sr. Member
Awalt541 Sr. Member
Aying Sr. Member
BERKUTcryp Sr. Member
BETAWI Sr. Member
BTC-Graphicdesigns Sr. Member
BTCBusinessConsult Sr. Member
BTCGOLD Sr. Member
BTCdude007 Sr. Member
Baby Dragon Sr. Member
Bacchu Sr. Member
Badboy[BTC] Sr. Member
Bakemat Sr. Member
BarbieCasino Sr. Member
Bastime Sr. Member
Bedebah Sr. Member
Beijideluotuo Sr. Member
BekantanSejagatTeamPenipu Sr. Member
Ber86 Sr. Member
BetcoinPoker Sr. Member
BicolIsarog Sr. Member
Bikers Sr. Member
BitTeo Sr. Member
BitcoinLoan Sr. Member
Bitinator Sr. Member
Bitum Sr. Member
BlackWidow Sr. Member
Blackdeath Sr. Member
Blackwhite69 Sr. Member
Blizzhard Sr. Member
Bloodxtz Sr. Member
Boathouse Sr. Member
BobBct Sr. Member
Bondho Kompeni Sr. Member
Bonenx14 Sr. Member
Braino Sr. Member
Brama Jasa Sr. Member
Brattavito Sr. Member
BtcVolcano Sr. Member
Bulletdodger Sr. Member
Bunsomjelican Sr. Member
ButtCrack Sr. Member
CC23 Sr. Member
CODE200 Sr. Member
CRYPTONAIRE Sr. Member
Caesar-Giulius Sr. Member
Calangaman Sr. Member
Carmen_Sandiego Sr. Member
Cashcash Sr. Member
Celendion Sr. Member
Chainsmokers Sr. Member
Chasoid Sr. Member
Cherylstar86 Sr. Member
Chinesegandalf Sr. Member
Cimmy_revenger Sr. Member
Clavulanic Sr. Member
CloudStrife Sr. Member
ClutchThese Sr. Member
CoinTasker Sr. Member
Colt81 Sr. Member
ComponY Sr. Member
Coroline Sr. Member
Cortes_Cripto Sr. Member
Cossack Sr. Member
CrowdFunder Sr. Member
Crypt1x Sr. Member
CryptoRekt Sr. Member
Cryptorast Sr. Member
Crypviser Sr. Member
CyanFox Sr. Member
CyberCombat Sr. Member
D4RK5T4R Sr. Member
DLCseller Sr. Member
DStefanov Sr. Member
Daha19 Sr. Member
Daneal Sr. Member
Dank Frank Sr. Member
DannyBOfficial Sr. Member
DaveWave Sr. Member
DavidSantamaria Sr. Member
Davids123 Sr. Member
Decksperiment Sr. Member
Defloration Sr. Member
Delaforetnoire Sr. Member
Delicieuxz Sr. Member
Delinquency Sr. Member
Denov Setu Sr. Member
DevSoft Sr. Member
DevilSlayer Sr. Member
DidiMidi Sr. Member
DimaKHV Sr. Member
Distraction Sr. Member
Do4a Sr. Member
Docent85 Sr. Member
Domenc Sr. Member
DonYo Sr. Member
DragonETH Sr. Member
DrearyUrbanite Sr. Member
Drobek Sr. Member
DroomieChikito Sr. Member
Duzter Sr. Member
ECore Sr. Member
Easteregg69 Sr. Member
EbenTheva Sr. Member
Eclipse26 Sr. Member
Eldest Sr. Member
EleGiggle Sr. Member
Elsonbol Sr. Member
Etanllah Sr. Member
EuSouBitcoin Sr. Member
Experia Sr. Member
Factmine Sr. Member
Faiyz Sr. Member
Fasdartin Sr. Member
FaucetKING Sr. Member
Faxmate Sr. Member
Fidemoga Sr. Member
Fishbones78 Sr. Member
Flapmin Sr. Member
Flexibit Sr. Member
Flooks Sr. Member
FlorentineNobleman Sr. Member
ForeverFener Sr. Member
Frank0209 Sr. Member
Frank37 Sr. Member
Fredii Sr. Member
FreshB Sr. Member
FridaKallo Sr. Member
Fulmand Sr. Member
Fundamentals Of Sr. Member
FundsMoney Sr. Member
GSpgh Sr. Member
Gabri Sr. Member
Ganlok Sr. Member
Gargo Sr. Member
GatotKaca Sr. Member
Geekphazm Sr. Member
Ghris Sr. Member
Ginger Ninja Sr. Member
GlacierBIT Sr. Member
Glen Hoddle Sr. Member
Gold.Boriska Sr. Member
Golstrim Sr. Member
GriTBitS Sr. Member
HV3S Sr. Member
HabiebRiziq Sr. Member
Heimer Sr. Member
Heishehui187 Sr. Member
Here4Trades Sr. Member
High Plains Drifter Sr. Member
HopeCrypto Sr. Member
HyperLup Sr. Member
HyunBin Sr. Member
Ignacia Sr. Member
Images21 Sr. Member
Infinity7 Sr. Member
IntelligentIdiot Sr. Member
Invester Sr. Member
Iserviceman Sr. Member
JC btc Sr. Member
JDS1000 Sr. Member
Jackling Sr. Member
JahriMeayer Sr. Member
James_H Sr. Member
Jammalan the Prophet Sr. Member
Jekwizor Sr. Member
Jelly0621 Sr. Member
Jembut Ireng Sr. Member
Jerzzz Sr. Member
Jian_Liux Sr. Member
JimmieA Sr. Member
Joe200 Sr. Member
Joker07 Sr. Member
Jose Mourinho Sr. Member
Joshapat Sr. Member
JumperN Sr. Member
KDjr Sr. Member
Kamayulka78 Sr. Member
Kand1990 Sr. Member
Karolina26 Sr. Member
Kasperiko Sr. Member
KawaBunGa Sr. Member
Kawasanz Sr. Member
Kazkar Sr. Member
Kennedy Sr. Member
Kersh768 Sr. Member
Kevinatin Sr. Member
Kewatia Sr. Member
KickItDown Sr. Member
Kienbui Sr. Member
Killerpotleaf Sr. Member
Kimi80 Sr. Member
Kizaki Sr. Member
Kj1 Sr. Member
Klausi Sr. Member
KnightElite Sr. Member
KnightRiderus Sr. Member
KoBaTeJIb Sr. Member
Koppa Sr. Member
Krista Sr. Member
Kupid002 Sr. Member
LIghtvelocityCoin Sr. Member
Larion94 Sr. Member
Larva14 Sr. Member
LastKiss Sr. Member
Lauren Smith Sr. Member
Lazada Sr. Member
Lebraam Sr. Member
Lecam Sr. Member
LegendOF45 Sr. Member
Lesya2015 Sr. Member
LilitKha Sr. Member
Linuld Sr. Member
Lone Shark Sr. Member
Lontongmie Sr. Member
Looarn Sr. Member
LordMeowMeow Sr. Member
Lorilikes Sr. Member
Lubang Bawah Sr. Member
LukkasG Sr. Member
MMysterious Sr. Member
MOSSAD Sr. Member
MSZCoin Sr. Member
MXXWLL Sr. Member
Macrochip Sr. Member
Magkirap Sr. Member
Magnavox Sr. Member
Mame89 Sr. Member
Mang86 Sr. Member
Marc De Mesel Sr. Member
Mark81 Sr. Member
Maryshka91 Sr. Member
Masyudhi Sr. Member
McKane Sr. Member
MehdiBmm Sr. Member
Meowth05 Sr. Member
Meteeray Sr. Member
Mihaylovic Sr. Member
MoonJeina Sr. Member
Moondreams Sr. Member
MorGan-id Sr. Member
Mr. Legendaris Sr. Member
MrBAU Sr. Member
MrData Sr. Member
MrZ28s Sr. Member
MtRev Sr. Member
Myfe Sr. Member
Myra4 Sr. Member
NASdaq Sr. Member
NH Sr. Member
NJB18 Sr. Member
Nathan047 Sr. Member
NathanJB Sr. Member
Nboramir Sr. Member
Neo501 Sr. Member
Nevsky Sr. Member
Newton90 Sr. Member
Ngewex Yuk Sr. Member
Nicol3 Sr. Member
NikuSH Sr. Member
Nobtcoin Sr. Member
Noidor Sr. Member
NoiseBoy Sr. Member
Nordblitcer Sr. Member
Northa Sr. Member
Noruka Sr. Member
ONCF Sr. Member
ORiN Sr. Member
Obito Sr. Member
OrsonJ Sr. Member
Osmanli42 Sr. Member
Oumal Sr. Member
P4ndoraBox Sr. Member
PM.coins Sr. Member
Paritor Sr. Member
Pejoh Asu Sr. Member
Periodik Sr. Member
PeterTheGrape Sr. Member
PinkHead Sr. Member
Pinkris128 Sr. Member
Pipshunter Sr. Member
Poloherb Sr. Member
Prettygirl01315 Sr. Member
Pride97 Sr. Member
Primal Base Sr. Member
Prodigan786 Sr. Member
Pulithey1986 Sr. Member
Pump N Dead Sr. Member
Pumuckel21 Sr. Member
QFT Sr. Member
QueenOf Sr. Member
Quietman Sr. Member
R4v37 Sr. Member
RACT Sr. Member
RAGEmond Sr. Member
Ragnarcoin Sr. Member
Rahman11 Sr. Member
Raizou Sr. Member
Rana590 Sr. Member
RandyMagnum Sr. Member
Rapidgator Sr. Member
Rasel5209 Sr. Member
Raven91 Sr. Member
Reatim Sr. Member
Reavon Sr. Member
Republicofizmir Sr. Member
Roidz Sr. Member
RonMank Sr. Member
Ronin_sv Sr. Member
Rora Sr. Member
RouletteRun Sr. Member
RussiaCoinDotInfo Sr. Member
RussianTranslator Sr. Member
Ryker1 Sr. Member
SNS Sr. Member
SUM2dev Sr. Member
SacriFries11 Sr. Member
Saidmod Sr. Member
Sam San Sr. Member
Sarisang Sr. Member
Sate Jamu Sr. Member
SateRebus Sr. Member
Satorus Sr. Member
Scyntech Sr. Member
SeaSoul Sr. Member
Selly Arumsari Sr. Member
Senja Kemuning Sr. Member
Serco Sr. Member
Servantes Sr. Member
Shanto Sr. Member
Sharkzz1 Sr. Member
Sifat33 Sr. Member
Silvercell Sr. Member
SimonBeCoinin Sr. Member
SimonJones Sr. Member
Sir Lagsalot Sr. Member
Sir Legend Sr. Member
SistaFista Sr. Member
Smoker00 Sr. Member
Sniar Sr. Member
Snipe85 Sr. Member
SoeNan89 Sr. Member
SomeRelax Sr. Member
Soots Sr. Member
Sorros Sr. Member
Sosaso75 Sr. Member
Sponsoredby15 Sr. Member
Spotswood Sr. Member
Squirrel Dearing Sr. Member
Starving_Marvin Sr. Member
StinkyLover Sr. Member
StonerStanley Sr. Member
Stormspirit Sr. Member
Sundoor Sr. Member
Surrapatt Sr. Member
Sven11 Sr. Member
TRONTON Sr. Member
TaShoKi Sr. Member
Take the red pill Sr. Member
TaliskerDarkStorm Sr. Member
Taner Sr. Member
Tara11 Sr. Member
Tcher_L Sr. Member
Termin4tor Sr. Member
TexasofblackseA Sr. Member
Tg87 Sr. Member
TheClownSong Sr. Member
TheCoinGrabber Sr. Member
The_Don Sr. Member
ThomasVeil Sr. Member
Tidsdilatation Sr. Member
TitanGEL Sr. Member
Tommot Sr. Member
TonTon Sr. Member
TravelsAsia Sr. Member
Tribizz Sr. Member
Turkoin Sr. Member
TyfrTR Sr. Member
UNOE Sr. Member
UltraPlay Sr. Member
Umbrella Holdings Sr. Member
VINSIN Sr. Member
Vanderbleek Sr. Member
Vasilije69 Sr. Member
VeiweiLo Sr. Member
Vesperion Sr. Member
VforVictory Sr. Member
ViceOfBTC21 Sr. Member
Victoo Sr. Member
Vika26 Sr. Member
Vilchaco Sr. Member
Vinaa77 Sr. Member
Virman01 Sr. Member
Viscera Sr. Member
Vlegale Sr. Member
Voidcrafter Sr. Member
Vovka4 Sr. Member
WackMack Sr. Member
Wandika Sr. Member
Wayan_Pedjeng Sr. Member
Wesimon Sr. Member
White Christmas Sr. Member
Whitly Sr. Member
WhyMe Sr. Member
Willeampere Sr. Member
Wipeout2097 Sr. Member
Wolframio Sr. Member
Wong Gendheng Sr. Member
Wysi Sr. Member
Xsinx Sr. Member
Yamifoud Sr. Member
Yoshi Livo Sr. Member
YourMom420 Sr. Member
Yza_azY Sr. Member
Zaizoun Sr. Member
Zechis966 Sr. Member
ZeroFossilFuel Sr. Member
ZhuldyzKaladinova Sr. Member
Zorik Sr. Member
[BTC]Girl Sr. Member
_Django05_ Sr. Member
_Lucky_ Sr. Member
___TR___ Sr. Member
_noname_ Sr. Member
aagert Sr. Member
abdulmad Sr. Member
abramovich Sr. Member
acedia Sr. Member
aces777 Sr. Member
acharias Sr. Member
acpr23 Sr. Member
adabau Sr. Member
adorid Sr. Member
adpinbr Sr. Member
aeternus Sr. Member
agentx44 Sr. Member
ahmia39 Sr. Member
airdnasxela Sr. Member
ak49er Sr. Member
akar87 Sr. Member
al7878 Sr. Member
alankasman Sr. Member
alexsandria Sr. Member
alfaisal890 Sr. Member
aligator2017 Sr. Member
alucard20724 Sr. Member
amy1284455127 Sr. Member
andibongkol Sr. Member
andriarto Sr. Member
anehh Sr. Member
angryswamp Sr. Member
anticolay26 Sr. Member
apolok Sr. Member
appbox Sr. Member
arikassuja Sr. Member
arin_muah Sr. Member
armlock Sr. Member
arus Sr. Member
aryana42 Sr. Member
ashuawei Sr. Member
asus09 Sr. Member
asyakashi Sr. Member
auctioneeeeer Sr. Member
autada Sr. Member
avp2306 Sr. Member
awas Sr. Member
awsses Sr. Member
ayoubouni95 Sr. Member
aysg76 Sr. Member
ayu07 Sr. Member
babaya Sr. Member
babos8383 Sr. Member
babysweetTiger0401 Sr. Member
badungs Sr. Member
baga105 Sr. Member
bagera Sr. Member
bagikoin Sr. Member
bambazamba Sr. Member
basesaw Sr. Member
baskanx Sr. Member
bere3kin Sr. Member
bestBTCdomains Sr. Member
betMaster Sr. Member
betterangels Sr. Member
bettercrypto Sr. Member
betudontbet Sr. Member
bgaf Sr. Member
bhabygrim Sr. Member
bigon Sr. Member
bitboxxer Sr. Member
bitcampaign Sr. Member
bitcasino Sr. Member
bitcoinbelieve Sr. Member
bitcoineverything Sr. Member
bitcub Sr. Member
bitillionaire Sr. Member
bitofc Sr. Member
bitvalak Sr. Member
bizzargin Sr. Member
blah01 Sr. Member
bleachX Sr. Member
blockchain.hk Sr. Member
bmxakias Sr. Member
boller Sr. Member
boo50 Sr. Member
borntorun Sr. Member
bosian Sr. Member
brjameng Sr. Member
brontosaurus Sr. Member
btc4peace Sr. Member
btcdamnit Sr. Member
btcjocan Sr. Member
btcsharehub Sr. Member
btmtb Sr. Member
bubblebit Sr. Member
budiartha Sr. Member
budlo Sr. Member
bustedsynx Sr. Member
butcherboss Sr. Member
byteminr Sr. Member
calya Sr. Member
capcaypro Sr. Member
carcassone Sr. Member
cashundone Sr. Member
castiloros Sr. Member
cattani30 Sr. Member
cbIpok Sr. Member
cbtc Sr. Member
cbw Sr. Member
cercitolga4545 Sr. Member
chadtn Sr. Member
chaosagent Sr. Member
charles2k Sr. Member
cherry11800 Sr. Member
chikiuso Sr. Member
chromosoma Sr. Member
cijulangboy Sr. Member
cisA Sr. Member
cleygaux Sr. Member
clint25n Sr. Member
codenamethisNutz Sr. Member
coin2.0 Sr. Member
coinpool_de Sr. Member
contactmike1 Sr. Member
cozytrade Sr. Member
cramcram21 Sr. Member
crazybtrade Sr. Member
crazyhashmanz Sr. Member
creepyjas Sr. Member
croTek4 Sr. Member
crocozino Sr. Member
cryp24x Sr. Member
cryptocyprus Sr. Member
cryptogaga Sr. Member
cryptogeek101 Sr. Member
cryptojoe Sr. Member
cryptomad Sr. Member
cryptospreader_temp Sr. Member
cryptotore Sr. Member
crzybilly Sr. Member
dacosta Sr. Member
dadach Sr. Member
dadas15 Sr. Member
dannygroove Sr. Member
dannyjr89 Sr. Member
deathmul Sr. Member
deddod Sr. Member
deep4u Sr. Member
deepcoreotc Sr. Member
deliveryman Sr. Member
dellzxd Sr. Member
dentldir Sr. Member
devid2017btc Sr. Member
devil11 Sr. Member
devlin Sr. Member
dgigit Sr. Member
dgmon Sr. Member
dieselmeister Sr. Member
digaran2 Sr. Member
dimastegar Sr. Member
dimb Sr. Member
dimonarka Sr. Member
disam Sr. Member
djgtr Sr. Member
djuragan Sr. Member
dmamigo Sr. Member
dmgta Sr. Member
dmty.0809 Sr. Member
dnz gns Sr. Member
domoy77 Sr. Member
doothewop Sr. Member
dragonares Sr. Member
drumamat Sr. Member
drumingspz Sr. Member
drwoo Sr. Member
duyduc256 Sr. Member
dycell Sr. Member
dzkrb Sr. Member
eP Sr. Member
ePesoInitiative Sr. Member
eagle10 Sr. Member
earnbitcoins Sr. Member
edutBTC Sr. Member
edwardspitz Sr. Member
eerygarden Sr. Member
einsteinium Sr. Member
emrek Sr. Member
entropi Sr. Member
erep Sr. Member
erickastella Sr. Member
erik777 Sr. Member
europesss Sr. Member
ex33s Sr. Member
ezehy2014 Sr. Member
fairbee Sr. Member
faridkifly Sr. Member
fearofsalt Sr. Member
febriyana Sr. Member
fenghush Sr. Member
findblocks.com Sr. Member
finist Sr. Member
finity Sr. Member
finzyoj Sr. Member
fivejonnyfive Sr. Member
fkod Sr. Member
fndsr Sr. Member
formator Sr. Member
franss Sr. Member
frozenking Sr. Member
fuer44 Sr. Member
fulcare Sr. Member
fullcointalk Sr. Member
funchiestz Sr. Member
gavrilo Sr. Member
gawuk Sr. Member
george888055 Sr. Member
getmoremonline Sr. Member
ghost15 Sr. Member
ghostfaceuk Sr. Member
gielbier Sr. Member
glavos Sr. Member
glax1983 Sr. Member
gobisirom Sr. Member
golder1 Sr. Member
goldkey0070 Sr. Member
grermezter Sr. Member
gri0 Sr. Member
gtzanap Sr. Member
halker2010 Sr. Member
hanlieuiypm9832 Sr. Member
hansen.ng Sr. Member
hashtag101 Sr. Member
hellsingfan Sr. Member
hellyeahent Sr. Member
heppot Sr. Member
hikky22 Sr. Member
himozavr Sr. Member
hovrah Sr. Member
ibuddy122505 Sr. Member
iged_war Sr. Member
ikm Sr. Member
inanilujimi Sr. Member
indika Sr. Member
indo1 Sr. Member
infarterr Sr. Member
inthelongrun Sr. Member
ipsec Sr. Member
ironm@n Sr. Member
isen Sr. Member
isprofits Sr. Member
itsonlikedonkeykong Sr. Member
ivandu Sr. Member
ivanovmoscow Sr. Member
ivanpoldark Sr. Member
iyan33 Sr. Member
izotoniq Sr. Member
izunuy Sr. Member
jackchun Sr. Member
jackflag Sr. Member
jaksone Sr. Member
jambul_kribo Sr. Member
jaybny Sr. Member
jc89 Sr. Member
jcpone Sr. Member
jeeb Sr. Member
jelma Sr. Member
jems Sr. Member
jesselivermore Sr. Member
jezus Sr. Member
jh0w4n1z Sr. Member
jimhsu Sr. Member
johan11 Sr. Member
jommy99 Sr. Member
joosep Sr. Member
jorenpo Sr. Member
jovi18 Sr. Member
jovs Sr. Member
judeafante Sr. Member
judypug1956 Sr. Member
juhakall Sr. Member
jw_industry Sr. Member
jyotianand01 Sr. Member
kalenen Sr. Member
kaltar Sr. Member
kamrulhasan001 Sr. Member
kanayaTabitha Sr. Member
kawacaki Sr. Member
kaycyrpto23 Sr. Member
kayvie Sr. Member
kbhutto Sr. Member
kelseydustin Sr. Member
ken thung Sr. Member
kendedes Sr. Member
kenelmark Sr. Member
kheein Sr. Member
kikiyo Sr. Member
kirdin Sr. Member
kissmarx Sr. Member
klychmen Sr. Member
knuckey Sr. Member
kojektea Sr. Member
kololo Sr. Member
konstant111 Sr. Member
kotakamal Sr. Member
krack-r Sr. Member
kralkral Sr. Member
kumala_abi Sr. Member
kuverty Sr. Member
kynaz Sr. Member
kyori Sr. Member
l3ocky Sr. Member
lagharto Sr. Member
lankyman Sr. Member
leetcoiner Sr. Member
leexhin Sr. Member
lehard Sr. Member
lenyro Sr. Member
lesom Sr. Member
lider1971 Sr. Member
ligator19840208 Sr. Member
lind82 Sr. Member
linkme Sr. Member
linyhan Sr. Member
liqidoxgen Sr. Member
lisasteca Sr. Member
loading... Sr. Member
lolgato1 Sr. Member
lombok Sr. Member
longyenthanh Sr. Member
lovewiki Sr. Member
loveyouforever Sr. Member
loveys Sr. Member
lukmandog Sr. Member
lusiaga Sr. Member
mackenzied Sr. Member
magmar Sr. Member
makerst Sr. Member
maleemk Sr. Member
maman09 Sr. Member
mamesso Sr. Member
mandor Sr. Member
martinholly167 Sr. Member
marufnang Sr. Member
masterkiller Sr. Member
masternode Sr. Member
mattmct Sr. Member
maursader Sr. Member
mbah Sr. Member
medsi2 Sr. Member
meemiinii Sr. Member
megacrypto Sr. Member
megadeth Sr. Member
megynacuna Sr. Member
melisande Sr. Member
meph Sr. Member
merle Sr. Member
meyer Sr. Member
mig5000 Sr. Member
mig6r Sr. Member
mihaisav Sr. Member
mikewirth Sr. Member
millgates Sr. Member
minairia3 Sr. Member
mine2slow Sr. Member
miramax-10 Sr. Member
mitsarasss Sr. Member
miztaziggy Sr. Member
mkhadazz Sr. Member
mlindjo Sr. Member
mmedinas Sr. Member
mmkiwi Sr. Member
mmo_online_1981 Sr. Member
mohammedfaiz143 Sr. Member
mone99 Sr. Member
monkeybars Sr. Member
moonfrog Sr. Member
mrbanjo Sr. Member
mrvision Sr. Member
mt55 Sr. Member
naira Sr. Member
namjar Sr. Member
necromastery Sr. Member
neite99 Sr. Member
neleonele Sr. Member
nelmari Sr. Member
nelson4lov Sr. Member
nesso Sr. Member
nethan1btc Sr. Member
ngerok Sr. Member
nhaila Sr. Member
nhfccbhjdrf Sr. Member
nhminer Sr. Member
nicomedya5 Sr. Member
nicster551 Sr. Member
nid125 Sr. Member
nihilnegativum Sr. Member
ninjaskip Sr. Member
nmaryrai Sr. Member
noashh Sr. Member
nogoodcoin Sr. Member
noninum Sr. Member
nu1mlock Sr. Member
nubbins7 Sr. Member
number37 Sr. Member
nur1labs Sr. Member
nyteo Sr. Member
oginiimaoyani Sr. Member
okissabam Sr. Member
oleg1984a Sr. Member
olesya Sr. Member
olloman Sr. Member
ololajulo Sr. Member
ongahawak Sr. Member
oogone Sr. Member
optigon Sr. Member
orarider Sr. Member
ottogary Sr. Member
oxygen88 Sr. Member
paladium Sr. Member
pastan Sr. Member
patrickus Sr. Member
paulk11087 Sr. Member
pavan@hosur Sr. Member
pdogg147 Sr. Member
pentol86 Sr. Member
peschi Sr. Member
piccionipier Sr. Member
pikachuy Sr. Member
pikkie Sr. Member
pisston Sr. Member
platinum4 Sr. Member
poiseulle Sr. Member
pokerjet Sr. Member
pokeviktor Sr. Member
polemarhos888 Sr. Member
poulembertus Sr. Member
prashanta Sr. Member
preda Sr. Member
proride Sr. Member
psyx80 Sr. Member
puffmais Sr. Member
pumawolf Sr. Member
pushyk Sr. Member
putradaerah Sr. Member
quake313 Sr. Member
quang99 Sr. Member
quantum Sr. Member
quintiilieo Sr. Member
raes Sr. Member
rainingbitcoins Sr. Member
ranggenga Sr. Member
rayday11 Sr. Member
rchstr Sr. Member
reflexmk Sr. Member
renbit Sr. Member
rizkyrz Sr. Member
rjp55 Sr. Member
rlm42 Sr. Member
rmyg5907 Sr. Member
robertiv2 Sr. Member
rocketron Sr. Member
rod1234 Sr. Member
roncar Sr. Member
rossr1 Sr. Member
rubiprojects Sr. Member
ruptan Sr. Member
ryjin1007 Sr. Member
sairji Sr. Member
sammrheza Sr. Member
santygo777 Sr. Member
saymissme Sr. Member
sconklin321 Sr. Member
scott btc Sr. Member
sealofsun Sr. Member
secdark Sr. Member
seddik Sr. Member
sekalitas Sr. Member
sellrai Sr. Member
sellscript Sr. Member
septi.JR Sr. Member
sergiorus Sr. Member
sergsen Sr. Member
sert Sr. Member
shadowdio Sr. Member
shams Sr. Member
shenxirrwya1582 Sr. Member
shimbark123 Sr. Member
sidodadii Sr. Member
silverleafy Sr. Member
skarais Sr. Member
skiorf Sr. Member
skish85 Sr. Member
skypeTeo Sr. Member
slackcryptoz Sr. Member
smic Sr. Member
snowcrawl Sr. Member
snowyNNN Sr. Member
soham Sr. Member
sokusimafuckusima Sr. Member
sonic212 Sr. Member
sorji Sr. Member
spacelab Sr. Member
spadormie Sr. Member
spartanrules Sr. Member
speedy1987 Sr. Member
speedy963 Sr. Member
spike420211 Sr. Member
spin Sr. Member
sprinkles Sr. Member
stas Sr. Member
stasyk411 Sr. Member
steinkopf Sr. Member
step_mike Sr. Member
stephanirain Sr. Member
stepwilli Sr. Member
stil55 Sr. Member
strasboug Sr. Member
stryker Sr. Member
summonerrk Sr. Member
supto005 Sr. Member
surfer43 Sr. Member
suryana Sr. Member
sva_h4cky0 Sr. Member
taibas Sr. Member
taidulvseh78044 Sr. Member
tanghere02 Sr. Member
tansoft64 Sr. Member
tarolog Sr. Member
tbonetony Sr. Member
tekno Sr. Member
temeler Sr. Member
tetra Sr. Member
tezcatcatl Sr. Member
thefaucetrunner Sr. Member
thesims Sr. Member
thms Sr. Member
thunderbitz2717 Sr. Member
tianglistrik Sr. Member
tigz Sr. Member
tittensor Sr. Member
titteringtacos Sr. Member
tommy163 Sr. Member
toodamntired Sr. Member
tosmartak Sr. Member
travwill Sr. Member
trickyriky Sr. Member
ttoroie Sr. Member
tukang_rosok Sr. Member
tukangkopi Sr. Member
tunctioncloud Sr. Member
ubeing Sr. Member
ucliktea Sr. Member
udecker Sr. Member
ugr_erkn92 Sr. Member
ullikume Sr. Member
umbara ardian Sr. Member
uniquehero Sr. Member
unlock.mk Sr. Member
usamamalik555 Sr. Member
utkuy Sr. Member
valuater Sr. Member
verb Sr. Member
vinc3 Sr. Member
vincentvincent Sr. Member
vindicare Sr. Member
vivland Sr. Member
voltesbit777 Sr. Member
vvu351 Sr. Member
wakier Sr. Member
wallstone Sr. Member
wawan99 Sr. Member
weav Sr. Member
weisonghypsp291 Sr. Member
welshy9 Sr. Member
wendelllee Sr. Member
wenzuo Sr. Member
what1005 Sr. Member
whiteblue Sr. Member
wiak2 Sr. Member
wickedsick Sr. Member
wildey Sr. Member
will_k Sr. Member
wiss19 Sr. Member
wnfmzm74 Sr. Member
wolverine5pl Sr. Member
worthyou Sr. Member
wowok Sr. Member
wry Sr. Member
www.www Sr. Member
xLays Sr. Member
xapwxrm5742 Sr. Member
xonecoinlovers Sr. Member
xvids Sr. Member
xx-man Sr. Member
xx63245613 Sr. Member
xypos Sr. Member
xyzzyx Sr. Member
ya.knf Sr. Member
yatogami Sr. Member
yohananaomi Sr. Member
yrreg ger Sr. Member
yslyv Sr. Member
yuLyaS Sr. Member
yudi09 Sr. Member
yulionoo Sr. Member
zaisha Sr. Member
zhongzy Sr. Member
zidanw Sr. Member
zombie6 Sr. Member
zoom_rich Sr. Member
zucknail Sr. Member
zuzuca Sr. Member
zxl912157 Sr. Member
Sr. Member

3. Who are the Hero users that have not earned any merit?
Code:
UserName Rank
--DarkSecrets-- Hero Member
... ... Hero Member
007eminem Hero Member
727miner Hero Member
77kdub Hero Member
@Hakermania@ Hero Member
ACP Hero Member
ADcoin.me Hero Member
Ab-Soul Hero Member
Ailmand Hero Member
AirFlame Hero Member
Ais08 Hero Member
Aleister Crowley Hero Member
AlexNeto Hero Member
Altcoin Agent Hero Member
Ambros Hero Member
Amritt Hero Member
Andre# Hero Member
AndrewBUD Hero Member
AndrewK Hero Member
Andrey Hero Member
Apened Hero Member
Arcas Hero Member
Arcteryx Hero Member
ArdiPrabowo Hero Member
Armstand Hero Member
Askit2 Hero Member
Asurmen Hero Member
AuroraHF Hero Member
BTCdoaA Hero Member
BTcoint Hero Member
Beans Hero Member
BernieCoin Hero Member
Bfljosh Hero Member
BitcSeo Hero Member
Bl4ckw00d Hero Member
BlackPrapor Hero Member
Bojcha Hero Member
BtcCrazy1 Hero Member
Burovik99 Hero Member
Byte16 Hero Member
CASlO Hero Member
Cacingkemi Hero Member
Camus Hero Member
CapnBDL Hero Member
Capuchino Hero Member
CasinoBetGame Hero Member
Cazkys Hero Member
Chainger Hero Member
CharlyKa Hero Member
Cloudpost Hero Member
Coinbuddy Hero Member
Coindgr Hero Member
Coiner.de Hero Member
Colombina Hero Member
Cosbycoin Hero Member
Daffadile Hero Member
Dammitt Hero Member
DanWalker Hero Member
Darker45 Hero Member
Darwin02 Hero Member
Dhoe Hero Member
Digitalbitcoin Hero Member
DocBones Hero Member
Doging Hero Member
DrkLvr_ Hero Member
Dusty Hero Member
Easy2Mine Hero Member
ErikvanBreen Hero Member
Evan Hero Member
Ezravdb Hero Member
FFI2013 Hero Member
FastSlots Hero Member
FeelTheBeat Hero Member
Flep182 Hero Member
FreedomCoin Hero Member
Frenk Best Hero Member
Frequency Hero Member
FrictionlessCoin Hero Member
Frizz23 Hero Member
Furious 7 Hero Member
Fuzzbawls Hero Member
GHCoins45 Hero Member
GideonGono Hero Member
Google+ Hero Member
GreenCoin22 Hero Member
HarHarHar9965 Hero Member
HardwarePal Hero Member
HasHe Hero Member
Hassan02 Hero Member
ICOcountdown.com Hero Member
IamNotSure Hero Member
Icon Hero Member
InVarianT Hero Member
Inkdatar Hero Member
Isildur (official) Hero Member
J1mb0 Hero Member
JGCMiner Hero Member
JL421 Hero Member
JakeThePanda Hero Member
Jody.Drummer Hero Member
JollyTrades Hero Member
Kashif009 Hero Member
Kazadar Hero Member
KenChanYu Hero Member
KennyR Hero Member
KickAzzDude Hero Member
Koadharber Hero Member
Kolder Hero Member
KosmoKisa Hero Member
Kotone Hero Member
LieXurui Hero Member
Lion BItcoin Shop Hero Member
LiskQH Hero Member
Litejavichu Hero Member
LoneRangir Hero Member
M0ndialu Hero Member
Mahanton Hero Member
Martisor-Sobru Hero Member
Master_dandosha Hero Member
Mento Hero Member
Mkmanik Hero Member
MoneyIsDebt Hero Member
Monkey1 Hero Member
Morguk Hero Member
Mountaingoat Hero Member
Myr Hero Member
NILIcoin Hero Member
NaXxow Hero Member
Nabilo Hero Member
Nevis Hero Member
Nibelung Hero Member
Nightz Hero Member
NikiForCrypt Hero Member
OracionSeis Hero Member
OrcaTech Hero Member
Panzersin Hero Member
Pattart Hero Member
Penguen Hero Member
PokerBetting Hero Member
PonzyManCrazyLiar Hero Member
Powerpuff Hero Member
PrintMule Hero Member
RB25 Hero Member
Red_Evil Hero Member
Rinder Hero Member
Rizky Aditya Hero Member
Russlenat Hero Member
SISAR Hero Member
SONG GEET Hero Member
Selsonblue Hero Member
SimpeleSimpele Hero Member
Sjacmur Hero Member
Snub Hero Member
Soha Hero Member
Stenull Hero Member
Sumo Hero Member
TERA Hero Member
TGD Hero Member
TR8888 Hero Member
Tamilson Hero Member
TeamDisaster Hero Member
Text Hero Member
TheGodFather Hero Member
Thomas-s Hero Member
Trial Hero Member
U2 Hero Member
USScrypto Hero Member
V1saya Hero Member
Varyg Hero Member
VenMiner Hero Member
Viva! Hero Member
WalkerIVIV Hero Member
Webcelerator. Hero Member
Xantrax Hero Member
Xtar Hero Member
YIz Hero Member
YinShuiSiYuan Hero Member
ZeroTheGreat Hero Member
Zoltan450 Hero Member
aakashsangwan Hero Member
abrakadabra Hero Member
abvhiael Hero Member
aceptamosbitcoin Hero Member
acholagi Hero Member
acs267 Hero Member
adamvp Hero Member
adi33 Hero Member
ahoenk Hero Member
ainv42 Hero Member
akim Hero Member
alamin99 Hero Member
albert11 Hero Member
alinda Hero Member
amgomez Hero Member
anami57 Hero Member
andycarrol Hero Member
axxo Hero Member
badjacks99 Hero Member
basket ball Hero Member
battyKit Hero Member
bclcjunkie Hero Member
beckspace Hero Member
beijihu Hero Member
bennana Hero Member
betlord90 Hero Member
bigdude Hero Member
bighobbit Hero Member
biodieselchris Hero Member
bitjoin Hero Member
blastbob Hero Member
blockman Hero Member
bluedeep Hero Member
bobcaticus Hero Member
bogdan2323 Hero Member
bomberb17 Hero Member
bonosurgut Hero Member
brother3 Hero Member
btcney Hero Member
butya Hero Member
cabron Hero Member
cacucacok91 Hero Member
casinobonusgiveaway Hero Member
cexylikepie Hero Member
chickenado Hero Member
chineseprancing Hero Member
chixka000 Hero Member
clickerz Hero Member
coa032 Hero Member
coin-investor Hero Member
coinmenace Hero Member
coinstatic Hero Member
coldice Hero Member
coynedterm Hero Member
cozk Hero Member
croato Hero Member
crossabdd Hero Member
cryptoheadd Hero Member
cshelswell Hero Member
cxboyminer Hero Member
cyberpinoy Hero Member
cypher21 Hero Member
d@nte Hero Member
dE_logics Hero Member
dakota neat Hero Member
danipay Hero Member
dasana212 Hero Member
daxiake Hero Member
deadsilent Hero Member
dearbesz1219 Hero Member
deepocean Hero Member
djjacket Hero Member
doktor1897 Hero Member
dopey Hero Member
dustboy Hero Member
dzonikg28 Hero Member
eagleman Hero Member
ebereon Hero Member
eeX Hero Member
ekoja Hero Member
ensign_lee Hero Member
error08 Hero Member
esotericizm Hero Member
expert4knowledge Hero Member
eye4bd Hero Member
f4tal1ty Hero Member
fearcoka Hero Member
fedmahnkassad Hero Member
feedo Hero Member
felixbrucker Hero Member
filipe3x Hero Member
flyer88 Hero Member
francisdean Hero Member
frankkkkkkk Hero Member
freigeist Hero Member
futurebit640 Hero Member
gadado Hero Member
garmin Hero Member
gcoffie7 Hero Member
generous Hero Member
geoffreyqp Hero Member
gidlark1 Hero Member
gijoes Hero Member
gomei Hero Member
goodyang Hero Member
hajimasan Hero Member
helipotte Hero Member
hicaribou Hero Member
howardb Hero Member
hugolp Hero Member
hyudien Hero Member
iluvpie60 Hero Member
infazan Hero Member
infested999 Hero Member
instacalm Hero Member
inushkin Hero Member
ipanks Hero Member
irlandescoin Hero Member
isaevski Hero Member
jasonjm Hero Member
jd1959 Hero Member
jeks Hero Member
jets567 Hero Member
jkminkov Hero Member
joesmoe2012 Hero Member
jokowi Hero Member
josephdd1 Hero Member
jpcfan Hero Member
jpoker272727 Hero Member
jt byte Hero Member
junglist.massive Hero Member
katrimans Hero Member
kebabman Hero Member
kendari Hero Member
kiffner Hero Member
klidex Hero Member
kliown Hero Member
kovaa Hero Member
kr105 Hero Member
krisnt80 Hero Member
lab rat hoax Hero Member
ladydark Hero Member
laredo7mm Hero Member
laris2 Hero Member
lastlove9091 Hero Member
laugh2btc Hero Member
lega46141 Hero Member
legendbtc Hero Member
lemfuture Hero Member
leshutov Hero Member
lg15x Hero Member
lindin99 Hero Member
loaddebitcard Hero Member
longthu Hero Member
luka1987 Hero Member
masewild Hero Member
mastica Hero Member
mauriek Hero Member
mega Hero Member
meisner Hero Member
mekar sari Hero Member
mellorbo Hero Member
merlyn22 Hero Member
micher143 Hero Member
micky123 Hero Member
midnight_miner Hero Member
minime0105 Hero Member
miningnew Hero Member
minionsgelato Hero Member
mnightwaffle Hero Member
mornabo Hero Member
mrayazgul Hero Member
mrbodz Hero Member
mrjoy15 Hero Member
mrkavasaki Hero Member
mrongoz_imut Hero Member
mv1986 Hero Member
mwheeleruk Hero Member
najzenmajsen Hero Member
nasashi Hero Member
neochiny Hero Member
nession Hero Member
nick777 Hero Member
nik009 Hero Member
nrigo Hero Member
nxtZen Hero Member
onlinedragon Hero Member
pacifista Hero Member
pashh Hero Member
pcfli Hero Member
phzi Hero Member
pieppiep Hero Member
pigheadbig Hero Member
poetra2501 Hero Member
popcoins Hero Member
pr0d1gy Hero Member
prix Hero Member
prtty2gal2 Hero Member
qory Hero Member
raaajlucky Hero Member
rancidgash Hero Member
rapidleech Hero Member
rekinthis Hero Member
remistevens Hero Member
rindo Hero Member
risatrakib Hero Member
rocku12345 Hero Member
rolik2001 Hero Member
ropyu1978 Hero Member
rpg Hero Member
sacskate Hero Member
salsa321 Hero Member
sandor111 Hero Member
sapusapu Hero Member
sasa9 Hero Member
satria33 Hero Member
savioroshan Hero Member
sebungkus Hero Member
senyorito123 Hero Member
sevendust777 Hero Member
sezyumx Hero Member
shapeshiftscam Hero Member
sinner Hero Member
sir.humus Hero Member
sirohige Hero Member
smithAwesson Hero Member
smokim87 Hero Member
someonesomeone Hero Member
sotoshihero Hero Member
soul-impact Hero Member
spartan82 Hero Member
superscommessebitcoin Hero Member
surfguy72 Hero Member
sxafir Hero Member
szafa Hero Member
t39 Hero Member
tamara163 Hero Member
tarzan2 Hero Member
teilwalL05 Hero Member
teletobi Hero Member
tema Hero Member
template Hero Member
temple Hero Member
thebitstreet Hero Member
thedue Hero Member
thend1949 Hero Member
thew3apon Hero Member
thisappointed Hero Member
thresher Hero Member
timbereagle Hero Member
tkon3 Hero Member
tm2013 Hero Member
tn211 Hero Member
tobsnn Hero Member
tommyj1 Hero Member
tonnynguyen Hero Member
torikan Hero Member
tosha566 Hero Member
totoy Hero Member
truimpheriues Hero Member
turkandjaydee Hero Member
tw0rak Hero Member
twicezeroiszero Hero Member
twiifm Hero Member
ubitcoin Hero Member
ufaiz50 Hero Member
unois Hero Member
unusualfacts30 Hero Member
uservalera Hero Member
vigmar Hero Member
vitvert Hero Member
vondi1122 Hero Member
vortex1878 Hero Member
w0lf0. Hero Member
warr1979 Hero Member
wavesroom Hero Member
wdnj Hero Member
wearepoor Hero Member
wenwen478 Hero Member
wingding Hero Member
wndrbr3d Hero Member
wolfgb888 Hero Member
worldinacoin Hero Member
xeqoRameshAxueamExaqana Hero Member
xleejohnx Hero Member
xp.rie Hero Member
xwebnetwork Hero Member
xzhybbs Hero Member
yokosan Hero Member
yurez Hero Member
zanzibar Hero Member
zcxvp Hero Member
zrunfeng Hero Member
zuggu-1 Hero Member
zupdawg Hero Member
zurg Hero Member

4. Who are the Legendary users that have not earned any merit?
Code:
UserName Rank
10000usdperbtc Legendary
2double0 Legendary
50cent_rapper Legendary
5ick3uffalo Legendary
7788bitcoin Legendary
A L I E N Legendary
AcoinL.L.C Legendary
Akka Legendary
Amel Legendary
Anarchy101 Legendary
AngusCanine Legendary
Asatur Legendary
BCEmporium Legendary
Bimmerhead Legendary
BitCoinNutJob Legendary
BitNow Legendary
BitcoinEXpress Legendary
Boussac Legendary
CrackedLogic Legendary
DGulari Legendary
Dewi Aries Legendary
Dogedigital Legendary
Dotto Legendary
Dux2K Legendary
Emerge Legendary
FlensGold Legendary
Geenstijl Legendary
GhostPlayer Legendary
Gianluca95 Legendary
Gizfreak Legendary
Googlulinks Legendary
GreatOrchid Legendary
Griffith Legendary
HappyS Legendary
Hyperjacked Legendary
IBGigglin Legendary
IMZ Legendary
Jasad Legendary
Jayjay04 Legendary
Kepasa Legendary
Kupsi Legendary
Kushedout Legendary
LastClingon Legendary
Lebubar Legendary
MaRSe Legendary
Matt9301 Legendary
Mervyn_Pumpkinhead Legendary
MickGhee Legendary
Micky25 Legendary
MinermanNC Legendary
Monnt Legendary
MonsterV Legendary
MsCollec Legendary
Nahl Legendary
ONLYfree Legendary
Paraka Legendary
Patel Legendary
Pipesnake Legendary
Prelude Legendary
Republikcoin.com Legendary
RoooooR Legendary
Shkembe Legendary
SmartIphone Legendary
Snail2 Legendary
Southpaw0 Legendary
Strongkored Legendary
SwingFirst Legendary
Tauja Legendary
Taxidermista Legendary
TheKoziTwo Legendary
Tony116 Legendary
Tyke Legendary
Undermood Legendary
Winner Legendary
Wusolini Legendary
YarkoL Legendary
Zadicar Legendary
Zicadis Legendary
Zich Legendary
Zombie123 Legendary
ZyTReX Legendary
ahmedjadoon Legendary
aikklond Legendary
aistto Legendary
aleandromagno Legendary
andulolika Legendary
anirgu Legendary
anref Legendary
anticlimax Legendary
bassdude Legendary
benthach Legendary
bitcon Legendary
bithalo Legendary
bitmaster1x Legendary
bittaitaliana Legendary
bitwho Legendary
bms2013 Legendary
boestin Legendary
brian_nguyen Legendary
bspus Legendary
buygazprom Legendary
cagrund Legendary
chryspano Legendary
corather Legendary
crunck Legendary
dadingsda Legendary
danherbias07 Legendary
dave111223 Legendary
david1365 Legendary
dbt1033 Legendary
deblue Legendary
dimox Legendary
dinda22 Legendary
djnocide Legendary
dload.1 Legendary
dnaleor Legendary
dopecoindude Legendary
dunfida Legendary
e1ghtSpace Legendary
edmundduke Legendary
enhu Legendary
eroxors Legendary
escalicha Legendary
etoque Legendary
farl4web Legendary
flower1024 Legendary
frankenmint Legendary
gnargnar Legendary
goxed Legendary
grandFX Legendary
guigui371 Legendary
hahay Legendary
hazarun Legendary
hdd3go Legendary
helloge Legendary
hiddensphinx Legendary
hurricandave Legendary
ifightformerkel Legendary
innocent93 Legendary
ivan1975 Legendary
joele Legendary
johny08 Legendary
joksim299 Legendary
keithers Legendary
keyscore44 Legendary
killerjoegreece Legendary
klf Legendary
kondiomir Legendary
koshgel Legendary
kronkodil Legendary
lionheart78 Legendary
liteon Legendary
logocreator Legendary
lolxxxx Legendary
lottery248 Legendary
louiseth1 Legendary
lowbander80 Legendary
makishart Legendary
malekbaba Legendary
mamamae Legendary
mastertrader777 Legendary
matveevka Legendary
maxll Legendary
maza5 Legendary
mettalmag Legendary
michietn94 Legendary
moppang Legendary
moxl Legendary
nekochan05 Legendary
neolinkhati Legendary
nizamcc Legendary
numismatist Legendary
ny2cafuse Legendary
oli123123 Legendary
pandacoin Legendary
pbleak Legendary
pickupcoin Legendary
piebeyb Legendary
polynesia Legendary
qwed Legendary
rdnkjdi Legendary
reb0rn21 Legendary
redjedievolution Legendary
roadbits Legendary
rodrigobitcoin Legendary
s1ng Legendary
sana54210 Legendary
sardokan Legendary
schnötzel Legendary
serje Legendary
server Legendary
shaklov Legendary
silverbox Legendary
snipsnoop Legendary
splawik21 Legendary
srgkrgkj Legendary
stahanovec Legendary
supermoney Legendary
sureshnsnet Legendary
tair85 Legendary
takagari Legendary
tarmi Legendary
the_poet Legendary
thefunkybits Legendary
tiggytomb Legendary
tiozes Legendary
tobeaj2mer01 Legendary
toptek Legendary
uki Legendary
unamis76 Legendary
usao Legendary
varanvaran Legendary
viboracecata Legendary
vladimirushev Legendary
vokain Legendary
wachtwoord Legendary
wadili89 Legendary
winter Legendary
wonko86 Legendary
wpalczynski Legendary
wuqing78 Legendary
xsentus Legendary
yslyung Legendary
zork Legendary

Please let me know what you think. Have you expected these results?
Also, if you have any ideas on what would be interesting to see related to users & merit, please let me know Smiley


Disclaimer:
1. The merit data is the latest one, from Friday, Sept 28th.
2. The user data is from Sept 24th.
3. The user data is comprised of 29039 users that have interacted with merit in some way (received or sent).
1563581637
Hero Member
*
Offline Offline

Posts: 1563581637

View Profile Personal Message (Offline)

Ignore
1563581637
Reply with quote  #2

1563581637
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1563581637
Hero Member
*
Offline Offline

Posts: 1563581637

View Profile Personal Message (Offline)

Ignore
1563581637
Reply with quote  #2

1563581637
Report to moderator
1563581637
Hero Member
*
Offline Offline

Posts: 1563581637

View Profile Personal Message (Offline)

Ignore
1563581637
Reply with quote  #2

1563581637
Report to moderator
1563581637
Hero Member
*
Offline Offline

Posts: 1563581637

View Profile Personal Message (Offline)

Ignore
1563581637
Reply with quote  #2

1563581637
Report to moderator
Findingnemo
Member
**
Offline Offline

Activity: 616
Merit: 64

Keep it simple,stupid!


View Profile
October 01, 2018, 03:38:43 PM
 #2

I hope few of the members deserves merit even if they don't have any because as you said there will be problem in the merit distribution is still persists.But there were lot of high ranked members actually shared merits between their alts at the very beginning so if we don't have any airdrop merits since the implementation of the merit system the four digit number of users who don't have any merits yet will go to five digit number even.

virendarnagpal
Member
**
Offline Offline

Activity: 560
Merit: 12


View Profile
October 01, 2018, 04:04:43 PM
 #3

Nothing is 100% complete in this world.  Whatever we create initially will be having some errors.

At the start there may be more irregularities but with the  passage of time the drawbacks are identified and improvements are done.  So after some time the the creators try to make their system more and more fool proof / efficient / error free. 

LoyceV
Legendary
*
Offline Offline

Activity: 1554
Merit: 4309


Self-made Legendary outside Meta!


View Profile WWW
October 01, 2018, 07:04:37 PM
 #4

There are 1778 users ranked Sr. Member & up that have not earned any merit, they just got "airdropped" merit from when the merit system was implemented.
I would have expected a much higher number. Apparently there's less high ranking (inactive or spamming) members than I expected.
Can you also produce the numbers for Full Members?

Quote
I was caught a bit off guard by this number, as I didn't think there could be so many users that have not earned any merit.
Considering that less than 1% of all users has received Merit, the percentage of high ranking accounts is much higher. Of course, many of them had sMerit to share with their alt accounts too, which means "merit received" doesn't necessarily mean the merit was "earned".

eddie13
Hero Member
*****
Offline Offline

Activity: 1190
Merit: 950


BTC or BUST


View Profile
October 01, 2018, 07:18:56 PM
 #5

Something is wrong making your list incomplete.. Must not cover all inactive users..

I was just looking at kwukduck https://bitcointalk.org/index.php?action=profile;u=654

Legendary, no merits, not on your list..

This Space For Rent
DdmrDdmr
Hero Member
*****
Offline Offline

Activity: 560
Merit: 2450

There are lies, damned lies and statistics. MTwain


View Profile WWW
October 01, 2018, 07:39:20 PM
Last edit: October 01, 2018, 10:05:53 PM by DdmrDdmr
 #6

I think that the data in the OP is completely wrong. The lists are not members that were airdropped merit and have not sent any, but rather members that have given merit and not received any themselves.

I guess you wrote something like this on Piggy’s SQL:

select rank, count(*) nUsers
from UserData u
where (select sum(merit)from MeritData m where m.ToID  = u.UserId)=0
group by Rank

or
select rank, count(*) nUsers
from UserData u
where not exists (select 1 from MeritData m where m.ToID  = u.UserId)
group by rank

Rank   nUsers
Brand new           4
Copper Member   9
Full Member   2424
Hero Member   476
Jr. Member        29
Legendary       224
Member          2811
Newbie              13
Sr. Member     1078


The UserData table has 29039 records, one for each user that has merited or received merit. Therefore, excluding the merited you get the meriters that have not yet been merited…

You cannot know who got an initial amount of sMerit (less of all how much on an individual level), since the formula depends on their activity during the year previous to sMerit System kick-off, and you cannot know this since there is no available full DB snapshot (not just merited) dating one year before and on the date of the merit system kick-off.

vlad230
Sr. Member
****
Offline Offline

Activity: 518
Merit: 276



View Profile
October 01, 2018, 09:03:40 PM
Last edit: October 01, 2018, 09:20:25 PM by vlad230
 #7

I would have expected a much higher number. Apparently there's less high ranking (inactive or spamming) members than I expected.
Can you also produce the numbers for Full Members?
Sure, I'll create it as soon as I have some time on my hands, this week.

Considering that less than 1% of all users has received Merit, the percentage of high ranking accounts is much higher. Of course, many of them had sMerit to share with their alt accounts too, which means "merit received" doesn't necessarily mean the merit was "earned".
Yes, there may be incomplete data in the UserData table so, there could be inconsistencies.

Yeah... I agree with the "earned" part, for the sake of this experiment I considered all users to be fair and not cheaters. Obviously this can't be true  Cheesy

Something is wrong making your list incomplete.. Must not cover all inactive users..

I was just looking at kwukduck https://bitcointalk.org/index.php?action=profile;u=654

Legendary, no merits, not on your list..
Yes you are correct, that user is missing because it is not available in the DB. Unfortunately I do not control the DB. Most probably some users are missing.
If you do a simple search in the DB, you won't find any data for him in the UserData table:
Code:
SELECT * FROM UserData WHERE UserName = 'kwukduck'

Good catch though Smiley

If you search for mine, you'll get a result:
Code:
SELECT * FROM UserData WHERE UserName = 'vlad230'

I think that the data in the OP is completely wrong. The lists are not members that were airdropped merit and have not sent any, but rather members that have given merit and not received any themselves.

I guess you write something like this on Piggy’s SQL:

select rank, count(*) nUsers
from UserData u
where (select sum(merit)from MeritData m where m.ToID  = u.UserId)=0
group by Rank

or
select rank, count(*) nUsers
from UserData u
where not exists (select 1 from MeritData m where m.ToID  = u.UserId)
group by rank
[..]
I understand your concerns but I believe my queries are correct. I'm using a more complicated approach, research SQL JOINS.
It should be easy to check though, if you find any user listed in the OP that has received merit prior to Sept 28th (latest merit data date) then I'm wrong Smiley

Regarding the queries you listed there, I'm sorry to say they are wrong. The first issue I see, is that you're trying to sum() something which does not exist (merit received for these users).

You cannot know who got an initial amount of sMerit (less of all how much on an individual level), since the formula depends on their activity during the year previous to sMerit System kick-off, and you cannot know this since there is no available full DB snapshot (not just merited) dating one year before and on the date of the merit system kick-off.
Yes, that's true you don't have that info but you need to see it in a different way.
We don't have any records of the initial merit that was airdropped but we do have the ranks of the users already so, that means they received airdropped merit (since they already have a higher rank) and we don't care how much they received either. Also, we need to keep into account that they didn't earn any merit and still have a higher rank.

Let me know if you have any questions.



Just wanted to add that Piggy's tool is really nice but I could create far more complex data analysis queries if I had more data for the user table like activity, post count, latest date active, registered date etc. I hope he will add them soon but I know the limitation here is the size of the DB that is stored for free on github .
cryptovigi
Sr. Member
****
Offline Offline

Activity: 490
Merit: 480


Self-made Sr. Member


View Profile
October 01, 2018, 10:01:21 PM
 #8

...
I was challenged by a user yesterday, in my [Merit Analysis] "Self Made" Jr. & Member users that have earned merit thread and promised I would deliver by today. Since I'm a big fan of challenges, I couldn't refuse  Cheesy
...

Man you are great!!! As I see you are really fan of stats!!!
Anyway great work and thanks for taking my challenge... I find this results quite interesting...

I'd like to play myself with such database... Few days ago i fonud only Bitcointalk Merit Dashboard by DdmrDdmr but the problem was i could download data to make some analysis on my own only in pdf format ;-( (which sucks for such purposes).
Today I read here about Piggy's SQL https://albertoit.github.io/Merit-Explorer-SQL/ - I understand that this is the source of your analysys?


Quickseller
Copper Member
Legendary
*
Offline Offline

Activity: 1848
Merit: 1717



View Profile WWW
October 01, 2018, 11:49:02 PM
Last edit: October 02, 2018, 12:01:10 AM by Quickseller
 #9

I think your list might be incomplete. See https://bitcointalk.org/index.php?action=profile;u=357263 a hero user who has not received any merit but is not on the list.

I suspect the number is far greater than what you say. If memory serves me correctly, well under 1% of all active accounts have received at least one merit as of a month or two ago.

Click Here to See Alex Morgan Twerking||2nd Video
(Videos Suchmoon doesn’t want you to see)
TeQuiero
Member
**
Offline Offline

Activity: 92
Merit: 29


View Profile
October 02, 2018, 04:16:39 AM
Last edit: October 02, 2018, 05:35:18 AM by TeQuiero
Merited by LoyceV (1)
 #10

Please let me know what you think. Have you expected these results?
Also, if you have any ideas on what would be interesting to see related to users & merit, please let me know Smiley

It took me 20-minute surfing some topics in Altcoin Discussion and I found this result. All are hero-ranked, established citizens of Altcoin Discussion board, without a single merit from default and not included in your list:
https://bitcointalk.org/index.php?action=profile;u=332316
https://bitcointalk.org/index.php?action=profile;u=370057
https://bitcointalk.org/index.php?action=profile;u=849498
https://bitcointalk.org/index.php?action=profile;u=524153
https://bitcointalk.org/index.php?action=profile;u=194388
https://bitcointalk.org/index.php?action=profile;u=105609
https://bitcointalk.org/index.php?action=profile;u=454
https://bitcointalk.org/index.php?action=profile;u=142423
https://bitcointalk.org/index.php?action=profile;u=549786
https://bitcointalk.org/index.php?action=profile;u=290496
https://bitcointalk.org/index.php?action=profile;u=372130
https://bitcointalk.org/index.php?action=profile;u=539927
https://bitcointalk.org/index.php?action=profile;u=91051

I believe the real numbers are much more larger than your result. Besides, I think there should be a demoting policy to these members. Look at their post histories, you'll see that all of their posts are in mega spam threads.

mu_enrico
Copper Member
Hero Member
*****
Offline Offline

Activity: 574
Merit: 875


Bitcoin >> Fiat


View Profile WWW
October 02, 2018, 05:04:58 AM
 #11

You know what is more interesting? Demoting them back to newbie Grin

...loteo...
DIGITAL ERA LOTTERY


r

▄▄███████████▄▄
▄███████████████████▄
▄███████████████████████▄
▄██████████████████████████▄
▄██  ███████▌ ▐██████████████▄
▐██▌ ▐█▀  ▀█    ▐█▀   ▀██▀  ▀██▌
▐██  █▌ █▌ ██  ██▌ ██▌ █▌ █▌ ██▌
▐█▌ ▐█ ▐█ ▐█▌ ▐██  ▄▄▄██ ▐█ ▐██▌
▐█  ██▄  ▄██    █▄    ██▄  ▄███▌
▀████████████████████████████▀
▀██████████████████████████▀
▀███████████████████████▀
▀███████████████████▀
▀▀███████████▀▀
r

RPLAY NOWR
BE A MOON VISITOR!
[/center]
DdmrDdmr
Hero Member
*****
Offline Offline

Activity: 560
Merit: 2450

There are lies, damned lies and statistics. MTwain


View Profile WWW
October 02, 2018, 06:32:10 AM
Merited by Jet Cash (2), LoyceV (1), vlad230 (1)
 #12

<…>I understand your concerns but I believe my queries are correct. I'm using a more complicated approach, research SQL JOINS.<...>
Maybe I didn’t explain my point clear enough. Let’s put it this way:

What your OP wants to list:
“Ranked Members - Member and above who was given merit airdrop (while introducing merit system) according to their ranks and didn't earn even one "by themself" this one maybe interesting!!!”

What you are really listing:
Members in the UserData table, that have not earned a single merit. Now the key is in understanding what is in the UserData table:

I use a very similar table as @Piggy’s, with exactly the same number of records: 29.039.Those 29.039 people in the table are those involved in a sMerit TX at any point in history. That is, those that have either sent sMerit, receives sMerit, or both.
Any user that has never sent nor received sMerit is not in the UserData table, which is likely the majority of cases that you are looking for.
So my point is that you are listing a different set of users to the intended objective (a subset really).

Note: There’s nothing wrong with Piggy’s database (it's rather similar to mine). It’s a good starting point for people that want to query and not download data themselves, buy we need to understand exactly what the tables hold. It is not a SQL issue, but a comprehension on the data in the DB.

vlad230
Sr. Member
****
Offline Offline

Activity: 518
Merit: 276



View Profile
October 02, 2018, 07:38:41 AM
 #13

I think your list might be incomplete. See https://bitcointalk.org/index.php?action=profile;u=357263 a hero user who has not received any merit but is not on the list.

I suspect the number is far greater than what you say. If memory serves me correctly, well under 1% of all active accounts have received at least one merit as of a month or two ago.
Yeah, please refer to the previous posts.

I have checked the UserData table, as DdmrDdmr said, it has only 29039 records which is a lot less that the current 2 mil members. @Piggy, any chance we could have a more detailed UserData table to be able to extract more information? I can also help with this task.
So, indeed, a lot of users are missing from the DB and this could only reflect a small portion of the users. I have updated the disclaimer.

Man you are great!!! As I see you are really fan of stats!!!
Anyway great work and thanks for taking my challenge... I find this results quite interesting...

I'd like to play myself with such database... Few days ago i fonud only Bitcointalk Merit Dashboard by DdmrDdmr but the problem was i could download data to make some analysis on my own only in pdf format ;-( (which sucks for such purposes).
Today I read here about Piggy's SQL https://albertoit.github.io/Merit-Explorer-SQL/ - I understand that this is the source of your analysys?
Thanks a lot! Yes, that's where I'm getting the stats from.

What you are really listing:
Members in the UserData table, that have not earned a single merit. Now the key is in understanding what is in the UserData table:

I use a very similar table as @Piggy’s, with exactly the same number of records: 29.039.Those 29.039 people in the table are those involved in a sMerit TX at any point in history. That is, those that have either sent sMerit, receives sMerit, or both.
Any user that has never sent nor received sMerit is not in the UserData table, which is likely the majority of cases that you are looking for.
So my point is that you are listing a different set of users to the intended objective (a subset really).

Note: There’s nothing wrong with Piggy’s database (it's rather similar to mine). It’s a good starting point for people that want to query and not download data themselves, buy we need to understand exactly what the tables hold. It is not a SQL issue, but a comprehension on the data in the DB.

Ok, I understand what you're saying now and yes, you are correct. The SQL is correct but the DB is not listing every user, I wasn't aware of this.

Anyways, even if this is a subset of the data here, we still have an idea on what is going on.

You know what is more interesting? Demoting them back to newbie Grin
I wouldn't go that far... They hanged on here for years and raised the activity. That has to be worth something.
LoyceV
Legendary
*
Offline Offline

Activity: 1554
Merit: 4309


Self-made Legendary outside Meta!


View Profile WWW
October 02, 2018, 08:07:53 AM
 #14

I use a very similar table as @Piggy’s, with exactly the same number of records: 29.039.Those 29.039 people in the table are those involved in a sMerit TX at any point in history. That is, those that have either sent sMerit, receives sMerit, or both.
This makes sense. It also means my initial assumption that I expected much higher numbers was correct.

I could quite easily produce a complete list of all higher ranked accounts with no Merit, especially since the number of accounts involved will never go up again, but I don't really want to download 2.5 million profiles just for this. It doesn't feel right to download 120 GB from the forum for something that isn't really important.
Maybe @Vod can provide a list of all user ranks since the Merit system, it would be easy to cross-reference this list with the list of merit receivers.

Veleor
Hero Member
*****
Offline Offline

Activity: 658
Merit: 814



View Profile
October 02, 2018, 11:49:07 AM
 #15

4. Who are the Legendary users that have not earned any merit?
Code:
UserName Rank
10000usdperbtc Legendary
2double0 Legendary
50cent_rapper Legendary
5ick3uffalo Legendary
7788bitcoin Legendary
A L I E N Legendary
AcoinL.L.C Legendary
Akka Legendary
Amel Legendary
Anarchy101 Legendary
AngusCanine Legendary
Asatur Legendary
BCEmporium Legendary
Bimmerhead Legendary
BitCoinNutJob Legendary
BitNow Legendary
BitcoinEXpress Legendary
Boussac Legendary
CrackedLogic Legendary
DGulari Legendary
Dewi Aries Legendary
Dogedigital Legendary
Dotto Legendary
Dux2K Legendary
Emerge Legendary
FlensGold Legendary
Geenstijl Legendary
GhostPlayer Legendary
Gianluca95 Legendary
Gizfreak Legendary
Googlulinks Legendary
GreatOrchid Legendary
Griffith Legendary
HappyS Legendary
Hyperjacked Legendary
IBGigglin Legendary
IMZ Legendary
Jasad Legendary
Jayjay04 Legendary
Kepasa Legendary
Kupsi Legendary
Kushedout Legendary
LastClingon Legendary
Lebubar Legendary
MaRSe Legendary
Matt9301 Legendary
Mervyn_Pumpkinhead Legendary
MickGhee Legendary
Micky25 Legendary
MinermanNC Legendary
Monnt Legendary
MonsterV Legendary
MsCollec Legendary
Nahl Legendary
ONLYfree Legendary
Paraka Legendary
Patel Legendary
Pipesnake Legendary
Prelude Legendary
Republikcoin.com Legendary
RoooooR Legendary
Shkembe Legendary
SmartIphone Legendary
Snail2 Legendary
Southpaw0 Legendary
Strongkored Legendary
SwingFirst Legendary
Tauja Legendary
Taxidermista Legendary
TheKoziTwo Legendary
Tony116 Legendary
Tyke Legendary
Undermood Legendary
Winner Legendary
Wusolini Legendary
YarkoL Legendary
Zadicar Legendary
Zicadis Legendary
Zich Legendary
Zombie123 Legendary
ZyTReX Legendary
ahmedjadoon Legendary
aikklond Legendary
aistto Legendary
aleandromagno Legendary
andulolika Legendary
anirgu Legendary
anref Legendary
anticlimax Legendary
bassdude Legendary
benthach Legendary
bitcon Legendary
bithalo Legendary
bitmaster1x Legendary
bittaitaliana Legendary
bitwho Legendary
bms2013 Legendary
boestin Legendary
brian_nguyen Legendary
bspus Legendary
buygazprom Legendary
cagrund Legendary
chryspano Legendary
corather Legendary
crunck Legendary
dadingsda Legendary
danherbias07 Legendary
dave111223 Legendary
david1365 Legendary
dbt1033 Legendary
deblue Legendary
dimox Legendary
dinda22 Legendary
djnocide Legendary
dload.1 Legendary
dnaleor Legendary
dopecoindude Legendary
dunfida Legendary
e1ghtSpace Legendary
edmundduke Legendary
enhu Legendary
eroxors Legendary
escalicha Legendary
etoque Legendary
farl4web Legendary
flower1024 Legendary
frankenmint Legendary
gnargnar Legendary
goxed Legendary
grandFX Legendary
guigui371 Legendary
hahay Legendary
hazarun Legendary
hdd3go Legendary
helloge Legendary
hiddensphinx Legendary
hurricandave Legendary
ifightformerkel Legendary
innocent93 Legendary
ivan1975 Legendary
joele Legendary
johny08 Legendary
joksim299 Legendary
keithers Legendary
keyscore44 Legendary
killerjoegreece Legendary
klf Legendary
kondiomir Legendary
koshgel Legendary
kronkodil Legendary
lionheart78 Legendary
liteon Legendary
logocreator Legendary
lolxxxx Legendary
lottery248 Legendary
louiseth1 Legendary
lowbander80 Legendary
makishart Legendary
malekbaba Legendary
mamamae Legendary
mastertrader777 Legendary
matveevka Legendary
maxll Legendary
maza5 Legendary
mettalmag Legendary
michietn94 Legendary
moppang Legendary
moxl Legendary
nekochan05 Legendary
neolinkhati Legendary
nizamcc Legendary
numismatist Legendary
ny2cafuse Legendary
oli123123 Legendary
pandacoin Legendary
pbleak Legendary
pickupcoin Legendary
piebeyb Legendary
polynesia Legendary
qwed Legendary
rdnkjdi Legendary
reb0rn21 Legendary
redjedievolution Legendary
roadbits Legendary
rodrigobitcoin Legendary
s1ng Legendary
sana54210 Legendary
sardokan Legendary
schnötzel Legendary
serje Legendary
server Legendary
shaklov Legendary
silverbox Legendary
snipsnoop Legendary
splawik21 Legendary
srgkrgkj Legendary
stahanovec Legendary
supermoney Legendary
sureshnsnet Legendary
tair85 Legendary
takagari Legendary
tarmi Legendary
the_poet Legendary
thefunkybits Legendary
tiggytomb Legendary
tiozes Legendary
tobeaj2mer01 Legendary
toptek Legendary
uki Legendary
unamis76 Legendary
usao Legendary
varanvaran Legendary
viboracecata Legendary
vladimirushev Legendary
vokain Legendary
wachtwoord Legendary
wadili89 Legendary
winter Legendary
wonko86 Legendary
wpalczynski Legendary
wuqing78 Legendary
xsentus Legendary
yslyung Legendary
zork Legendary

Three legendaries from the list have been banned:

[BPIP] 10000usdperbtc
[BPIP] chryspano
[BPIP] hdd3go

manfredmann
Member
**
Offline Offline

Activity: 420
Merit: 16

"I AM A TEACHER"


View Profile WWW
October 02, 2018, 02:35:04 PM
 #16

I was really inspired by your post especially in technical aspects. If you may I would like to ask you on how did you extract the data for this forum? Is it really alright for the admin if one will going to do like this? I am not against this type of post taking some technical aspects of the forum in fact I was curios on one how to extract data for this forum? Is the forum not secured and could be access its system or breaching the system?

vlad230
Sr. Member
****
Offline Offline

Activity: 518
Merit: 276



View Profile
October 02, 2018, 06:26:11 PM
 #17

I was really inspired by your post especially in technical aspects. If you may I would like to ask you on how did you extract the data for this forum? Is it really alright for the admin if one will going to do like this? I am not against this type of post taking some technical aspects of the forum in fact I was curios on one how to extract data for this forum? Is the forum not secured and could be access its system or breaching the system?
There is a public data dump which was published (it gets refreshed every Friday). Piggy took it and created a MySQL DB from it & a basic UI to query it here: https://albertoit.github.io/Merit-Explorer-SQL/

If you're not familiar with SQL you can find a lot about it online. It's the most common DB querying language available right now.
A good place to start would be: https://www.w3schools.com/sql/
vphasitha01
Full Member
***
Offline Offline

Activity: 196
Merit: 172


View Profile
October 02, 2018, 06:33:03 PM
 #18

You know what is more interesting? Demoting them back to newbie Grin
I wouldn't go that far... They hanged on here for years and raised the activity. That has to be worth something.
I don't agree with both of you because just hanging on here but not giving anything to other members for years wouldn't mean anything at all to me.

Demoting them back to the newbies by just simply disregarding the activity they achieved through their career is not an option too.

What I think is the answer is laying between above two options. How about if we implement a system for trigger( having opptunity to award merits)the airdrop merits only when a user earned some predefined merits. By that way we can reduse most of the merit abuse cases where users tends to giving away merits for their alt accounts.

Any user that has never sent nor received sMerit is not in the UserData table, which is likely the majority of cases that you are looking for.
So my point is that you are listing a different set of users to the intended objective (a subset really).
I don't know why people are so worrying and anylizing about the never sent portion since it's nothing to do with the number of users ranked Sr. Members &  up that have not earned any merit. Why we just couldn't consider the received sMerits part only because I have seen that some members still didn't shared their intial airdrop merits at least once.
cryptovigi
Sr. Member
****
Offline Offline

Activity: 490
Merit: 480


Self-made Sr. Member


View Profile
October 04, 2018, 12:17:36 AM
Last edit: October 10, 2018, 05:03:47 PM by cryptovigi
Merited by DdmrDdmr (2), taikuri13 (1), vlad230 (1)
 #19


1. How many Sr. Member & up users exist that have not earned any merit?
Code:
1078 Sr. Members
476 Hero Members
224 Legendary Members
There are 1778 users ranked Sr. Member & up that have not earned any merit, they just got "airdropped" merit from when the merit system was implemented.
...

As you know I was the one who challenged vlad230 to make this analysis.

Unfortunately I’ve read that this results due to a limited only data source (only given and received merits) its results may be far from the reality.
I was really interested in the results, so I was looking for a way to make this analysis in a more appropriate way. I didn’t find a database which contains all users who was airdropped a merit, I didn’t find also a database with current number of users and their ranks and the number of merits held…. But I found some further threads by mazdafunsun who scraped first 2 million users of Bitcointalk in July this year https://bitcointalk.org/index.php?topic=4901670.0;all and decided to take take this numbers to make some comparison….

I took this number than checked how many users has ranked up since July. To check it I took all users who has received any merit from https://albertoit.github.io/Merit-Explorer-SQL/ than checked current merit number on the bitcointalk.com site. After deduction I got the number of airdropped merit to each user (who have received at least one merit). Then I checked once again on merit explorer number of merit given till July. Thanks to that I was able to correct mazdafunsun’s result with rank promotions
by merit since July (there still be some inaccuracy because probably some users has been promoted since July by activity, unfortunately I have no way to check it...)

After comparing these results with given merit in merit explorer I’ve received such set of data:

Rank                       number of users      number of users      
received at least
1 merit

number of users      
with who didn’t
earn any merit

Member27 9184 744 (17%)23 174  (83%)
Full Member18 1813 173 (17,45%)15 008  (82,55%)
Sr. Member9 0161 818 (20,16%)7 198  (79,84%)
Hero Member4 1431 105 (26,67%)3 038  (73,33%)
Legendary2 1451 133 (52,82%)1 012  (47,18%)

As you can see, my results differ significantly from vlad230's and the numbers are few times bigger.

@vlad230: I think that case you should update numbers or description in your opening post...

It looks like there are really plenty of high ranked users who hasn't earn even one merit yet. Probably some of them are "dead souls" - users who aren't active for many month or even years, but for sure there are as well a lot of "ranked" users who simply didn't deserved any merit yet. This number decreases (percentage) with the increase of rhe rank, but its level in all groups (maybe exept Legendary) remains high.

So  guys look at these numbers and be little more lenient for newbies and jr. members  as you see the rank not always it determines their value...




dumedoiiph
Member
**
Offline Offline

Activity: 99
Merit: 12


View Profile
November 05, 2018, 03:34:04 AM
 #20

The results of merit data analyis made by @cryptovigi, shown that there are un-significant difference between lower- and higher-ranked users in the forum in terms of ability to earn at least one merit via their really construtive stuffs.
Only Ledgendary rank is different from other ranks.
It means there are so many shitty Senior and Hero users around the forum. They have been unable to earn at least 1 merit point almost 10 months after the day merit system and new rank requirements implemented.
Pages: [1] 2 »  All
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!