Tool to run online SQL queries over Full Merit Data

[Piggy]

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
 

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

[Piggy]

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
 

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

[Piggy]

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
 

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

[fillippone]

So proud of this!

Top Sender per board last week

Code:

18	fillippone	Sr. Member	Italiano (Italian)

[Piggy]

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
 

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

[Lakai01]

Hi piggy!
Hope you didnt stop maintaining your database? I am keenly awaiting the July-statistics

[Saint-loup]

No more updates? 
Piggy should be on holiday I guess.

[Lakai01]

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.
Edit: The last update of Piggys database was on 2nd of August, so all data until that day is available and queryable.

[Lakai01]

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)

[DdmrDdmr]

<…>

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

[Lakai01]

<…>

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

Thanks for the review DdmrDdmr! Piggy uploaded his data til the first week of August, so I decided to start from this date onwards. I will recheck if I any data is missing!
The userdata table is missing on purpose, if someone needs the data I will upload it, too, of course!

[Lakai01]

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