Re: Top 200 Merit receivers without Merit from the Top 200 Merit receivers
Excellent statistics, as usual. I will bookmark this thread and send merit when I have one.
I think someone is still hungry, can you create the same statistics for Meta? How many merits top 200/500 merit receivers have received in Meta
I think someone is still hungry, can you create the same statistics for Meta? How many merits top 200/500 merit receivers have received in Meta
You can see this data in this sheet
https://docs.google.com/spreadsheets/d/1iE2gJf7tdyAqf5VHHaoid-Mx0lhZH0UPflgdQ_Pag58/edit?usp=sharing
or alternatively in this codebox
Code:
Rank Username UserId Total Merit Merits outside Meta Merits in Meta
1 theymos 35 3062 601 2461
2 satoshi 3 1462 1462 0
3 DdmrDdmr 1582324 1371 190 1181
4 LoyceV 459836 1344 519 825
5 hilariousetc 397737 1140 154 986
6 Last of the V8s 479624 1116 1113 3
7 suchmoon 234771 1081 567 514
8 micgoossens 1067333 1052 1052 0
9 The Pharmacist 487418 1023 357 666
10 Vod 30747 872 339 533
11 xtraelv 897509 865 331 534
12 Jet Cash 698159 847 383 464
13 o_e_l_e_o 1188543 838 542 296
14 achow101 290195 799 762 37
15 Piggy 188198 788 200 588
16 Lutpin 520313 764 102 662
17 nullius 976210 764 476 288
18 gmaxwell 11425 746 676 70
19 xhomerx10 120694 736 708 28
20 TMAN 98986 700 125 575
21 Lauda 101872 675 344 331
22 krogothmanhattan 1000199 670 670 0
23 joniboini 1275282 662 641 21
24 iasenko 1291828 657 200 457
25 BobLawblaw 569455 639 637 2
26 HairyMaclairy 181806 628 628 0
27 marlboroza 787736 558 308 250
28 theyoungmillionaire 1180530 555 373 182
29 abhiseshakana 1878246 551 550 1
30 jojo69 49008 531 530 1
31 qwk 24140 529 463 66
32 bitmover 1554927 515 419 96
33 HCP 867786 500 488 12
34 bob123 579628 498 489 9
35 coinlocket$ 1339716 490 358 132
36 OgNasty 18321 487 311 176
37 sncc 1560793 487 69 418
38 mole0815 1424178 485 485 0
39 infofront 41175 484 483 1
40 JayJuanGee 252510 482 389 93
41 DarkStar_ 507936 481 345 136
42 pitipawn 1076869 478 86 392
43 BTCforJoe 557989 471 352 119
44 zazarb 369212 447 445 2
45 PHI1618 1071136 445 442 3
46 TheQuin 143168 424 204 220
47 Hhampuz 881377 424 422 2
48 GameKyuubi 26945 423 423 0
49 philipma1957 64507 423 397 26
50 Steamtyme 1112531 418 291 127
51 Carlton Banks 64205 417 414 3
52 Torque 163318 414 414 0
53 LeGaulois 507856 409 315 94
54 hilariousandco 164822 404 60 344
55 Flying Hellfish 79608 403 275 128
56 Smart man 1090672 401 401 0
57 Alex_Sr 1762404 387 135 252
58 Welsh 84521 386 72 314
59 DannyHamilton 60820 385 370 15
60 mu_enrico 1574226 376 358 18
61 BitCryptex 1169179 375 358 17
62 minerjones 346731 372 371 1
63 bill gator 370611 372 262 110
64 deeperx 1038794 367 367 0
65 QuestionAuthority 72795 364 329 35
66 roycilik 1051955 363 360 3
67 SaltySpitoon 38894 362 181 181
68 explorder 1108331 361 361 0
69 Husna QA 1827294 355 349 6
70 Toxic2040 239406 354 354 0
71 TryNinja 557798 354 245 109
72 Coolcryptovator 1980983 354 298 56
73 mfort312 182284 348 348 0
74 HeRetiK 99837 346 329 17
75 gentlemand 155345 345 334 11
76 ETFbitcoin 359716 344 272 72
77 romanornr 225292 340 340 0
78 yahoo62278 355846 339 228 111
79 gawlea 925926 329 329 0
80 stompix 164749 328 167 161
81 LFC_Bitcoin 379487 325 284 41
82 esmanthra 1764764 320 223 97
83 d_eddie 1027694 314 313 1
84 pandukelana2712 1304130 314 309 5
85 actmyname 465017 313 139 174
86 pugman 325061 311 196 115
87 Elwar 554 310 308 2
88 sidehack 130792 310 298 12
89 mdayonliner 1432468 308 109 199
90 poptop 906023 306 305 1
91 paxmao 1192397 305 200 105
92 bitserve 87930 304 304 0
93 mstfprcn 915311 303 270 33
94 ibminer 84866 298 180 118
95 franky1 65837 295 273 22
96 mocacinno 405464 294 222 72
97 pooya87 379147 287 277 10
98 AlyattesLydia 1046135 287 287 0
99 RichDaniel 886352 283 283 0
100 morvillz7z 1825672 281 187 94
101 Matthias9515 1018510 279 268 11
102 shorena 181801 278 276 2
103 taikuri13 1855828 276 260 16
104 vlad230 1268116 275 157 118
105 by rallier 152486 274 274 0
106 Claymore 306958 271 271 0
107 Xynerise 1250855 271 269 2
108 Goran_ 1039323 270 268 2
109 hugeblack 1059082 269 234 35
110 tonych 412662 267 267 0
111 d5000 85033 265 225 40
112 zentdex 1331637 264 0 264
113 kirreev070 1221497 262 209 53
114 Limx Dev 389271 259 259 0
115 zonefloor 934649 259 259 0
116 alex bond 909175 258 256 2
117 mithrim 1056258 257 236 21
118 sabotag3x 846936 254 252 2
119 saulzaents 944905 251 246 5
120 RuSS512 979216 251 97 154
121 athanz88 1141886 251 99 152
122 vit05 194811 250 197 53
123 identifyuser 227450 250 250 0
124 buwaytress 901859 250 227 23
125 Ajpa94 911155 250 175 75
126 fine99 917021 250 250 0
127 Tukang Becak 921087 250 250 0
128 ATMcoin 932514 250 250 0
129 TheBobyHunter 905442 244 244 0
130 Xal0lex 1068464 244 162 82
131 Rosewater Foundation 1257516 244 244 0
132 HagssFIN 348185 243 242 1
133 1Referee 308793 239 229 10
134 ICOEthics 2204241 238 233 5
135 Lafu 805820 235 170 65
136 1miau 2143453 235 229 6
137 kenzawak 1082600 232 225 7
138 Hal 2436 230 230 0
139 ocminer 43526 229 226 3
140 Foxpup 55384 229 131 98
141 seoincorporation 334783 229 129 100
142 crypmike 1837238 229 206 23
143 mprep 51173 228 33 195
144 jillscarbrough 447935 228 228 0
145 Twinscoin2017 1093001 228 76 152
146 BitcoinTurk 511692 226 226 0
147 cAPSLOCK 35501 225 225 0
148 nullCoiner 960511 225 225 0
149 asche 1580039 225 207 18
150 Speculatoross 1695463 225 224 1
151 arulbero 170072 224 224 0
152 killyou72 408367 223 41 182
153 Trofo 1099980 222 216 6
154 Coin-1 1133335 222 73 149
155 phantastisch 18312 221 219 2
156 trantute2 1808705 221 221 0
157 Quickseller 358020 219 139 80
158 ui_zakharchenko 1052653 219 216 3
159 laszlo 143 218 218 0
160 goldkingcoiner 1112467 215 215 0
161 Moloch 229393 214 214 0
162 aleksej996 1069508 214 207 7
163 Raja_MBZ 771962 213 211 2
164 TERA2 1285294 212 212 0
165 yogg 140827 210 210 0
166 bones261 452769 204 186 18
167 EcuaMobi 169515 203 63 140
168 amishmanish 1107844 202 174 28
169 aliashraf 820936 201 200 1
170 Aerys2 991046 201 201 0
171 Wind_FURY 844914 200 191 9
172 mjglqw 886521 198 162 36
173 Silent26 1091163 198 53 145
174 odolvlobo 62955 196 173 23
175 DooMAD 175361 196 170 26
176 AdolfinWolf 877396 195 111 84
177 Mitchell 113670 194 175 19
178 Scheede 1005083 193 193 0
179 AverageGlabella 392646 192 133 59
180 Coin++ 990983 192 192 0
181 Hydrogen 68364 191 191 0
182 eddie13 580327 191 106 85
183 Co1n 95019 190 178 12
184 alexberezov 1066970 190 190 0
185 CarlOrff 822485 189 189 0
186 NLNico 107762 188 180 8
187 ace4549 359844 188 180 8
188 r1s2g3 1446224 188 77 111
189 SFR10 521899 186 97 89
190 Joel_Jantsen 560412 186 60 126
191 mindrust 176777 185 170 15
192 BitcoinPenny 352429 184 184 0
193 EFS 140584 183 183 0
194 guybrushthreepwood 187618 183 173 10
195 Don Pedro Dinero 1107222 182 112 70
196 BrewMaster 803757 181 164 17
197 Parodium 1162397 181 155 26
198 Anon136 3028 180 179 1
199 Coding Enthusiast 879277 180 180 0
200 gbianchi 140582 179 179 0
1 theymos 35 3062 601 2461
2 satoshi 3 1462 1462 0
3 DdmrDdmr 1582324 1371 190 1181
4 LoyceV 459836 1344 519 825
5 hilariousetc 397737 1140 154 986
6 Last of the V8s 479624 1116 1113 3
7 suchmoon 234771 1081 567 514
8 micgoossens 1067333 1052 1052 0
9 The Pharmacist 487418 1023 357 666
10 Vod 30747 872 339 533
11 xtraelv 897509 865 331 534
12 Jet Cash 698159 847 383 464
13 o_e_l_e_o 1188543 838 542 296
14 achow101 290195 799 762 37
15 Piggy 188198 788 200 588
16 Lutpin 520313 764 102 662
17 nullius 976210 764 476 288
18 gmaxwell 11425 746 676 70
19 xhomerx10 120694 736 708 28
20 TMAN 98986 700 125 575
21 Lauda 101872 675 344 331
22 krogothmanhattan 1000199 670 670 0
23 joniboini 1275282 662 641 21
24 iasenko 1291828 657 200 457
25 BobLawblaw 569455 639 637 2
26 HairyMaclairy 181806 628 628 0
27 marlboroza 787736 558 308 250
28 theyoungmillionaire 1180530 555 373 182
29 abhiseshakana 1878246 551 550 1
30 jojo69 49008 531 530 1
31 qwk 24140 529 463 66
32 bitmover 1554927 515 419 96
33 HCP 867786 500 488 12
34 bob123 579628 498 489 9
35 coinlocket$ 1339716 490 358 132
36 OgNasty 18321 487 311 176
37 sncc 1560793 487 69 418
38 mole0815 1424178 485 485 0
39 infofront 41175 484 483 1
40 JayJuanGee 252510 482 389 93
41 DarkStar_ 507936 481 345 136
42 pitipawn 1076869 478 86 392
43 BTCforJoe 557989 471 352 119
44 zazarb 369212 447 445 2
45 PHI1618 1071136 445 442 3
46 TheQuin 143168 424 204 220
47 Hhampuz 881377 424 422 2
48 GameKyuubi 26945 423 423 0
49 philipma1957 64507 423 397 26
50 Steamtyme 1112531 418 291 127
51 Carlton Banks 64205 417 414 3
52 Torque 163318 414 414 0
53 LeGaulois 507856 409 315 94
54 hilariousandco 164822 404 60 344
55 Flying Hellfish 79608 403 275 128
56 Smart man 1090672 401 401 0
57 Alex_Sr 1762404 387 135 252
58 Welsh 84521 386 72 314
59 DannyHamilton 60820 385 370 15
60 mu_enrico 1574226 376 358 18
61 BitCryptex 1169179 375 358 17
62 minerjones 346731 372 371 1
63 bill gator 370611 372 262 110
64 deeperx 1038794 367 367 0
65 QuestionAuthority 72795 364 329 35
66 roycilik 1051955 363 360 3
67 SaltySpitoon 38894 362 181 181
68 explorder 1108331 361 361 0
69 Husna QA 1827294 355 349 6
70 Toxic2040 239406 354 354 0
71 TryNinja 557798 354 245 109
72 Coolcryptovator 1980983 354 298 56
73 mfort312 182284 348 348 0
74 HeRetiK 99837 346 329 17
75 gentlemand 155345 345 334 11
76 ETFbitcoin 359716 344 272 72
77 romanornr 225292 340 340 0
78 yahoo62278 355846 339 228 111
79 gawlea 925926 329 329 0
80 stompix 164749 328 167 161
81 LFC_Bitcoin 379487 325 284 41
82 esmanthra 1764764 320 223 97
83 d_eddie 1027694 314 313 1
84 pandukelana2712 1304130 314 309 5
85 actmyname 465017 313 139 174
86 pugman 325061 311 196 115
87 Elwar 554 310 308 2
88 sidehack 130792 310 298 12
89 mdayonliner 1432468 308 109 199
90 poptop 906023 306 305 1
91 paxmao 1192397 305 200 105
92 bitserve 87930 304 304 0
93 mstfprcn 915311 303 270 33
94 ibminer 84866 298 180 118
95 franky1 65837 295 273 22
96 mocacinno 405464 294 222 72
97 pooya87 379147 287 277 10
98 AlyattesLydia 1046135 287 287 0
99 RichDaniel 886352 283 283 0
100 morvillz7z 1825672 281 187 94
101 Matthias9515 1018510 279 268 11
102 shorena 181801 278 276 2
103 taikuri13 1855828 276 260 16
104 vlad230 1268116 275 157 118
105 by rallier 152486 274 274 0
106 Claymore 306958 271 271 0
107 Xynerise 1250855 271 269 2
108 Goran_ 1039323 270 268 2
109 hugeblack 1059082 269 234 35
110 tonych 412662 267 267 0
111 d5000 85033 265 225 40
112 zentdex 1331637 264 0 264
113 kirreev070 1221497 262 209 53
114 Limx Dev 389271 259 259 0
115 zonefloor 934649 259 259 0
116 alex bond 909175 258 256 2
117 mithrim 1056258 257 236 21
118 sabotag3x 846936 254 252 2
119 saulzaents 944905 251 246 5
120 RuSS512 979216 251 97 154
121 athanz88 1141886 251 99 152
122 vit05 194811 250 197 53
123 identifyuser 227450 250 250 0
124 buwaytress 901859 250 227 23
125 Ajpa94 911155 250 175 75
126 fine99 917021 250 250 0
127 Tukang Becak 921087 250 250 0
128 ATMcoin 932514 250 250 0
129 TheBobyHunter 905442 244 244 0
130 Xal0lex 1068464 244 162 82
131 Rosewater Foundation 1257516 244 244 0
132 HagssFIN 348185 243 242 1
133 1Referee 308793 239 229 10
134 ICOEthics 2204241 238 233 5
135 Lafu 805820 235 170 65
136 1miau 2143453 235 229 6
137 kenzawak 1082600 232 225 7
138 Hal 2436 230 230 0
139 ocminer 43526 229 226 3
140 Foxpup 55384 229 131 98
141 seoincorporation 334783 229 129 100
142 crypmike 1837238 229 206 23
143 mprep 51173 228 33 195
144 jillscarbrough 447935 228 228 0
145 Twinscoin2017 1093001 228 76 152
146 BitcoinTurk 511692 226 226 0
147 cAPSLOCK 35501 225 225 0
148 nullCoiner 960511 225 225 0
149 asche 1580039 225 207 18
150 Speculatoross 1695463 225 224 1
151 arulbero 170072 224 224 0
152 killyou72 408367 223 41 182
153 Trofo 1099980 222 216 6
154 Coin-1 1133335 222 73 149
155 phantastisch 18312 221 219 2
156 trantute2 1808705 221 221 0
157 Quickseller 358020 219 139 80
158 ui_zakharchenko 1052653 219 216 3
159 laszlo 143 218 218 0
160 goldkingcoiner 1112467 215 215 0
161 Moloch 229393 214 214 0
162 aleksej996 1069508 214 207 7
163 Raja_MBZ 771962 213 211 2
164 TERA2 1285294 212 212 0
165 yogg 140827 210 210 0
166 bones261 452769 204 186 18
167 EcuaMobi 169515 203 63 140
168 amishmanish 1107844 202 174 28
169 aliashraf 820936 201 200 1
170 Aerys2 991046 201 201 0
171 Wind_FURY 844914 200 191 9
172 mjglqw 886521 198 162 36
173 Silent26 1091163 198 53 145
174 odolvlobo 62955 196 173 23
175 DooMAD 175361 196 170 26
176 AdolfinWolf 877396 195 111 84
177 Mitchell 113670 194 175 19
178 Scheede 1005083 193 193 0
179 AverageGlabella 392646 192 133 59
180 Coin++ 990983 192 192 0
181 Hydrogen 68364 191 191 0
182 eddie13 580327 191 106 85
183 Co1n 95019 190 178 12
184 alexberezov 1066970 190 190 0
185 CarlOrff 822485 189 189 0
186 NLNico 107762 188 180 8
187 ace4549 359844 188 180 8
188 r1s2g3 1446224 188 77 111
189 SFR10 521899 186 97 89
190 Joel_Jantsen 560412 186 60 126
191 mindrust 176777 185 170 15
192 BitcoinPenny 352429 184 184 0
193 EFS 140584 183 183 0
194 guybrushthreepwood 187618 183 173 10
195 Don Pedro Dinero 1107222 182 112 70
196 BrewMaster 803757 181 164 17
197 Parodium 1162397 181 155 26
198 Anon136 3028 180 179 1
199 Coding Enthusiast 879277 180 180 0
200 gbianchi 140582 179 179 0
I will say everybody has his own area of contributions and gaining merit in Meta does not make it circle. Analyze the data, you will find few user received 0 merits or very few merits in Meta but their merit are coming from other single subboard. (like WO thread)
@LoyceV, Though I was first to attempt this statistics but I will be never able to match you in presenting the data.
Thanks for posting the top 50 exclusion list. That's the first time I have got ahead of TMAN in a long time. 
You was ahead of TMAN in below list too.https://bitcointalk.org/index.php?topic=5067161.msg47783837#msg47783837
queries
Code:
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 where u1.userid=A.toid;
select u1.toid,sum(u1.merit) from Meritdata u1 ,(select m.toid,sum(m.Merit) summerit from Meritdata m group by m.toid order by sum(m.merit) desc limit 200)A where u1.toid=A.toid and u1.subboard !='Meta' group by u1.toid;
select u1.toid,sum(u1.merit) from Meritdata u1 ,(select m.toid,sum(m.Merit) summerit from Meritdata m group by m.toid order by sum(m.merit) desc limit 200)A where u1.toid=A.toid and u1.subboard !='Meta' group by u1.toid;
Disclaimer: Special thanks to Piggy for creating this tool which I used in this analysis.