Tool to run online SQL queries over Full Merit Data

[Piggy]

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://bitcointalk.org/index.php?topic=4456438.0 is in general more user friendly, but has limited query capabilities compared to this one.

[1715281061]

1715281061

[1715281061]

1715281061

[1715281061]

1715281061

[1715281061]

1715281061

[1715281061]

1715281061

[mainconcept]

I get an error when I use this query:

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]

I get an error when I use this query:

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

[Saint-loup]

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  

Code:

Uncaught Error: no such table: meritdata

[Piggy]

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  

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

[Piggy]

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]

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

[tranthidung]

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)

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]

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)

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

[Piggy]

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]

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]

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]

The tool is now updated with the latest data from today Friday 21st of December

Here is the usual snapshot about the last week:

Top Sender per board last week

Code:

237	dbshck	Staff	Bahasa Indonesia (Indonesian)
115	Flying Hellfish	Staff	Marketplace
79	chimk	Full Member	Pyccкий (Russian)
60	dragonmike	Hero Member	
54	JayJuanGee	Legendary	Economics
52	suchmoon	Legendary	Meta
52	suchmoon	Legendary	Trading Discussion
50	hv_	Hero Member	Bitcoin Discussion
47	Halab	Staff	Français
46	paxmao	Sr. Member	Español (Spanish)
44	frodocooper	Staff	Mining
40	Foxpup	Legendary	Off-topic
32	suchmoon	Legendary	Development & Technical Discussion
20	MarketMagic	Hero Member	Announcements (Altcoins)
20	Flying Hellfish	Staff	Politics & Society
20	teramit	Legendary	Türkçe (Turkish)
18	paxmao	Sr. Member	Serious discussion
15	dbshck	Staff	Bitcoin Technical Support
13	paxmao	Sr. Member	Beginners & Help
12	n00b3rt	Sr. Member	Altcoin Discussion
10	n00b3rt	Sr. Member	Speculation (Altcoins)
8	o_solo_miner	Legendary	Deutsch (German)
8	sabotag3x	Hero Member	Português (Portuguese)
7	RegulusHr	Full Member	Hrvatski (Croatian)
6	Vod	Legendary	Project Development
5	oscar2000	Legendary	עברית (Hebrew)
4	suchmoon	Legendary	Mining (Altcoins)
4	hugeblack	Sr. Member	العربية (Arabic)
3	Piggy	Hero Member	Italiano (Italian)
2	friends1980	Full Member	Nederlands (Dutch)
2	aleksej996	Sr. Member	Other languages/locations
1	Dobrii	Sr. Member	Marketplace (Altcoins)

Top Receivers per board last week

Code:

66	GameKyuubi	Sr. Member	Economics
61	satoshi	Founder	Bitcoin Discussion
57	joniboini	Sr. Member	Bahasa Indonesia (Indonesian)
50	victorhing	Legendary	Marketplace
47	achow101	Staff	Development & Technical Discussion
42	theymos	Administrator	Meta
40	saginaw32	Newbie	
24	achow101	Staff	Bitcoin Technical Support
24	Nikisa	Member	Pyccкий (Russian)
20	ICOEthics	Full Member	Trading Discussion
17	logfiles	Copper Member	Beginners & Help
15	thierry4wd	Newbie	Mining
14	kenzawak	Full Member	Français
12	DdmrDdmr	Sr. Member	Español (Spanish)
12	cestmoi	Newbie	Politics & Society
12	eddie13	Hero Member	Serious discussion
11	SynchrotronCoinDev	Jr. Member	Announcements (Altcoins)
11	nullCoiner	Sr. Member	Deutsch (German)
10	cryptomaster420	Member	Altcoin Discussion
10	NoMoreForksPls	Member	Speculation (Altcoins)
9	RodeoX	Legendary	Off-topic
6	omer-jamal	Member	العربية (Arabic)
5	Dammitt	Hero Member	Türkçe (Turkish)
4	Plutosky	Member	Italiano (Italian)
4	vapourminer	Legendary	Mining (Altcoins)
4	Adeilton	Newbie	Português (Portuguese)
3	Dzeronimo	Member	Hrvatski (Croatian)
3	Vod	Legendary	Project Development
2	temple93	Newbie	Other languages/locations
1	Leva	Jr. Member	Marketplace (Altcoins)
1	Janportfolio	Newbie	Nederlands (Dutch)
1	EndryoBit	Newbie	עברית (Hebrew)

Sub boards merit circulation last week

Code:

91	
67	Altcoin Discussion
139	Announcements (Altcoins)
314	Bahasa Indonesia (Indonesian)
98	Beginners & Help
175	Bitcoin Discussion
40	Bitcoin Technical Support
79	Deutsch (German)
203	Development & Technical Discussion
454	Economics
57	Español (Spanish)
106	Français
12	Hrvatski (Croatian)
14	Italiano (Italian)
489	Marketplace
2	Marketplace (Altcoins)
360	Meta
98	Mining
13	Mining (Altcoins)
2	Nederlands (Dutch)
72	Off-topic
3	Other languages/locations
55	Politics & Society
18	Português (Portuguese)
14	Project Development
75	Serious discussion
19	Speculation (Altcoins)
142	Trading Discussion
37	Türkçe (Turkish)
352	Pyccкий (Russian)
5	עברית (Hebrew)
12	العربية (Arabic)

Merits sent from each rank last week

Code:

Administrator	2
Brand new	5
Copper Member	89
Donator	73
Full Member	250
Global Moderator	10
Hero Member	389
Jr. Member	97
Legendary	1355
Member	198
Newbie	60
Sr. Member	373
Staff	715
VIP	1

Merits received from each rank last week

Code:

Administrator	44
Brand new	8
Copper Member	166
Donator	5
Founder	61
Full Member	392
Global Moderator	41
Hero Member	262
Jr. Member	336
Legendary	868
Member	458
Newbie	314
Sr. Member	544
Staff	113
VIP	5

[mikeywith]

just for fun ,generous members who gave newbies more than 10 merits.

Code:

select username ,1.0* date as dt ,rank,toid,fromid ,Merit  from MeritData  inner join UserData on UserData.userid = meritdata.fromid
where toid in (select userid from userdata where rank = 'Newbie')
and merit >10 and dt = 2018 
order by username ,merit desc limit  1000

@piggy , can you add post count to user table? thanks

[Piggy]

Hi

I prefer to keep the size of this database as small as possible. Otherwise would be nice to have all the possible data coming along with each user.

However In here you can find a recent snapshot taken for all the users in the forum with all the infos publicly available https://bitcointalk.org/index.php?topic=5066192.0

[mikeywith]

Hi

I prefer to keep the size of this database as small as possible. Otherwise would be nice to have all the possible data coming along with each user.

However In here you can find a recent snapshot taken for all the users in the forum with all the infos publicly available https://bitcointalk.org/index.php?topic=5066192.0

 I have that db as well, i want to make a report of ( received merit to post ration) which in the link you provided is not possible, since there is no way to know whether the merit was airdropped or received. and on this database the post count is not there. do you have any other db that contains both post count and received merit ? thanks

[Piggy]

Hi

I prefer to keep the size of this database as small as possible. Otherwise would be nice to have all the possible data coming along with each user.

However In here you can find a recent snapshot taken for all the users in the forum with all the infos publicly available https://bitcointalk.org/index.php?topic=5066192.0

 I have that db as well, i want to make a report of ( received merit to post ration) which in the link you provided is not possible, since there is no way to know whether the merit was airdropped or received. and on this database the post count is not there. do you have any other db that contains both post count and received merit ? thanks

I think there may be some way to export a table from a db file to another using SQL lite, ill have a look later and see if i find some guide or resources.

Edit: perhaps this can help ( i have not tried this myself) https://tableplus.io/blog/2018/07/sqlite-how-to-copy-table-to-another-database.html

Using SQLite command-line tool
Open the old database then dump the table

Code:

sqlite> .output table_dump.sql
sqlite> .dump table_name
sqlite> .quit

Then open the new database and read the dump:

Code:

sqlite> .read table_dump.sql

[mikeywith]

will try that later on , thanks piggy

[Piggy]

will try that later on , thanks piggy

The database with the latest merit data can be downloaded in here on the github project https://github.com/AlbertoIT/Merit-Explorer-SQL/tree/master/Data

So you can add directly in this one the scraped user table.

[Piggy]

Sorry, I couldn't update the merit data this week due to holidays and no access to my pc, it will be updated alltogheter the next Friday