Topic: Ranking based on Merit received by distinct users + stats requested by users. (Read 720 times)

Rank UserName count (distinct m.fromid) Previous Value
1 theymos 640 565
2 LoyceV 274 232
3 Vod 229 201
4 Jet Cash 208 187
5 DdmrDdmr 202 158
6 The Pharmacist 196 156
7 explorder 194 192
8 suchmoon 190 147
9 satoshi 171 144
10 TMAN 160 141
11 hilariousetc 159 150
12 o_e_l_e_o 156 115
13 yahoo62278 156 145
14 iasenko 153 136
15 bill gator 150 147
16 bitmover 150 127
17 OgNasty 149 121
18 Lutpin 143 141
19 Last of the V8s 142 120
20 xtraelv 142 124
21 DarkStar_ 140 114
22 gentlemand 140 115
23 qwk 138 112
24 Piggy 135 113
25 nullius 135 132
26 micgoossens 134 94
27 Lauda 133 117
28 TheQuin 133 131
29 ui_zakharchenko 133 133
30 TryNinja 130 111
31 Coolcryptovator 129 101
32 marlboroza 129 109
33 coinlocket$ 128 103
34 LeGaulois 125 113
35 krogothmanhattan 125 103
36 tvplus006 124 114
37 achow101 123 109
38 HCP 119 109
39 JayJuanGee 116 108
40 franky1 116 96
41 HairyMaclairy 115 91
42 Hhampuz 115 95
43 xhomerx10 114 89
44 pooya87 109 92
45 BTCforJoe 108 108
46 theyoungmillionaire 108 108
47 QuestionAuthority 107 92
48 joniboini 106 99
49 stompix 105 96
50 Smart man 104 104
51 mjglqw 104 77
52 mdayonliner 103 98
53 hilariousandco 100 90
54 Carlton Banks 99 81
55 HeRetiK 98 87
56 kenzawak 98 #N/A
57 kirreev070 98 98
58 BobLawblaw 97 86
59 actmyname 97 83
60 infofront 96 84
61 pugman 95 94
62 hugeblack 94 88
63 Welsh 93 82
64 bones261 92 61
65 DannyHamilton 91 90
66 jojo69 91 78
67 ETFbitcoin 90 68
68 d5000 90 84
69 mocacinno 90 79
70 vit05 90 75
71 sncc 89 89
72 Ranyar 88 88
73 philipma1957 88 73
74 Elwar 87 77
75 Torque 87 84
76 buwaytress 87 76
77 zentdex 87 87
78 Steamtyme 86 71
79 bob123 86 76
80 killyou72 86 84
81 1Referee 85 75
82 DooMAD 85 72
83 pandukelana2712 85 83
84 AlyattesLydia 83 82
85 cellard 83 77
86 SFR10 82 77
87 athanz88 82 81
88 crypmike 82 75
89 LFC_Bitcoin 81 58
90 Silent26 81 81
91 Kakmakr 80 73
92 Mitchell 80 73
93 bitserve 80 #N/A
94 deeperx 79 78
95 mfort312 79 77
96 r1s2g3 79 54
97 Flying Hellfish 78 70
98 Heisenberg_Hunter 78 67
99 Toxic2040 78 62
100 mindrust 77 61
101 GameKyuubi 76 65
102 gmaxwell 76 54
103 BitCryptex 75 65
104 dbshck 75 72
105 OmegaStarScream 74 61
106 Xynerise 74 74
107 AdolfinWolf 73 66
108 EcuaMobi 73 67
109 Coin-1 72 56
110 Matthias9515 72 71
111 eddie13 72 #N/A
112 nutildah 71 #N/A
113 PHI1618 70 64
114 ibminer 70 60
115 lemonrabid 70 69
116 Raja_MBZ 68 52
117 taikuri13 68 54
118 vlad230 68 68
119 paxmao 67 64
120 Samarkand 66 66
121 amishmanish 66 65
122 Foxpup 65 #N/A
123 Goran_ 65 58
124 TERA2 65 65
125 asche 65 #N/A
126 chimk 65 51
127 figmentofmyass 65 56
128 ICOEthics 64 #N/A
129 eternalgloom 64 51
130 Hydrogen 63 62
131 mikeywith 63 #N/A
132 odolvlobo 63 58
133 squatter 63 55
134 600watt 62 60
135 Coding Enthusiast 62 #N/A
136 Hakamura 62 62
137 Husna QA 62 58
138 Lafu 62 #N/A
139 ToTheMoon_XOM9IK 62 62
140 mole0815 62 51
141 nc50lc 62 61
142 roycilik 62 53
143 PavelRostov 61 61
144 Trofo 61 57
145 d_eddie 61 #N/A
146 finaleshot2016 61 60
147 hatshepsut93 61 #N/A
148 shahzadafzal 61 57
149 shorena 61 61
150 Alex_Sr 60 #N/A
151 Joel_Jantsen 60 60
152 Lucius 60 #N/A
153 bolshojkush 60 60
154 Pmalek 59 #N/A
155 poptop 59 54
156 Alone055 58 #N/A
157 Ariem 58 55
158 BrewMaster 58 54
159 Co1n 58 58
160 Quickseller 58 53
161 Sylon 58 58
162 mu_enrico 58 52
163 pitipawn 58 58
164 seoincorporation 58 #N/A
165 1miau 57 #N/A
166 cAPSLOCK 57 50
167 numanoid 57 57
168 tmfp 57 #N/A
169 Anon136 56 54
170 Juliya_D 56 #N/A
171 SaltySpitoon 56 #N/A
172 bL4nkcode 56 #N/A
173 esmanthra 56 #N/A
174 mithrim 56 56
175 sabotag3x 56 51
176 tonych 56 55
177 cabalism13 55 #N/A
178 mprep 55 #N/A
179 Paashaas 54 #N/A
180 Pursuer 54 #N/A
181 Veleor 54 #N/A
182 Xal0lex 54 #N/A
183 hirozaki faraday 54 54
184 sapta 54 53
185 xenon131 54 #N/A
186 BitcoinTurk 53 52
187 Daboy_Lyle 53 50
188 Don Pedro Dinero 53 #N/A
189 MagicSmoker 53 51
190 STT 53 #N/A
191 Slow death 53 #N/A
192 Speculatoross 53 53
193 Wind_FURY 53 51
194 aTriz 53 53
195 avikz 53 #N/A
196 butka 53 50
197 morvillz7z 53 #N/A
198 BTCMILLIONAIRE 52 #N/A
199 NeuroticFish 52 #N/A
200 TheUltraElite 52 #N/A
201 Wekkel 52 #N/A
202 jseverson 52 52
203 minerjones 52 #N/A
204 EFS 51 51
205 Ibian 51 #N/A
206 Limx Dev 51 #N/A
207 ocminer 51 #N/A
208 toknormal 51 #N/A
209 Claymore 50 50
210 LTU_btc 50 #N/A
211 S_Therapist 50 #N/A
212 cryptovigi 50 #N/A
213 kaar 50 50
214 kurious 50 #N/A

select u1.username, A.toid,A.summerit from userdata u1 ,(select m.toid,sum(m.Merit) summerit from Meritdata m group by m.toid order by sum(m.merit) desc limit 200)A ) and u1.userid=A.toid;

select u1.username,sum(r.merit) from Meritdata r, userdata u1 where r.fromid not in ( select A.toid from (select m.toid,sum(m.Merit) from Meritdata m group by m.toid order by sum(m.merit) desc limit 200)A ) and u1.userid=r.toid
group by u1.username order by sum(r.merit) desc limit 200;

select sum(A.summerit) from (select sum(m.Merit) summerit  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100) A ;
48648  total merit recieved by top 100

select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100 );  
47776  Total merit given by top 100

select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100 )
and  m1.toid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100 ) ;    
15903 is total number of merit given by top 100 to top 100

select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100 )
and  m1.toid not in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100 ) ;  
31873 is total number of merit given by top 100 that are not in top 100

select sum(A.summerit) from (select sum(m.Merit) summerit  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200) A ;  
69120 is total merit recieved by top 200.

select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200 );  

65641 total merit given by top 200.


select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200 )
and  m1.toid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200 ) ;  
29958 is total merit given by top 200 to top 200.

select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200 )
and  m1.toid not in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200 ) ;  

35683 is total merit given by top 200 that are not in top 200.

select u.username,count (distinct m.subboard)  from userdata u,meritdata m where u.userid=m.toid
group by u.username having count (distinct m.subboard) >=5  order by count (distinct m.subboard) desc

UserName count (distinct m.subboard)
suchmoon 15
NeuroticFish 14
hugeblack 14
theymos 14
LeGaulois 13
LoyceV 13
bill gator 13
bitmover 13
gentlemand 13
vit05 13
ETFbitcoin 12
Heisenberg_Hunter 12
Lauda 12
Leteravian 12
OgNasty 12
OmegaStarScream 12
Quickseller 12
Steamtyme 12
iasenko 12
nc50lc 12
seoincorporation 12
xtraelv 12
DarkStar_ 11
Direwolve735 11
HeRetiK 11
Jet Cash 11
The Pharmacist 11
TheQuin 11
aleksej996 11
eternalgloom 11
jhenfelipe 11
mdayonliner 11
mocacinno 11
o_e_l_e_o 11
BitCryptex 10
HCP 10
Parodium 10
TryNinja 10
Vod 10
amishmanish 10
butka 10
coinlocket$ 10
franky1 10
joniboini 10
marlboroza 10
mjglqw 10
shahzadafzal 10
stompix 10
vlad230 10
xhomerx10 10
BTCforJoe 9
DireWolfM14 9
Don Pedro Dinero 9
European Central Bank 9
Gleb Gamow 9
Lafu 9
Samarkand 9
Seetheummerallyeah 9
Thirdspace 9
Trofo 9
bitperson 9
bones261 9
cryptothief 9
d5000 9
mindrust 9
odolvlobo 9
r1s2g3 9
steve_rogers 9
theyoungmillionaire 9
tmfp 9
AverageGlabella 8
BitcoinTurk 8
ChiBitCTy 8
DannyHamilton 8
DaveF 8
DdmrDdmr 8
DooMAD 8
EcuaMobi 8
Flying Hellfish 8
Foxpup 8
Kate Beckett 8
KingScorpio 8
LTU_btc 8
Last of the V8s 8
LastJedi 8
LogitechMouse 8
Raja_MBZ 8
RivAngE 8
RodeoX 8
Sellingaccs 8
Thekool1s 8
adaseb 8
alani123 8
alia 8
aoluain 8
athanz88 8
atrocityx 8
buwaytress 8
edgycorner 8
guybrushthreepwood 8
harizen 8
iluvbitcoins 8
legendster 8
nullius 8
pawel7777 8
paxmao 8
philipma1957 8
pooya87 8
shield132 8
shorena 8
squatter 8
wwzsocki 8
AdolfinWolf 7
Anon136 7
BitMaxz 7
Bonakid 7
Branko 7
CarlosCorreia 7
Carlton Banks 7
Crypto Girl 7
Daboy_Lyle 7
Elwar 7
EthanB 7
Gummybear67 7
Hueristic 7
Kakmakr 7
Kemarit 7
Lucius 7
MadGamer 7
Makkara 7
Mpamaegbu 7
Nestade 7
OriginTrain 7
Paractor 7
Piggy 7
Pursuer 7
RGBKey 7
Slow death 7
Speculatoross 7
TMAN 7
Theb 7
Welsh 7
Wind_FURY 7
Wipro 7
YuTü.Co.in 7
asche 7
audaciousbeing 7
big_daddy 7
bob123 7
cellard 7
criptix 7
denis-z12 7
digaran 7
dooglus 7
eddie13 7
figmentofmyass 7
green547 7
hilariousandco 7
hilariousetc 7
ibminer 7
jackg 7
kenzawak 7
khufuking 7
macartem 7
mithrim 7
nngella 7
orkoso 7
poptok1 7
ranman09 7
spirali 7
sud 7
vapourminer 7
vphasitha01 7
yojodojo21 7
1Referee 6
ACVinegar 6
AngelSky 6
ArkiCrypto 6
Astargath 6
Avirunes 6
BTCMILLIONAIRE 6
Baofeng 6
Baoo 6
BayAreaCoins 6
Beerwizzard 6
BenOnceAgain 6
BillyBobZorton 6
BitcoinFX 6
Bitfort 6
BlockEye 6
Blue Tyrant 6
BobLawblaw 6
BrewMaster 6
CoinEraser 6
Dabs 6
Dread Pirate Roberts 6
Fazlurkhan.kz 6
Flodner 6
FrueGreads 6
Furgon Chino 6
Harlot 6
Hhampuz 6
Hydrogen 6
Jating 6
JayJuanGee 6
Joel_Jantsen 6
Kevin77 6
Kprawn 6
LFC_Bitcoin 6
Liza Soberano 6
LtMotioN 6
Lutpin 6
Neelix 6
Pleione527 6
Pmalek 6
QuestionAuthority 6
SFR10 6
Searing 6
Silent26 6
TECSHARE 6
Taras 6
TeQuiero 6
ThePunisher49X 6
Upgrade00 6
Zandar 6
Zwei 6
achow101 6
ahmad21 6
allahabadi 6
ausbit 6
bbc.reporter 6
bitChipper 6
bitart 6
bitbunnny 6
cissrawk 6
coin8coin8 6
crairezx20 6
crwth 6
crypmike 6
cryptohunter 6
cynical 6
dado7 6
darkangel11 6
dreamax25 6
finaleshot2016 6
friends1980 6
fxstrike 6
haroldtee 6
jseverson 6
jtipt 6
julerz12 6
killyou72 6
kirreev070 6
leea-1334 6
levyashin 6
lolchina 6
maarx 6
markj113 6
mattcode 6
mrcash02 6
mu_enrico 6
nutildah 6
pvk444 6
qwk 6
reflector 6
richardsNY 6
roll on 6
shasan 6
siddartha1492 6
squatz1 6
veleten 6
vladimirhf 6
1993jochico 5
2112 5
8Habits 5
AGD 5
Aikidoka 5
Ale88 5
Altcoindealer 5
Aura 5
BTCHadzija 5
BTCLovingDude 5
BTCeminjas 5
BTRIC 5
Barcode_ 5
BitPotus 5
BitcoinHodler 5
BitcoinSupremo 5
Bushrat Jahan 5
Cobalt9317 5
Cocojam0610 5
Coding Enthusiast 5
CoinClarity 5
Coin_trader 5
Coolcryptovator 5
CryptoBry 5
CryptopreneurBrainboss 5
DimaS1574 5
F2b 5
Febo 5
Gavin Andresen 5
Globb0 5
Guvn0r 5
HabBear 5
Hazaki 5
Helana 5
Heyyyrenz 5
Initscri 5
InvoKing 5
JohnUser 5
JollyGood 5
Jrashid 5
Juggy777 5
JungleOnion 5
Karartma1 5
Klara_karlovna 5
KonstantinosM 5
Lovecove 5
MagicSmoker 5
Mardoker135 5
Mind Control 5
Minnie1928 5
MoonIsBlue 5
Moxivuki 5
NadiaHel 5
Naida_BR 5
Patatas 5
Protected101 5
PsylockReborn 5
Red-Apple 5
S3cco 5
STT 5
SaltySpitoon 5
SergiuDemerji 5
Squishy01 5
Sutters Mill 5
SyGambler 5
TheArchaeologist 5
TheNewAnon135246 5
TheUltraElite 5
Timelord2067 5
TimtheYoutuber 5
TitanAI 5
Titus Maximus 5
TravelMug 5
Traxo 5
Tszunami98 5
Tyrantt 5
Whosdaddy 5
Xynerise 5
Yantoaja 5
Zapo 5
aTriz 5
ace4549 5
actmyname 5
aencarnaci 5
aliashraf 5
allohha 5
alyssa85 5
angel55 5
anjho.ace 5
apoorvlathey 5
bL4nkcode 5
bakasabo 5
baricuri 5
batang_bitcoin 5
botany 5
btc_angela 5
btcltcdigger 5
celtic99 5
coly20032003 5
coolws 5
cry4crypto 5
crypto mania 5
cryptoaddictchie 5
deevan 5
dogtana 5
dothebeats 5
dumbtool45 5
examplens 5
fillippone 5
gmaxwell 5
gunhell16 5
hase0278 5
hous26 5
hubballi 5
hurry_hore 5
iambakov 5
infofront 5
iqlimasyadiqa 5
irfan_pak10 5
jemarleon 5
jjeeppeerrxx 5
jojo69 5
jonemil24 5
jossiel 5
jvdp 5
k0er 5
kiemnhieutien 5
kjnfmplm 5
klaaas 5
knight20 5
kpcian 5
krishnapramod 5
krogothmanhattan 5
kzv 5
leowonderful 5
loicuagio1979 5
magneto 5
magpie_lover 5
malikusama 5
max2607 5
mazdafunsun 5
mharz 5
mikeywith 5
mikfresh 5
minerjones 5
mprep 5
nafantc 5
onrise 5
owlcatz 5
pixie85 5
psycodad 5
pugman 5
qiwoman2 5
rajurathod18 5
ralle14 5
ranochigo 5
raske 5
rhamzter 5
sapta 5
silent17 5
sirazimuth 5
slaman29 5
sluppy 5
sncc 5
solarion 5
ss890 5
starmyc 5
stomachgrowls 5
supermine 5
swogerino 5
tactac 5
target 5
tbct_mt2 5
thehun 5
timoshani 5
togoshigekata 5
tomahawk9 5
tvplus006 5
tylerderden 5
tyz 5
upsidedown75 5
vella85 5
vlom 5
vv181 5
xdrpx 5
yahoo62278 5
zazarb 5
zickle 5

select u.username,count (distinct m.board)  from userdata u,meritdata m where u.userid=m.toid and m.board not in ('Message DELETED!')
group by u.username having count (distinct m.board) >=4  order by count (distinct m.board) desc;

UserName count (distinct m.board)
Anon136 5
ArkiCrypto 5
Daboy_Lyle 5
DarkStar_ 5
Direwolve735 5
DooMAD 5
Dread Pirate Roberts 5
ETFbitcoin 5
Gleb Gamow 5
Gummybear67 5
HCP 5
Heisenberg_Hunter 5
Kate Beckett 5
KingScorpio 5
Lafu 5
Lauda 5
LeGaulois 5
Liza Soberano 5
LogitechMouse 5
Lutpin 5
NeuroticFish 5
OmegaStarScream 5
RivAngE 5
Samarkand 5
Thirdspace 5
Trofo 5
TryNinja 5
anjho.ace 5
bitmover 5
cissrawk 5
coinlocket$ 5
crairezx20 5
d5000 5
denis-z12 5
edgycorner 5
fxstrike 5
harizen 5
hugeblack 5
iasenko 5
joniboini 5
macartem 5
marlboroza 5
mdayonliner 5
mindrust 5
nc50lc 5
pawel7777 5
paxmao 5
poptok1 5
ranman09 5
rhamzter 5
roll on 5
seoincorporation 5
shahzadafzal 5
spirali 5
steve_rogers 5
suchmoon 5
sud 5
timoshani 5
tmfp 5
vit05 5
vlad230 5
wwzsocki 5
xtraelv 5
yojodojo21 5
1Referee 4
1miau 4
8Habits 4
AdolfinWolf 4
AlisaWhishie 4
Analyst101 4
AngelSky 4
Aura 4
AverageGlabella 4
Avirunes 4
BTCHadzija 4
Baofeng 4
Barcode_ 4
BayAreaCoins 4
Beerwizzard 4
BillyBobZorton 4
BitCryptex 4
BitMaxz 4
BitcoinArsenal 4
BitcoinFX 4
BitcoinTurk 4
BobLawblaw 4
Bonakid 4
CarlosCorreia 4
Cobalt9317 4
Coffee135 4
CoinClarity 4
CoinEraser 4
Coin_trader 4
Crypto Girl 4
CryptoBry 4
CryptoGamblingSites 4
Crypto_Sassy 4
Dabs 4
DaveF 4
DdmrDdmr 4
DimaS1574 4
Don Pedro Dinero 4
EcuaMobi 4
Elwar 4
European Central Bank 4
F2b 4
FlightyPouch 4
Flodner 4
Flying Hellfish 4
FrueGreads 4
GDragon 4
Gordante12 4
HabBear 4
HeRetiK 4
Hueristic 4
Hydrogen 4
Jating 4
JayJuanGee 4
JeremyB 4
Joel_Jantsen 4
Kakmakr 4
Kprawn 4
LTU_btc 4
Last of the V8s 4
LastJedi 4
LoyceV 4
Lucius 4
MadGamer 4
Makkara 4
ManaMan 4
Mc_Moneysack 4
Mind Control 4
Minnie1928 4
Moxivuki 4
Mpamaegbu 4
Mycrypto1222 4
Neelix 4
Neo-Design 4
Nestade 4
OgNasty 4
OriginTrain 4
Paractor 4
Patatas 4
Piggy 4
Pleione527 4
Pmalek 4
ProofOfLambo 4
Protected101 4
PsylockReborn 4
Pursuer 4
Quarantine34 4
Quickseller 4
RGBKey 4
Raja_MBZ 4
RodeoX 4
S3cco 4
SFR10 4
STT 4
Seetheummerallyeah 4
Sellingaccs 4
Silent26 4
Slow death 4
Speculatoross 4
Star_Bucks 4
StartupAnalyst 4
Steamtyme 4
Tankdestroyer 4
Taras 4
Tekno2020 4
The Pharmacist 4
Thekool1s 4
TimtheYoutuber 4
TitanAI 4
ToTheMoon_XOM9IK 4
Traxo 4
Tszunami98 4
Tyr808 4
Upgrade00 4
Urbinklin 4
Vod 4
Wind_FURY 4
Yantoaja 4
Zandar 4
Zebra.Guy 4
ace4549 4
ahmad21 4
aleksej996 4
amishmanish 4
android17 4
aoluain 4
asche 4
athanz88 4
bL4nkcode 4
bakasabo 4
bbc.reporter 4
bill gator 4
bitChipper 4
bitbunnny 4
bitperson 4
blackmagical 4
bob123 4
bones261 4
btc-facebook 4
btcrut2017 4
butka 4
buwaytress 4
cellard 4
codemanX 4
coin8coin 4
coin8coin8 4
coinycoiny 4
coly20032003 4
coolws 4
criptix 4
crwth 4
crypmike 4
cryptohunter 4
cryptothief 4
cynical 4
dado7 4
deadley 4
dooglus 4
electrobit 4
empoy 4
eternalgloom 4
examplens 4
fanatic26 4
fanatic26_ 4
fattyforhire 4
fillippone 4
finaleshot2016 4
franky1 4
gentlemand 4
green547 4
hagiyatmaz 4
haroldtee 4
hilariousandco 4
hilariousetc 4
hopenotlate 4
hubballi 4
ibminer 4
icalical 4
iillaa 4
infofront 4
inv_ker 4
jbreher 4
jhenfelipe 4
jhongzjhong 4
jinksters09 4
john1010 4
jojo69 4
jossiel 4
jseverson 4
julerz12 4
jvdp 4
k0er 4
kenzawak 4
kevoh 4
khufuking 4
kjnfmplm 4
kzv 4
leowonderful 4
loicuagio1979 4
lok8nusa 4
lordquanta 4
lovesybitz 4
maarx 4
mattcode 4
metenjean 4
mharz 4
mikeywith 4
mikfresh 4
mimienamphine 4
mithrim 4
mjglqw 4
mocacinno 4
moneyangel 4
mu_enrico 4
nlcars 4
npredtorch 4
nullius 4
o_e_l_e_o 4
odolvlobo 4
onrise 4
orkoso 4
otandelapaz 4
philipma1957 4
pixie85 4
pugman 4
pvk444 4
qwk 4
ralle14 4
rickbig41 4
rillater 4
ruthbabe 4
sapta 4
sham100899 4
shield132 4
shorena 4
shulio 4
sidehack 4
silent17 4
squatz1 4
ss890 4
stompix 4
swogerino 4
tactac 4
target 4
theymos 4
theyoungmillionaire 4
tim-bc 4
tylerderden 4
vapourminer 4
veleten 4
wantjokull 4
waqasniaz007 4
xhomerx10 4
yahoo62278 4
ymemey 4
zenrol28 4
zlatan07 4
zoran.drobnjak 4

Rank UserName count (distinct m.fromid)
1 theymos 565
2 LoyceV 232
3 Vod 201
4 explorder 192
5 Jet Cash 187
6 DdmrDdmr 158
7 The Pharmacist 156
8 hilariousetc 150
9 bill gator 147
10 suchmoon 147
11 yahoo62278 145
12 satoshi 144
13 Lutpin 141
14 TMAN 141
15 iasenko 136
16 ui_zakharchenko 133
17 nullius 132
18 TheQuin 131
19 bitmover 127
20 xtraelv 124
21 OgNasty 121
22 Last of the V8s 120
23 Lauda 117
24 gentlemand 115
25 o_e_l_e_o 115
26 DarkStar_ 114
27 tvplus006 114
28 LeGaulois 113
29 Piggy 113
30 qwk 112
31 TryNinja 111
32 HCP 109
33 achow101 109
34 marlboroza 109
35 BTCforJoe 108
36 JayJuanGee 108
37 theyoungmillionaire 108
38 Smart man 104
39 coinlocket$ 103
40 krogothmanhattan 103
41 Coolcryptovator 101
42 joniboini 99
43 kirreev070 98
44 mdayonliner 98
45 franky1 96
46 stompix 96
47 Hhampuz 95
48 micgoossens 94
49 pugman 94
50 QuestionAuthority 92
51 pooya87 92
52 HairyMaclairy 91
53 DannyHamilton 90
54 hilariousandco 90
55 sncc 89
56 xhomerx10 89
57 Ranyar 88
58 hugeblack 88
59 HeRetiK 87
60 zentdex 87
61 BobLawblaw 86
62 Torque 84
63 d5000 84
64 infofront 84
65 killyou72 84
66 actmyname 83
67 pandukelana2712 83
68 AlyattesLydia 82
69 Welsh 82
70 Carlton Banks 81
71 Silent26 81
72 athanz88 81
73 mocacinno 79
74 deeperx 78
75 jojo69 78
76 Elwar 77
77 SFR10 77
78 cellard 77
79 mfort312 77
80 mjglqw 77
81 bob123 76
82 buwaytress 76
83 1Referee 75
84 crypmike 75
85 vit05 75
86 Xynerise 74
87 Kakmakr 73
88 Mitchell 73
89 philipma1957 73
90 DooMAD 72
91 dbshck 72
92 Matthias9515 71
93 Steamtyme 71
94 Flying Hellfish 70
95 lemonrabid 69
96 ETFbitcoin 68
97 vlad230 68
98 EcuaMobi 67
99 Heisenberg_Hunter 67
100 AdolfinWolf 66
101 Samarkand 66
102 BitCryptex 65
103 GameKyuubi 65
104 TERA2 65
105 amishmanish 65
106 PHI1618 64
107 paxmao 64
108 Hakamura 62
109 Hydrogen 62
110 ToTheMoon_XOM9IK 62
111 Toxic2040 62
112 OmegaStarScream 61
113 PavelRostov 61
114 bones261 61
115 mindrust 61
116 nc50lc 61
117 shorena 61
118 600watt 60
119 Joel_Jantsen 60
120 bolshojkush 60
121 finaleshot2016 60
122 ibminer 60
123 Co1n 58
124 Goran_ 58
125 Husna QA 58
126 LFC_Bitcoin 58
127 Sylon 58
128 odolvlobo 58
129 pitipawn 58
130 Trofo 57
131 numanoid 57
132 shahzadafzal 57
133 Coin-1 56
134 figmentofmyass 56
135 mithrim 56
136 Ariem 55
137 squatter 55
138 tonych 55
139 Anon136 54
140 BrewMaster 54
141 gmaxwell 54
142 hirozaki faraday 54
143 poptop 54
144 r1s2g3 54
145 taikuri13 54
146 Quickseller 53
147 Speculatoross 53
148 aTriz 53
149 roycilik 53
150 sapta 53
151 BitcoinTurk 52
152 Raja_MBZ 52
153 jseverson 52
154 mu_enrico 52
155 EFS 51
156 MagicSmoker 51
157 Wind_FURY 51
158 chimk 51
159 eternalgloom 51
160 mole0815 51
161 sabotag3x 51
162 Claymore 50
163 Daboy_Lyle 50
164 butka 50
165 cAPSLOCK 50
166 kaar 50

select u.username,count (distinct m.fromid)  from userdata u,meritdata m where u.userid=m.toid
group by u.username having count (distinct m.fromid) >=50  order by count (distinct m.fromid) desc ;

select A.sum_merits,f.* from
(select sum(m.merit) sum_merits ,m.fromid fid from userdata u,meritdata m where u.userid=m.toid and u.username='theymos' group by m.fromid ) A,userdata f where f.userid=A.fid
order by A.sum_merits desc;

sum_merits UserId UserName Rank
136 55384 Foxpup Legendary
96 51173 mprep Global Moderator
74 30747 Vod Legendary
66 158505 roslinpl Legendary
50 6822 Scorpion Hero Member
50 81995 peloso Legendary
50 140584 EFS Staff
50 183495 otrkid70 Legendary
50 340026 sofu Legendary
50 346731 minerjones Copper Member
50 406631 Kiritsugu Legendary
50 662288 Palider Hero Member
39 234771 suchmoon Legendary
35 18321 OgNasty Donator
35 459836 LoyceV Legendary
33 553678 rickbig41 Global Moderator
32 358020 Quickseller Copper Member
32 880238 Angelo Santos Sr. Member
32 914465 crwth Sr. Member
30 76847 notaek Legendary
29 915303 TheDistrictsProject Sr. Member
28 164822 hilariousandco Global Moderator
25 81419 ny2cafuse Legendary
25 175302 Avirunes Copper Member
25 390370 keesdewit Copper Member
25 548195 Topknotbam Legendary
25 558519 socks435 Legendary
22 402366 Betwrong Legendary
21 521899 SFR10 Legendary
20 214323 ltcrstrbrt Legendary
20 808310 batang_bitcoin Hero Member
19 23092 malevolent Staff
18 211419 redsn0w Legendary
18 527272 Wapinter Copper Member
18 747519 Sponsoredby15 Sr. Member
16 325061 pugman Legendary
16 355846 yahoo62278 Legendary
16 525058 InvoKing Legendary
15 140827 yogg Legendary
15 219961 --Encrypted-- Copper Member
15 381705 cellard Legendary
15 507936 DarkStar_ Legendary
15 755235 arwin100 Hero Member
15 836384 Frenk Best Hero Member
15 1192397 paxmao Sr. Member
14 153634 dbshck Staff
13 359658 hahay Legendary
13 875360 BicolIsarog Sr. Member
13 1291828 iasenko Sr. Member
12 364070 bitbollo Legendary
12 884853 BlackMambaPH Hero Member
11 397611 Jeremycoin Legendary
11 885934 SamReomo Sr. Member
10 55122 DiamondCardz Legendary
10 97213 deadley Legendary
10 125554 mishax1 Legendary
10 129114 xIIImaL Legendary
10 197395 fearcoka Hero Member
10 334527 izanagi narukami Legendary
10 359716 ETFbitcoin Legendary
10 369699 grandFX Legendary
10 458393 harizen Legendary
10 539350 crairezx20 Legendary
10 557413 chichidori Legendary
10 561804 JanpriX Hero Member
10 661339 Zocadas Hero Member
10 810882 BALIK Copper Member
10 826292 carlisle1 Hero Member
10 851885 jerald125 Hero Member
10 947291 Polar91 Sr. Member
10 969327 Anon11073 Staff
10 986141 Vishnu.Reang Sr. Member
10 1003345 ChipMixer Full Member
9 78147 Cyrus Administrator
9 84866 ibminer Legendary
9 697888 Script3d Hero Member
9 976210 nullius Copper Member
8 24140 qwk Donator
8 151761 CoinCube Legendary
8 249495 Cøbra Member
8 452769 bones261 Legendary
8 543626 jackg Copper Member
8 765632 bL4nkcode Copper Member
7 5797 grue Legendary
7 20174 fcmatt Legendary
7 176777 mindrust Legendary
7 379487 LFC_Bitcoin Copper Member
7 410218 ashmodeus Hero Member
7 543848 newinbtc Legendary
7 806776 digaran Hero Member
7 897509 xtraelv Sr. Member
7 1059021 Arteezy.rtx Copper Member
6 98986 TMAN Hero Member
6 133846 monbux Legendary
6 317618 nutildah Legendary
6 333524 numanoid Legendary
6 372359 krishnapramod Legendary
6 465017 actmyname Copper Member
6 553037 jhenfelipe Hero Member
6 782831 akamit Hero Member
6 841337 shield132 Hero Member
6 884600 Dahman El_Harrachi Hero Member
6 971594 centralbanksequalsbombs Sr. Member
6 1000199 krogothmanhattan Hero Member
6 1188543 o_e_l_e_o Sr. Member
5 554 Elwar Legendary
5 21178 MintCondition Legendary
5 68448 KonstantinosM Hero Member
5 71414 mnightwaffle Hero Member
5 84521 Welsh Staff
5 85981 Abdussamad Legendary
5 113670 Mitchell Staff
5 137541 twbt Legendary
5 140736 nydiacaskey01 Legendary
5 156391 abel1337 Legendary
5 161390 Cloudpost Hero Member
5 173873 xxxgoodgirls Legendary
5 252510 JayJuanGee Legendary
5 372697 Punggawa Legendary
5 393354 julian071 Hero Member
5 397737 hilariousetc Legendary
5 462517 Landak Hero Member
5 516752 DaddyMonsi Legendary
5 519783 asu Hero Member
5 535215 ralle14 Legendary
5 553066 BlockEye Legendary
5 579628 bob123 Hero Member
5 698159 Jet Cash Legendary
5 757564 Bitcoinsummoner Hero Member
5 805497 CREATIVE_Life Hero Member
5 809963 Wowcoin Hero Member
5 838716 bubblebit Sr. Member
5 849178 Mapagmahal Copper Member
5 857883 Yatsan Hero Member
5 888861 merlyn22 Hero Member
5 894829 0t3p0t Sr. Member
5 895005 Cacingkemi Hero Member
5 897586 OculusMan Hero Member
5 909116 Blake_Last Sr. Member
5 916507 liviux Full Member
5 925386 ReLieD Sr. Member
5 932714 BCTBF Sr. Member
5 954930 hirokazu Sr. Member
5 961494 theunbeatable Sr. Member
5 1011165 rjbtc2017 Sr. Member
5 1109214 f150 Full Member
5 1135453 Revenant 02 Full Member
5 1202061 chimk Full Member
5 1359124 sister1001 Member
4 3079 chris200x9 Legendary
4 6706 RodeoX Legendary
4 99837 HeRetiK Hero Member
4 114848 Financisto Hero Member
4 370611 bill gator Copper Member
4 392456 twicezeroiszero Hero Member
4 458761 vizito Legendary
4 546617 npredtorch Legendary
4 560412 Joel_Jantsen Legendary
4 798632 Woshib Hero Member
4 799123 Getcoinsite Sr. Member
4 805820 Lafu Hero Member
4 844914 Wind_FURY Hero Member
4 919736 FlamingFingers Sr. Member
4 935741 cissrawk Sr. Member
4 988740 frodocooper Staff
4 1053456 Ben271286 Full Member
4 1105948 patz22 Full Member
4 1582324 DdmrDdmr Sr. Member
3 11425 gmaxwell Staff
3 23067 FractalUniverse Hero Member
3 138637 btcton Legendary
3 163641 eternalgloom Legendary
3 172217 Matt9301 Legendary
3 182468 RGBKey Hero Member
3 183781 pawel7777 Legendary
3 257071 NeuroticFish Legendary
3 306338 dothebeats Legendary
3 350580 irfan_pak10 Copper Member
3 379147 pooya87 Legendary
3 501333 jtipt Hero Member
3 523235 knuckey Sr. Member
3 525056 BitMaxz Legendary
3 717272 trecore4 Sr. Member
3 729995 SparkyU Hero Member
3 813715 thisappointed Hero Member
3 821995 hatshepsut93 Hero Member
3 876572 limmousine Sr. Member
3 950662 julerz12 Sr. Member
3 967277 speem28 Sr. Member
3 1059032 cuo Full Member
3 1066674 yojodojo21 Full Member
3 1079049 Jessy Mediola Full Member
3 1086882 tweetbit Full Member
3 1117058 kier010 Full Member
3 1147936 rommelzkie Full Member
3 1180530 theyoungmillionaire Full Member
2 33156 vapourminer Legendary
2 62358 Gyrsur Legendary
2 74719 fruit Legendary
2 123417 digit Legendary
2 157691 piebeyb Legendary
2 178657 fr4nkthetank Legendary
2 186520 Initscri Hero Member
2 194811 vit05 Sr. Member
2 223994 Hexah Sr. Member
2 252402 TheStuhlman Legendary
2 313016 owlcatz Legendary
2 314792 examplens Legendary
2 322667 tobeaj2mer01 Legendary
2 334783 seoincorporation Legendary
2 337097 iluvbitcoins Legendary
2 346449 botany Legendary
2 347141 sapta Staff
2 358787 Dudeperfect Hero Member
2 373425 dinda22 Legendary
2 396906 bitcoinmasterlord Legendary
2 398485 xdrpx Hero Member
2 479624 Last of the V8s Legendary
2 511899 RoomBot Legendary
2 533583 Lucius Legendary
2 535846 Aleister Crowley Hero Member
2 544972 yolanda222 Legendary
2 554429 Indrawan77 Hero Member
2 554812 DeathAngel Legendary
2 556382 TheGodFather Hero Member
2 580327 eddie13 Hero Member
2 599866 eye4bd Hero Member
2 640554 Strongkored Legendary
2 688810 Tyrantt Hero Member
2 757107 Bakemat Sr. Member
2 787736 marlboroza Hero Member
2 816788 gandame Hero Member
2 818704 Soranith Hero Member
2 818934 coinmenace Hero Member
2 820936 aliashraf Sr. Member
2 854798 Oceat Sr. Member
2 862738 Astvile Sr. Member
2 877396 AdolfinWolf Hero Member
2 881564 BlackRock Sr. Member
2 894862 DaftAjax Sr. Member
2 917908 Rooster101 Sr. Member
2 926641 seven2smoke1 Full Member
2 947337 Xenrise Sr. Member
2 955917 tanghere02 Sr. Member
2 958159 onecall123 Sr. Member
2 959979 creepyjas Sr. Member
2 960511 nullCoiner Sr. Member
2 969551 SoulBargain Full Member
2 970256 btc_angela Sr. Member
2 984212 llyfee4u Full Member
2 986243 7jaka7 Sr. Member
2 989138 Maykl Sr. Member
2 1000368 LouVandetta Sr. Member
2 1013536 Be_Happy Sr. Member
2 1017434 richminded Sr. Member
2 1020285 Rebisco Full Member
2 1047996 bluefirecorp_ Member
2 1091163 Silent26 Sr. Member
2 1100851 katinko Full Member
2 1107844 amishmanish Sr. Member
2 1109403 BenOnceAgain Member
2 1180810 rodmanqs Full Member
2 1214159 Crypto Capital Member
2 1560793 sncc Sr. Member
2 1574226 mu_enrico Copper Member
2 1605387 cabalism13 Member
2 1649515 hakka Member
2 1701092 Husires Member
2 1938519 butka Full Member
2 2049993 DoriangrayTW Member
1 13544 hdclover Hero Member
1 16392 RakelA96 Member
1 17501 iCEBREAKER Legendary
1 18700 Pipesnake Legendary
1 28719 jbreher Legendary
1 32419 linkme Sr. Member
1 34692 fronti Legendary
1 35501 cAPSLOCK Legendary
1 47593 ajqjjj Hero Member
1 51285 NaXxow Hero Member
1 54791 Dabs Staff
1 58607 FuzzyBear Legendary
1 61202 AmDD Legendary
1 64748 flynn Hero Member
1 65716 CoinEraser Hero Member
1 73389 dave111223 Legendary
1 80810 solosequenosenada Sr. Member
1 85033 d5000 Legendary
1 87229 yefi Legendary
1 87449 pangu Hero Member
1 88912 600watt Legendary
1 100591 veleten Legendary
1 101872 Lauda Legendary
1 110785 AGD Legendary
1 113838 itod Legendary
1 120694 xhomerx10 Legendary
1 122077 AngelSky Hero Member
1 125747 Taras Legendary
1 131361 Timelord2067 Legendary
1 131686 HarHarHar9965 Hero Member
1 135920 aTriz Hero Member
1 136484 figmentofmyass Hero Member
1 152666 Mountaingoat Hero Member
1 153644 tyz Legendary
1 154742 anirgu Legendary
1 154816 cagrund Legendary
1 162290 bitcoinblog Sr. Member
1 162680 squatter Hero Member
1 163318 Torque Legendary
1 164749 stompix Hero Member
1 172868 Gelbstich Hero Member
1 174480 MadZ Hero Member
1 177723 hopenotlate Legendary
1 179437 w0lf0. Hero Member
1 183392 undeadbitcoiner Sr. Member
1 186337 itsonlikedonkeykong Sr. Member
1 192825 _Miracle Hero Member
1 195140 Xtar Hero Member
1 206368 cryptonit Legendary
1 208580 pol5 Legendary
1 231127 adjiadjo Legendary
1 233431 john1010 Hero Member
1 239406 Toxic2040 Sr. Member
1 240233 funsponge Hero Member
1 242809 kimamaxgreen Member
1 255065 ebliever Legendary
1 262695 OROBTC Legendary
1 289817 NotFuzzyWarm Legendary
1 303026 Velkro Legendary
1 311045 hodlcoins Legendary
1 315016 djangocoin Sr. Member
1 318891 Jocuserious Sr. Member
1 320412 5tift Hero Member
1 325680 HI-TEC99 Legendary
1 325777 lite Legendary
1 330633 s1ng Legendary
1 336203 penoze Legendary
1 338580 CrazyCraig Sr. Member
1 339978 bozo333 Sr. Member
1 340795 vanobe Member
1 341170 free-bit.co.in Hero Member
1 344995 saddampbuh Legendary
1 348185 HagssFIN Legendary
1 352642 fitraok09 Hero Member
1 353493 Dread Pirate Roberts Copper Member
1 358471 jesoa Member
1 362644 wanispwnz Full Member
1 362982 KuromaYoichi Sr. Member
1 366549 max2000irc Hero Member
1 368438 ccsang Full Member
1 368837 r1d1 Hero Member
1 369212 zazarb Legendary
1 372249 bitcoin revo Legendary
1 374061 Kakmakr Legendary
1 374598 codenamethisNutz Sr. Member
1 375981 OmegaStarScream Staff
1 378130 andycarrol Hero Member
1 378257 FrueGreads Legendary
1 385855 Patatas Legendary
1 386072 Salmen Legendary
1 387544 oHnK Hero Member
1 389271 Limx Dev Copper Member
1 391624 sonerbo Copper Member
1 393142 stingers Legendary
1 396526 ezeminer Legendary
1 397256 Bitfort Sr. Member
1 401307 zork Legendary
1 405032 rozee Legendary
1 408246 YuTü.Co.in Sr. Member
1 408367 killyou72 Copper Member
1 430390 psycodad Hero Member
1 497745 RealPhotoshoper Legendary
1 508748 Zeroxal Hero Member
1 509986 Emperor of Man Hero Member
1 510707 hanifhadzar Sr. Member
1 514956 freedoge.co Hero Member
1 516369 kamvreto Legendary
1 533006 richardsNY Legendary
1 545598 Isildur (official) Hero Member
1 557798 TryNinja Hero Member
1 569455 BobLawblaw Legendary
1 598528 debutant Hero Member
1 623643 johhnyUA Hero Member
1 643028 Greaves7 Hero Member
1 662310 Kolder Hero Member
1 662570 HabBear Hero Member
1 669141 Xavofat Hero Member
1 675302 leonix007 Sr. Member
1 703997 mrcash02 Hero Member
1 704626 moamin77 Full Member
1 735878 apoorvlathey Hero Member
1 741872 poptok1 Hero Member
1 765554 Quidat Sr. Member
1 771962 Raja_MBZ Hero Member
1 782621 alisafidel58 Full Member
1 808881 eaLiTy Hero Member
1 816300 Jelly0621 Sr. Member
1 816537 ankit10 Sr. Member
1 816896 sunsilk Hero Member
1 817592 IeSua Hero Member
1 819957 prettybuds Full Member
1 824455 nkarm1 Full Member
1 828352 Immor108 Hero Member
1 834384 mrjoy15 Hero Member
1 838362 JayCue Full Member
1 843526 bitcoinsforall Hero Member
1 849797 Loganota Hero Member
1 853829 Adbitco Sr. Member
1 854519 entrepmind23 Sr. Member
1 864005 kaicrypzen Hero Member
1 864332 Hassan02 Hero Member
1 870895 darklus123 Hero Member
1 874477 8Habits Sr. Member
1 876001 SamsungBitcoin Sr. Member
1 876156 Kaznachej123 Hero Member
1 879277 Coding Enthusiast Sr. Member
1 887277 snowyNNN Sr. Member
1 888099 finaleshot2016 Sr. Member
1 897423 spov Full Member
1 902263 carcassone Sr. Member
1 905157 anorganix Copper Member
1 908236 digitalgame4life Full Member
1 908376 MrCrank Sr. Member
1 910477 PHPSELLER Sr. Member
1 914868 ThatRandom8543 Sr. Member
1 919220 Renji Abarai Full Member
1 919836 AlcatelBravo Full Member
1 920544 Tara11 Sr. Member
1 924222 HEWRA Full Member
1 925907 okissabam Sr. Member
1 928004 kurbeks Sr. Member
1 928111 Live.me Full Member
1 932735 Akash1243 Sr. Member
1 937706 iamqw Member
1 938170 Cobalt9317 Copper Member
1 938265 kidsuzudn Full Member
1 952464 scum Member
1 961738 Tesorex Full Member
1 964169 nix_7878 Member
1 969459 Velogin Jr. Member
1 970591 jakirtanvir Full Member
1 971496 necromastery Sr. Member
1 973054 NewStar Sr. Member
1 973996 Chris314 Sr. Member
1 974425 shadowdio Sr. Member
1 978539 revenant2017 Sr. Member
1 984384 Baofeng Sr. Member
1 987982 kissmarx Sr. Member
1 995487 Kawasanz Sr. Member
1 995655 Gekkoo Sr. Member
1 998621 mrcastelo Full Member
1 1004188 Bagaji Sr. Member
1 1006408 caneca Full Member
1 1006592 nioschka Full Member
1 1009071 vinc3 Sr. Member
1 1010389 L1544 Full Member
1 1014315 Mungurul Sr. Member
1 1016829 edgycorner Full Member
1 1016958 Fujiati Full Member
1 1018532 sekapai Member
1 1019229 axiline Full Member
1 1020270 GeniusAko Full Member
1 1025090 DU18 Full Member
1 1025104 bbcolex Full Member
1 1026915 Squishy01 Member
1 1035145 Delphinus Full Member
1 1035841 josephpogi Full Member
1 1037063 Butchick Full Member
1 1045345 jatin729 Full Member
1 1045367 kurian Full Member
1 1047959 pinoyden Full Member
1 1048361 YouShallNotPass Full Member
1 1052329 Mahirap Full Member
1 1054592 Aventhe Full Member
1 1061824 Chrystora123 Full Member
1 1062153 btc78 Full Member
1 1065054 Piratte Full Member
1 1067333 micgoossens Sr. Member
1 1076800 1020kingz Full Member
1 1081647 friends1980 Full Member
1 1083030 Wingo Full Member
1 1086501 ModaFuka1994 Member
1 1095532 blacksky Full Member
1 1098120 TheKeyLongThumbI Full Member
1 1099214 Gracechen17 Full Member
1 1100191 shesheboy Full Member
1 1100242 hothot Member
1 1101238 Highspeed123 Full Member
1 1106178 wiredideas Full Member
1 1109297 Valentina N Full Member
1 1116762 imstillthebest Full Member
1 1118386 NedShift Member
1 1119424 NoMar02 Full Member
1 1121336 shoreno Full Member
1 1122795 jhongzjhong Full Member
1 1126497 Crumple Cat Full Member
1 1127008 NavI_027 Full Member
1 1127855 xXLimbXx Full Member
1 1129436 dirgayeah Full Member
1 1132169 felipe04 Full Member
1 1132999 Zastria Full Member
1 1137497 Kpmaline Jr. Member
1 1138034 dameh2100 Full Member
1 1142832 nioctiB#1 Full Member
1 1143164 LogitechMouse Full Member
1 1143460 mak2017 Full Member
1 1143867 cepedacharles29 Full Member
1 1147321 Fazlurkhan.kz Full Member
1 1148377 Tristan1337 Member
1 1156114 orionluckyse7en Full Member
1 1158586 DRAWDE_3691 Full Member
1 1159221 ferrybitcoin.1996 Full Member
1 1162741 dr.cheema Full Member
1 1171091 Shiroxx Member
1 1178098 nanna Full Member
1 1179651 sheenshane Full Member
1 1189098 sneeze11 Full Member
1 1194201 farhan28 Full Member
1 1196880 aervin11 Full Member
1 1203847 Deathgamer Member
1 1207215 cryptovagas Member
1 1232224 zenrol28 Copper Member
1 1246658 pranazzs Member
1 1249182 Godric-Gryffindor Member
1 1254896 mazdafunsun Member
1 1257516 Rosewater Foundation Full Member
1 1261329 chamika888 Member
1 1276985 WUWARAOLUOXIANG Member
1 1280710 Stamil Member
1 1289764 spiderm4n15 Member
1 1295824 cpmcgrat Member
1 1305518 akashark Member
1 1308233 peach56 Member
1 1311953 t1Zona Member
1 1318827 dxbcoin Member
1 1329214 kingjackoin Member
1 1337707 EnterTheLight Member
1 1341921 krishnaverma Member
1 1346246 orkoso Member
1 1348516 Pantoflascrypt017 Member
1 1369827 tesla80 Member
1 1374659 mightwalker Jr. Member
1 1383162 OlgaAmraie Jr. Member
1 1413633 OWZ1337 Member
1 1427952 snowblack Member
1 1432468 mdayonliner Sr. Member
1 1435147 zenman0 Member
1 1554927 bitmover Sr. Member
1 1634314 shahzadafzal Copper Member
1 1644225 unabomber Newbie
1 1645049 BitExalt Copper Member
1 1781008 Daboy_Lyle Member
1 1825672 morvillz7z Full Member
1 1837238 crypmike Full Member
1 1867995 roda00 Jr. Member
1 1878246 abhiseshakana Full Member
1 1920386 as9ardia Member
1 1980983 Coolcryptovator Copper Member
1 2003859 DireWolfM14 Member
1 2124069 vphasitha01 Full Member
1 2132794 IgorKiselev Jr. Member
1 2307759 TheArchaeologist Member
1 2363935 YOSHIE Jr. Member
1 2391740 Dont trust for money Newbie
1 2423416 S_Therapist Newbie

select A.username MeritGiver,A.Date,A.Merit,A.msg,r.username MeritReciever,A.board,a.subboard,a.titlethread from (select * from userdata u ,meritdata m where u.username='Foxpup' and u.userid=m.fromid) A, userdata r where a.toid=r.userid
and r.username='theymos';

MeritGiver Date Merit Msg MeritReciever Board SubBoard TitleThread
Foxpup 2018-10-18T12:26:26 4 5047729.msg46740675 theymos Bitcoin Development & Technical Discussion How is bitcoind “shy” when exchanging `version` packets?
Foxpup 2018-10-18T12:25:56 4 4659296.msg46290617 theymos Other Politics & Society Supreme Court pick Brett Kavanaugh
Foxpup 2018-09-29T03:07:28 2 5035303.msg46042843 theymos Other Meta Growing Blackmarket for Merit trading
Foxpup 2018-09-22T09:17:17 9 5035144.msg46014777 theymos Bitcoin Development & Technical Discussion The duplicate input vulnerability shouldn*t be forgotten
Foxpup 2018-09-20T11:35:58 4 5031079.msg45923426 theymos Bitcoin Development & Technical Discussion Flaws in LN (Lightning Network).
Foxpup 2018-09-20T05:11:43 4 5032980.msg45922658 theymos Bitcoin Development & Technical Discussion When Schnorr will be added?
Foxpup 2018-09-20T05:10:47 3 5032980.msg45920204 theymos Bitcoin Development & Technical Discussion When Schnorr will be added?
Foxpup 2018-09-18T04:29:09 1 5030366.msg45823950 theymos Other Meta Enhanced newbie restrictions & requirements
Foxpup 2018-09-18T04:06:47 2 5030366.msg45814117 theymos Other Meta Enhanced newbie restrictions & requirements
Foxpup 2018-09-18T04:04:16 5 2818350.msg45849233 theymos Other Meta Merit & new rank requirements
Foxpup 2018-09-18T03:57:23 4 5030366.msg45810953 theymos Other Meta Enhanced newbie restrictions & requirements
Foxpup 2018-09-18T03:56:13 15 5030366.msg45810047 theymos Other Meta Enhanced newbie restrictions & requirements
Foxpup 2018-08-29T03:40:45 2 4967555.msg44845552 theymos Other Meta FAO MODS: Why not charge a fee to recover hacked accounts?
Foxpup 2018-08-16T10:05:51 3 4905191.msg44172369 theymos Other Serious discussion What would the top coins be if people were sane?
Foxpup 2018-08-16T03:53:12 1 4897173.msg44101782 theymos Other Meta Can we get whoever the mod is who did this banned?
Foxpup 2018-08-05T17:05:29 4 2260983.msg43473905 theymos Bitcoin Development & Technical Discussion Creating private key from 2 different RNG:s?
Foxpup 2018-08-05T17:05:28 3 2260983.msg43445376 theymos Bitcoin Development & Technical Discussion Creating private key from 2 different RNG:s?
Foxpup 2018-07-16T02:07:15 2 4675898.msg42257358 theymos Other Meta Anunymint ban
Foxpup 2018-07-13T07:08:26 4 4659296.msg42066357 theymos Other Politics & Society Supreme Court pick Brett Kavanaugh
Foxpup 2018-07-06T14:23:51 6 4609442.msg41610959 theymos Other Meta Idea: Courses
Foxpup 2018-05-20T04:48:26 15 3920469.msg37611040 theymos Alternate cryptocurrencies Announcements (Altcoins) [ANN][PRE-ICO]HoweyCoins: the only BitcoinTalk-endorsed ICO - GUARANTEED PROFIT
Foxpup 2018-05-10T02:17:26 1 3683184.msg36818653 theymos Other Meta Report to the moderator -Deserve some rewards  
Foxpup 2018-05-05T03:29:22 1 3540892.msg36329486 theymos Other Meta Image caching
Foxpup 2018-05-01T03:49:39 3 3432369.msg35976937 theymos Other Meta Banned Account Question
Foxpup 2018-04-21T03:42:30 6 3341237.msg34961604 theymos Other Politics & Society Anacyclosis - cycles of society/government
Foxpup 2018-03-16T07:13:03 3 2945878.msg32334739 theymos Other Meta overwhelming consensus excludes Lauda, remains in DT2, went in2 buz w sold act  
Foxpup 2018-03-13T04:08:28 3 2986106.msg32186049 theymos Other Meta Newbie, Jr Members, Members suffering from merit-phobia: Explanations and Advice
Foxpup 2018-03-07T07:06:12 6 1469099.msg14823618 theymos Bitcoin Bitcoin Discussion Theymos: “Bitcoins Belonging to Satoshi Should Be Destroyed”
Foxpup 2018-03-07T07:05:55 1 1469099.msg14823504 theymos Bitcoin Bitcoin Discussion Theymos: “Bitcoins Belonging to Satoshi Should Be Destroyed”
Foxpup 2018-02-27T15:33:38 3 3030477.msg31180145 theymos Bitcoin Development & Technical Discussion Thoughts on the early bugs discovered by Peter Todd in LN?
Foxpup 2018-02-04T01:55:44 6 2818350.msg29540717 theymos Other Meta Merit & new rank requirements
Foxpup 2018-01-25T03:09:51 6 2818350.msg28856522 theymos Other Meta Merit & new rank requirements