Tool to run online SQL queries over Full Merit Data - page 4.

Piggy

hero member

Activity: 784

Merit: 1416

The tool is now updated with the latest data from today Friday 14th of December

Here is the usual snapshot about the last week:

Top Sender per board last week

Code:

144	chimk	Full Member	Pyccкий (Russian)
88	suchmoon	Legendary	Meta
81	dbshck	Staff	Bahasa Indonesia (Indonesian)
75	frodocooper	Staff	Mining
67	Halab	Staff	Français
50	template	Hero Member	Announcements (Altcoins)
42	JayJuanGee	Legendary	Economics
40	Flying Hellfish	Staff	Politics & Society
40	bomberb17	Hero Member	Eλληνικά (Greek)
38	fisheater	Hero Member	Development & Technical Discussion
36	suchmoon	Legendary	Beginners & Help
35	Welsh	Staff	Serious discussion
32	suchmoon	Legendary	Bitcoin Technical Support
25	Welsh	Staff	Trading Discussion
20	Micio	Legendary	Italiano (Italian)
20	scryptr	Legendary	Mining (Altcoins)
19	EFS	Staff	Türkçe (Turkish)
17	paxmao	Sr. Member	Español (Spanish)
17	polymerbit	Full Member	Marketplace
14	Foxpup	Legendary	
14	RegulusHr	Full Member	Hrvatski (Croatian)
14	Vod	Legendary	Off-topic
12	Vod	Legendary	Project Development
11	willi9974	Legendary	Deutsch (German)
9	JayJuanGee	Legendary	Bitcoin Discussion
6	halisakal	Hero Member	Altcoin Discussion
6	tudor_simion	Member	Română (Romanian)
5	Flying Hellfish	Staff	Archival
4	scarface-T	Full Member	Speculation (Altcoins)
3	Heisenberg_Hunter	Full Member	India
3	KLoUN287	Member	Marketplace (Altcoins)
3	sbogovac	Legendary	Nederlands (Dutch)
3	hugeblack	Sr. Member	العربية (Arabic)
2	bitart	Hero Member	Other languages/locations
2	alegotardo	Full Member	Português (Portuguese)
2	Anon11073	Staff	日本語 (Japanese)
1	Barcode_	Staff	中文 (Chinese)

Top Receivers per board last week

Code:

72	DdmrDdmr	Sr. Member	Meta
62	micgoossens	Sr. Member	Economics
50	techbytes	Legendary	Announcements (Altcoins)
40	MZ4	Newbie	Eλληνικά (Greek)
38	dreamhouse	Hero Member	Development & Technical Discussion
34	sidehack	Legendary	Mining
31	mu_enrico	Copper Member	Bahasa Indonesia (Indonesian)
30	Xprim777	Legendary	Marketplace
23	Hc01	Full Member	Türkçe (Turkish)
22	TryNinja	Hero Member	Beginners & Help
20	theymos	Administrator	Politics & Society
17	nutildah	Legendary	Off-topic
16	Coding Enthusiast	Sr. Member	Bitcoin Technical Support
15	Saint-loup	Sr. Member	Français
14	TheFuzzStone	Hero Member	Pyccкий (Russian)
13	gbianchi	Legendary	Italiano (Italian)
12	Macadonian	Member	Serious discussion
10	Miner.Hosting	Newbie	Deutsch (German)
10	kerney666	Jr. Member	Mining (Altcoins)
9	Locotoni	Copper Member	Trading Discussion
8	Kakmakr	Legendary	Bitcoin Discussion
7	Trofo	Sr. Member	Hrvatski (Croatian)
6	AlexSimion	Full Member	Română (Romanian)
5	AlexSG	Full Member	
5	basty03	Jr. Member	Altcoin Discussion
5	Hhampuz	Hero Member	Archival
5	seoincorporation	Legendary	Español (Spanish)
5	crabby	Member	Project Development
4	TwSeventh	Full Member	Speculation (Altcoins)
3	ambeo	Jr. Member	Marketplace (Altcoins)
3	QuadsPoker	Copper Member	Nederlands (Dutch)
2	amicrypto	Newbie	India
2	TryNinja	Hero Member	Português (Portuguese)
2	hakka	Member	日本語 (Japanese)
1	Fenya96	Jr. Member	Other languages/locations
1	hesham51	Member	العربية (Arabic)
1	baobao2000	Member	中文 (Chinese)

Sub boards merit circulation last week

Code:

6	Română (Romanian)
45	Eλληνικά (Greek)
7	Archival
2	日本語 (Japanese)
49	
59	Altcoin Discussion
191	Announcements (Altcoins)
134	Bahasa Indonesia (Indonesian)
171	Beginners & Help
102	Bitcoin Discussion
136	Bitcoin Technical Support
79	Deutsch (German)
175	Development & Technical Discussion
556	Economics
22	Español (Spanish)
125	Français
30	Hrvatski (Croatian)
3	India
47	Italiano (Italian)
216	Marketplace
15	Marketplace (Altcoins)
598	Meta
144	Mining
32	Mining (Altcoins)
5	Nederlands (Dutch)
54	Off-topic
4	Other languages/locations
99	Politics & Society
7	Português (Portuguese)
22	Project Development
110	Serious discussion
14	Speculation (Altcoins)
89	Trading Discussion
59	Türkçe (Turkish)
302	Pyccкий (Russian)
4	العربية (Arabic)
1	中文 (Chinese)

Merits sent from each rank last week

Code:

Administrator	18
Copper Member	79
Donator	32
Full Member	373
Global Moderator	11
Hero Member	438
Jr. Member	70
Legendary	1428
Member	200
Newbie	29
Sr. Member	362
Staff	673
VIP	1

Merits received from each rank last week

Code:

Administrator	84
Brand new	3
Copper Member	177
Donator	24
Founder	6
Full Member	332
Global Moderator	9
Hero Member	452
Jr. Member	351
Legendary	929
Member	427
Newbie	250
Sr. Member	580
Staff	89
VIP	1

Piggy

hero member

Activity: 784

Merit: 1416

The tool is now updated with the latest data from today Friday 7th of December

Here is the usual snapshot about the last week:

Top Sender per board last week

Code:

90	Micio	Legendary	Italiano (Italian)
70	dbshck	Staff	Bahasa Indonesia (Indonesian)
65	DarkStar_	Legendary	Development & Technical Discussion
64	GRAND EX	Hero Member	Pyccкий (Russian)
57	qwk	Donator	Deutsch (German)
53	BitSler support	Hero Member	Marketplace
52	paxmao	Sr. Member	Español (Spanish)
50	notsofast	Legendary	Economics
46	Halab	Staff	Français
45	OgNasty	Donator	
45	frodocooper	Staff	Mining
42	dbshck	Staff	Bitcoin Discussion
40	suchmoon	Legendary	Meta
36	Vlad2Vlad	Legendary	Announcements (Altcoins)
34	Foxpup	Legendary	Politics & Society
28	suchmoon	Legendary	Beginners & Help
28	suchmoon	Legendary	Trading Discussion
28	mitzie	Staff	Eλληνικά (Greek)
23	EFS	Staff	Türkçe (Turkish)
20	paxmao	Sr. Member	Serious discussion
17	LoyceV	Legendary	Bitcoin Technical Support
14	krogothmanhattan	Hero Member	Project Development
13	RegulusHr	Full Member	Hrvatski (Croatian)
9	vapourminer	Legendary	Mining (Altcoins)
8	Vlad2Vlad	Legendary	Altcoin Discussion
6	Foxpup	Legendary	Off-topic
5	rahmanrock	Full Member	Marketplace (Altcoins)
5	kodtycoon	Legendary	Speculation (Altcoins)
5	hugeblack	Sr. Member	العربية (Arabic)
5	Anon11073	Staff	日本語 (Japanese)
4	amishmanish	Sr. Member	India
4	sabotag3x	Hero Member	Português (Portuguese)
3	Barcode_	Staff	中文 (Chinese)
2	Iced	Full Member	Nederlands (Dutch)
2	BitCryptex	Sr. Member	Polski
1	Incomelocker	Jr. Member	Other languages/locations
1	BlackMambaPH	Hero Member	Philippines

Top Receivers per board last week

Code:

89	JagerBeen	Jr. Member	Pyccкий (Russian)
59	micgoossens	Sr. Member	Economics
52	LV5ME	Member	Announcements (Altcoins)
38	Baryom	Hero Member	Marketplace
38	fisheater	Hero Member	Trading Discussion
30	Flying Hellfish	Staff	Politics & Society
28	coinlocket$	Sr. Member	Italiano (Italian)
24	roycilik	Sr. Member	Bahasa Indonesia (Indonesian)
22	aliashraf	Sr. Member	Development & Technical Discussion
20	panagot	Sr. Member	Eλληνικά (Greek)
19	hold-coins	Newbie	Bitcoin Discussion
19	HCP	Hero Member	Bitcoin Technical Support
17	kenzawak	Full Member	Français
17	friends1980	Full Member	Serious discussion
16	DdmrDdmr	Sr. Member	Español (Spanish)
16	ekiller	Hero Member	Türkçe (Turkish)
15	nullCoiner	Sr. Member	Deutsch (German)
14	SaltySpitoon	Legendary	Meta
14	canton	Sr. Member	Project Development
12	Last of the V8s	Legendary	Off-topic
11	mgoz	Member	Mining
10	phitan	Member	
10	hashbook	Copper Member	Mining (Altcoins)
7	Jet Cash	Legendary	Beginners & Help
5	nix1977	Jr. Member	Marketplace (Altcoins)
5	Cacingkemi	Hero Member	Speculation (Altcoins)
4	capableuwa1	Copper Member	Altcoin Discussion
4	Pmalek	Hero Member	Hrvatski (Croatian)
3	Jewel2895	Jr. Member	India
3	cryptovigi	Member	Polski
3	outsidertrader	Jr. Member	Português (Portuguese)
3	miswo	Newbie	日本語 (Japanese)
2	sbogovac	Legendary	Nederlands (Dutch)
2	Simayi	Member	中文 (Chinese)
1	R.I.F	Newbie	Other languages/locations
1	harizen	Legendary	Philippines
1	Kavelj22	Newbie	العربية (Arabic)

Sub boards merit circulation last week

Code:

38	Eλληνικά (Greek)
2	Nederlands (Dutch)
5	Polski
5	日本語 (Japanese)
91	
36	Altcoin Discussion
335	Announcements (Altcoins)
110	Bahasa Indonesia (Indonesian)
79	Beginners & Help
138	Bitcoin Discussion
73	Bitcoin Technical Support
149	Deutsch (German)
151	Development & Technical Discussion
657	Economics
63	Español (Spanish)
85	Français
23	Hrvatski (Croatian)
12	India
122	Italiano (Italian)
424	Marketplace
10	Marketplace (Altcoins)
195	Meta
69	Mining
28	Mining (Altcoins)
24	Off-topic
2	Other languages/locations
2	Philippines
158	Politics & Society
11	Português (Portuguese)
24	Project Development
109	Serious discussion
19	Speculation (Altcoins)
123	Trading Discussion
89	Türkçe (Turkish)
438	Pyccкий (Russian)
7	العربية (Arabic)
3	中文 (Chinese)

Merits sent from each rank last week

Code:

Administrator	2
Copper Member	79
Donator	128
Full Member	262
Global Moderator	6
Hero Member	511
Jr. Member	70
Legendary	1514
Member	196
Newbie	54
Sr. Member	624
Staff	462
VIP	1

Merits received from each rank last week

Code:

Administrator	6
Brand new	5
Copper Member	200
Donator	32
Founder	23
Full Member	356
Global Moderator	5
Hero Member	446
Jr. Member	380
Legendary	880
Member	481
Newbie	338
Sr. Member	667
Staff	69
VIP	21

Piggy

hero member

Activity: 784

Merit: 1416

The tool is now updated with the latest data from today Friday 30th of November

Here is the usual snapshot about the last week:

Top Sender per board last week

Code:

183	chimk	Full Member	Pyccкий (Russian)
141	qwk	Donator	Deutsch (German)
124	suchmoon	Legendary	Meta
63	Halab	Staff	Français
60	suchmoon	Legendary	Serious discussion
55	klintay	Legendary	Announcements (Altcoins)
50	cryptohunter	Legendary	Bitcoin Discussion
50	monocolor	Hero Member	Development & Technical Discussion
50	sammy007	Legendary	Economics
42	klintay	Legendary	Mining
29	Flying Hellfish	Staff	Politics & Society
25	EFS	Staff	Türkçe (Turkish)
23	dbshck	Staff	Bahasa Indonesia (Indonesian)
22	Vlad2Vlad	Legendary	Altcoin Discussion
21	bitkilo	Legendary	Marketplace
20	Jet Cash	Legendary	Beginners & Help
18	paxmao	Sr. Member	Español (Spanish)
11	Micio	Legendary	Italiano (Italian)
11	nutildah	Legendary	Trading Discussion
10	sabotag3x	Hero Member	Português (Portuguese)
9	LoyceV	Legendary	Bitcoin Technical Support
9	RegulusHr	Full Member	Hrvatski (Croatian)
8	suchmoon	Legendary	
8	Anon11073	Staff	日本語 (Japanese)
7	dbshck	Staff	Mining (Altcoins)
5	batesresearch	Legendary	Marketplace (Altcoins)
4	amishmanish	Sr. Member	India
4	suchmoon	Legendary	Off-topic
4	joshua123	Full Member	Philippines
4	Vod	Legendary	Project Development
4	hugeblack	Sr. Member	العربية (Arabic)
2	pawel7777	Legendary	Polski
2	Hueristic	Legendary	Speculation (Altcoins)
2	Barcode_	Staff	中文 (Chinese)
1	sbogovac	Legendary	Nederlands (Dutch)
1	Dzeronimo	Member	Other languages/locations

Top Receivers per board last week

Code:

62	satoshi	Founder	Bitcoin Discussion
54	realr0ach	Full Member	Economics
50	VeilDango	Copper Member	Announcements (Altcoins)
50	dreamhouse	Hero Member	Development & Technical Discussion
39	suchmoon	Legendary	Meta
33	phantastisch	Staff	Deutsch (German)
25	abhiseshakana	Full Member	Bahasa Indonesia (Indonesian)
24	o_e_l_e_o	Sr. Member	Serious discussion
22	vh	Hero Member	Mining
21	zazarb	Legendary	Marketplace
20	CoinHoarder	Legendary	Altcoin Discussion
20	Nomad88	Legendary	Türkçe (Turkish)
19	Smartprofit	Full Member	Pyccкий (Russian)
17	Flying Hellfish	Staff	Politics & Society
15	HeRetiK	Hero Member	Bitcoin Technical Support
12	kenzawak	Full Member	Français
10	gbianchi	Legendary	Italiano (Italian)
9	big_daddy	Full Member	Hrvatski (Croatian)
7	jstefanop	Legendary	Mining (Altcoins)
7	coinlocket$	Sr. Member	Trading Discussion
6	kingpin4321	Newbie	Beginners & Help
6	Zarg0n	Member	Español (Spanish)
5	geostima	Newbie	Marketplace (Altcoins)
5	DireWolfM14	Member	Off-topic
5	mcnocon2	Jr. Member	Philippines
5	hakka	Member	日本語 (Japanese)
4	ETFbitcoin	Legendary	
4	Vod	Legendary	Project Development
3	TryNinja	Hero Member	Português (Portuguese)
3	Summation	Jr. Member	中文 (Chinese)
2	amicrypto	Newbie	India
2	BitCryptex	Sr. Member	Polski
2	johnalan	Member	Speculation (Altcoins)
2	hugeblack	Sr. Member	العربية (Arabic)
1	bit my coin	Newbie	Nederlands (Dutch)
1	CryptoLavlu	Jr. Member	Other languages/locations

Sub boards merit circulation last week

Code:

42	
98	Altcoin Discussion
348	Announcements (Altcoins)
81	Bahasa Indonesia (Indonesian)
67	Beginners & Help
216	Bitcoin Discussion
29	Bitcoin Technical Support
315	Deutsch (German)
142	Development & Technical Discussion
656	Economics
23	Español (Spanish)
112	Français
39	Hrvatski (Croatian)
5	India
40	Italiano (Italian)
220	Marketplace
18	Marketplace (Altcoins)
364	Meta
128	Mining
20	Mining (Altcoins)
1	Nederlands (Dutch)
20	Off-topic
3	Other languages/locations
6	Philippines
113	Politics & Society
3	Polski
13	Português (Portuguese)
21	Project Development
145	Serious discussion
8	Speculation (Altcoins)
92	Trading Discussion
90	Türkçe (Turkish)
377	Pyccкий (Russian)
7	العربية (Arabic)
4	中文 (Chinese)
13	日本語 (Japanese)

Merits sent from each rank last week

Code:

Administrator	1
Copper Member	82
Donator	165
Full Member	400
Global Moderator	13
Hero Member	439
Jr. Member	58
Legendary	1787
Member	189
Newbie	53
Sr. Member	395
Staff	297

Merits received from each rank last week

Code:

Administrator	7
Brand new	3
Copper Member	131
Donator	35
Founder	65
Full Member	473
Global Moderator	29
Hero Member	532
Jr. Member	311
Legendary	933
Member	422
Newbie	262
Sr. Member	536
Staff	139
VIP	1

Piggy

hero member

Activity: 784

Merit: 1416

Quote from: tranthidung on November 24, 2018, 09:27:51 PM

Highly appreciated your time to do it, keep it update weekly.
Would you mind spending your precious time to scrap data and give me and others the sort of weekly merits sent from each rank over weeks, since the start of merit system, please.

Additionally, if you have intention to do this, I suggest you to do the same for total weekly merit received from each rank over weeks, since the start of merit sytem.

I asked this because I have a topic, which shows the observations of distributed merits over days, weeks, and months, since the start of merit system.
By now, I use LoyceV's data source, which has not had the sort of data mentioned above.
My topic is here: Time Series Analysis on Distributed Merits in the forum (daily, weekly, monthly)

Quote from: Piggy on November 23, 2018, 08:52:57 AM

Merits sent from each rank last week

Code:

Administrator	12
Copper Member	92
Donator	141
Full Member	313
Global Moderator	31
Hero Member	450
Jr. Member	82
Legendary	2012
Member	226
Newbie	40
Sr. Member	499
Staff	380

To extract the information you need you can use this query for the merit sent from each rank:

Code:

SELECT UserData.Rank, SUM(MeritData.Merit) as Total
FROM MeritData 
INNER JOIN UserData ON UserData.UserId = MeritData.fromid
WHERE date between  '2018-11-16' AND '2018-11-23' 
GROUP BY UserData.Rank;

And this one for the merit received from each rank:

Code:

SELECT UserData.Rank, SUM(MeritData.Merit) as Total
FROM MeritData 
INNER JOIN UserData ON UserData.UserId = MeritData.toid
WHERE date between  '2018-11-16' AND '2018-11-23' 
GROUP BY UserData.Rank;

Then you can select the time range corresponding to the range you need to extract the weekly data

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Highly appreciated your time to do it, keep it update weekly.
Would you mind spending your precious time to scrap data and give me and others the sort of weekly merits sent from each rank over weeks, since the start of merit system, please.

Additionally, if you have intention to do this, I suggest you to do the same for total weekly merit received from each rank over weeks, since the start of merit sytem.

I asked this because I have a topic, which shows the observations of distributed merits over days, weeks, and months, since the start of merit system.
By now, I use LoyceV's data source, which has not had the sort of data mentioned above.
My topic is here: Time Series Analysis on Distributed Merits in the forum (daily, weekly, monthly)

Quote from: Piggy on November 23, 2018, 08:52:57 AM

Merits sent from each rank last week

Code:

Administrator	12
Copper Member	92
Donator	141
Full Member	313
Global Moderator	31
Hero Member	450
Jr. Member	82
Legendary	2012
Member	226
Newbie	40
Sr. Member	499
Staff	380

Piggy

hero member

Activity: 784

Merit: 1416

The tool is now updated with the latest data from today Friday 23th of November

Here is the usual snapshot about the last week:

Top Sender per board last week

Code:

102	qwk	Donator	Deutsch (German)
100	suchmoon	Legendary	Meta
81	chimk	Full Member	Pyccкий (Russian)
76	QuestionAuthority	Legendary	Economics
72	dbshck	Staff	Bahasa Indonesia (Indonesian)
53	Foxpup	Legendary	Politics & Society
51	Jeremycoin	Legendary	Bitcoin Discussion
51	EFS	Staff	Türkçe (Turkish)
50	lyka	Legendary	Altcoin Discussion
45	bones261	Legendary	Development & Technical Discussion
41	Halab	Staff	Français
40	Vlad2Vlad	Legendary	Announcements (Altcoins)
37	Micio	Legendary	Italiano (Italian)
31	paxmao	Sr. Member	Español (Spanish)
30	Flying Hellfish	Staff	Marketplace
28	suchmoon	Legendary	Trading Discussion
20	suchmoon	Legendary	Serious discussion
19	Real14Hero	Hero Member	Other languages/locations
18	suchmoon	Legendary	Bitcoin Technical Support
16	Foxpup	Legendary	Beginners & Help
14	dbshck	Staff	Mining (Altcoins)
14	Vod	Legendary	Off-topic
14	hugeblack	Sr. Member	العربية (Arabic)
13	RegulusHr	Full Member	Hrvatski (Croatian)
12	suchmoon	Legendary	Mining
11	Barcode_	Staff	中文 (Chinese)
10	sabotag3x	Hero Member	Português (Portuguese)
9	el kaka22	Legendary	
8	Vod	Legendary	Project Development
8	suchmoon	Legendary	Speculation (Altcoins)
4	Whiteness	Copper Member	Marketplace (Altcoins)
1	Heisenberg_Hunter	Full Member	India
1	cryptoaddictchie	Member	Philippines
1	Tytanowy Janusz	Member	Polski

Top Receivers per board last week

Code:

68	goldkingcoiner	Member	Economics
51	satoshi	Founder	Bitcoin Discussion
50	lybship53	Sr. Member	Altcoin Discussion
47	SaltySpitoon	Legendary	Meta
38	SaltySpitoon	Legendary	Politics & Society
36	deadsea33	Jr. Member	Announcements (Altcoins)
34	PHI1618	Sr. Member	Türkçe (Turkish)
32	roycilik	Sr. Member	Bahasa Indonesia (Indonesian)
30	minerjones	Copper Member	Marketplace
25	HeRetiK	Hero Member	Development & Technical Discussion
25	Plutosky	Member	Italiano (Italian)
22	philipma1957	Legendary	Mining
20	Ultramarine	Member	Pyccкий (Russian)
19	IggySe7ven	Member	Other languages/locations
17	acarli	Member	Serious discussion
15	siulynotb	Jr. Member	Español (Spanish)
15	asche	Full Member	Français
14	chenille	Newbie	Deutsch (German)
13	KingZee	Sr. Member	Bitcoin Technical Support
11	marlboroza	Hero Member	Trading Discussion
8	DdmrDdmr	Sr. Member	Beginners & Help
8	Sk_Ezaz	Copper Member	Marketplace (Altcoins)
8	QuestionAuthority	Legendary	Off-topic
8	Summation	Jr. Member	中文 (Chinese)
6	andrucrypt	Member	Mining (Altcoins)
6	xtraelv	Sr. Member	Speculation (Altcoins)
5	Godplan	Newbie	
4	bernardos	Newbie	Hrvatski (Croatian)
4	texgeek	Member	Português (Portuguese)
3	ibminer	Legendary	Project Development
3	HAKHALI	Jr. Member	العربية (Arabic)
1	drmilind2004	Member	India
1	Maus0728	Member	Philippines
1	Tytanowy Janusz	Member	Polski

Sub boards merit circulation last week

Code:

16	中文 (Chinese)
29	
112	Altcoin Discussion
211	Announcements (Altcoins)
205	Bahasa Indonesia (Indonesian)
66	Beginners & Help
148	Bitcoin Discussion
34	Bitcoin Technical Support
240	Deutsch (German)
279	Development & Technical Discussion
751	Economics
60	Español (Spanish)
106	Français
23	Hrvatski (Croatian)
1	India
83	Italiano (Italian)
264	Marketplace
20	Marketplace (Altcoins)
466	Meta
43	Mining
33	Mining (Altcoins)
58	Off-topic
35	Other languages/locations
2	Philippines
255	Politics & Society
3	Polski
14	Português (Portuguese)
12	Project Development
71	Serious discussion
32	Speculation (Altcoins)
150	Trading Discussion
139	Türkçe (Turkish)
298	Pyccкий (Russian)
19	العربية (Arabic)

Merits sent from each rank last week

Code:

Administrator	12
Copper Member	92
Donator	141
Full Member	313
Global Moderator	31
Hero Member	450
Jr. Member	82
Legendary	2012
Member	226
Newbie	40
Sr. Member	499
Staff	380

Piggy

hero member

Activity: 784

Merit: 1416

The tool is now updated with the latest data from today Friday 16th of November

Here is the usual snapshot about the last week:

Top Sender per board last week

Code:

154	chimk	Full Member	Pyccкий (Russian)
71	suchmoon	Legendary	Meta
57	paxmao	Sr. Member	Español (Spanish)
56	DarkStar_	Legendary	Development & Technical Discussion
50	adroitful_one	Legendary	Altcoin Discussion
50	DECENT	Hero Member	Announcements (Altcoins)
50	fr4nkthetank	Legendary	Bitcoin Discussion
50	ziomik	Legendary	Italiano (Italian)
47	Flying Hellfish	Staff	Politics & Society
40	dbshck	Staff	Bahasa Indonesia (Indonesian)
40	BitCryptex	Sr. Member	Polski
39	LFC_Bitcoin	Copper Member	Economics
38	Flying Hellfish	Staff	Marketplace
37	qwk	Donator	Deutsch (German)
35	bg002h	Donator	Trading Discussion
32	dbshck	Staff	Beginners & Help
30	Halab	Staff	Français
28	suchmoon	Legendary	Serious discussion
24	Leteravian	Full Member	Türkçe (Turkish)
20	olkah	Hero Member	Marketplace (Altcoins)
16	suchmoon	Legendary	Off-topic
13	RegulusHr	Full Member	Hrvatski (Croatian)
13	dbshck	Staff	Mining (Altcoins)
12	frodocooper	Staff	Mining
10	3x2	Legendary	
8	LoyceV	Legendary	Bitcoin Technical Support
8	suchmoon	Legendary	Project Development
8	3x2	Legendary	日本語 (Japanese)
4	Flying Hellfish	Staff	Archival
4	cAPSLOCK	Legendary	Speculation (Altcoins)
2	Heisenberg_Hunter	Full Member	India
2	bitmover	Sr. Member	Português (Portuguese)
2	hugeblack	Sr. Member	العربية (Arabic)
2	Barcode_	Staff	中文 (Chinese)
1	Dzeronimo	Member	Other languages/locations
1	Kemarit	Legendary	Philippines

Top Receivers per board last week

Code:

60	DECENT Marketing	Newbie	Announcements (Altcoins)
58	gmaxwell	Staff	Trading Discussion
54	Hal	VIP	Bitcoin Discussion
51	satoshi	Founder	Development & Technical Discussion
50	Devawnm367	Member	Altcoin Discussion
50	gallisiardi	Member	Italiano (Italian)
46	karimushkin	Jr. Member	Pyccкий (Russian)
45	DdmrDdmr	Sr. Member	Meta
43	Kylapoiss	Member	Economics
43	1Dq	Copper Member	Marketplace
34	coins4commies	Member	Politics & Society
30	cryptovigi	Member	Polski
25	Hilde X	Member	Deutsch (German)
23	seoincorporation	Legendary	Español (Spanish)
21	ranchi	Jr. Member	Marketplace (Altcoins)
19	mu_enrico	Copper Member	Bahasa Indonesia (Indonesian)
12	asche	Full Member	Français
11	Jet Cash	Legendary	Serious discussion
10	duma18	Newbie	
10	acarli	Member	Mining
10	Cemlik	Member	Türkçe (Turkish)
9	TrailingStop	Newbie	Mining (Altcoins)
9	Flying Hellfish	Staff	Off-topic
9	arulbero	Hero Member	Project Development
8	AverageGlabella	Full Member	Beginners & Help
8	Choco99	Newbie	日本語 (Japanese)
7	Dzeronimo	Member	Hrvatski (Croatian)
4	dazedfool	Legendary	Archival
4	BitCryptex	Sr. Member	Bitcoin Technical Support
4	lrvjvt	Jr. Member	中文 (Chinese)
3	Locotoni	Copper Member	Speculation (Altcoins)
2	amicrypto	Newbie	India
2	Keeshan	Member	Other languages/locations
1	eldrin	Full Member	Philippines
1	Mamaecrypto	Member	Português (Portuguese)
1	Gamals	Jr. Member	العربية (Arabic)

Sub boards merit circulation last week

Code:

8	日本語 (Japanese)
5	Archival
48	
176	Altcoin Discussion
464	Announcements (Altcoins)
112	Bahasa Indonesia (Indonesian)
149	Beginners & Help
214	Bitcoin Discussion
25	Bitcoin Technical Support
196	Deutsch (German)
265	Development & Technical Discussion
437	Economics
74	Español (Spanish)
69	Français
34	Hrvatski (Croatian)
3	India
122	Italiano (Italian)
300	Marketplace
87	Marketplace (Altcoins)
359	Meta
54	Mining
37	Mining (Altcoins)
21	Off-topic
1	Other languages/locations
1	Philippines
155	Politics & Society
66	Polski
3	Português (Portuguese)
36	Project Development
199	Serious discussion
13	Speculation (Altcoins)
267	Trading Discussion
77	Türkçe (Turkish)
510	Pyccкий (Russian)
6	العربية (Arabic)
5	中文 (Chinese)

Merits sent from each rank last week

Code:

Administrator	1
Copper Member	107
Donator	115
Full Member	413
Global Moderator	1
Hero Member	563
Jr. Member	151
Legendary	1788
Member	269
Newbie	47
Sr. Member	562
Staff	581

Piggy

hero member

Activity: 784

Merit: 1416

Quote from: Saint-loup on November 10, 2018, 01:36:22 PM

Quote from: Piggy on November 02, 2018, 06:17:18 AM

The data is now updated to Friday 2th of November

Here is some general numbers about the last week:

Top Sender per board last week
[...]

Hello
No scores for this week?
I tried to execute some sql queries in your tool to get them, but I got this error message instead Undecided

Code:

Uncaught Error: no such table: meritdata

Not sure about the error what i may be, however when you see the list of the table specifications when you first load the page you are good to go and run the queries.

Here are the usual queries for the past week:

Top Sender per board last week

Code:

102	frodocooper	Staff	Mining
80	chimk	Full Member	Pyccкий (Russian)
77	dbshck	Staff	Bahasa Indonesia (Indonesian)
68	qwk	Donator	Deutsch (German)
60	QuestionAuthority	Legendary	Economics
58	Flying Hellfish	Staff	Marketplace
38	Flying Hellfish	Staff	Politics & Society
36	Foxpup	Legendary	Trading Discussion
35	paxmao	Sr. Member	Español (Spanish)
32	Halab	Staff	Français
30	Vod	Legendary	Meta
24	suchmoon	Legendary	Serious discussion
21	NoNetwork	Sr. Member	Bitcoin Discussion
20	marcus_of_augustus	Legendary	Announcements (Altcoins)
19	Piggy	Hero Member	Italiano (Italian)
18	teramit	Legendary	Türkçe (Turkish)
16	dbshck	Staff	Beginners & Help
15	RegulusHr	Full Member	Hrvatski (Croatian)
12	Foxpup	Legendary	Development & Technical Discussion
12	BitCryptex	Sr. Member	Polski
11	dbshck	Staff	
11	Foxpup	Legendary	Bitcoin Technical Support
10	Vod	Legendary	Off-topic
10	chek2fire	Legendary	Eλληνικά (Greek)
9	Vod	Legendary	Project Development
6	KeyJockey	Hero Member	Speculation (Altcoins)
6	hugeblack	Sr. Member	العربية (Arabic)
5	Haunebu	Hero Member	Altcoin Discussion
5	italianMiner72	Hero Member	Marketplace (Altcoins)
5	vapourminer	Legendary	Mining (Altcoins)
3	Heisenberg_Hunter	Full Member	India
3	Barcode_	Staff	中文 (Chinese)
2	friends1980	Full Member	Nederlands (Dutch)
2	siddu67	Full Member	Other languages/locations
2	Lassie	Member	Philippines
2	sabotag3x	Hero Member	Português (Portuguese)
2	Anon11073	Staff	日本語 (Japanese)

Top Receivers per board last week

Code:

53	Last of the V8s	Legendary	Economics
50	TNM1WPCK	Newbie	Pyccкий (Russian)
33	mu_enrico	Copper Member	Bahasa Indonesia (Indonesian)
27	OgNasty	Donator	Meta
27	sidehack	Legendary	Mining
24	Vod	Legendary	Trading Discussion
21	Jcabudx	Member	Bitcoin Discussion
20	karakozov	Newbie	Announcements (Altcoins)
20	laszlo	Full Member	Marketplace
19	squatz1	Hero Member	Politics & Society
18	aundroid	Full Member	Deutsch (German)
15	arulbero	Hero Member	Development & Technical Discussion
15	wwzsocki	Sr. Member	Polski
13	BitCryptex	Sr. Member	Bitcoin Technical Support
13	Raja_MBZ	Hero Member	Serious discussion
11	duesoldi	Sr. Member	Italiano (Italian)
10	ureticy	Newbie	Türkçe (Turkish)
10	MAR 85	Newbie	Eλληνικά (Greek)
9	poloniex777	Jr. Member	Español (Spanish)
8	CarlOrff	Sr. Member	Français
8	slackovic	Full Member	Hrvatski (Croatian)
7	mu_enrico	Copper Member	Beginners & Help
7	Loki11	Newbie	Project Development
6	lightlord	Donator	Off-topic
5	3kpk3	Full Member	Altcoin Discussion
5	Krishniche	Jr. Member	Marketplace (Altcoins)
4	Febo	Legendary	Speculation (Altcoins)
4	HAKHALI	Jr. Member	العربية (Arabic)
3	HCP	Hero Member	
3	Hiranand	Newbie	India
3	todxx	Jr. Member	Mining (Altcoins)
3	sncc	Sr. Member	日本語 (Japanese)
2	kabirhusen	Jr. Member	Other languages/locations
2	OptimusFries	Jr. Member	Philippines
2	#BitcoinCore	Sr. Member	Português (Portuguese)
1	FIEX	Sr. Member	Nederlands (Dutch)
1	Canadabiter	Jr. Member	中文 (Chinese)

Sub boards merit circulation last week

Code:

10	Eλληνικά (Greek)
2	Other languages/locations
34	
53	Altcoin Discussion
228	Announcements (Altcoins)
195	Bahasa Indonesia (Indonesian)
59	Beginners & Help
135	Bitcoin Discussion
11	Bitcoin Technical Support
206	Deutsch (German)
103	Development & Technical Discussion
484	Economics
45	Español (Spanish)
71	Français
38	Hrvatski (Croatian)
10	India
59	Italiano (Italian)
267	Marketplace
13	Marketplace (Altcoins)
297	Meta
199	Mining
28	Mining (Altcoins)
3	Nederlands (Dutch)
16	Off-topic
5	Philippines
123	Politics & Society
30	Polski
6	Português (Portuguese)
49	Project Development
88	Serious discussion
20	Speculation (Altcoins)
168	Trading Discussion
67	Türkçe (Turkish)
330	Pyccкий (Russian)
11	العربية (Arabic)
6	中文 (Chinese)
7	日本語 (Japanese)

Merits sent from each rank last week

Code:

Copper Member	102
Donator	107
Full Member	346
Hero Member	299
Jr. Member	65
Legendary	1316
Member	210
Newbie	25
Sr. Member	457
Staff	549

Saint-loup

legendary

Activity: 2604

Merit: 2353

Quote from: Piggy on November 02, 2018, 06:17:18 AM

The data is now updated to Friday 2th of November

Here is some general numbers about the last week:

Top Sender per board last week
[...]

Hello
No scores for this week?
I tried to execute some sql queries in your tool to get them, but I got this error message instead Undecided

Code:

Uncaught Error: no such table: meritdata

Piggy

hero member

Activity: 784

Merit: 1416

Quote from: mainconcept on November 09, 2018, 09:45:52 AM

I get an error when I use this query:

Quote from: Piggy on June 27, 2018, 03:31:57 AM

Code:

SELECT MAX(result.total) as "Total Merit", result.toID as "Top merit receiver", result.SubBoard as "Board" FROM (
	SELECT toid, SubBoard, SUM(Merit) AS total
	FROM meritdata as m
	WHERE m.SubBoard in (SELECT SubBoard FROM meritdata GROUP BY SubBoard)
	GROUP BY toid, SubBoard
	ORDER BY SubBoard,total Desc) AS result
GROUP BY SubBoard
ORDER BY result.total Desc;

Error:

Code:

Uncaught abort("Cannot enlarge memory arrays. Either (1) compile with -s TOTAL_MEMORY=X with X higher than the current value 16777216, (2) compile with -s ALLOW_MEMORY_GROWTH=1 
which allows increasing the size at runtime but prevents some optimizations, (3) set Module.TOTAL_MEMORY to a higher value before the program runs, or (4) if you want malloc to return NULL (0) instead of this

The local section query works fine. Probably a too resource intensive task.

Try to run it this way and refresh the page first, as i see after that error not even a normal query seems to be working anymore (probably cannot recover from it):

Code:

SELECT MAX(result.total) as "Total Merit", result.SubBoard as "Non-Local board" FROM (
	SELECT toid, SubBoard, SUM(Merit) AS total
	FROM meritdata as m
	GROUP BY toid, Board
	ORDER BY Board,total Desc) AS result
GROUP BY SubBoard
ORDER BY result.total Desc

The data is updated to the 9th of November

mainconcept

sr. member

Activity: 588

Merit: 422

I get an error when I use this query:

Quote from: Piggy on June 27, 2018, 03:31:57 AM

Code:

SELECT MAX(result.total) as "Total Merit", result.toID as "Top merit receiver", result.SubBoard as "Board" FROM (
	SELECT toid, SubBoard, SUM(Merit) AS total
	FROM meritdata as m
	WHERE m.SubBoard in (SELECT SubBoard FROM meritdata GROUP BY SubBoard)
	GROUP BY toid, SubBoard
	ORDER BY SubBoard,total Desc) AS result
GROUP BY SubBoard
ORDER BY result.total Desc;

Error:

Code:

Uncaught abort("Cannot enlarge memory arrays. Either (1) compile with -s TOTAL_MEMORY=X with X higher than the current value 16777216, (2) compile with -s ALLOW_MEMORY_GROWTH=1 
which allows increasing the size at runtime but prevents some optimizations, (3) set Module.TOTAL_MEMORY to a higher value before the program runs, or (4) if you want malloc to return NULL (0) instead of this

The local section query works fine. Probably a too resource intensive task.

Piggy

hero member

Activity: 784

Merit: 1416

Quote from: r1s2g3 on November 08, 2018, 02:05:41 PM

If you are able to add "ToUsername" and "Fromusername" in the Meritdata table than it will be great because we rarely recognize anybody with their userids (ToID and FromID).

I'm trying to keep it the database as light as possible so that it doesn't take much space, so i need to avoid redundant informations

This other tool does that https://bitcointalksearch.org/topic/swiss-army-knife-tool-to-query-merit-data-online-full-history-4456438 is in general more user friendly, but has limited query capabilities compared to this one.

r1s2g3

sr. member

Activity: 742

Merit: 395

I am alive but in hibernation.

You have made a brilliant tool.

If you are able to add "ToUsername" and "Fromusername" in the Meritdata table than it will be great because we rarely recognize anybody with their userids (ToID and FromID).

I know, we can still get this data by joins but just a suggestion.

Piggy

hero member

Activity: 784

Merit: 1416

The data is now updated to Friday 2th of November

Here is some general numbers about the last week:

Top Sender per board last week

Code:

96	chimk	Full Member	Pyccкий (Russian)
89	Micio	Legendary	Italiano (Italian)
66	Greshamsches Geld	Legendary	Deutsch (German)
65	Flying Hellfish	Staff	Politics & Society
60	Anon11073	Staff	日本語 (Japanese)
50	jovan85	Hero Member	Hrvatski (Croatian)
49	JayJuanGee	Legendary	Economics
48	paxmao	Sr. Member	Español (Spanish)
40	frodocooper	Staff	Mining
37	Flying Hellfish	Staff	Marketplace
34	EFS	Staff	Türkçe (Turkish)
32	suchmoon	Legendary	Meta
31	Halab	Staff	Français
25	dbshck	Staff	Bahasa Indonesia (Indonesian)
25	Flying Hellfish	Staff	Off-topic
25	TMAN	Hero Member	Trading Discussion
22	jimmybob_007	Sr. Member	Announcements (Altcoins)
19	dbshck	Staff	Beginners & Help
15	dbshck	Staff	Bitcoin Technical Support
15	dbshck	Staff	Mining (Altcoins)
15	Vod	Legendary	Project Development
14	DarkStar_	Legendary	Development & Technical Discussion
13	dbshck	Staff	Bitcoin Discussion
10	flash101k	Jr. Member	Altcoin Discussion
10	bathrobehero	Legendary	Marketplace (Altcoins)
10	sabotag3x	Hero Member	Português (Portuguese)
10	paxmao	Sr. Member	Serious discussion
8	sockpuppet1911	Sr. Member	Speculation (Altcoins)
6	snakey	Legendary	Other languages/locations
5	AnnC+	Jr. Member	
5	hugeblack	Sr. Member	العربية (Arabic)
3	Swenna	Full Member	Philippines
2	pawel7777	Legendary	Polski
2	Barcode_	Staff	中文 (Chinese)
1	F2b	Full Member	Archival
1	ajochems	Hero Member	India
1	sbogovac	Legendary	Nederlands (Dutch)

Top Receivers per board last week

Code:

55	SaltySpitoon	Legendary	Off-topic
54	xhomerx10	Legendary	Economics
50	sunce33	Hero Member	Hrvatski (Croatian)
40	Moloch	Hero Member	Politics & Society
33	arulbero	Hero Member	Italiano (Italian)
32	mezzomix	Legendary	Deutsch (German)
23	GGurol	Member	Türkçe (Turkish)
22	themonkii	Full Member	Announcements (Altcoins)
21	hakka	Member	日本語 (Japanese)
19	suchmoon	Legendary	Meta
16	Cloudbet	Legendary	Marketplace
15	Flying Hellfish	Staff	Trading Discussion
13	bitmover	Sr. Member	Beginners & Help
12	abhiseshakana	Full Member	Bahasa Indonesia (Indonesian)
12	DdmrDdmr	Sr. Member	Español (Spanish)
11	bob123	Hero Member	Development & Technical Discussion
11	Initscri	Hero Member	Project Development
10	Elenaholt	Jr. Member	
10	alimarh	Member	Altcoin Discussion
10	Zeta0S	Legendary	Marketplace (Altcoins)
10	kerney666	Jr. Member	Mining (Altcoins)
10	Jamilowi	Member	Pyccкий (Russian)
9	asche	Full Member	Français
9	tim-bc	Member	Mining
8	ICO-Master	Member	Speculation (Altcoins)
7	theymos	Administrator	Bitcoin Discussion
7	achow101	Staff	Bitcoin Technical Support
6	mamad.sky	Jr. Member	Other languages/locations
5	Piggy	Hero Member	Serious discussion
5	mamad.sky	Jr. Member	العربية (Arabic)
3	Maggiordomo	Jr. Member	Archival
3	euphemia	Jr. Member	Philippines
3	#BitcoinCore	Sr. Member	Português (Portuguese)
3	Summation	Jr. Member	中文 (Chinese)
2	arispen	Newbie	Polski
1	Allaboutcryptos12	Jr. Member	India
1	CubitDev	Newbie	Nederlands (Dutch)

Sub boards merit circulation last week

Code:

11	Other languages/locations
5	Archival
81	
109	Altcoin Discussion
158	Announcements (Altcoins)
76	Bahasa Indonesia (Indonesian)
66	Beginners & Help
75	Bitcoin Discussion
57	Bitcoin Technical Support
133	Deutsch (German)
83	Development & Technical Discussion
410	Economics
55	Español (Spanish)
64	Français
97	Hrvatski (Croatian)
2	India
118	Italiano (Italian)
305	Marketplace
24	Marketplace (Altcoins)
329	Meta
61	Mining
66	Mining (Altcoins)
1	Nederlands (Dutch)
62	Off-topic
4	Philippines
138	Politics & Society
3	Polski
19	Português (Portuguese)
29	Project Development
32	Serious discussion
22	Speculation (Altcoins)
154	Trading Discussion
107	Türkçe (Turkish)
351	Pyccкий (Russian)
8	العربية (Arabic)
5	中文 (Chinese)
68	日本語 (Japanese)

Merits sent from each rank last week

Code:

Administrator	18
Copper Member	108
Donator	58
Full Member	300
Global Moderator	2
Hero Member	440
Jr. Member	129
Legendary	1119
Member	260
Newbie	60
Sr. Member	415
Staff	479

Piggy

hero member

Activity: 784

Merit: 1416

The data is now updated to Friday 26th of October

Here is some general numbers about the last week:

Top Sender per board last week

Code:

276	qwk	Donator	Deutsch (German)
136	chimk	Full Member	Pyccкий (Russian)
124	suchmoon	Legendary	Meta
100	lyka	Legendary	Announcements (Altcoins)
82	dbshck	Staff	Bahasa Indonesia (Indonesian)
56	Micio	Legendary	Italiano (Italian)
51	dbshck	Staff	Marketplace
50	xhomerx10	Legendary	Economics
45	teramit	Legendary	Türkçe (Turkish)
44	Halab	Staff	Français
42	frodocooper	Staff	Mining
38	Foxpup	Legendary	Development & Technical Discussion
35	s1lverbox	Legendary	Trading Discussion
32	suchmoon	Legendary	Politics & Society
31	gold969	Sr. Member	Bitcoin Discussion
30	hajimasan	Hero Member	Altcoin Discussion
30	paxmao	Sr. Member	Español (Spanish)
18	dbshck	Staff	Beginners & Help
18	dbshck	Staff	Serious discussion
12	Jet Cash	Legendary	Bitcoin Technical Support
12	krisgt30	Sr. Member	Mining (Altcoins)
11	flash101k	Jr. Member	
11	btcdiggingmaster	Hero Member	India
11	Barcode_	Staff	中文 (Chinese)
10	Herbet Fry	Sr. Member	Marketplace (Altcoins)
10	snakey	Legendary	Other languages/locations
8	sabotag3x	Hero Member	Português (Portuguese)
7	Hueristic	Legendary	Speculation (Altcoins)
6	Daniel91	Legendary	Hrvatski (Croatian)
5	TMAN	Hero Member	Archival
4	jackflag	Sr. Member	Off-topic
4	Sheme	Full Member	Polski
4	suchmoon	Legendary	Project Development
3	SyGambler	Legendary	العربية (Arabic)
3	Anon11073	Staff	日本語 (Japanese)
2	Daboy_Lyle	Member	Philippines
2	RikyRO	Jr. Member	Română (Romanian)

Top Receivers per board last week

Code:

65	xhomerx10	Legendary	Economics
63	mole0815	Sr. Member	Deutsch (German)
62	sidehack	Legendary	Mining
56	suchmoon	Legendary	Meta
50	Fallout4	Sr. Member	Announcements (Altcoins)
44	minerjones	Copper Member	Marketplace
38	gmaxwell	Staff	Development & Technical Discussion
32	satoshi	Founder	Bitcoin Discussion
31	ni23457	Copper Member	Trading Discussion
29	abhiseshakana	Full Member	Bahasa Indonesia (Indonesian)
23	Paolo.Demidov	Member	Italiano (Italian)
21	Flying Hellfish	Staff	Politics & Society
19	Saint-loup	Sr. Member	Français
16	bob123	Hero Member	Bitcoin Technical Support
12	Laviathon	Sr. Member	Mining (Altcoins)
11	losiva	Member	
11	cryptocurrencyguru	Member	India
11	phoenixdowndee	Full Member	Marketplace (Altcoins)
11	lordquas	Newbie	Português (Portuguese)
10	Daliloz	Member	Altcoin Discussion
10	ebi1790	Member	Other languages/locations
10	Blonelly	Member	Pyccкий (Russian)
9	SaltySpitoon	Legendary	Serious discussion
9	coin8coin8	Member	中文 (Chinese)
8	cryptobaro	Member	Türkçe (Turkish)
6	Hhampuz	Hero Member	Archival
6	OmegaStarScream	Staff	Beginners & Help
6	xtraelv	Sr. Member	Off-topic
5	Zarg0n	Member	Español (Spanish)
5	RegulusHr	Full Member	Hrvatski (Croatian)
5	cryptovigi	Member	Polski
5	Bolivar_Tony	Member	Speculation (Altcoins)
5	hakka	Member	日本語 (Japanese)
4	Slow death	Hero Member	Project Development
2	queennathalia	Member	Philippines
2	7ossam7afez	Member	العربية (Arabic)
1	HBKMusiK	Member	Română (Romanian)

Sub boards merit circulation last week

Code:

5	Polski
13	India
49	
161	Altcoin Discussion
377	Announcements (Altcoins)
7	Archival
153	Bahasa Indonesia (Indonesian)
101	Beginners & Help
144	Bitcoin Discussion
35	Bitcoin Technical Support
434	Deutsch (German)
194	Development & Technical Discussion
464	Economics
40	Español (Spanish)
97	Français
22	Hrvatski (Croatian)
117	Italiano (Italian)
468	Marketplace
32	Marketplace (Altcoins)
662	Meta
166	Mining
74	Mining (Altcoins)
17	Off-topic
15	Other languages/locations
4	Philippines
132	Politics & Society
28	Português (Portuguese)
16	Project Development
2	Română (Romanian)
39	Serious discussion
37	Speculation (Altcoins)
193	Trading Discussion
110	Türkçe (Turkish)
499	Pyccкий (Russian)
10	العربية (Arabic)
14	中文 (Chinese)
10	日本語 (Japanese)

Merits sent from each rank last week

Code:

Administrator	16
Copper Member	81
Donator	320
Full Member	382
Hero Member	667
Jr. Member	186
Legendary	1916
Member	294
Newbie	41
Sr. Member	536
Staff	502

Piggy

hero member

Activity: 784

Merit: 1416

The data is now updated to Friday 19th of October

Here is some general numbers about the last week:

Top Sender per board last week

Code:

112	chimk	Full Member	Pyccкий (Russian)
110	Vlad2Vlad	Legendary	Announcements (Altcoins)
92	suchmoon	Legendary	Meta
78	qwk	Donator	Deutsch (German)
73	MoreFun	Legendary	Altcoin Discussion
61	dbshck	Staff	Bahasa Indonesia (Indonesian)
55	Halab	Staff	Français
50	snakey	Legendary	
46	JayJuanGee	Legendary	Economics
42	TMAN	Hero Member	Marketplace
40	suchmoon	Legendary	Development & Technical Discussion
37	dbshck	Staff	Mining
37	Cyper_BLC	Sr. Member	Türkçe (Turkish)
32	Flying Hellfish	Staff	Politics & Society
28	paxmao	Sr. Member	Español (Spanish)
24	suchmoon	Legendary	Trading Discussion
20	jovan85	Hero Member	Hrvatski (Croatian)
16	dbshck	Staff	Beginners & Help
12	paxmao	Sr. Member	Serious discussion
11	dbshck	Staff	Bitcoin Discussion
10	Micio	Legendary	Italiano (Italian)
10	HagssFIN	Legendary	Mining (Altcoins)
10	Patatas	Legendary	Project Development
10	hugeblack	Sr. Member	العربية (Arabic)
9	Jet Cash	Legendary	Bitcoin Technical Support
6	Vod	Legendary	Off-topic
6	carlisle1	Hero Member	Speculation (Altcoins)
4	FIEX	Sr. Member	Nederlands (Dutch)
4	Paredao	Legendary	Português (Portuguese)
3	Hueristic	Legendary	Marketplace (Altcoins)
3	GDragon	Member	Philippines
3	Barcode_	Staff	中文 (Chinese)
2	Jrashid	Member	India
1	Salauddin1994	Jr. Member	Other languages/locations
1	becometa.pl	Copper Member	Polski

Top Receivers per board last week

Code:

85	xhomerx10	Legendary	Economics
50	Capt.Morris	Newbie	
50	deadsea33	Jr. Member	Announcements (Altcoins)
48	DdmrDdmr	Sr. Member	Meta
44	anonymousminer	Member	Marketplace
42	ekiller	Hero Member	Türkçe (Turkish)
36	maja39	Newbie	Hrvatski (Croatian)
29	Coding Enthusiast	Sr. Member	Development & Technical Discussion
27	HagssFIN	Legendary	Mining
25	MinoRaiola	Member	Deutsch (German)
24	KonstantinosM	Hero Member	Politics & Society
20	abhiseshakana	Full Member	Bahasa Indonesia (Indonesian)
20	Makkara	Member	Trading Discussion
13	Coding Enthusiast	Sr. Member	Project Development
11	VoskCoin	Sr. Member	Mining (Altcoins)
11	Decker	Member	Pyccкий (Russian)
9	MartaKlin	Jr. Member	Altcoin Discussion
8	Coolcryptovator	Copper Member	Beginners & Help
8	paxmao	Sr. Member	Español (Spanish)
8	Plutosky	Member	Italiano (Italian)
8	Oldi-mii	Jr. Member	Speculation (Altcoins)
7	Rocou	Legendary	Français
5	franky1	Legendary	Bitcoin Discussion
5	gmaxwell	Staff	Bitcoin Technical Support
5	Carlton Banks	Legendary	Serious discussion
4	[Maarten]	Jr. Member	Nederlands (Dutch)
3	bitcoinmee	Jr. Member	Philippines
3	7ossam7afez	Member	العربية (Arabic)
2	Little Mouse	Newbie	India
2	cheus	Full Member	Marketplace (Altcoins)
2	BobLawblaw	Legendary	Off-topic
2	alegotardo	Full Member	Português (Portuguese)
2	Zsywt1024	Jr. Member	中文 (Chinese)
1	cryptofarid10	Jr. Member	Other languages/locations
1	cryptovigi	Member	Polski

Sub boards merit circulation last week

Code:

2	India
85	
253	Altcoin Discussion
395	Announcements (Altcoins)
144	Bahasa Indonesia (Indonesian)
95	Beginners & Help
65	Bitcoin Discussion
17	Bitcoin Technical Support
152	Deutsch (German)
161	Development & Technical Discussion
460	Economics
52	Español (Spanish)
74	Français
65	Hrvatski (Croatian)
45	Italiano (Italian)
299	Marketplace
23	Marketplace (Altcoins)
474	Meta
80	Mining
37	Mining (Altcoins)
6	Nederlands (Dutch)
22	Off-topic
1	Other languages/locations
15	Philippines
90	Politics & Society
3	Polski
11	Português (Portuguese)
79	Project Development
28	Serious discussion
29	Speculation (Altcoins)
127	Trading Discussion
153	Türkçe (Turkish)
378	Pyccкий (Russian)
16	العربية (Arabic)
3	中文 (Chinese)

Merits sent from each rank last week

Code:

Administrator	38
Copper Member	96
Donator	98
Full Member	305
Global Moderator	9
Hero Member	431
Jr. Member	146
Legendary	1753
Member	187
Newbie	28
Sr. Member	457
Staff	390
VIP	1

Piggy

hero member

Activity: 784

Merit: 1416

The tool is now updated with the latest data from today Friday 12th of October

Here is some usual general recap of what has happened:

Top Sender per board last week

Code:

180	QuestionAuthority	Legendary	Economics
142	bryant.coleman	Legendary	Politics & Society
121	chimk	Full Member	Pyccкий (Russian)
100	QuestionAuthority	Legendary	Off-topic
82	suchmoon	Legendary	Meta
66	EFS	Staff	Türkçe (Turkish)
51	dbshck	Staff	Bahasa Indonesia (Indonesian)
50	citronick	Legendary	Mining (Altcoins)
37	generous	Hero Member	Altcoin Discussion
36	Flying Hellfish	Staff	Marketplace
30	Foxpup	Legendary	Development & Technical Discussion
30	Micio	Legendary	Italiano (Italian)
26	paxmao	Sr. Member	Español (Spanish)
26	TMAN	Hero Member	Trading Discussion
24	Halab	Staff	Français
24	suchmoon	Legendary	Mining
24	paxmao	Sr. Member	Serious discussion
20	generous	Hero Member	Announcements (Altcoins)
20	TMAN	Hero Member	Beginners & Help
15	deadsilent	Hero Member	Bitcoin Discussion
15	RegulusHr	Full Member	Hrvatski (Croatian)
12	Welsh	Staff	Bitcoin Technical Support
12	fronti	Legendary	Deutsch (German)
8	hugeblack	Sr. Member	العربية (Arabic)
7	Zapo	Copper Member	
6	Ukraine2020	Sr. Member	Other languages/locations
5	yo-blin	Legendary	Marketplace (Altcoins)
5	becometa.pl	Copper Member	Polski
5	Vod	Legendary	Project Development
4	Barcode_	Staff	中文 (Chinese)
3	sabotag3x	Hero Member	Português (Portuguese)
3	justspare	Hero Member	Speculation (Altcoins)
3	sncc	Sr. Member	日本語 (Japanese)
2	electronicash	Legendary	Philippines
1	DdmrDdmr	Sr. Member	India
1	veccar9008	Member	Română (Romanian)

Top Receivers per board last week

Code:

52	Claymore	Donator	Mining (Altcoins)
49	d_eddie	Sr. Member	Economics
46	Piggy	Hero Member	Meta
44	AztecGoldHero	Hero Member	Türkçe (Turkish)
28	Alizaind	Newbie	Bahasa Indonesia (Indonesian)
26	aliashraf	Sr. Member	Development & Technical Discussion
25	Mometaskers	Hero Member	Politics & Society
23	TheFuzzStone	Hero Member	Pyccкий (Russian)
22	jokowi	Hero Member	Altcoin Discussion
21	LoyceV	Legendary	Trading Discussion
20	BitcoinTurk	Sr. Member	Off-topic
15	iasenko	Sr. Member	Beginners & Help
15	Immakillya	Sr. Member	Bitcoin Discussion
15	HagssFIN	Legendary	Mining
13	qwk	Donator	Deutsch (German)
12	Lesbian Cow	Legendary	Marketplace
10	Andrey123	Sr. Member	Announcements (Altcoins)
9	AdolfinWolf	Hero Member	Bitcoin Technical Support
9	DdmrDdmr	Sr. Member	Español (Spanish)
9	Speculatoross	Full Member	Italiano (Italian)
7	mdayonliner	Sr. Member	
7	cryptovigi	Member	Polski
7	Vod	Legendary	Project Development
7	paxmao	Sr. Member	Serious discussion
5	yogg	Legendary	Français
5	Smart man	Sr. Member	Marketplace (Altcoins)
4	ZeljkoNemet	Newbie	Hrvatski (Croatian)
4	clear cookies	Jr. Member	Philippines
4	omer-jamal	Member	العربية (Arabic)
3	Direwolve735	Full Member	Other languages/locations
2	alegotardo	Full Member	Português (Portuguese)
2	Hueristic	Legendary	Speculation (Altcoins)
2	Zsywt1024	Jr. Member	中文 (Chinese)
2	tactac	Member	日本語 (Japanese)
1	deadley	Legendary	India

Sub boards merit circulation last week

Code:

45	
288	Altcoin Discussion
237	Announcements (Altcoins)
163	Bahasa Indonesia (Indonesian)
108	Beginners & Help
103	Bitcoin Discussion
40	Bitcoin Technical Support
101	Deutsch (German)
187	Development & Technical Discussion
520	Economics
48	Español (Spanish)
40	Français
21	Hrvatski (Croatian)
1	India
66	Italiano (Italian)
197	Marketplace
27	Marketplace (Altcoins)
475	Meta
73	Mining
108	Mining (Altcoins)
114	Off-topic
16	Other languages/locations
16	Philippines
259	Politics & Society
14	Polski
11	Português (Portuguese)
20	Project Development
1	Română (Romanian)
89	Serious discussion
12	Speculation (Altcoins)
180	Trading Discussion
186	Türkçe (Turkish)
441	Pyccкий (Russian)
18	العربية (Arabic)
5	中文 (Chinese)
4	日本語 (Japanese)

Merits sent from each rank last week

Code:

Administrator	6
Copper Member	105
Donator	54
Full Member	341
Hero Member	546
Jr. Member	137
Legendary	1705
Member	231
Newbie	26
Sr. Member	498
Staff	414

Piggy

hero member

Activity: 784

Merit: 1416

Updated with the data provided today (Friday 5th of October)

I'm working on a way to include full information about the users related with merit, but is going to be most likely an ad hoc solution rather than integrate all the data in this tool as the size of the database could start to grow too much.

Top Sender per board last week

Code:

total	username	rank	subboard
130	QuestionAuthority	Legendary	Off-topic
124	dbshck	Staff	Bahasa Indonesia (Indonesian)
94	frodocooper	Staff	Mining
85	MalReynolds	Legendary	Pyccкий (Russian)
75	paxmao	Sr. Member	Español (Spanish)
69	Foxpup	Legendary	Meta
50	EddyGameta	Hero Member	Bitcoin Discussion
50	casinobitco	Legendary	Marketplace
47	qwk	Donator	Deutsch (German)
38	EFS	Staff	Türkçe (Turkish)
37	JayJuanGee	Legendary	Economics
37	Halab	Staff	Français
32	Flying Hellfish	Staff	Politics & Society
30	rgornik	Sr. Member	Announcements (Altcoins)
28	suchmoon	Legendary	Serious discussion
25	oneforall	Full Member	Archival
24	suchmoon	Legendary	Development & Technical Discussion
24	suchmoon	Legendary	Trading Discussion
20	Q_R_V	Sr. Member	Mining (Altcoins)
18	MalReynolds	Legendary	Altcoin Discussion
17	vit05	Sr. Member	Português (Portuguese)
16	suchmoon	Legendary	Beginners & Help
16	suchmoon	Legendary	Bitcoin Technical Support
13	RegulusHr	Full Member	Hrvatski (Croatian)
12	AztecGoldHero	Hero Member	Marketplace (Altcoins)
12	MalReynolds	Legendary	Speculation (Altcoins)
10	Lantind	Sr. Member	
10	Piggy	Hero Member	Italiano (Italian)
10	oneforall	Full Member	中文 (Chinese)
5	hugeblack	Sr. Member	العربية (Arabic)
4	SabrinaBianka	Jr. Member	Philippines
4	Vod	Legendary	Project Development
3	Cyrus	Administrator	Română (Romanian)
2	chek2fire	Legendary	Eλληνικά (Greek)
1	Cryptosandy1987	Jr. Member	India
1	friends1980	Full Member	Nederlands (Dutch)
1	bitart	Hero Member	Other languages/locations
1	pawel7777	Legendary	Polski

Top Receivers per board last week

Code:

total	username	rank	subboard
90	oneforall	Full Member	Bitcoin Discussion
64	DarkStar_	Legendary	Marketplace
50	AztecGoldHero	Hero Member	Türkçe (Turkish)
44	mu_enrico	Copper Member	Bahasa Indonesia (Indonesian)
44	vlad230	Sr. Member	Meta
38	an@sha	Jr. Member	Pyccкий (Russian)
31	Alex_Sr	Full Member	Off-topic
26	WorldCoiner	Hero Member	Deutsch (German)
23	BossBee	Hero Member	Announcements (Altcoins)
20	Juggernaut118	Jr. Member	Archival
20	micgoossens	Sr. Member	Economics
20	minerja	Sr. Member	Mining (Altcoins)
18	automaticmoney	Member	Altcoin Discussion
18	Wananavu99	Full Member	Politics & Society
14	tim-bc	Member	Mining
14	Coolcryptovator	Copper Member	Trading Discussion
12	PHI1618	Sr. Member	Marketplace (Altcoins)
11	HeRetiK	Hero Member	Development & Technical Discussion
11	Shawshank	Legendary	Español (Spanish)
10	zulfan786	Member	
10	hdfxst	Jr. Member	Beginners & Help
10	LoyceV	Legendary	Bitcoin Technical Support
10	blink	Jr. Member	中文 (Chinese)
9	Initscri	Hero Member	Project Development
8	Helana	Jr. Member	Serious discussion
7	yangS	Hero Member	Français
7	Daboy_Lyle	Member	Philippines
6	Trofo	Sr. Member	Hrvatski (Croatian)
5	Makkara	Member	Italiano (Italian)
4	tg88	Full Member	Português (Portuguese)
3	jojohamasa	Jr. Member	العربية (Arabic)
2	RikyRO	Jr. Member	Română (Romanian)
2	Cosbycoin	Hero Member	Speculation (Altcoins)
2	theoulis	Legendary	Eλληνικά (Greek)
1	coinfunda	Jr. Member	India
1	CurrentCrypto	Jr. Member	Nederlands (Dutch)
1	Uhu77miner	Newbie	Other languages/locations
1	Mycrypto1222	Jr. Member	Polski

Sub boards merit circulation last week

Code:

Total Merit	SubBoard
29	Archival
2	Eλληνικά (Greek)
46	
250	Altcoin Discussion
309	Announcements (Altcoins)
242	Bahasa Indonesia (Indonesian)
82	Beginners & Help
194	Bitcoin Discussion
56	Bitcoin Technical Support
152	Deutsch (German)
137	Development & Technical Discussion
260	Economics
97	Español (Spanish)
46	Français
33	Hrvatski (Croatian)
1	India
36	Italiano (Italian)
294	Marketplace
57	Marketplace (Altcoins)
572	Meta
144	Mining
65	Mining (Altcoins)
1	Nederlands (Dutch)
114	Off-topic
1	Other languages/locations
15	Philippines
168	Politics & Society
1	Polski
30	Português (Portuguese)
25	Project Development
3	Română (Romanian)
44	Serious discussion
43	Speculation (Altcoins)
132	Trading Discussion
192	Türkçe (Turkish)
558	Pyccкий (Russian)
12	العربية (Arabic)
15	中文 (Chinese)

Merits sent from each rank last week

Code:

Rank	Total
Administrator	27
Copper Member	157
Donator	68
Full Member	454
Global Moderator	13
Hero Member	498
Jr. Member	174
Legendary	1530
Member	286
Newbie	56
Sr. Member	678
Staff	517

Piggy

hero member

Activity: 784

Merit: 1416

Quote from: vlad230 on September 28, 2018, 06:55:31 AM

Quote from: Piggy on September 28, 2018, 05:12:10 AM

as soon as i have time to re-run the all thing i'll be correcting that as well indeed, is something i saw as well and actually forgot to fix.

Thanks a lot for the prompt responses!

Looking forward for the fix and by all means, if you need any help, let me know. I have some years of Java programming experience behind me.

Any chance you could add a new column to the UserData table to also add the activity of the user? Not to mention other metrics like post count, registered date or last active.
This would be extremely helpful to collect and compound loads of interesting metrics.

i have all the data already but i decided to put just userid name and rank mainly to keep the the database small and not having problem space wise uploading it in github.
https://help.github.com/articles/working-with-large-files/

I'll try to see how much would increase by adding all the other information and if it's too much i can give out the information in some other way

vlad230

sr. member

Activity: 616

Merit: 279

Quote from: Piggy on September 28, 2018, 05:12:10 AM

as soon as i have time to re-run the all thing i'll be correcting that as well indeed, is something i saw as well and actually forgot to fix.

Thanks a lot for the prompt responses!

Looking forward for the fix and by all means, if you need any help, let me know. I have some years of Java programming experience behind me.

Any chance you could add a new column to the UserData table to also add the activity of the user? Not to mention other metrics like post count, registered date or last active.
This would be extremely helpful to collect and compound loads of interesting metrics.

Topic: Tool to run online SQL queries over Full Merit Data - page 4. (Read 23373 times)