[Merit Analysis] Users ranked Sr. Member & up that have not earned any merit

[vlad230]

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  

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


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).

[Findingnemo]

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]

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]

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?

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]

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..

[DdmrDdmr]

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]

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 

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

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

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]

...
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  
...

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]

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.

[TeQuiero]

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

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]

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

[DdmrDdmr]

<…>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]

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

I wouldn't go that far... They hanged on here for years and raised the activity. That has to be worth something.

[LoyceV]

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]

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]

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]

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]

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

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]

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
Member	27 918	4 744 (17%)	23 174  (83%)
Full Member	18 181	3 173 (17,45%)	15 008  (82,55%)
Sr. Member	9 016	1 818 (20,16%)	7 198  (79,84%)
Hero Member	4 143	1 105 (26,67%)	3 038  (73,33%)
Legendary	2 145	1 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]

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.