- needs and uses the data. If someone still wants to have the data please send me a PM, I will upload and share it of course 
Topic: Tool to run online SQL queries over Full Merit Data (Read 23325 times)
Due to the fact that no one (except DdmrDdmr) downloaded the csv for August I don't think that anyone - except me - needs and uses the data. If someone still wants to have the data please send me a PM, I will upload and share it of course
- needs and uses the data. If someone still wants to have the data please send me a PM, I will upload and share it of course <…>
@Laika, I’ve seen the file you’ve uploaded (McAffee WebAdvisor gave me a warning for some reason that was not very specific). It seems to be lacking the first week of august, and an equivalent to the “UserData” file to fully mimic @Piggy’s database info set.
-snip-
Note: It may be interesting to create your own thread from this point onwards, so as to place your updates in a thread to that effect.
The userdata table is missing on purpose, if someone needs the data I will upload it, too, of course!
<…>
@Laika, I’ve seen the file you’ve uploaded (McAffee WebAdvisor gave me a warning for some reason that was not very specific). It seems to be lacking the first week of august, and an equivalent to the “UserData” file to fully mimic @Piggy’s database info set. It may be interesting to get a feel of how many people would be interested before you commit to regular updates and make the effort to go over all past TXs.
Sometime ago, I gave it a go at looking into SQL Queries on Google Sheets, to see if that was a viable alternative (see for example https://blog.sheetgo.com/google-sheets-formulas/query-formula-google-sheets/). Nevertheless, when I loaded my full database it was too slow for my liking, and it does not accept joins between tables. I then denormalized the data, adding the user names and such to the TX table, but Google Sheets then became even slower and the 5M cell limit was a challenge.
Note: It may be interesting to create your own thread from this point onwards, so as to place your updates in a thread to that effect.
Because Piggy hasn't updated his database since July I decided to develop the tools necessary to get those infos by myself. I sticked to Piggys database schema, so anyone interested can simply download the following csv-file, import it into any database (sqlite for example) and run his/her statements.
This is the data for August, I will upload the data of September asap.
http://s000.tinyupload.com/?file_id=26186164095264151782
-> File was checked with Virustotal (Virustotal-Report)
This is the data for August, I will upload the data of September asap.
http://s000.tinyupload.com/?file_id=26186164095264151782
-> File was checked with Virustotal (Virustotal-Report)
No more updates? 
Piggy should be on holiday I guess.
I think so, too. At least Piggy hasnt been online since 7th of August. Hopefully, he is back soon, would definitly miss his updates and statistics. Piggy should be on holiday I guess.
Edit: The last update of Piggys database was on 2nd of August, so all data until that day is available and queryable.
No more updates?
Piggy should be on holiday I guess.
Piggy should be on holiday I guess.
Hi piggy!
Hope you didnt stop maintaining your database? I am keenly awaiting the July-statistics
Hope you didnt stop maintaining your database? I am keenly awaiting the July-statistics
The tool is now updated with the latest data from Friday 5th of July
Here is the usual snapshot about the last week:
Top Sender per board last week
Top Receivers per board last week
Sub boards merit circulation last week
Merits sent from each rank last week
Merits received from each rank last week
Here is the data for the whole month of June:
Top Sender per board last month
Top Receivers per board last month
Sub boards merit circulation last month
Merits sent from each rank last month
Merits received from each rank last month
Here is the usual snapshot about the last week:
Top Sender per board last week
Code:
178 chimk Hero Member Pyccкий (Russian)
110 teramit Legendary Türkçe (Turkish)
103 Flying Hellfish Staff Marketplace
83 iCEBREAKER Legendary Announcements (Altcoins)
80 TMAN Legendary Meta
76 suchmoon Legendary Beginners & Help
65 micgoossens Hero Member Economics
50 frodocooper Staff Mining
48 Foxpup Legendary Bitcoin Discussion
43 Halab Staff Français
42 dbshck Staff Development & Technical Discussion
36 suchmoon Legendary Trading Discussion
20 dbshck Staff Bahasa Indonesia (Indonesian)
20 davide72 Legendary Italiano (Italian)
20 Forsyth Jones Sr. Member Português (Portuguese)
18 tk808 Hero Member Altcoin Discussion
14 1miau Sr. Member Deutsch (German)
13 DdmrDdmr Hero Member Español (Spanish)
12 LoyceV Legendary Bitcoin Technical Support
7 OgNasty Donator Off-topic
6 cabalism13 Sr. Member Pilipinas
6 Foxpup Legendary Politics & Society
6 wwzsocki Hero Member Polski
6 Macadonian Member Serious discussion
5 Heisenberg_Hunter Sr. Member India
5 arbitragecryptotrader Full Member Marketplace (Altcoins)
5 TheUltraElite Hero Member Project Development
5 Globb0 Legendary Speculation (Altcoins)
5 khaled0111 Sr. Member العربية (Arabic)
4 numanoid Legendary null
4 Anon11073 Staff 日本語 (Japanese)
2 JFoxOne Member Mining (Altcoins)
1 Gyrsur Legendary Archival
1 big_daddy Full Member Hrvatski (Croatian)
Top Receivers per board last week
Code:
72 CryptopreneurBrainboss Sr. Member Meta
44 micgoossens Hero Member Economics
35 sportsbet.io Hero Member Marketplace
31 taikuri13 Sr. Member Pyccкий (Russian)
26 gospodin Full Member Türkçe (Turkish)
25 BitCryptex Hero Member Development & Technical Discussion
23 charlie137 Full Member Announcements (Altcoins)
23 morvillz7z Sr. Member Trading Discussion
21 1miau Sr. Member Deutsch (German)
18 bitmover Hero Member Beginners & Help
18 PassThePopcorn Full Member Mining
17 masulum Member Bahasa Indonesia (Indonesian)
17 Ale88 Sr. Member Italiano (Italian)
16 squatter Hero Member Bitcoin Discussion
13 o_e_l_e_o Hero Member Bitcoin Technical Support
13 BitcoinFX Legendary Off-topic
10 Adeilton Newbie Português (Portuguese)
9 Mighty_crypt Jr. Member Altcoin Discussion
8 DdmrDdmr Hero Member Español (Spanish)
8 Macadonian Member Serious discussion
7 Saint-loup Hero Member Français
6 Krsps Newbie Politics & Society
6 cryptovigi Sr. Member Polski
5 josephdd1 Hero Member Project Development
5 arpon11 Sr. Member Speculation (Altcoins)
5 mikeywith Sr. Member العربية (Arabic)
4 Bitlover10 Newbie India
3 Akonobea Jr. Member null
3 Bttzed03 Member Pilipinas
2 LoyceV Legendary Archival
2 CryptoBry Sr. Member Marketplace (Altcoins)
2 coinscrow Sr. Member Mining (Altcoins)
2 hakka Full Member 日本語 (Japanese)
1 Domchi Full Member Hrvatski (Croatian)
Sub boards merit circulation last week
Code:
29 null
74 Altcoin Discussion
238 Announcements (Altcoins)
1 Archival
63 Bahasa Indonesia (Indonesian)
320 Beginners & Help
178 Bitcoin Discussion
61 Bitcoin Technical Support
129 Deutsch (German)
138 Development & Technical Discussion
461 Economics
28 Español (Spanish)
59 Français
2 Hrvatski (Croatian)
5 India
73 Italiano (Italian)
483 Marketplace
14 Marketplace (Altcoins)
344 Meta
73 Mining
11 Mining (Altcoins)
29 Off-topic
24 Pilipinas
43 Politics & Society
23 Polski
46 Português (Portuguese)
15 Project Development
31 Serious discussion
16 Speculation (Altcoins)
293 Trading Discussion
273 Türkçe (Turkish)
483 Pyccкий (Russian)
15 العربية (Arabic)
5 日本語 (Japanese)
Merits sent from each rank last week
Code:
Administrator 14
Copper Member 114
Donator 45
Full Member 197
Global Moderator 36
Hero Member 858
Jr. Member 68
Legendary 1621
Member 217
Newbie 11
Sr. Member 407
Staff 427
Merits received from each rank last week
Code:
Administrator 20
Copper Member 146
Donator 4
Full Member 431
Global Moderator 17
Hero Member 836
Jr. Member 206
Legendary 887
Member 421
Newbie 54
Sr. Member 728
Staff 54
VIP 5
Here is the data for the whole month of June:
Top Sender per board last month
Code:
695 chimk Hero Member ??????? (Russian)
438 suchmoon Legendary Meta
373 Flying Hellfish Staff Marketplace
293 DarkStar_ Legendary Pilipinas
238 qwk Donator Deutsch (German)
230 suchmoon Legendary Trading Discussion
223 dbshck Staff Bahasa Indonesia (Indonesian)
221 teramit Legendary Türkçe (Turkish)
213 micgoossens Hero Member Economics
174 frodocooper Staff Mining
144 ETFbitcoin Legendary Development & Technical Discussion
139 paxmao Sr. Member Español (Spanish)
138 Halab Staff Français
105 tk808 Hero Member Altcoin Discussion
104 suchmoon Legendary Politics & Society
102 TMAN Legendary Beginners & Help
81 Vlad2Vlad Legendary Announcements (Altcoins)
65 Welsh Staff Serious discussion
63 Micio Legendary Italiano (Italian)
50 MicroGuy Legendary null
50 aigeezer Legendary Bitcoin Discussion
50 fr4nkthetank Legendary Mining (Altcoins)
45 SyGambler Legendary ??????? (Arabic)
40 ETFbitcoin Legendary Bitcoin Technical Support
29 KeyJockey Hero Member Speculation (Altcoins)
25 Heisenberg_Hunter Sr. Member India
24 wwzsocki Hero Member Polski
24 sabotag3x Hero Member Português (Portuguese)
20 OgNasty Donator Off-topic
10 crazyearner Legendary Marketplace (Altcoins)
9 micgoossens Hero Member Nederlands (Dutch)
5 eckmar Legendary Project Development
4 finaleshot2016 Sr. Member Hrvatski (Croatian)
4 Anon11073 Staff ??? (Japanese)
3 popcoins Hero Member ?? (Chinese)
2 xandry Staff Archival
2 Sharon121212 Full Member Other languages/locations
1 NeuroticFish Legendary Româna (Romanian)
1 dwminer1 Hero Member ??? (Korean)
Top Receivers per board last month
Code:
208 suchmoon Legendary Meta
132 micgoossens Hero Member Economics
132 asu Hero Member Pilipinas
123 gospodin Full Member Türkçe (Turkish)
118 suchmoon Legendary Trading Discussion
101 masulum Member Bahasa Indonesia (Indonesian)
92 witcher_sense Sr. Member ??????? (Russian)
79 bitmover Hero Member Beginners & Help
77 Agrawas Full Member Marketplace
70 Macadonian Member Serious discussion
60 Eliovp Legendary Mining (Altcoins)
58 Carlton Banks Legendary Bitcoin Discussion
53 XEL-project Copper Member Announcements (Altcoins)
52 Scheede Sr. Member Deutsch (German)
50 Jimmy Crypto Jr. Member null
49 DdmrDdmr Hero Member Español (Spanish)
45 Plutosky Sr. Member Italiano (Italian)
39 HCP Legendary Development & Technical Discussion
37 khaled0111 Sr. Member ??????? (Arabic)
35 LoyceV Legendary Bitcoin Technical Support
33 HagssFIN Legendary Mining
33 wwzsocki Hero Member Polski
30 cAPSLOCK Legendary Speculation (Altcoins)
26 Flying Hellfish Staff Politics & Society
25 Bitlover10 Newbie India
23 Forsyth Jones Sr. Member Português (Portuguese)
18 F2b Full Member Français
10 HCP Legendary Altcoin Discussion
10 cryptogendrop Newbie Marketplace (Altcoins)
10 BitcoinFX Legendary Off-topic
7 micgoossens Hero Member Nederlands (Dutch)
5 LoyceV Legendary Project Development
3 SISAR Hero Member Hrvatski (Croatian)
3 CryptopreneurBrainboss Sr. Member Other languages/locations
3 Ber86 Member ?? (Chinese)
2 hakka Full Member ??? (Japanese)
1 igor72 Sr. Member Archival
1 Danezu Jr. Member Româna (Romanian)
Sub boards merit circulation last month
Code:
210 null
389 Altcoin Discussion
567 Announcements (Altcoins)
2 Archival
455 Bahasa Indonesia (Indonesian)
871 Beginners & Help
485 Bitcoin Discussion
478 Bitcoin Technical Support
661 Deutsch (German)
605 Development & Technical Discussion
2064 Economics
243 Español (Spanish)
211 Français
16 Hrvatski (Croatian)
72 India
356 Italiano (Italian)
1937 Marketplace
83 Marketplace (Altcoins)
2920 Meta
421 Mining
168 Mining (Altcoins)
24 Nederlands (Dutch)
90 Off-topic
7 Other languages/locations
895 Pilipinas
511 Politics & Society
141 Polski
114 Português (Portuguese)
47 Project Development
1 Româna (Romanian)
191 Serious discussion
109 Speculation (Altcoins)
1364 Trading Discussion
1219 Türkçe (Turkish)
1759 ??????? (Russian)
138 ??????? (Arabic)
4 ?? (Chinese)
6 ??? (Japanese)
1 ??? (Korean)
Merits sent from each rank last month
Code:
Administrator 52
Copper Member 601
Donator 388
Full Member 743
Global Moderator 156
Hero Member 3695
Jr. Member 132
Legendary 7990
Member 549
Newbie 63
Sr. Member 2245
Staff 2943
Merits received from each rank last month
Code:
Administrator 249
Brand new 9
Copper Member 909
Donator 65
Founder 44
Full Member 1877
Global Moderator 102
Hero Member 3727
Jr. Member 662
Legendary 4873
Member 2017
Newbie 359
Sr. Member 3549
Staff 393
So proud of this!
Quote
Top Sender per board last week
Code:
18 fillippone Sr. Member Italiano (Italian)
The tool is now updated with the latest data from Friday 28th of June
Here is the usual snapshot about the last week:
Top Sender per board last week
Top Receivers per board last week
Sub boards merit circulation last week
Merits sent from each rank last week
Merits received from each rank last week
Here is the usual snapshot about the last week:
Top Sender per board last week
Code:
152 chimk Hero Member Pyccкий (Russian)
144 Welsh Staff Meta
98 teramit Legendary Türkçe (Turkish)
95 micgoossens Hero Member Economics
75 TMAN Legendary Beginners & Help
68 frodocooper Staff Mining
65 Welsh Staff Serious discussion
53 killyou72 Copper Member Marketplace
52 suchmoon Legendary Trading Discussion
50 aigeezer Legendary Bitcoin Discussion
46 dbshck Staff Bahasa Indonesia (Indonesian)
44 tk808 Hero Member Altcoin Discussion
34 qwk Donator Deutsch (German)
31 Halab Staff Français
29 KeyJockey Hero Member Speculation (Altcoins)
28 paxmao Sr. Member Español (Spanish)
25 cabalism13 Sr. Member Pilipinas
24 Foxpup Legendary Politics & Society
20 Vlad2Vlad Legendary Announcements (Altcoins)
18 Foxpup Legendary Bitcoin Technical Support
18 fillippone Sr. Member Italiano (Italian)
18 cryptovigi Sr. Member Polski
14 HCP Legendary Development & Technical Discussion
14 Heisenberg_Hunter Sr. Member India
11 SyGambler Legendary العربية (Arabic)
10 vapourminer Legendary Mining (Altcoins)
10 TryNinja Legendary Português (Portuguese)
5 Welsh Staff Marketplace (Altcoins)
5 OgNasty Donator Off-topic
4 dbshck Staff null
3 friends1980 Sr. Member Nederlands (Dutch)
2 Sharon121212 Full Member Other languages/locations
2 LoyceV Legendary Project Development
1 marlboroza Legendary Hrvatski (Croatian)
1 NeuroticFish Legendary Română (Romanian)
Top Receivers per board last week
Code:
81 1miau Sr. Member Meta
69 Macadonian Member Serious discussion
55 Carlton Banks Legendary Bitcoin Discussion
55 cryptjh Full Member Economics
52 Agrawas Full Member Marketplace
50 0n0t0le Legendary Pyccкий (Russian)
44 fillippone Sr. Member Beginners & Help
38 Quite Full Member Türkçe (Turkish)
34 marlboroza Legendary Trading Discussion
29 cAPSLOCK Legendary Speculation (Altcoins)
23 Forsyth Jones Sr. Member Português (Portuguese)
22 Flying Hellfish Staff Politics & Society
21 masulum Member Bahasa Indonesia (Indonesian)
20 Limx Dev Copper Member Announcements (Altcoins)
20 Scheede Sr. Member Deutsch (German)
20 MagicByt3 Full Member Mining
18 bob123 Hero Member Bitcoin Technical Support
17 fillippone Sr. Member Italiano (Italian)
16 mikeywith Sr. Member العربية (Arabic)
14 BitCryptex Hero Member Development & Technical Discussion
14 Bitlover10 Newbie India
14 adamvp Hero Member Polski
10 DdmrDdmr Hero Member Español (Spanish)
10 theyoungmillionaire Sr. Member Pilipinas
8 asche Hero Member Français
7 thd26bct Member Altcoin Discussion
6 mikeywith Sr. Member Mining (Altcoins)
5 Gunthar Hero Member Marketplace (Altcoins)
4 Whaleagent Jr. Member null
4 micgoossens Hero Member Nederlands (Dutch)
3 CryptopreneurBrainboss Sr. Member Other languages/locations
2 turtletime Jr. Member Off-topic
2 BitCryptex Hero Member Project Development
1 Trofo Sr. Member Hrvatski (Croatian)
1 Danezu Jr. Member Română (Romanian)
Sub boards merit circulation last week
Code:
26 null
104 Altcoin Discussion
117 Announcements (Altcoins)
79 Bahasa Indonesia (Indonesian)
479 Beginners & Help
174 Bitcoin Discussion
119 Bitcoin Technical Support
154 Deutsch (German)
151 Development & Technical Discussion
759 Economics
54 Español (Spanish)
39 Français
1 Hrvatski (Croatian)
33 India
83 Italiano (Italian)
432 Marketplace
9 Marketplace (Altcoins)
419 Meta
110 Mining
27 Mining (Altcoins)
5 Nederlands (Dutch)
28 Off-topic
4 Other languages/locations
62 Pilipinas
46 Politics & Society
44 Polski
47 Português (Portuguese)
17 Project Development
1 Română (Romanian)
164 Serious discussion
46 Speculation (Altcoins)
318 Trading Discussion
301 Türkçe (Turkish)
435 Pyccкий (Russian)
33 العربية (Arabic)
Merits sent from each rank last week
Code:
Administrator 5
Copper Member 183
Donator 48
Full Member 192
Global Moderator 6
Hero Member 906
Jr. Member 33
Legendary 1932
Member 141
Newbie 14
Sr. Member 641
Staff 742
Merits received from each rank last week
Code:
Administrator 9
Brand new 9
Copper Member 179
Donator 4
Founder 4
Full Member 627
Global Moderator 6
Hero Member 872
Jr. Member 142
Legendary 1186
Member 527
Newbie 47
Sr. Member 884
Staff 112
The tool is now updated with the latest data from Friday 21st of June
Here is the usual snapshot about the last week:
Top Sender per board last week
Top Receivers per board last week
Sub boards merit circulation last week
Merits sent from each rank last week
Merits received from each rank last week
Here is the usual snapshot about the last week:
Top Sender per board last week
Code:
76 suchmoon Legendary Meta
68 suchmoon Legendary Beginners & Help
68 chimk Hero Member Pyccкий (Russian)
67 paxmao Sr. Member Español (Spanish)
64 suchmoon Legendary Politics & Society
61 dbshck Staff Bahasa Indonesia (Indonesian)
58 Flying Hellfish Staff Marketplace
49 suchmoon Legendary Trading Discussion
48 cabalism13 Sr. Member Pilipinas
46 frodocooper Staff Mining
44 suchmoon Legendary Serious discussion
44 Vispilio Sr. Member Türkçe (Turkish)
43 JayJuanGee Legendary Economics
35 ETFbitcoin Legendary Development & Technical Discussion
34 Halab Staff Français
21 tk808 Hero Member Altcoin Discussion
20 marcetin Legendary Announcements (Altcoins)
15 OgNasty Donator Bitcoin Technical Support
12 Carlton Banks Legendary Bitcoin Discussion
12 qwk Donator Deutsch (German)
12 babo Legendary Italiano (Italian)
10 Metroid Sr. Member Mining (Altcoins)
10 xandry Staff Polski
10 bitmover Hero Member Português (Portuguese)
8 suchmoon Legendary Off-topic
7 micgoossens Hero Member Nederlands (Dutch)
6 bones261 Legendary null
6 Heisenberg_Hunter Sr. Member India
6 4rzun4 Sr. Member Speculation (Altcoins)
6 OmegaStarScream Staff العربية (Arabic)
3 jonathan6655321 Member Marketplace (Altcoins)
2 xandry Staff Archival
2 o_e_l_e_o Hero Member Project Development
1 Daniel91 Legendary Hrvatski (Croatian)
1 S_Therapist Full Member Other languages/locations
1 dwminer1 Hero Member 한국어 (Korean)
Top Receivers per board last week
Code:
95 Vispilio Sr. Member Meta
56 bitmover Hero Member Beginners & Help
51 witcher_sense Sr. Member Pyccкий (Russian)
50 WhyFhy Member Marketplace
33 roycilik Hero Member Bahasa Indonesia (Indonesian)
32 Toxic2040 Hero Member Economics
32 nutildah Legendary Trading Discussion
31 trendcoin Member Türkçe (Turkish)
27 HagssFIN Legendary Mining
26 asu Hero Member Pilipinas
23 satoshi Founder Development & Technical Discussion
23 DdmrDdmr Hero Member Español (Spanish)
15 bitbollo Legendary Italiano (Italian)
15 JaredKaragen Legendary Politics & Society
12 Scheede Sr. Member Deutsch (German)
12 CryptopreneurBrainboss Sr. Member Serious discussion
11 khaled0111 Sr. Member العربية (Arabic)
10 jbreher Legendary Announcements (Altcoins)
10 satoshi Founder Bitcoin Discussion
10 Eliovp Legendary Mining (Altcoins)
10 wwzsocki Hero Member Polski
7 Royse777 Hero Member Bitcoin Technical Support
7 F2b Full Member Français
7 Bitlover10 Newbie India
7 johnjimjack Jr. Member Marketplace (Altcoins)
6 tonych Hero Member Altcoin Discussion
6 bitmover Hero Member Português (Portuguese)
6 adrianto1995 Full Member Speculation (Altcoins)
5 bones261 Legendary null
4 friends1980 Sr. Member Nederlands (Dutch)
4 Jet Cash Legendary Off-topic
2 buwaytress Hero Member Project Development
1 igor72 Sr. Member Archival
1 Keeshan Member Hrvatski (Croatian)
1 Mpamaegbu Sr. Member Other languages/locations
Sub boards merit circulation last week
Code:
48 null
127 Altcoin Discussion
145 Announcements (Altcoins)
2 Archival
132 Bahasa Indonesia (Indonesian)
371 Beginners & Help
127 Bitcoin Discussion
45 Bitcoin Technical Support
97 Deutsch (German)
153 Development & Technical Discussion
508 Economics
90 Español (Spanish)
57 Français
2 Hrvatski (Croatian)
19 India
80 Italiano (Italian)
598 Marketplace
23 Marketplace (Altcoins)
666 Meta
135 Mining
29 Mining (Altcoins)
11 Nederlands (Dutch)
17 Off-topic
3 Other languages/locations
195 Pilipinas
87 Politics & Society
33 Polski
23 Português (Portuguese)
6 Project Development
80 Serious discussion
23 Speculation (Altcoins)
350 Trading Discussion
231 Türkçe (Turkish)
269 Pyccкий (Russian)
25 العربية (Arabic)
1 한국어 (Korean)
Merits sent from each rank last week
Code:
Administrator 17
Copper Member 185
Donator 71
Full Member 163
Global Moderator 47
Hero Member 777
Jr. Member 40
Legendary 1900
Member 139
Newbie 14
Sr. Member 612
Staff 697
Merits received from each rank last week
Code:
Administrator 30
Copper Member 231
Donator 5
Founder 33
Full Member 330
Global Moderator 42
Hero Member 893
Jr. Member 103
Legendary 1216
Member 551
Newbie 73
Sr. Member 849
Staff 74
The tool is now updated with the latest data from Friday 14th of June
The users ranks has been updated (this was happening already the last week but i forgot to mention it).
Here is the usual snapshot about the last week:
Top Sender per board last week
Top Receivers per board last week
Sub boards merit circulation last week
Merits sent from each rank last week
Merits received from each rank last week
The users ranks has been updated (this was happening already the last week but i forgot to mention it).
Here is the usual snapshot about the last week:
Top Sender per board last week
Code:
278 DarkStar_ Legendary Pilipinas
256 suchmoon Legendary Meta
233 chimk Hero Member Pyccкий (Russian)
192 Flying Hellfish Staff Marketplace
108 ETFbitcoin Legendary Development & Technical Discussion
105 suchmoon Legendary Trading Discussion
87 dbshck Staff Türkçe (Turkish)
78 dbshck Staff Bahasa Indonesia (Indonesian)
62 qwk Donator Deutsch (German)
50 bones261 Legendary Beginners & Help
46 frodocooper Staff Mining
40 suchmoon Legendary Politics & Society
37 ETFbitcoin Legendary Bitcoin Technical Support
32 Halab Staff Français
29 JayJuanGee Legendary Economics
27 Vlad2Vlad Legendary Announcements (Altcoins)
24 dbshck Staff Bitcoin Discussion
23 Micio Legendary Italiano (Italian)
16 Vlad2Vlad Legendary Altcoin Discussion
16 DdmrDdmr Hero Member Español (Spanish)
10 mixerxxpasc Sr. Member null
10 BldSwtTrs Legendary Speculation (Altcoins)
9 khaled0111 Sr. Member العربية (Arabic)
8 OgNasty Donator Off-topic
8 malevolent Staff Polski
7 frodocooper Staff Mining (Altcoins)
5 Lauda Legendary Serious discussion
4 finaleshot2016 Sr. Member Hrvatski (Croatian)
4 triangles Full Member Marketplace (Altcoins)
3 MattLeBlanc Member India
2 friends1980 Sr. Member Nederlands (Dutch)
2 Paredao Legendary Português (Portuguese)
2 OgNasty Donator Project Development
1 kazuki.t Member 日本語 (Japanese)
Top Receivers per board last week
Code:
157 theymos Administrator Meta
77 finaleshot2016 Sr. Member Pilipinas
62 ICOEthics Sr. Member Trading Discussion
40 Matthias9515 Hero Member Türkçe (Turkish)
37 masulum Member Bahasa Indonesia (Indonesian)
28 taikuri13 Sr. Member Pyccкий (Russian)
26 bible_pay Full Member Announcements (Altcoins)
26 frankbitcoin Full Member Marketplace
21 aundroid Sr. Member Deutsch (German)
20 selo Copper Member Mining
19 micgoossens Hero Member Economics
19 gbianchi Legendary Italiano (Italian)
18 gmaxwell Staff Development & Technical Discussion
14 hd49728 Member Beginners & Help
13 wwzsocki Hero Member Polski
12 iamsheikhadil Copper Member Politics & Society
11 LoyceV Legendary Bitcoin Technical Support
11 joroz Jr. Member Speculation (Altcoins)
10 Traxo Full Member Altcoin Discussion
7 khaled0111 Sr. Member Bitcoin Discussion
7 coinscrow Sr. Member Mining (Altcoins)
6 RHavar Legendary null
6 DdmrDdmr Hero Member Español (Spanish)
5 Foxpup Legendary Serious discussion
5 khaled0111 Sr. Member العربية (Arabic)
4 GrosWesh Full Member Français
3 deadley Legendary India
3 roughswap Jr. Member Marketplace (Altcoins)
3 dkdaniz Newbie Português (Portuguese)
2 notbatman Legendary Off-topic
2 BitCryptex Hero Member Project Development
1 Bokile Member Hrvatski (Croatian)
1 JorisK Full Member Nederlands (Dutch)
1 tactac Full Member 日本語 (Japanese)
Sub boards merit circulation last week
Code:
35 Polski
53 Serious discussion
44 null
56 Altcoin Discussion
87 Announcements (Altcoins)
181 Bahasa Indonesia (Indonesian)
146 Beginners & Help
124 Bitcoin Discussion
110 Bitcoin Technical Support
164 Deutsch (German)
233 Development & Technical Discussion
265 Economics
26 Español (Spanish)
50 Français
6 Hrvatski (Croatian)
9 India
77 Italiano (Italian)
434 Marketplace
19 Marketplace (Altcoins)
1207 Meta
103 Mining
19 Mining (Altcoins)
5 Nederlands (Dutch)
21 Off-topic
521 Pilipinas
101 Politics & Society
7 Português (Portuguese)
16 Project Development
17 Speculation (Altcoins)
500 Trading Discussion
297 Türkçe (Turkish)
536 Pyccкий (Russian)
28 العربية (Arabic)
1 日本語 (Japanese)
Merits sent from each rank last week
Code:
Administrator 19
Copper Member 130
Donator 117
Full Member 155
Global Moderator 59
Hero Member 904
Jr. Member 32
Legendary 2494
Member 131
Newbie 12
Sr. Member 451
Staff 965
Merits received from each rank last week
Code:
Administrator 166
Copper Member 289
Donator 14
Founder 5
Full Member 459
Global Moderator 35
Hero Member 995
Jr. Member 134
Legendary 1454
Member 481
Newbie 68
Sr. Member 1058
Staff 129
The tool is now updated with the latest data from Friday 7th of June
The title of the thread merited was put back into the database Lakai01.
Here is the usual snapshot about the last week and the monthly recap for May is coming right after:
Top Sender per board last week
Top Receivers per board last week
Sub boards merit circulation last week
Merits sent from each rank last week
Merits received from each rank last week
The title of the thread merited was put back into the database Lakai01.
Here is the usual snapshot about the last week and the monthly recap for May is coming right after:
Top Sender per board last week
Code:
318 chimk Hero Member Pyccкий (Russian)
130 qwk Donator Deutsch (German)
94 DarkStar_ Legendary Türkçe (Turkish)
75 Flying Hellfish Staff Marketplace
66 Foxpup Legendary Meta
54 micgoossens Hero Member Economics
50 MicroGuy Legendary null
50 NutMasterTardd Legendary Announcements (Altcoins)
50 fr4nkthetank Legendary Mining (Altcoins)
44 paxmao Sr. Member Español (Spanish)
44 Halab Staff Français
39 frodocooper Staff Mining
34 dbshck Staff Development & Technical Discussion
28 suchmoon Legendary Trading Discussion
27 TMAN Legendary Beginners & Help
26 dbshck Staff Bahasa Indonesia (Indonesian)
25 SyGambler Legendary العربية (Arabic)
24 Micio Legendary Italiano (Italian)
23 dbshck Staff Pilipinas
21 btcdiggingmaster Hero Member Speculation (Altcoins)
20 dbshck Staff Politics & Society
17 tk808 Hero Member Altcoin Discussion
16 LoyceV Legendary Bitcoin Technical Support
13 sabotag3x Hero Member Português (Portuguese)
12 Tytanowy Janusz Sr. Member Polski
10 DdmrDdmr Hero Member Bitcoin Discussion
10 crazyearner Legendary Marketplace (Altcoins)
7 paxmao Sr. Member Serious discussion
5 TECSHARE Legendary Off-topic
5 eckmar Legendary Project Development
3 Foxpup Legendary Archival
3 Alohadanc3 Member India
3 friends1980 Sr. Member Nederlands (Dutch)
3 popcoins Hero Member 中文 (Chinese)
2 big_daddy Full Member Hrvatski (Croatian)
1 DTalk Member Other languages/locations
1 hakka Full Member 日本語 (Japanese)
Top Receivers per board last week
Code:
97 Matthias9515 Hero Member Türkçe (Turkish)
71 micgoossens Hero Member Economics
52 XEL-project Copper Member Announcements (Altcoins)
50 Jimmy Crypto Jr. Member null
50 Eliovp Legendary Mining (Altcoins)
41 FontSeli Full Member Pyccкий (Russian)
35 nutildah Legendary Trading Discussion
28 asu Hero Member Pilipinas
26 suchmoon Legendary Meta
24 qwk Donator Deutsch (German)
21 coingrowth Member Speculation (Altcoins)
18 Plutosky Sr. Member Italiano (Italian)
17 Hhampuz Legendary Marketplace
15 Steamtyme Hero Member Mining
15 cryptovigi Sr. Member Polski
14 bob123 Hero Member Development & Technical Discussion
14 khaled0111 Sr. Member العربية (Arabic)
12 theymos Administrator Politics & Society
10 masulum Member Bahasa Indonesia (Indonesian)
10 bitcoinzen Jr. Member Bitcoin Discussion
10 cryptogendrop Newbie Marketplace (Altcoins)
9 Redemption59 Jr. Member Altcoin Discussion
9 DdmrDdmr Hero Member Español (Spanish)
9 F2b Full Member Français
8 CryptopreneurBrainboss Sr. Member Beginners & Help
6 LoyceV Legendary Bitcoin Technical Support
5 TheCreationStation Newbie Off-topic
5 LoyceV Legendary Project Development
4 sabotag3x Hero Member Português (Portuguese)
3 o_e_l_e_o Hero Member Archival
3 deadley Legendary India
3 Ber86 Member 中文 (Chinese)
2 SISAR Hero Member Hrvatski (Croatian)
2 Carlton Banks Legendary Serious discussion
1 AdolfinWolf Hero Member Nederlands (Dutch)
1 Review Master Jr. Member Other languages/locations
1 kazuki.t Member 日本語 (Japanese)
Sub boards merit circulation last week
Code:
86 null
89 Altcoin Discussion
147 Announcements (Altcoins)
56 Bahasa Indonesia (Indonesian)
130 Beginners & Help
81 Bitcoin Discussion
102 Bitcoin Technical Support
226 Deutsch (German)
83 Development & Technical Discussion
446 Economics
66 Español (Spanish)
68 Français
8 Hrvatski (Croatian)
6 India
98 Italiano (Italian)
288 Marketplace
23 Marketplace (Altcoins)
427 Meta
85 Mining
82 Mining (Altcoins)
4 Nederlands (Dutch)
16 Off-topic
1 Other languages/locations
118 Pilipinas
39 Politics & Society
28 Polski
25 Português (Portuguese)
14 Project Development
6 Serious discussion
29 Speculation (Altcoins)
252 Trading Discussion
409 Türkçe (Turkish)
585 Pyccкий (Russian)
56 العربية (Arabic)
4 中文 (Chinese)
1 日本語 (Japanese)
Merits sent from each rank last week
Code:
Administrator 13
Copper Member 96
Donator 141
Full Member 214
Global Moderator 45
Hero Member 1100
Jr. Member 30
Legendary 1450
Member 104
Newbie 20
Sr. Member 459
Staff 512
Merits received from each rank last week
Code:
Administrator 51
Copper Member 200
Donator 41
Founder 2
Full Member 380
Global Moderator 27
Hero Member 1014
Jr. Member 265
Legendary 898
Member 380
Newbie 179
Sr. Member 667
Staff 80
Thank you very much Piggy!
Btw. I host a thread in the German local board which contains a lot of statistics (and sql-statements to get that info) how merits are used in our board on a monthly basis (top spender per month, top receiver, top merited thread, ...). If someone would be interested to do the same for his/her local board and needs some help/advice or some tailored sql-statements please let me know, would love to share them.
Here is the thread in our German board if someone wants to have a look: https://bitcointalksearch.org/topic/neue-auswertungen-wir-deutschsprachigen-und-die-merits-4657305
Btw. I host a thread in the German local board which contains a lot of statistics (and sql-statements to get that info) how merits are used in our board on a monthly basis (top spender per month, top receiver, top merited thread, ...). If someone would be interested to do the same for his/her local board and needs some help/advice or some tailored sql-statements please let me know, would love to share them.
Here is the thread in our German board if someone wants to have a look: https://bitcointalksearch.org/topic/neue-auswertungen-wir-deutschsprachigen-und-die-merits-4657305
Hi Piggy!
I saw the that TitleThread column is missing from the MeritData-table. I wonder if thats intentional? We did some very nice statistics with this info in the German local board
I saw the that TitleThread column is missing from the MeritData-table. I wonder if thats intentional? We did some very nice statistics with this info in the German local board
I had to rebuild the database a couple of weeks ago and it may have been accidentally left out in fact. I'll see to add it back on the next update.
Hi Piggy!
I saw the that TitleThread column is missing from the MeritData-table. I wonder if thats intentional? We did some very nice statistics with this info in the German local board
I saw the that TitleThread column is missing from the MeritData-table. I wonder if thats intentional? We did some very nice statistics with this info in the German local board
The tool is now updated with the latest data from Friday 31st of May
Here is the usual snapshot about the last week and the monthly recap for May is coming right after:
Top Sender per board last week
Top Receivers per board last week
Sub boards merit circulation last week
Merits sent from each rank last week
Merits received from each rank last week
Top Sender per board for May
Top Receivers per board for May
Sub boards merit circulation for May
Merits sent from each rank for May
Merits received from each rank for May
Here is the usual snapshot about the last week and the monthly recap for May is coming right after:
Top Sender per board last week
Code:
167 chimk Full Member Pyccкий (Russian)
86 Flying Hellfish Staff Marketplace
79 suchmoon Legendary Meta
75 frodocooper Staff Mining
65 suchmoon Legendary Trading Discussion
57 micgoossens Sr. Member Economics
47 suchmoon Legendary Beginners & Help
45 dbshck Staff Bahasa Indonesia (Indonesian)
42 bones261 Legendary Development & Technical Discussion
42 Micio Legendary Italiano (Italian)
31 asu Hero Member Pilipinas
28 EFS Staff Türkçe (Turkish)
27 Halab Staff Français
26 tk808 Hero Member Altcoin Discussion
23 paxmao Sr. Member Español (Spanish)
21 squatz1 Hero Member Politics & Society
18 SyGambler Legendary العربية (Arabic)
12 iCEBREAKER Legendary Announcements (Altcoins)
11 mole0815 Sr. Member Deutsch (German)
10 bones261 Legendary Bitcoin Technical Support
8 dbshck Staff Mining (Altcoins)
8 suchmoon Legendary Off-topic
7 Mike Mayor Hero Member Bitcoin Discussion
7 Paredao Legendary Português (Portuguese)
6 Halab Staff Project Development
5 Flying Hellfish Staff Archival
5 JSRAW Jr. Member India
5 paxmao Sr. Member Serious discussion
4 OgNasty Donator null
4 adamvp Hero Member Polski
3 S_Therapist Newbie Other languages/locations
2 SISAR Hero Member Hrvatski (Croatian)
2 Cryptogainsairdrop Jr. Member Marketplace (Altcoins)
2 Hueristic Legendary Speculation (Altcoins)
1 mitzie Staff Eλληνικά (Greek)
Top Receivers per board last week
Code:
63 theymos Administrator Meta
50 Halmater Hero Member Türkçe (Turkish)
47 nutildah Legendary Trading Discussion
46 Crypto_Collection Jr. Member Marketplace
41 cAPSLOCK Legendary Economics
28 asu Hero Member Pilipinas
27 viscolex Member Announcements (Altcoins)
27 theymos Administrator Beginners & Help
25 Pieter Wuille Legendary Development & Technical Discussion
25 edgycorner Full Member Project Development
25 Goran_ Sr. Member Pyccкий (Russian)
20 duesoldi Sr. Member Italiano (Italian)
20 Artemis3 Jr. Member Mining
16 masulum Member Bahasa Indonesia (Indonesian)
15 hugeblack Sr. Member Archival
11 Kavelj22 Newbie العربية (Arabic)
10 hornetsnest Member Altcoin Discussion
10 Vishnu.Reang Sr. Member Politics & Society
9 Vegemite Jr. Member Deutsch (German)
6 bob123 Hero Member Bitcoin Technical Support
6 LUCKMCFLY Full Member Español (Spanish)
6 asche Full Member Français
6 joseph32 Jr. Member Mining (Altcoins)
6 tomahawk9 Sr. Member Off-topic
5 gentlemand Legendary Bitcoin Discussion
5 Tytanowy Janusz Member Polski
5 Pumared Sr. Member Português (Portuguese)
2 Lafu Hero Member null
2 Domchi Full Member Hrvatski (Croatian)
2 JSRAW Jr. Member India
2 Jet Cash Legendary Serious discussion
2 7jaka7 Sr. Member Speculation (Altcoins)
1 Kavelj22 Newbie Marketplace (Altcoins)
1 DTalk Newbie Other languages/locations
Sub boards merit circulation last week
Code:
23 Archival
20 null
71 Altcoin Discussion
128 Announcements (Altcoins)
106 Bahasa Indonesia (Indonesian)
147 Beginners & Help
86 Bitcoin Discussion
74 Bitcoin Technical Support
99 Deutsch (German)
198 Development & Technical Discussion
552 Economics
37 Español (Spanish)
48 Français
5 Hrvatski (Croatian)
8 India
108 Italiano (Italian)
675 Marketplace
9 Marketplace (Altcoins)
617 Meta
103 Mining
30 Mining (Altcoins)
6 Off-topic
6 Other languages/locations
134 Pilipinas
60 Politics & Society
14 Polski
21 Português (Portuguese)
52 Project Development
7 Serious discussion
7 Speculation (Altcoins)
290 Trading Discussion
204 Türkçe (Turkish)
1 Eλληνικά (Greek)
336 Pyccкий (Russian)
47 العربية (Arabic)
Merits sent from each rank last week
Code:
Administrator 2
Copper Member 164
Donator 61
Full Member 426
Global Moderator 21
Hero Member 511
Jr. Member 108
Legendary 1562
Member 230
Newbie 90
Sr. Member 535
Staff 526
VIP 1
Merits received from each rank last week
Code:
Administrator 113
Copper Member 220
Donator 35
Founder 3
Full Member 515
Global Moderator 8
Hero Member 574
Jr. Member 284
Legendary 989
Member 458
Newbie 181
Sr. Member 568
Staff 86
VIP 1
Top Sender per board for May
Code:
671 chimk Full Member Pyccкий (Russian)
642 dbshck Staff Bahasa Indonesia (Indonesian)
495 Flying Hellfish Staff Marketplace
396 Vod Legendary Trading Discussion
318 Foxpup Legendary Meta
271 frodocooper Staff Mining
266 qwk Donator Deutsch (German)
218 DarkStar_ Legendary Polski
215 dbshck Staff Beginners & Help
159 JayJuanGee Legendary Economics
144 Halab Staff Français
134 bones261 Legendary Development & Technical Discussion
96 squatz1 Hero Member Politics & Society
82 asu Hero Member Pilipinas
67 teramit Legendary Türkçe (Turkish)
64 tk808 Hero Member Altcoin Discussion
63 Vlad2Vlad Legendary Announcements (Altcoins)
63 bones261 Legendary Bitcoin Technical Support
62 Micio Legendary Italiano (Italian)
58 suchmoon Legendary Bitcoin Discussion
57 paxmao Sr. Member Español (Spanish)
47 hugeblack Sr. Member العربية (Arabic)
38 dbshck Staff null
37 vapourminer Legendary Mining (Altcoins)
29 Vod Legendary Project Development
27 sabotag3x Hero Member Português (Portuguese)
21 Heisenberg_Hunter Full Member India
14 OgNasty Donator Off-topic
12 Jet Cash Legendary Serious discussion
12 Hueristic Legendary Speculation (Altcoins)
11 micgoossens Sr. Member Nederlands (Dutch)
10 Daniel91 Legendary Hrvatski (Croatian)
7 Vlad2Vlad Legendary Marketplace (Altcoins)
6 Anon11073 Staff 日本語 (Japanese)
5 Flying Hellfish Staff Archival
5 subSTRATA Legendary 한국어 (Korean)
3 CryptopreneurBrainboss Member Other languages/locations
2 josephdd1 Hero Member Română (Romanian)
2 mo Legendary 中文 (Chinese)
1 mitzie Staff Eλληνικά (Greek)
Top Receivers per board for May
Code:
193 LoyceV Legendary Meta
119 ICOEthics Full Member Trading Discussion
116 ryzaadit Full Member Bahasa Indonesia (Indonesian)
114 Toxic2040 Sr. Member Economics
112 qwk Donator Deutsch (German)
109 asu Hero Member Pilipinas
101 Hhampuz Hero Member Marketplace
82 Tytanowy Janusz Member Polski
75 JSRAW Jr. Member Politics & Society
72 Goran_ Sr. Member Pyccкий (Russian)
56 theymos Administrator Beginners & Help
55 Videlicet Legendary Announcements (Altcoins)
55 HCP Hero Member Development & Technical Discussion
52 Hal VIP Bitcoin Discussion
51 Matthias9515 Hero Member Türkçe (Turkish)
50 mstrozier Newbie Mining
39 duesoldi Sr. Member Italiano (Italian)
39 khaled0111 Full Member العربية (Arabic)
38 Eliovp Legendary Mining (Altcoins)
33 coinlocket$ Sr. Member null
33 achow101 Staff Bitcoin Technical Support
33 Saint-loup Sr. Member Français
25 edgycorner Full Member Project Development
24 DdmrDdmr Sr. Member Español (Spanish)
16 hornetsnest Member Altcoin Discussion
16 hugeblack Sr. Member Archival
16 Dzeronimo Member Hrvatski (Croatian)
14 alegotardo Full Member Português (Portuguese)
13 webtricks Sr. Member India
10 John Kreese Newbie Off-topic
9 heraware Jr. Member Speculation (Altcoins)
8 sbogovac Legendary Nederlands (Dutch)
8 hakka Member 日本語 (Japanese)
7 NashAmajh Jr. Member Marketplace (Altcoins)
6 CryptopreneurBrainboss Member Serious discussion
5 koreacryptocurrency Full Member 한국어 (Korean)
2 James_CRYPTOSTAR.MONEY Newbie Other languages/locations
2 IonCreanga Jr. Member Română (Romanian)
1 SergeyP77 Jr. Member 中文 (Chinese)
Sub boards merit circulation for May
Code:
5 한국어 (Korean)
273 null
344 Altcoin Discussion
565 Announcements (Altcoins)
3 Archival
1269 Bahasa Indonesia (Indonesian)
684 Beginners & Help
522 Bitcoin Discussion
224 Bitcoin Technical Support
1012 Deutsch (German)
1078 Development & Technical Discussion
2179 Economics
159 Español (Spanish)
284 Français
50 Hrvatski (Croatian)
61 India
261 Italiano (Italian)
2582 Marketplace
63 Marketplace (Altcoins)
2824 Meta
422 Mining
206 Mining (Altcoins)
25 Nederlands (Dutch)
83 Off-topic
11 Other languages/locations
510 Pilipinas
667 Politics & Society
371 Polski
79 Português (Portuguese)
144 Project Development
3 Română (Romanian)
29 Serious discussion
132 Speculation (Altcoins)
1906 Trading Discussion
415 Türkçe (Turkish)
1 Eλληνικά (Greek)
1644 Pyccкий (Russian)
207 العربية (Arabic)
3 中文 (Chinese)
14 日本語 (Japanese)
Merits sent from each rank for May
Code:
Administrator 53
Copper Member 703
Donator 522
Full Member 1945
Global Moderator 94
Hero Member 2167
Jr. Member 450
Legendary 8290
Member 1152
Newbie 340
Sr. Member 2238
Staff 3225
VIP 2
Merits received from each rank for May
Code:
Administrator 332
Brand new 13
Copper Member 1154
Donator 234
Founder 23
Full Member 2721
Global Moderator 81
Hero Member 2677
Jr. Member 1518
Legendary 4903
Member 2544
Newbie 1253
Sr. Member 2750
Staff 514
VIP 53
Also, one thing worth noting is that most Members in the latest have ranked up, but they still seem to be listed with the ranks they had 2 - 3 moths ago.
Shouldn't it be necessary to show the latest rank or it's does not matter in this case?
Shouldn't it be necessary to show the latest rank or it's does not matter in this case?
the rank is not updated indeed, is not really critical as the main purpose is to see who gets/sends merits, however i can see if i find the script i had to update the users and run it
Also, one thing worth noting is that most Members in the latest have ranked up, but they still seem to be listed with the ranks they had 2 - 3 moths ago.
Shouldn't it be necessary to show the latest rank or it's does not matter in this case?
Shouldn't it be necessary to show the latest rank or it's does not matter in this case?
I second the idea of monthly statistics, in line with MS refill cycle. It makes a lot of sense IMHO.
One thing to bear in mind though is that Merit Source allocation is not filled-up to it’s max. on a single date per month, nor did all Merit Sources being one on the same date.For example, a Merit Source may start being one on the 10th of a given month, and give out (for simplicity) 5 merits per day. That would mean that, 30 days later, the Merit Source will get a refill of 5 sMerits in his allowance, 5 on the following day and so on. The rule being that you get a refill cloned to what you spend on a given day exactly 30 days down the road (down to hour and minute).
This are my only 2 cents.
Jump to: