Title: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on June 27, 2018, 07:31:57 AM
UPDATES: - Script system added (https://bitcointalk.org/index.php?topic=4551881.msg41943987#msg41943987)
- Added Users(name and rank), readable date for the merit data, new SQL examples (https://bitcointalk.org/index.php?topic=4551881.msg41142643#msg41142643)
This is a tool that allow you to run full SQL queries over the merit data and is based on SQLite (https://www.sqlite.org/index.html). If you are familiar with SQL you know the possibilities are basically endless or limited to your SQL knowledge. My previous similar tool (here (http://"https://bitcointalk.org/index.php?topic=4456438.0")) is perhaps more user friendly, but has some limitation: speed and research flexibility. So this is why i made this. You can find more information about SQL syntax in here (https://www.w3schools.com/sql/)if you are interested to learn, i may also give a hand if somebody want to get out some particular information out, even though my SQL skills are a bit rusty. Table structure:MeritData(
"Date" TEXT,
"Merit" Integer,
"Msg" TEXT,
"FromID" Integer,
"ToID" Integer,
"Board" TEXT,
"SubBoard" TEXT,
"TitleThread" TEXT
)
UserData(
UserId Integer PRIMARY KEY,
UserName TEXT,
Rank TEXT,
Trust TEXT,
Location TEXT
) Just type the query in the box and press Exceute, F5 or Ctrl-Enter to execute it. Link:https://albertoit.github.io/Merit-Explorer-SQL/ https://i.imgur.com/z3NmTvL.pngFor those of you who are not familiar with SQL, beside the fact that you will get any result extremely fast, this is what it means:[/b] We can easily get the Top Receiver for any local section simply using this: SELECT MAX(result.total) as "Total Merit", result.toid as "Top merit receiver", result.SubBoard as "Local board" FROM (
SELECT toid, SubBoard, SUM(Merit) AS total
FROM meritdata as m
WHERE m.Board in (SELECT Board FROM meritdata Where Board like "Local%" GROUP BY Board)
GROUP BY toid, Board
ORDER BY Board,total Desc) AS result
GROUP BY SubBoard
ORDER BY result.total Desc or for any board: 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; Similarly we can find out the Top Giver: SELECT MAX(result.total) as "Total Merit", result.fromid as "Top merit giver", result.SubBoard as "Local board" FROM (
SELECT fromid, SubBoard, SUM(Merit) AS total
FROM meritdata as m
WHERE m.Board in (SELECT Board FROM meritdata Where Board like "Local%" GROUP BY Board)
GROUP BY fromid, Board
ORDER BY Board,total Desc) AS result
GROUP BY SubBoard
ORDER BY result.total Desc; or for any any board: SELECT MAX(result.total) as "Total Merit", result.fromID as "Top merit giver", result.SubBoard as "Board" FROM (
SELECT fromid, SubBoard, SUM(Merit) AS total
FROM meritdata as m
WHERE m.SubBoard in (SELECT SubBoard FROM meritdata GROUP BY SubBoard)
GROUP BY fromID, SubBoard
ORDER BY SubBoard,total Desc) AS result
GROUP BY SubBoard
ORDER BY result.total Desc; Find out the total merit awarded so far: SELECT Sum(Merit) FROM MeritData; Want the full history for a particular user? SELECT * FROM MeritData WHERE toID=35 OR fromID=35 ORDER BY fromid,toid;
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: mdayonliner on June 27, 2018, 07:52:06 AM
I was interested in SELECT all query. And... This things are getting really interesting for me. May be I want to start learning how to scrape data :) Good job mate. PS: It took long time to pull-up the entire table (Letting you know only - hoping you can do something)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: DdmrDdmr on June 27, 2018, 08:03:13 AM
Nicely done there Piggy, i'm sure you'll build on it furthermore. Perhaps you could transform de unix date field into common date field for viewers who cannot do it themselves.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: lukeburchill on June 27, 2018, 08:12:57 AM
Table structure:MeritData(
"Date" Float,
"Merit" Integer,
"Msg" TEXT,
"FromID" Float,
"ToID" Float,
"Board" TEXT,
"SubBoard" TEXT
) I have been creating your script in XAMPP, but have errors then I add a bit script "create table" and removes the symbol (""). and done created a table in DB create table MeritData(
Date Float,
Merit Integer,
Msg TEXT,
FromID Float,
ToID Float,
Board TEXT,
SubBoard TEXT
)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: babo on June 27, 2018, 08:21:33 AM
if you didnt block some operations, do it fast
block
- INSERT
- UPDATE
- DELETE
for avoid trolls and vandals
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on June 27, 2018, 08:34:31 AM
All the changes are "local", the database cannot be modified really as is hosted in Github and there are no write permissions in there. If you make changes and then refresh the page the original data will be back. Nicely done there Piggy, i'm sure you'll build on it furthermore. Perhaps you could transform de unix date field into common date field for viewers who cannot do it themselves.
Yes can be further improved for sure. I'll improve the data quality so can be used easily and more effectively. create table MeritData(
Date Float,
Merit Integer,
Msg TEXT,
FromID Float,
ToID Float,
Board TEXT,
SubBoard TEXT
)
Yes, that above was just to show the field in the table I was interested in SELECT all query. And... This things are getting really interesting for me. May be I want to start learning how to scrape data :) Good job mate. PS: It took long time to pull-up the entire table (Letting you know only - hoping you can do something) Not much can be done there, prefer to keeping it "unchecked", everything run on local so no harm is done.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: babo on June 27, 2018, 11:58:43 AM
little advice
use a different repo (and not one repo for all)
i sent you a pm
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: funsponge on June 27, 2018, 05:06:25 PM
This could spit out some interesting data what about gathering a certain rank like "hero members" and spitting out the usernames of the ones which have received at least 5 merits what sort of command would need to be put in?
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: jackg on June 27, 2018, 06:01:14 PM
if you didnt block some operations, do it fast
block
- INSERT
- UPDATE
- DELETE
for avoid trolls and vandals
I mean, considering vod's database previously got hacked, I'd be surprised if those commands weren't already blocked. I was interested in SELECT all query. And... This things are getting really interesting for me. May be I want to start learning how to scrape data :) Good job mate. PS: It took long time to pull-up the entire table (Letting you know only - hoping you can do something) I'd suggest against doing this unless you want a copy of the database. Unless all commands run with more than a few seconds/minutes lag then don't do anything op.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on June 27, 2018, 06:03:27 PM
This could spit out some interesting data what about gathering a certain rank like "hero members" and spitting out the usernames of the ones which have received at least 5 merits what sort of command would need to be put in?
I will have a look tomorrow and add the rank information per user in another table, perhaps LoyceV has already it available, in that case would be quite fast to include that in. After that should not be a problem giving an answer to that question. At the moment since there is no rank you can run this for all the users: Link because the forum is blocking sql in the message: https://pastebin.com/3dqMdeK0
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: funsponge on June 27, 2018, 06:32:15 PM
This could spit out some interesting data what about gathering a certain rank like "hero members" and spitting out the usernames of the ones which have received at least 5 merits what sort of command would need to be put in?
I will have a look tomorrow and add the rank information per user in another table, perhaps LoyceV has already it available, in that case would be quite fast to include that in. After that should not be a problem giving an answer to that question. At the moment since there is no rank you can run this for all the users: Link because the forum is blocking sql in the message: https://pastebin.com/3dqMdeK0 Nice one I just tried the tool and its incredibly fast so good work on that. Keep on bringing us these sort of things please as I'm sure everyone appreciates these data dumps and tools.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: mdayonliner on June 27, 2018, 11:38:48 PM
I'd suggest against doing this unless you want a copy of the database.
I actually wanted to see all data of the table :P
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on June 28, 2018, 10:31:45 AM
One thing i forgot to add, since the output is shown on a web page, is possible to give html formatting to it, this means we can add direct links for the users profile page and to the post merited, here is an example: SELECT
date,
'<a href=https://bitcointalk.org/index.php?action=profile;u=' || fromid || '>' || fromid || '</a>' as Sender,
'<a href=https://bitcointalk.org/index.php?action=profile;u=' || toid || '>' || toid || '</a>' as Receiver,
merit,
'<a href=https://bitcointalk.org/index.php?topic=' || msg || '#' || substr(msg,instr(msg,'.')+1) || '>Link Merited post</a>' as MeritedPost
FROM meritdata
WHERE merit >= 50
LIMIT 10;
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on June 29, 2018, 11:20:24 AM
Updated the data in general (29/06/2018): New link: https://albertoit.github.io/Merit-Explorer-SQL/ Added User data: 23147 users, with name and rank, that have either sent or received any merits Table: TABLE UserData(
UserId Integer PRIMARY KEY,
UserName TEXT,
Rank TEXT
); the merit data table, added readable format date and Title of the thread where the comment was merited TABLE MeritData(
"Date" TEXT,
"Merit" Integer,
"Msg" TEXT,
"FromID" Integer,
"ToID" Integer,
"Board" TEXT,
"SubBoard" TEXT,
"TitleThread" TEXT
) Few new example based on the update in this link (forum preventing posting SQL for security reason): https://pastebin.com/PRrQ81Ld - Show the user information instead of the user id:
- Selecting data by a particular time frame is quite easy (all merit transaction happened the 1/06/2018):
- Select by a time frame (from 2018 to 15/06/2018):
- You can also use hour minutes (and seconds) to check a 30 minutes interval:
- How many merits sent for each rank?
- How may merits sent from one rank to another?
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: TheBeardedBaby on June 29, 2018, 02:36:29 PM
I can't wait to get my PC back online to play a little with your database.
I just want to list all the users with 9 , 99, 249,... etc. merit and some other fun stats.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on June 29, 2018, 06:37:25 PM
I can't wait to get my PC back online to play a little with your database.
I just want to list all the users with 9 , 99, 249,... etc. merit and some other fun stats.
Yes that is the idea, if somebody has some particular method or theory to show something interesting within the data, it can be done quite easily, your imagination is the limit :) Just want to remind, If anybody need some help with the SQL i can advise.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Makkara on June 30, 2018, 06:53:53 PM
Very nice work. 8)
One suggestion: Why not at this point adding the text of the comment merited itself, that could be good info as could also be used to search for particular words in the message itself. Offcourse could make the db much heavier, but peraphs is worth investigating and make some test?
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on July 01, 2018, 02:07:11 PM
I should make some calculation on paper, but i believe the database would become quite large and the main problem i see is the waiting time to download it. Otherwise there should not be big problems speed wise, if the tables will be properly indexed.
What im planning to do next is some sort of scripting system ( that would be the equivalent of store procedures, which are missing in SQLite ), nothing very sophisticated, just some injecting of javascript where you can define the sql, execute it and manipulate the results to get the information you want in some complex case.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on July 06, 2018, 07:44:31 AM
Updated with the latest data from today (6th of July), added Trust and Location fields to the user table: UserData(
UserId Integer PRIMARY KEY,
UserName TEXT,
Rank TEXT,
Trust TEXT,
Location TEXT
)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on July 08, 2018, 05:35:20 AM
Im working on the scripting system at the moment and it should be ready by the next week, with it is going to be easier to extract data without comin up with very long sql queries, like this one i'm about to show you now.
I was actually looking into an interesting question, what is the minimum amount of smerits generated just by sending them to somebody and still unspent ? We need for each user to calculate the merits received, half that minus the merit sent. We are going to disregard remaining airdropped smerits or smerits given to merit sources. This is why i refer to it as minimum amount of smerits unspent, in reality is higher but this still can be a good indicator for future sustainability. Select sum(res) FROM (
SELECT fromid, table2.received, Sum(MERIT) as given, (received/2 - Sum(MERIT)) as res
FROM MeritData
INNER JOIN
(
SELECT toid, Sum(MERIT) as received
FROM MeritData
WHERE toid in (SELECT userid FROM userdata )
GROUP BY toid
) as table2 ON table2.toid = fromid
WHERE fromID in (SELECT userid FROM userdata )
GROUP BY fromid
Having received/2 - Sum(MERIT) >=0)
Btw the answer is 11846 This Sql above doesn't work as intended unfortunately, must have got something wrong :'(
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: chiyenbtre on July 08, 2018, 07:22:32 AM
Thank you, OP.
You made great guideline on how to use SQL to analyze merit data.
Honestly, I have never used SQL before, but I gonna learn it for sure after reading your helpful topic.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on July 08, 2018, 09:26:23 AM
Thank you, OP.
You made great guideline on how to use SQL to analyze merit data.
Honestly, I have never used SQL before, but I gonna learn it for sure after reading your helpful topic.
Good, is always a nice idea learning new skills. And in this case it may be spendable elsewhere, in a working context. :)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on July 11, 2018, 05:55:55 AM
Script systemThe scripting system is now ready, i may make still some small changes, in any case it can be used already. With this you can break down those few remaining limits coming from using SQL. I was talking few days back about the problem of calculating the minimum amount of merits generated by simply receiving merits and not spent yet. That has proven to be quite difficult to be calculated solely with SQL, since trying to do many operations at the same time increase the complexity and generate convoluted queries which are hard to understand :( Now i can show you how this can be done in an easier and more understandable way with the new scripting system. How it works?Its a mix of Javascript and SQL that get injected and executed. How to use it:With the scripting system you can basically use everything Javascript has to offer, i also added a set of functions to facilitate the interaction with the data: - PrintTableResult(query_result_data): Draw a tabulated version of the data coming from a SQL query.
- RunSQLSynch(sql_command): Execute the SQL command specified and return an object containing the data
- RunSQLAsynch(sql_command): Execute the SQL command in asynchronous mode, the output cannot be captured back and just show the result of the query on table
- GetDataField(query_result_data,row_index,coulmn_index) given a query result get the field specified by row and column index
- GetCoulmHeader(query_result_data,coulmn_index) given a query result get the header data name by column index
- Length(query_result_data): number of rows we got from a query result
- WriteLine(text): output anything you want to show as a result of your operations
- Clear(): clear the output, anything that was written or displayed
If you make some mistake in building up your script, you should get an error hinting where the problem is, however i recommend to look into the Console of your browser if you encounter some problem you cannot wrap your head around (you can open it with F12, Console tab). In here you can find all the SQL/Script examples and info: https://github.com/AlbertoIT/Merit-Explorer-SQL/blob/master/README.md Link to the tool: https://albertoit.github.io/Merit-Explorer-SQL/ Any feedback appreciated, if you need help feel free to ask here
Here is an example on how to solve the problem stated above with an explanation (this is also the default script which will be loaded automatically as you select the Script tab): https://i.imgur.com/19Ygdkg.png
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on July 13, 2018, 09:50:45 AM
Updated with the latest data (Friday 13th of July)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on July 20, 2018, 04:50:22 PM
The tool is updated with the data from today, 20th of July.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Lakai01 on July 24, 2018, 03:50:23 AM
Thank you very much for the effort you put into this project. I really appreciate it! I built a bunch of statements to get statistics about local boards, I am going to share them asap :)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on July 24, 2018, 03:00:51 PM
Thank you very much for the effort you put into this project. I really appreciate it! I built a bunch of statements to get statistics about local boards, I am going to share them asap :)
Glad to hear it was of help. Feel free to share in here your finding, maybe other people may find it useful or get inspired :)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on July 27, 2018, 01:41:53 PM
Updated with the new merit data log, 27th of July
Total merits 197.570
Merit given in this last week: 3.864
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on August 03, 2018, 07:29:10 AM
Updated with the latest data and few informations about the last week: Total merit amount so far 201185 Top merit receivers in all boards in the last week: Total Merit UserName Top merit receiver Local board
65 theyoungmillionaire Member Meta
63 dagarair Sr. Member Mining (Altcoins)
50 secousa Full Member Announcements (Altcoins)
40 BitCryptex Member Off-topic
29 ryanc Member Development & Technical Discussion
25 erguse Sr. Member Türkçe (Turkish)
22 Jet Cash Hero Member Beginners & Help
21 Spendulus Legendary Politics & Society
20 nullCoiner Sr. Member Deutsch (German)
20 DaveF Hero Member Marketplace
17 Kakmakr Legendary Bitcoin Discussion
17 yahoo62278 Legendary Trading Discussion
16 micgoossens Sr. Member Economics
15 finaleshot2016 Full Member Philippines
13 achow101 Staff Bitcoin Technical Support
12 malekcap Member Marketplace (Altcoins)
12 esmanthra Full Member Pyccкий (Russian)
10 Compiler Member Español (Spanish)
10 bittraffic Hero Member Speculation (Altcoins)
9 Steamtyme Full Member Mining
7 Shazam!!! Full Member
7 Nusa Platform Copper Member Bahasa Indonesia (Indonesian)
7 Halab Member Français
7 texgeek Jr. Member Português (Portuguese)
6 reypinyoko Newbie Altcoin Discussion
5 HostFat Staff Italiano (Italian)
4 andrew4 Jr. Member Eλληνικά (Greek)
3 slackovic Full Member Hrvatski (Croatian)
3 Vod Legendary Project Development
2 kenzawak Member Serious discussion
2 riosakamoto Full Member العربية (Arabic)
1 Arrrvin Member Nederlands (Dutch)
1 wego Sr. Member 中文 (Chinese)
1 sncc Full Member 日本語 (Japanese)
Merit distibuted per board the last week Total Merit SubBoard
39 deleted
140 Altcoin Discussion
270 Announcements (Altcoins)
47 Bahasa Indonesia (Indonesian)
75 Beginners & Help
150 Bitcoin Discussion
16 Bitcoin Technical Support
133 Deutsch (German)
114 Development & Technical Discussion
186 Economics
31 Español (Spanish)
31 Français
14 Hrvatski (Croatian)
7 India
9 Italiano (Italian)
161 Marketplace
26 Marketplace (Altcoins)
606 Meta
45 Mining
129 Mining (Altcoins)
1 Nederlands (Dutch)
46 Off-topic
44 Philippines
76 Politics & Society
26 Português (Portuguese)
13 Project Development
8 Serious discussion
62 Speculation (Altcoins)
127 Trading Discussion
202 Türkçe (Turkish)
5 Eλληνικά (Greek)
331 Pyccкий (Russian)
6 العربية (Arabic)
2 中文 (Chinese)
2 日本語 (Japanese)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: lukeburchill on August 03, 2018, 08:15:36 AM
@Piggy
your tool is awesome, I tried to rebuild it in a local db (xampp).
btw,
You are a star on my local board ;D
see one member on the local board, made a topic about the distribution of merit also he included your name with the title and said a special thank you in the last sentence.
Merit Analisis Local Indonesian (use a tool by Piggy) (https://bitcointalk.org/index.php?topic=4677836.0)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on August 03, 2018, 01:23:20 PM
@Piggy
your tool is awesome, I tried to rebuild it in a local db (xampp).
btw,
You are a star on my local board ;D
see one member on the local board, made a topic about the distribution of merit also he included your name with the title and said a special thank you in the last sentence.
Merit Analisis Local Indonesian (use a tool by Piggy) (https://bitcointalk.org/index.php?topic=4677836.0)
Nice to see somebody is actually using it, i don't understand what is written, but i see there are quite interesting informations shown in there :)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on August 10, 2018, 11:42:06 AM
Updated with the latest data of today 10th of August Some information about last week merit distribution: Top sender per boardTotal Merit UserName Top merit sender Local board
170 chimk Full Member Pyccкий (Russian)
156 suchmoon Legendary Meta
106 suchmoon Legendary Development & Technical Discussion
83 suchmoon Legendary Economics
66 iCEBREAKER Legendary Announcements (Altcoins)
50 Vlad2Vlad Legendary Bitcoin Discussion
45 stingers Legendary Marketplace
40 dbshck Staff Bahasa Indonesia (Indonesian)
33 EFS Staff Türkçe (Turkish)
31 Halab Member Français
30 klf Legendary
25 paxmao Sr. Member Español (Spanish)
25 generalizethis Legendary Speculation (Altcoins)
22 qwk Donator Deutsch (German)
20 kellendil Hero Member Altcoin Discussion
20 grendel25 Legendary Mining (Altcoins)
19 LoyceV Legendary Beginners & Help
16 Micio Legendary Italiano (Italian)
16 Vod Legendary Project Development
16 Vod Legendary Trading Discussion
11 frodocooper Staff Mining
10 Jet Cash Hero Member Bitcoin Technical Support
10 Leonard2016 Hero Member Other languages/locations
10 theymos Administrator Serious discussion
9 Jurgen Sr. Member Nederlands (Dutch)
9 jacee Legendary Philippines
9 theymos_away Member Politics & Society
8 u9y42 Legendary Português (Portuguese)
7 RegulusHr Full Member Hrvatski (Croatian)
5 Aleister Crowley Hero Member Marketplace (Altcoins)
5 rekinthis Hero Member 中文 (Chinese)
3 irfan_pak10 Copper Member India
3 malevolent Staff Polski
3 hugeblack Sr. Member العربية (Arabic)
3 sncc Full Member 日本語 (Japanese)
2 tvbcof Legendary Off-topic
1 Spazzer Member Archival
Total Merit UserName Top merit receiver Local board
69 hilariousetc Hero Member Meta
53 satoshi Founder Bitcoin Discussion
48 Hhampuz Hero Member Marketplace
38 micgoossens Sr. Member Economics
37 MarcusMillstrom Full Member Announcements (Altcoins)
34 ICOEthics Newbie Trading Discussion
27 Jet Cash Hero Member Serious discussion
25 BitCryptex Member Development & Technical Discussion
25 yurimir Legendary Speculation (Altcoins)
21 achow101 Staff Bitcoin Technical Support
21 Cryptoshka Member Pyccкий (Russian)
19 abhiseshakana Member Bahasa Indonesia (Indonesian)
16 joulion86 Member Beginners & Help
14 squatz1 Hero Member Politics & Society
13 dagarair Sr. Member Mining (Altcoins)
13 finaleshot2016 Full Member Philippines
12 javierbaco Full Member Español (Spanish)
12 baba0000000000 Full Member Français
12 Halminer Newbie Mining
12 WaDa Full Member Türkçe (Turkish)
10 hilariousandco Global Moderator
10 BTCforJoe Hero Member Project Development
9 Valuyet Member Altcoin Discussion
9 SjoerdBakker Jr. Member Nederlands (Dutch)
8 mole0815 Full Member Deutsch (German)
6 Broon Jr. Member Archival
6 nngella Jr. Member Marketplace (Altcoins)
6 hakka Member 日本語 (Japanese)
4 RegulusHr Full Member Hrvatski (Croatian)
4 Ale88 Sr. Member Italiano (Italian)
4 texgeek Jr. Member Português (Portuguese)
2 hugeblack Sr. Member العربية (Arabic)
2 smileflowers Jr. Member 中文 (Chinese)
1 Decker Jr. Member Off-topic
1 wgd Legendary Polski
1 SergiuDemerji Member Română (Romanian)
Circulation per board Total Merit SubBoard
10 Other languages/locations
9 Nederlands (Dutch)
3 India
10 日本語 (Japanese)
119 deleted
163 Altcoin Discussion
457 Announcements (Altcoins)
7 Archival
105 Bahasa Indonesia (Indonesian)
127 Beginners & Help
242 Bitcoin Discussion
38 Bitcoin Technical Support
77 Deutsch (German)
146 Development & Technical Discussion
415 Economics
62 Español (Spanish)
65 Français
21 Hrvatski (Croatian)
22 Italiano (Italian)
461 Marketplace
43 Marketplace (Altcoins)
644 Meta
76 Mining
114 Mining (Altcoins)
11 Off-topic
60 Philippines
32 Politics & Society
3 Polski
26 Português (Portuguese)
36 Project Development
1 Română (Romanian)
85 Serious discussion
49 Speculation (Altcoins)
127 Trading Discussion
105 Türkçe (Turkish)
617 Pyccкий (Russian)
6 العربية (Arabic)
8 中文 (Chinese)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: babo on August 10, 2018, 01:58:44 PM
always good job and thank you for your tool and your work
:)
and another big bonus because your tool is opensource ;)
another merit to you
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on August 17, 2018, 08:32:15 AM
Updated with today's data Friday 17th August, in here some weekly report to have a picture of what happened: Top Sender last week182 suchmoon Legendary Meta
167 chimk Full Member Pyccкий (Russian)
112 suchmoon Legendary Mining
95 bitpop Legendary Marketplace
62 suchmoon Legendary Trading Discussion
54 BobLawblaw Legendary Economics
40 Halab Member Français
37 pokerowned Legendary Announcements (Altcoins)
34 dbshck Staff Bahasa Indonesia (Indonesian)
34 paxmao Sr. Member Español (Spanish)
32 qwk Donator Deutsch (German)
25 grendel25 Legendary Mining (Altcoins)
25 EFS Staff Türkçe (Turkish)
22 Welsh Legendary Development & Technical Discussion
20 ImHash Hero Member Bitcoin Discussion
20 QuestionAuthority Legendary Off-topic
20 theymos_away Member Serious discussion
18 Svelto Sr. Member Altcoin Discussion
16 alexrossi Legendary Português (Portuguese)
14 Jet Cash Hero Member Beginners & Help
12 LoyceV Legendary Bitcoin Technical Support
10 batesresearch Legendary Marketplace (Altcoins)
10 Leonard2016 Hero Member Other languages/locations
8 RegulusHr Full Member Hrvatski (Croatian)
8 Steamtyme Full Member Politics & Society
7 suchmoon Legendary
7 Vod Legendary Project Development
6 Tipsters Sr. Member Philippines
6 adiebitsler Hero Member Speculation (Altcoins)
5 Micio Legendary Italiano (Italian)
4 hugeblack Sr. Member العربية (Arabic)
3 RAMSHIVDEEPAK Member India
3 malevolent Staff Polski
2 onlinedragon Hero Member Nederlands (Dutch)
1 Barcode_ Staff 中文 (Chinese)
Total Merit UserName Top merit receiver Local board
105 hilariousetc Hero Member Meta
62 Hhampuz Hero Member Marketplace
53 Last of the V8s Hero Member Economics
53 crypmike Jr. Member Pyccкий (Russian)
49 MarcusMillstrom Full Member Announcements (Altcoins)
34 suchmoon Legendary Politics & Society
27 bob123 Sr. Member Development & Technical Discussion
22 friends1980 Full Member Serious discussion
20 abhiseshakana Member Bahasa Indonesia (Indonesian)
20 vit05 Full Member Off-topic
18 tyuner4 Full Member Altcoin Discussion
18 coinlocket$ Full Member Trading Discussion
13 mezzomix Legendary Deutsch (German)
13 sidehack Legendary Mining
13 finaleshot2016 Full Member Philippines
12 LoyceV Legendary Bitcoin Technical Support
12 dragonmike Hero Member Mining (Altcoins)
10 faceoff97 Full Member Beginners & Help
10 hatshepsut93 Hero Member Bitcoin Discussion
10 margoslend Full Member Marketplace (Altcoins)
10 Leteravian Member Türkçe (Turkish)
9 nysha90 Jr. Member
8 BTCHadzija Member Hrvatski (Croatian)
7 Speculatoross Member Italiano (Italian)
6 F2b Member Français
6 realknow Full Member Speculation (Altcoins)
5 MbyzIco Jr. Member Español (Spanish)
5 UmerIdrees Member Other languages/locations
4 vit05 Full Member Português (Portuguese)
3 Cryptosandy1987 Jr. Member India
3 NLNico Legendary Project Development
2 friends1980 Full Member Nederlands (Dutch)
2 samcoin Hero Member العربية (Arabic)
1 wgd Legendary Polski
1 nanna Full Member 日本語 (Japanese)
3 India
2 Nederlands (Dutch)
70 Deleted
152 Altcoin Discussion
340 Announcements (Altcoins)
129 Bahasa Indonesia (Indonesian)
92 Beginners & Help
222 Bitcoin Discussion
67 Bitcoin Technical Support
120 Deutsch (German)
113 Development & Technical Discussion
544 Economics
46 Español (Spanish)
46 Français
27 Hrvatski (Croatian)
27 Italiano (Italian)
491 Marketplace
43 Marketplace (Altcoins)
634 Meta
78 Mining
105 Mining (Altcoins)
26 Off-topic
25 Other languages/locations
40 Philippines
82 Politics & Society
3 Polski
21 Português (Portuguese)
19 Project Development
111 Serious discussion
18 Speculation (Altcoins)
154 Trading Discussion
55 Türkçe (Turkish)
584 Pyccкий (Russian)
9 العربية (Arabic)
1 中文 (Chinese)
1 日本語 (Japanese) Rank Total
Administrator 5
Copper Member 91
Donator 54
Full Member 576
Global Moderator 63
Hero Member 664
Jr. Member 65
Legendary 1636
Member 262
Newbie 6
Sr. Member 481
Staff 126
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: babo on August 17, 2018, 08:53:45 AM
In the russian local board i see more movimented merits
Its incredible
In italian board for example 27
In russian 590
Incredible
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on August 17, 2018, 09:41:27 AM
In the russian local board i see more movimented merits
Its incredible
In italian board for example 27
In russian 590
Incredible
The Russian board is not doing well only compared to any local board, but compared to any board :) Here is a detailed total recap of senders users in the Russian board for this last week Total Merit Sender167 https://bitcointalk.org/index.php?action=profile;u=1202061 50 https://bitcointalk.org/index.php?action=profile;u=54484 39 https://bitcointalk.org/index.php?action=profile;u=62573 22 https://bitcointalk.org/index.php?action=profile;u=1764764 21 https://bitcointalk.org/index.php?action=profile;u=786044 15 https://bitcointalk.org/index.php?action=profile;u=830112 12 https://bitcointalk.org/index.php?action=profile;u=48075 11 https://bitcointalk.org/index.php?action=profile;u=399366 10 https://bitcointalk.org/index.php?action=profile;u=164938 10 https://bitcointalk.org/index.php?action=profile;u=186124 8 https://bitcointalk.org/index.php?action=profile;u=1083891 7 https://bitcointalk.org/index.php?action=profile;u=234771 7 https://bitcointalk.org/index.php?action=profile;u=906023 6 https://bitcointalk.org/index.php?action=profile;u=1299760 5 https://bitcointalk.org/index.php?action=profile;u=13137 5 https://bitcointalk.org/index.php?action=profile;u=498782 5 https://bitcointalk.org/index.php?action=profile;u=925231 5 https://bitcointalk.org/index.php?action=profile;u=1039323 5 https://bitcointalk.org/index.php?action=profile;u=1199798 5 https://bitcointalk.org/index.php?action=profile;u=1221497 5 https://bitcointalk.org/index.php?action=profile;u=1347520 5 https://bitcointalk.org/index.php?action=profile;u=1372318 5 https://bitcointalk.org/index.php?action=profile;u=1380108 5 https://bitcointalk.org/index.php?action=profile;u=1699073 5 https://bitcointalk.org/index.php?action=profile;u=1769892 5 https://bitcointalk.org/index.php?action=profile;u=2264347 4 https://bitcointalk.org/index.php?action=profile;u=978945 4 https://bitcointalk.org/index.php?action=profile;u=1090672 4 https://bitcointalk.org/index.php?action=profile;u=1117066 4 https://bitcointalk.org/index.php?action=profile;u=1855828 3 https://bitcointalk.org/index.php?action=profile;u=344996 3 https://bitcointalk.org/index.php?action=profile;u=485194 3 https://bitcointalk.org/index.php?action=profile;u=888882 3 https://bitcointalk.org/index.php?action=profile;u=897509 3 https://bitcointalk.org/index.php?action=profile;u=965234 3 https://bitcointalk.org/index.php?action=profile;u=1068464 3 https://bitcointalk.org/index.php?action=profile;u=1126486 3 https://bitcointalk.org/index.php?action=profile;u=1133335 3 https://bitcointalk.org/index.php?action=profile;u=1203125 3 https://bitcointalk.org/index.php?action=profile;u=1762404 2 https://bitcointalk.org/index.php?action=profile;u=220998 2 https://bitcointalk.org/index.php?action=profile;u=422621 2 https://bitcointalk.org/index.php?action=profile;u=485285 2 https://bitcointalk.org/index.php?action=profile;u=720415 2 https://bitcointalk.org/index.php?action=profile;u=899758 2 https://bitcointalk.org/index.php?action=profile;u=1064569 2 https://bitcointalk.org/index.php?action=profile;u=1071005 2 https://bitcointalk.org/index.php?action=profile;u=1101862 2 https://bitcointalk.org/index.php?action=profile;u=1110348 2 https://bitcointalk.org/index.php?action=profile;u=1117482 2 https://bitcointalk.org/index.php?action=profile;u=1299841 2 https://bitcointalk.org/index.php?action=profile;u=1324228 2 https://bitcointalk.org/index.php?action=profile;u=1334818 2 https://bitcointalk.org/index.php?action=profile;u=1412698 2 https://bitcointalk.org/index.php?action=profile;u=1511943 2 https://bitcointalk.org/index.php?action=profile;u=1548373 2 https://bitcointalk.org/index.php?action=profile;u=1671662 2 https://bitcointalk.org/index.php?action=profile;u=1772924 2 https://bitcointalk.org/index.php?action=profile;u=2097897 2 https://bitcointalk.org/index.php?action=profile;u=2145518 2 https://bitcointalk.org/index.php?action=profile;u=2223956 2 https://bitcointalk.org/index.php?action=profile;u=2245383 1 https://bitcointalk.org/index.php?action=profile;u=33631 1 https://bitcointalk.org/index.php?action=profile;u=188136 1 https://bitcointalk.org/index.php?action=profile;u=258051 1 https://bitcointalk.org/index.php?action=profile;u=289619 1 https://bitcointalk.org/index.php?action=profile;u=335282 1 https://bitcointalk.org/index.php?action=profile;u=392914 1 https://bitcointalk.org/index.php?action=profile;u=407174 1 https://bitcointalk.org/index.php?action=profile;u=459836 1 https://bitcointalk.org/index.php?action=profile;u=479945 1 https://bitcointalk.org/index.php?action=profile;u=488319 1 https://bitcointalk.org/index.php?action=profile;u=522297 1 https://bitcointalk.org/index.php?action=profile;u=539873 1 https://bitcointalk.org/index.php?action=profile;u=623643 1 https://bitcointalk.org/index.php?action=profile;u=642538 1 https://bitcointalk.org/index.php?action=profile;u=662400 1 https://bitcointalk.org/index.php?action=profile;u=749357 1 https://bitcointalk.org/index.php?action=profile;u=821756 1 https://bitcointalk.org/index.php?action=profile;u=845847 1 https://bitcointalk.org/index.php?action=profile;u=847576 1 https://bitcointalk.org/index.php?action=profile;u=896431 1 https://bitcointalk.org/index.php?action=profile;u=909172 1 https://bitcointalk.org/index.php?action=profile;u=933342 1 https://bitcointalk.org/index.php?action=profile;u=952198 1 https://bitcointalk.org/index.php?action=profile;u=990536 1 https://bitcointalk.org/index.php?action=profile;u=1037701 1 https://bitcointalk.org/index.php?action=profile;u=1064481 1 https://bitcointalk.org/index.php?action=profile;u=1096781 1 https://bitcointalk.org/index.php?action=profile;u=1100290 1 https://bitcointalk.org/index.php?action=profile;u=1112165 1 https://bitcointalk.org/index.php?action=profile;u=1165714 1 https://bitcointalk.org/index.php?action=profile;u=1291828 1 https://bitcointalk.org/index.php?action=profile;u=1302577 1 https://bitcointalk.org/index.php?action=profile;u=1378804 1 https://bitcointalk.org/index.php?action=profile;u=1525844 1 https://bitcointalk.org/index.php?action=profile;u=1616153 1 https://bitcointalk.org/index.php?action=profile;u=1627234 1 https://bitcointalk.org/index.php?action=profile;u=1694449 1 https://bitcointalk.org/index.php?action=profile;u=1711015 1 https://bitcointalk.org/index.php?action=profile;u=1711582 1 https://bitcointalk.org/index.php?action=profile;u=1740809 1 https://bitcointalk.org/index.php?action=profile;u=1813195 1 https://bitcointalk.org/index.php?action=profile;u=1832978 1 https://bitcointalk.org/index.php?action=profile;u=1837238 1 https://bitcointalk.org/index.php?action=profile;u=1853630 1 https://bitcointalk.org/index.php?action=profile;u=1896174 1 https://bitcointalk.org/index.php?action=profile;u=1918270 1 https://bitcointalk.org/index.php?action=profile;u=1951496 1 https://bitcointalk.org/index.php?action=profile;u=2002563 1 https://bitcointalk.org/index.php?action=profile;u=2287195
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on August 24, 2018, 05:47:36 AM
- Updated with the latest data from today Friday 24th of August
- Updated the user information in the table UserData adding missing users which sent/received merits
Top Sender last weekTotal Merit UserName Top merit receiver Local board
179 chimk Full Member Pyccкий (Russian)
142 suchmoon Legendary Meta
79 dbshck Staff Bahasa Indonesia (Indonesian)
63 _javi_ Hero Member Türkçe (Turkish)
56 qwk Donator Deutsch (German)
48 tomsmith26 Hero Member Announcements (Altcoins)
41 suchmoon Legendary Trading Discussion
40 Moloch Hero Member Politics & Society
39 suchmoon Legendary Mining
36 suchmoon Legendary Mining (Altcoins)
30 mymenace Legendary Economics
27 Jet Cash Hero Member Beginners & Help
26 Halab Member Français
25 Vod Legendary Project Development
21 suchmoon Legendary
21 Foxpup Legendary Bitcoin Technical Support
20 LoyceV Legendary Development & Technical Discussion
20 Micio Legendary Italiano (Italian)
18 Carlton Banks Legendary Bitcoin Discussion
14 quantum Sr. Member Altcoin Discussion
14 paxmao Sr. Member Español (Spanish)
14 RegulusHr Full Member Hrvatski (Croatian)
14 Lauda Legendary Marketplace
9 vit05 Full Member Português (Portuguese)
8 taxmanmt5 Legendary Other languages/locations
6 finaleshot2016 Full Member Philippines
6 DarkStar_ Legendary Serious discussion
4 vinbentrob Member Speculation (Altcoins)
3 adiebitsler Hero Member Marketplace (Altcoins)
3 aliashraf Sr. Member Off-topic
3 chairmanMao Member 中文 (Chinese)
2 RJX Legendary Nederlands (Dutch)
1 hopenotlate Legendary Archival
1 FlamingFingers Sr. Member العربية (Arabic)
1 Anon11073 Staff 日本語 (Japanese)
Total Merit UserName Top merit receiver Local board
92 DdmrDdmr Full Member Meta
80 Katewind Member Announcements (Altcoins)
80 fine99 Sr. Member Bahasa Indonesia (Indonesian)
67 Matthias9515 Copper Member Türkçe (Turkish)
50 phantastisch Staff Deutsch (German)
31 micgoossens Sr. Member Economics
26 alphateam Hero Member Français
24 BitCryptex Member Bitcoin Technical Support
18 o_e_l_e_o Sr. Member Politics & Society
15 gmaxwell Staff Development & Technical Discussion
15 temarazin Member Pyccкий (Russian)
14 shorena Copper Member Beginners & Help
14 Hhampuz Hero Member Marketplace
14 Moloch Hero Member Off-topic
14 suchmoon Legendary Trading Discussion
11 Welsh Legendary Serious discussion
10 faetos Hero Member
10 Trofo Full Member Hrvatski (Croatian)
9 TheArchaeologist Jr. Member Bitcoin Discussion
9 Paolo.Demidov Member Italiano (Italian)
8 moshuk Jr. Member Marketplace (Altcoins)
8 VoskCoin Sr. Member Mining (Altcoins)
8 UmerIdrees Member Other languages/locations
8 finaleshot2016 Full Member Philippines
7 RadekG2 Newbie Mining
6 buwaytress Hero Member Project Development
5 TranslateIntoDutch Member Nederlands (Dutch)
4 iram1011 Hero Member Altcoin Discussion
4 sabotag3x Hero Member Português (Portuguese)
2 t1Zona Member Español (Spanish)
2 Astrilian Full Member Speculation (Altcoins)
1 CryptoGamblingSites Member Archival
1 hakka Member 日本語 (Japanese) Total Merit SubBoard
87 DELETED
71 Altcoin Discussion
299 Announcements (Altcoins)
1 Archival
263 Bahasa Indonesia (Indonesian)
52 Beginners & Help
118 Bitcoin Discussion
62 Bitcoin Technical Support
178 Deutsch (German)
85 Development & Technical Discussion
313 Economics
19 Español (Spanish)
116 Français
30 Hrvatski (Croatian)
57 Italiano (Italian)
204 Marketplace
27 Marketplace (Altcoins)
621 Meta
40 Mining
84 Mining (Altcoins)
6 Nederlands (Dutch)
26 Off-topic
9 Other languages/locations
25 Philippines
72 Politics & Society
15 Português (Portuguese)
34 Project Development
78 Serious discussion
13 Speculation (Altcoins)
167 Trading Discussion
220 Türkçe (Turkish)
469 Pyccкий (Russian)
1 العربية (Arabic)
6 中文 (Chinese)
2 日本語 (Japanese)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on August 31, 2018, 06:37:06 AM
Updated with the data from today Friday 31st August Top Sender last week Total Merit UserName Top merit receiver Local board
68 Micio Legendary Italiano (Italian)
64 qwk Donator Deutsch (German)
55 Vod Legendary Meta
52 frodocooper Staff Mining
35 DarkStar_ Legendary Development & Technical Discussion
35 BobLawblaw Legendary Economics
25 generalizethis Legendary Speculation (Altcoins)
24 BitcoinFX Legendary Bitcoin Discussion
24 suchmoon Legendary Serious discussion
24 EFS Staff Türkçe (Turkish)
24 Yaremi Legendary Pyccкий (Russian)
18 Flodner Full Member Announcements (Altcoins)
18 Ariess Sr. Member Bahasa Indonesia (Indonesian)
18 DdmrDdmr Full Member Politics & Society
17 Halab Member Français
16 CjMapope Legendary Mining (Altcoins)
16 suchmoon Legendary Trading Discussion
13 ETFbitcoin Legendary Bitcoin Technical Support
13 buckrogers Legendary Marketplace
10 WhiteShum Legendary Altcoin Discussion
9 RegulusHr Full Member Hrvatski (Croatian)
8 Foxpup Legendary Español (Spanish)
8 Vod Legendary Project Development
6 EbonHawk Hero Member Português (Portuguese)
6 hugeblack Sr. Member العربية (Arabic)
5 Steamtyme Full Member Beginners & Help
5 Simayi Member Off-topic
4 Flodner Full Member Other languages/locations
4 finaleshot2016 Full Member Philippines
3 Direwolve735 Full Member Marketplace (Altcoins)
2 Vod Legendary
2 DikkieD Member Nederlands (Dutch)
1 sgk Legendary India
1 malevolent Staff Polski
1 NeuroticFish Legendary Română (Romanian)
1 hakka Member 日本語 (Japanese) Top Receivers last week Total Merit UserName Top merit receiver Local board
40 Flodner Full Member Meta
37 Last of the V8s Hero Member Economics
34 Piggy Sr. Member Italiano (Italian)
33 fine99 Sr. Member Bahasa Indonesia (Indonesian)
29 xtraelv Sr. Member Off-topic
25 BitCryptex Member Development & Technical Discussion
24 satoshi Founder Bitcoin Discussion
23 LFC_Bitcoin Copper Member Marketplace
22 teramit Legendary Türkçe (Turkish)
21 LoyceV Legendary Bitcoin Technical Support
18 ICOEthics Newbie Trading Discussion
16 o_e_l_e_o Sr. Member Politics & Society
16 Juliya_D Jr. Member Pyccкий (Russian)
15 cryptolord2077 Member Altcoin Discussion
15 sidehack Legendary Mining
13 Direwolve735 Full Member Announcements (Altcoins)
12 mole0815 Full Member Deutsch (German)
12 guybrushthreepwood Legendary Serious discussion
10 zawawa Sr. Member Mining (Altcoins)
10 ozkraut Sr. Member Speculation (Altcoins)
9 r1s2g3 Member Beginners & Help
9 NadiaHel Member Español (Spanish)
8 Kate Beckett Member Marketplace (Altcoins)
7 CarlOrff Sr. Member Français
6 texgeek Jr. Member Português (Portuguese)
5 ovcijisir Member Hrvatski (Croatian)
5 zenrol28 Member Philippines
4 pugman Legendary
4 Flodner Full Member Project Development
2 meatfreak Jr. Member Nederlands (Dutch)
2 Ukraine2020 Sr. Member Other languages/locations
2 qwlsnow Jr. Member 中文 (Chinese)
1 sncc Full Member 日本語 (Japanese) Sub boards merit circulation last week Total Merit SubBoard
2 Nederlands (Dutch)
27
195 Altcoin Discussion
202 Announcements (Altcoins)
140 Bahasa Indonesia (Indonesian)
70 Beginners & Help
148 Bitcoin Discussion
49 Bitcoin Technical Support
115 Deutsch (German)
111 Development & Technical Discussion
269 Economics
30 Español (Spanish)
39 Français
32 Hrvatski (Croatian)
2 India
125 Italiano (Italian)
201 Marketplace
18 Marketplace (Altcoins)
361 Meta
79 Mining
103 Mining (Altcoins)
40 Off-topic
9 Other languages/locations
19 Philippines
61 Politics & Society
1 Polski
16 Português (Portuguese)
39 Project Development
1 Română (Romanian)
52 Serious discussion
102 Speculation (Altcoins)
126 Trading Discussion
50 Türkçe (Turkish)
325 Pyccкий (Russian)
12 العربية (Arabic)
4 中文 (Chinese)
1 日本語 (Japanese) Merits sent from each rank last week Rank Total
Administrator 53
Copper Member 73
Donator 84
Full Member 323
Global Moderator 16
Hero Member 387
Jr. Member 71
Legendary 1081
Member 237
Newbie 26
Sr. Member 272
Staff 114
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: DdmrDdmr on September 01, 2018, 04:44:21 PM
Updated with the data from today Friday 31st August Top Sender last week Total Merit UserName Top merit receiver Local board
<...>
18 DdmrDdmr Full Member Politics & Society
<
>
There seems to be something wrong with this weeks update. I figure on one of the lists, but I only awarded 3 merits last week to Politics & Society ...
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on September 02, 2018, 05:40:33 AM
Updated with the data from today Friday 31st August Top Sender last week Total Merit UserName Top merit receiver Local board
<...>
18 DdmrDdmr Full Member Politics & Society
<
>
There seems to be something wrong with this weeks update. I figure on one of the lists, but I only awarded 3 merits last week to Politics & Society ... Yes, i see there is some problem in the query itself i made to gather the data, when merits are given in multiple boards. The data itself is correct, i need to see and recheck how to get the those information out when i'm i bit more fresh in my mind :)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on September 07, 2018, 07:45:10 AM
The tool is now updated with the latest data from today Friday 7th of September Top Sender per board last week total username rank subboard
91 chimk Full Member Pyccкий (Russian)
66 iCEBREAKER Legendary Announcements (Altcoins)
60 theymos_away Member Development & Technical Discussion
51 hilariousetc Hero Member Politics & Society
51 BitNow Legendary Trading Discussion
48 Foxpup Legendary Meta
47 scryptr Legendary Mining (Altcoins)
34 dbshck Staff Bahasa Indonesia (Indonesian)
30 klf Legendary
27 EFS Staff Türkçe (Turkish)
25 Foxpup Legendary Bitcoin Technical Support
23 JayJuanGee Legendary Economics
23 paxmao Sr. Member Español (Spanish)
20 frodocooper Staff Mining
18 teramit Legendary Project Development
14 RegulusHr Full Member Hrvatski (Croatian)
12 fuathan Hero Member Altcoin Discussion
12 TMAN Hero Member Beginners & Help
11 Micio Legendary Italiano (Italian)
10 Quidat Sr. Member Bitcoin Discussion
10 CryptKeeper Legendary Deutsch (German)
10 bitspill Legendary Marketplace
9 Halab Member Français
7 Jet Cash Hero Member Serious discussion
7 tyoA7X Hero Member Speculation (Altcoins)
4 Pumared Sr. Member Português (Portuguese)
3 dwminer1 Hero Member Marketplace (Altcoins)
3 Anon11073 Staff 日本語 (Japanese)
2 lienfaye Hero Member Philippines
2 hugeblack Sr. Member العربية (Arabic)
2 sunshinewang Member 中文 (Chinese)
Top Receivers per board last week total username rank subboard
55 morvillz7z Member Trading Discussion
50 bitcoinbabys Jr. Member Announcements (Altcoins)
49 hilariousetc Hero Member Meta
34 joblo Legendary Mining (Altcoins)
26 micgoossens Sr. Member Economics
26 Prometheu$ Full Member Pyccкий (Russian)
24 Coolcryptovator Copper Member Beginners & Help
22 Zapo Copper Member Marketplace
21 gmaxwell Staff Development & Technical Discussion
19 achow101 Staff Bitcoin Technical Support
18 abhiseshakana Member Bahasa Indonesia (Indonesian)
15 guybrushthreepwood Legendary Politics & Society
15 teramit Legendary Türkçe (Turkish)
11 Compiler Member Español (Spanish)
10 Matthias9515 Copper Member
10 sadmaster Jr. Member Altcoin Discussion
10 carlfebz2 Hero Member Bitcoin Discussion
10 nullCoiner Sr. Member Deutsch (German)
6 slackovic Full Member Hrvatski (Croatian)
6 LordStapy Member Italiano (Italian)
6 finaleshot2016 Full Member Philippines
6 Don Pedro Dinero Full Member Serious discussion
5 Zeppelins Full Member Marketplace (Altcoins)
5 -ck Staff Mining
5 phabulu Member Português (Portuguese)
3 Lafu Hero Member Français
2 Caulon Member Project Development
2 Febo Legendary Speculation (Altcoins)
2 hesham51 Member العربية (Arabic)
2 ji23189455 Member 中文 (Chinese)
2 sncc Full Member 日本語 (Japanese)
Sub boards merit circulation last week Total Merit SubBoard
116
146 Altcoin Discussion
364 Announcements (Altcoins)
71 Bahasa Indonesia (Indonesian)
114 Beginners & Help
95 Bitcoin Discussion
69 Bitcoin Technical Support
55 Deutsch (German)
224 Development & Technical Discussion
288 Economics
66 Español (Spanish)
27 Français
34 Hrvatski (Croatian)
1 India
23 Italiano (Italian)
207 Marketplace
51 Marketplace (Altcoins)
400 Meta
47 Mining
122 Mining (Altcoins)
3 Off-topic
15 Philippines
127 Politics & Society
27 Português (Portuguese)
29 Project Development
56 Serious discussion
23 Speculation (Altcoins)
151 Trading Discussion
91 Türkçe (Turkish)
459 Pyccкий (Russian)
8 العربية (Arabic)
4 中文 (Chinese)
3 日本語 (Japanese) Merits sent from each rank last week Rank Total
Administrator 5
Copper Member 93
Donator 8
Full Member 324
Global Moderator 40
Hero Member 556
Jr. Member 77
Legendary 1258
Member 251
Newbie 28
Sr. Member 273
Staff 158
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on September 14, 2018, 07:59:13 AM
The tool is now updated with the latest data from today Friday 14th of September Top Sender per board last week total username rank subboard
142 chimk Full Member Pyccкий (Russian)
99 Micio Legendary Italiano (Italian)
62 dbshck Staff Bahasa Indonesia (Indonesian)
56 suchmoon Legendary Meta
50 Johnny00 Hero Member Altcoin Discussion
46 suchmoon Legendary Mining
46 EFS Staff Türkçe (Turkish)
43 Vlad2Vlad Legendary Bitcoin Discussion
36 qwk Donator Deutsch (German)
32 suchmoon Legendary Trading Discussion
28 Halab Member Français
25 anahata Sr. Member Speculation (Altcoins)
24 suchmoon Legendary Development & Technical Discussion
24 suchmoon Legendary Mining (Altcoins)
23 Cyrus Administrator Română (Romanian)
22 JayJuanGee Legendary Economics
21 1369 Legendary Announcements (Altcoins)
21 paxmao Sr. Member Español (Spanish)
21 Foxpup Legendary Politics & Society
20 suchmoon Legendary Bitcoin Technical Support
16 Welsh Legendary Serious discussion
12 micher143 Hero Member Marketplace
10 chek2fire Legendary Eλληνικά (Greek)
8 suchmoon Legendary Beginners & Help
8 RegulusHr Full Member Hrvatski (Croatian)
7 Flodner Full Member Other languages/locations
5 micher143 Hero Member
5 huige007 Sr. Member Marketplace (Altcoins)
5 ice18 Hero Member Philippines
4 suchmoon Legendary Off-topic
4 suchmoon Legendary Project Development
2 EbonHawk Hero Member Português (Portuguese)
2 OmegaStarScream Staff العربية (Arabic)
1 s0lidus Member Nederlands (Dutch)
1 malevolent Staff Polski
1 ji23189455 Member 中文 (Chinese)
1 nanna Full Member 日本語 (Japanese)
Top Receivers per board last week total username rank subboard
50 anahata Sr. Member Altcoin Discussion
50 1369 Legendary Announcements (Altcoins)
48 hilariousetc Hero Member Meta
45 satoshi Founder Bitcoin Discussion
32 achow101 Staff Bitcoin Technical Support
26 Veleor Full Member Trading Discussion
25 Paolo.Demidov Member Italiano (Italian)
25 Johnny00 Hero Member Speculation (Altcoins)
21 Goran_ Full Member Pyccкий (Russian)
20 micgoossens Sr. Member Economics
17 joniboini Full Member Bahasa Indonesia (Indonesian)
15 BitcoinTurk Full Member Türkçe (Turkish)
13 Coolcryptovator Copper Member Beginners & Help
12 Yatsan Hero Member Marketplace
12 -ck Staff Mining
12 HBKMusiK Member Română (Romanian)
11 mole0815 Full Member Deutsch (German)
11 HeRetiK Hero Member Development & Technical Discussion
11 philipma1957 Legendary Mining (Altcoins)
10 Moloch Hero Member Politics & Society
8 guybrushthreepwood Legendary Serious discussion
7 Direwolve735 Full Member Other languages/locations
6 campica Full Member Hrvatski (Croatian)
6 nakamura12 Jr. Member Philippines
5 Blackhammer321 Member
5 MbyzIco Jr. Member Español (Spanish)
5 Yaplatu Member Français
5 Biggapp Sr. Member Marketplace (Altcoins)
5 vit05 Full Member Português (Portuguese)
5 RivAngE Member Eλληνικά (Greek)
4 bkbirge Full Member Off-topic
4 TheArchaeologist Jr. Member Project Development
2 caex Hero Member Polski
2 hugeblack Sr. Member العربية (Arabic)
1 TranslateIntoDutch Member Nederlands (Dutch)
1 kinopi Member 日本語 (Japanese) Sub boards merit circulation last week Total Merit SubBoard
12 Other languages/locations
15 Eλληνικά (Greek)
2 Polski
73
189 Altcoin Discussion
403 Announcements (Altcoins)
114 Bahasa Indonesia (Indonesian)
35 Beginners & Help
149 Bitcoin Discussion
71 Bitcoin Technical Support
73 Deutsch (German)
87 Development & Technical Discussion
306 Economics
40 Español (Spanish)
39 Français
32 Hrvatski (Croatian)
140 Italiano (Italian)
136 Marketplace
20 Marketplace (Altcoins)
343 Meta
54 Mining
95 Mining (Altcoins)
1 Nederlands (Dutch)
9 Off-topic
11 Philippines
36 Politics & Society
14 Português (Portuguese)
4 Project Development
25 Română (Romanian)
81 Serious discussion
61 Speculation (Altcoins)
177 Trading Discussion
111 Türkçe (Turkish)
476 Pyccкий (Russian)
7 العربية (Arabic)
1 中文 (Chinese)
1 日本語 (Japanese)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on September 24, 2018, 10:35:40 AM
Updated with the latest data from Friday 21st of September Top Sender per board last week total username rank subboard
664 qwk Donator Deutsch (German)
141 Foxpup Legendary Meta
136 dbshck Staff Bahasa Indonesia (Indonesian)
127 chimk Full Member Pyccкий (Russian)
95 Halab Member Français
80 EFS Staff Türkçe (Turkish)
73 paxmao Sr. Member Español (Spanish)
58 BobLawblaw Legendary Economics
50 bumbacoin Legendary Announcements (Altcoins)
50 sureshnsnet Legendary Speculation (Altcoins)
46 Flying Hellfish Staff Politics & Society
45 krogothmanhattan Sr. Member Marketplace
43 bones261 Legendary Beginners & Help
36 suchmoon Legendary Trading Discussion
30 paxmao Sr. Member Serious discussion
28 suchmoon Legendary Mining
25 ETFbitcoin Legendary Development & Technical Discussion
21 dumbtool45 Sr. Member Altcoin Discussion
20 suchmoon Legendary Bitcoin Technical Support
19 krogothmanhattan Sr. Member Bitcoin Discussion
17 hugeblack Sr. Member العربية (Arabic)
16 suchmoon Legendary Mining (Altcoins)
13 babo Legendary Italiano (Italian)
12 Vod Legendary Project Development
9 RegulusHr Full Member Hrvatski (Croatian)
9 TMAN Hero Member Off-topic
8 dbshck Staff
8 sabotag3x Hero Member Português (Portuguese)
7 Barcode_ Staff 中文 (Chinese)
5 foserfox Legendary Marketplace (Altcoins)
5 Mungurul Sr. Member Other languages/locations
3 jhenfelipe Hero Member Philippines
3 pawel7777 Legendary Polski
3 Naida_BR Jr. Member Eλληνικά (Greek)
2 friends1980 Full Member Nederlands (Dutch)
2 NeuroticFish Legendary Română (Romanian)
1 TheUltraElite Hero Member Archival
1 cryptokingKG Member India
1 hakka Member 日本語 (Japanese) Top Receivers per board last week total username rank subboard
185 theymos Administrator Meta
55 PHI1618 Sr. Member Türkçe (Turkish)
43 mole0815 Full Member Deutsch (German)
43 micgoossens Sr. Member Economics
42 Demirung Member Pyccкий (Russian)
33 Moloch Hero Member Politics & Society
29 abhiseshakana Member Bahasa Indonesia (Indonesian)
24 nkampala Member Beginners & Help
24 achow101 Staff Development & Technical Discussion
22 satoshi Founder Bitcoin Discussion
21 Pon13 Full Member Announcements (Altcoins)
21 hybridsole Hero Member Marketplace
19 Ale88 Sr. Member Italiano (Italian)
17 spirali Newbie Serious discussion
17 Zapo Copper Member Trading Discussion
16 F2b Member Français
13 electrobit Member Español (Spanish)
12 aleksej996 Sr. Member Bitcoin Technical Support
11 suchmoon Legendary Mining (Altcoins)
10 ibminer Legendary Project Development
9 o_e_l_e_o Sr. Member
7 BitcoinTurk Full Member Altcoin Discussion
7 HagssFIN Hero Member Mining
6 hugeblack Sr. Member العربية (Arabic)
5 slackovic Full Member Hrvatski (Croatian)
5 Foxpup Legendary Off-topic
5 wilwxk Sr. Member Português (Portuguese)
5 B.A.S. Full Member Speculation (Altcoins)
3 Smart man Sr. Member Marketplace (Altcoins)
3 Daboy_Lyle Member Philippines
2 TranslateIntoDutch Member Nederlands (Dutch)
2 invincible49 Member Other languages/locations
2 BitHub.pl Sr. Member Polski
2 veccar9008 Jr. Member Română (Romanian)
1 The Pharmacist Legendary Archival
1 rajnipatel1983@gmail.com Jr. Member India
1 majorrp2 Member 中文 (Chinese) Sub boards merit circulation last week Total Merit SubBoard
3 Eλληνικά (Greek)
145
528 Altcoin Discussion
872 Announcements (Altcoins)
1 Archival
312 Bahasa Indonesia (Indonesian)
217 Beginners & Help
258 Bitcoin Discussion
59 Bitcoin Technical Support
781 Deutsch (German)
176 Development & Technical Discussion
439 Economics
125 Español (Spanish)
154 Français
31 Hrvatski (Croatian)
5 India
77 Italiano (Italian)
286 Marketplace
121 Marketplace (Altcoins)
1271 Meta
68 Mining
88 Mining (Altcoins)
3 Nederlands (Dutch)
29 Off-topic
14 Other languages/locations
25 Philippines
164 Politics & Society
3 Polski
19 Português (Portuguese)
33 Project Development
5 Română (Romanian)
65 Serious discussion
166 Speculation (Altcoins)
199 Trading Discussion
681 Türkçe (Turkish)
970 Pyccкий (Russian)
42 العربية (Arabic)
14 中文 (Chinese)
4 日本語 (Japanese) Merits sent from each rank last week Rank Total
Administrator 40
Copper Member 161
Donator 786
Full Member 662
Global Moderator 69
Hero Member 719
Jr. Member 164
Legendary 2254
Member 588
Newbie 25
Sr. Member 802
Staff 524
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: babo on September 24, 2018, 12:42:28 PM
For subforum 13 babo Legendary Italiano (Italian) :) good thank you a lot for statistics
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: vlad230 on September 27, 2018, 01:22:22 PM
This is a great tool Piggy! :) Thanks a lot for sharing it.
Any chance you could update the merit data to the latest one?
I'm working on something ;)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on September 27, 2018, 01:45:07 PM
Welcome :)
The merit data is now updated to 21st of September, tomorrow ill update it with the new data coming.
The user table is not updated yet so if you are looking for all the usernames they are not all there yet.
You can find some example here if you need it https://github.com/AlbertoIT/Merit-Explorer-SQL
Otherwise if you need help ask.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: vlad230 on September 27, 2018, 02:30:00 PM
Welcome :)
The merit data is now updated to 21st of September, tomorrow ill update it with the new data coming.
The user table is not updated yet so if you are looking for all the usernames they are not all there yet.
You can find some example here if you need it https://github.com/AlbertoIT/Merit-Explorer-SQL
Otherwise if you need help ask.
Thanks a lot! Yes, I know the merit stats are usually updated on a Friday but wanted to know if you're planning to update them. Glad to hear that you are! :) I'm mainly interested in Merit data but curious if the Ranks are up to date for the existing users (not really interested in new users that much), if not would appreciate it if you could update them for tomorrow.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on September 27, 2018, 04:14:13 PM
Welcome :)
The merit data is now updated to 21st of September, tomorrow ill update it with the new data coming.
The user table is not updated yet so if you are looking for all the usernames they are not all there yet.
You can find some example here if you need it https://github.com/AlbertoIT/Merit-Explorer-SQL
Otherwise if you need help ask.
Thanks a lot! Yes, I know the merit stats are usually updated on a Friday but wanted to know if you're planning to update them. Glad to hear that you are! :) I'm mainly interested in Merit data but curious if the Ranks are up to date for the existing users (not really interested in new users that much), if not would appreciate it if you could update them for tomorrow. Existing users ranks are updated to the 23/24th of September, but there are some missing which may require several hours to gather, i don't think i can add them by tomorrow unfortunately. Ddmrdmr or Loyce may have a complete user list already.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: DdmrDdmr on September 27, 2018, 06:10:26 PM
<...>
Ddmrdmr or Loyce may have a complete user list already.
If anyone needs the current user list (meriter union merited), I've uploaded it here: https://docs.google.com/spreadsheets/d/1_2R2-R7cYakD3f1oMKGtH9hKNgBpsFcZFcWPFKQGBSg/edit?usp=sharing. If you need it, I can update it tomorrow (late), after I redownload all the profiles+this week's new ones.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on September 28, 2018, 07:00:18 AM
The merit data is now updated with the data provided today (Friday 28th of September), the user data update is in progress, but is not going to be ready anytime soon :) Top Sender per board last week total username rank subboard
143 chimk Full Member Pyccкий (Russian)
134 chek2fire Legendary Eλληνικά (Greek)
131 QuestionAuthority Legendary Off-topic
86 frodocooper Staff Mining
84 teramit Legendary Türkçe (Turkish)
78 dbshck Staff Bahasa Indonesia (Indonesian)
71 suchmoon Legendary Meta
58 paxmao Sr. Member Español (Spanish)
56 suchmoon Legendary Development & Technical Discussion
50 MICRO Legendary Hrvatski (Croatian)
50 coingamblingreviews Legendary Marketplace
48 Foxpup Legendary Politics & Society
42 Halab Staff Français
30 AngusCanine Legendary Announcements (Altcoins)
30 BitCoinNutJob Legendary India
28 TMAN Hero Member Beginners & Help
26 CjMapope Legendary Mining (Altcoins)
26 Vod Legendary Trading Discussion
25 Elwar Legendary Economics
21 dbshck Staff Serious discussion
20 jeeb Sr. Member 中文 (Chinese)
19 Vod Legendary Project Development
15 Micio Legendary Italiano (Italian)
14 qwk Donator Deutsch (German)
11 foserfox Legendary Altcoin Discussion
11 generous Hero Member Speculation (Altcoins)
10 MOSSAD Sr. Member
10 Foxpup Legendary Bitcoin Discussion
10 rindo Hero Member Marketplace (Altcoins)
8 hugeblack Sr. Member العربية (Arabic)
7 sabotag3x Hero Member Português (Portuguese)
4 LoyceV Legendary Bitcoin Technical Support
4 wgd Legendary Polski
3 Kayum10029 Full Member Other languages/locations
2 steampunkz Sr. Member Philippines
2 Tszunami98 Full Member Română (Romanian)
1 TryNinja Hero Member Archival
Top Receivers per board last week total username rank subboard
91 Dice-Bet Full Member Marketplace
65 gmaxwell Staff Development & Technical Discussion
61 DdmrDdmr Sr. Member Meta
40 panagot Sr. Member Eλληνικά (Greek)
39 abhiseshakana Full Member Bahasa Indonesia (Indonesian)
35 bitserve Sr. Member Economics
33 PHI1618 Sr. Member Türkçe (Turkish)
32 Smart man Sr. Member Pyccкий (Russian)
30 kaicrypzen Hero Member Off-topic
25 theymos Administrator Bitcoin Discussion
23 mu_enrico Copper Member Beginners & Help
20 Moloch Hero Member Politics & Society
19 TomCrypto Member Français
18 o_e_l_e_o Sr. Member Trading Discussion
17 Initscri Hero Member Project Development
16 NotFuzzyWarm Legendary Mining
13 Ale88 Sr. Member Italiano (Italian)
11 LibertValance Full Member Deutsch (German)
11 efudd Member Mining (Altcoins)
10 sekker Jr. Member Announcements (Altcoins)
8 Zarg0n Member Español (Spanish)
7 rodney0404 Jr. Member Altcoin Discussion
6 slackovic Full Member Hrvatski (Croatian)
4 Yeril Jr. Member
4 alegotardo Full Member Português (Portuguese)
4 NadiaHel Full Member Serious discussion
3 seoincorporation Legendary Bitcoin Technical Support
3 mdodong Full Member Marketplace (Altcoins)
3 Salauddin1994 Jr. Member Other languages/locations
3 Daboy_Lyle Member Philippines
3 bbc.reporter Hero Member Speculation (Altcoins)
3 omer-jamal Member العربية (Arabic)
2 NeuroticFish Legendary Română (Romanian)
2 coin8coin8 Member 中文 (Chinese)
1 Bitfort Sr. Member Archival
1 caex Hero Member Polski
Sub boards merit circulation last week Total Merit SubBoard
4 Română (Romanian)
137 Eλληνικά (Greek)
88
239 Altcoin Discussion
252 Announcements (Altcoins)
173 Bahasa Indonesia (Indonesian)
149 Beginners & Help
300 Bitcoin Discussion
8 Bitcoin Technical Support
99 Deutsch (German)
181 Development & Technical Discussion
282 Economics
90 Español (Spanish)
81 Français
85 Hrvatski (Croatian)
32 India
39 Italiano (Italian)
378 Marketplace
48 Marketplace (Altcoins)
756 Meta
163 Mining
90 Mining (Altcoins)
120 Off-topic
7 Other languages/locations
9 Philippines
95 Politics & Society
9 Polski
19 Português (Portuguese)
50 Project Development
42 Serious discussion
52 Speculation (Altcoins)
215 Trading Discussion
366 Türkçe (Turkish)
583 Pyccкий (Russian)
22 العربية (Arabic)
33 中文 (Chinese)
Merits sent from each rank last week Rank Total
Administrator 33
Copper Member 129
Donator 46
Full Member 520
Global Moderator 24
Hero Member 487
Jr. Member 222
Legendary 2134
Member 413
Newbie 29
Sr. Member 738
Staff 521
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: vlad230 on September 28, 2018, 07:47:23 AM
Existing users ranks are updated to the 23/24th of September, but there are some missing which may require several hours to gather, i don't think i can add them by tomorrow unfortunately.
Ddmrdmr or Loyce may have a complete user list already.
Thanks a lot Piggy! I see a lot of users have the rank of Copper Member or other special membership listed in the User data. Any chance this could be updated to the "real" rank (aka Hero, Legendary) etc. I'm curious how/where you're getting this data, maybe I could help on this part.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on September 28, 2018, 09:12:10 AM
Existing users ranks are updated to the 23/24th of September, but there are some missing which may require several hours to gather, i don't think i can add them by tomorrow unfortunately.
Ddmrdmr or Loyce may have a complete user list already.
Thanks a lot Piggy! I see a lot of users have the rank of Copper Member or other special membership listed in the User data. Any chance this could be updated to the "real" rank (aka Hero, Legendary) etc. I'm curious how/where you're getting this data, maybe I could help on this part. 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.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: vlad230 on September 28, 2018, 10:55:31 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.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on September 28, 2018, 11:11:29 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 :)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on October 05, 2018, 07:01:46 AM
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 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 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 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 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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on October 12, 2018, 07:28:19 AM
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 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 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 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 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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on October 19, 2018, 07:07:27 AM
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 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 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 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 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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on October 26, 2018, 11:42:39 AM
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 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 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 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 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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on November 02, 2018, 10: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 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 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 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 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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: r1s2g3 on November 08, 2018, 06:05:41 PM
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.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on November 08, 2018, 08:11:39 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://bitcointalk.org/index.php?topic=4456438.0 is in general more user friendly, but has limited query capabilities compared to this one.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: mainconcept on November 09, 2018, 01:45:52 PM
I get an error when I use this query: 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: 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.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on November 09, 2018, 01:53:09 PM
I get an error when I use this query: 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: 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): 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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Saint-loup on November 10, 2018, 05:36:22 PM
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 :-\ Uncaught Error: no such table: meritdata
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on November 11, 2018, 07:14:46 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 :-\ 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 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 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 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 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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on November 16, 2018, 08:36:59 AM
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 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 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 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 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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on November 23, 2018, 12:52:57 PM
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 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 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 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 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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: tranthidung on November 25, 2018, 01:27:51 AM
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) (https://bitcointalk.org/index.php?topic=5069140.0) Merits sent from each rank last week 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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on November 25, 2018, 07:04:04 AM
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) (https://bitcointalk.org/index.php?topic=5069140.0) Merits sent from each rank last week 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: 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: 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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on November 30, 2018, 07:47:59 AM
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 week183 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 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 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) 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 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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on December 07, 2018, 09:50:05 AM
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 week90 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 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) 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) 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 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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on December 17, 2018, 06:40:33 AM
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 week144 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) 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) 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) 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 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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on December 21, 2018, 06:51:34 AM
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 week237 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) 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) 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) 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 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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: mikeywith on December 25, 2018, 02:15:53 AM
just for fun ,generous members who gave newbies more than 10 merits. 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 ;D
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on December 25, 2018, 09:42:36 AM
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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: mikeywith on December 25, 2018, 01:15:17 PM
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
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on December 25, 2018, 02:19:46 PM
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 toolOpen the old database then dump the table sqlite> .output table_dump.sql
sqlite> .dump table_name
sqlite> .quit Then open the new database and read the dump: sqlite> .read table_dump.sql
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: mikeywith on December 26, 2018, 09:33:53 PM
will try that later on , thanks piggy
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on December 27, 2018, 09:17:42 AM
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.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on December 30, 2018, 09:45:32 AM
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 :)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Saint-loup on January 02, 2019, 02:53:41 PM
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 :)
Thank you. Happy new year
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on January 04, 2019, 08:38:00 AM
The tool is now updated with the latest data from today Friday 4th of January Here is the usual snapshot about the last week: Top Sender per board last week141 chimk Full Member Pyccкий (Russian)
56 suchmoon Legendary Development & Technical Discussion
50 krogothmanhattan Hero Member Marketplace
44 suchmoon Legendary Trading Discussion
40 iGotSpots Legendary Announcements (Altcoins)
40 Vod Legendary Meta
34 frodocooper Staff Mining
32 jbreher Legendary Economics
30 suchmoon Legendary Beginners & Help
29 Halab Staff Français
20 willi9974 Legendary Deutsch (German)
20 suchmoon Legendary Serious discussion
17 Piggy Hero Member Italiano (Italian)
16 Vod Legendary Bitcoin Discussion
15 EFS Staff Türkçe (Turkish)
11 dbshck Staff Bahasa Indonesia (Indonesian)
10 cod3gen Member Mining (Altcoins)
10 BADecker Legendary Politics & Society
10 MirkoIta Legendary Speculation (Altcoins)
8 suchmoon Legendary
8 suchmoon Legendary Bitcoin Technical Support
8 poptok1 Hero Member Polski
7 paxmao Sr. Member Español (Spanish)
7 MadeInUkraine Sr. Member Other languages/locations
7 presduterte Newbie Pilipinas
7 sabotag3x Hero Member Português (Portuguese)
6 Iwillgotothemoon Jr. Member Altcoin Discussion
5 siddu67 Full Member Marketplace (Altcoins)
5 tactac Member 日本語 (Japanese)
4 RegulusHr Full Member Hrvatski (Croatian)
4 Vod Legendary Off-topic
3 bittraffic Hero Member Project Development
2 JensS Hero Member Nederlands (Dutch)
2 mikeywith Member العربية (Arabic)
1 pooya87 Legendary India
1 Cyrus Administrator Română (Romanian)
1 ptiper21 Full Member Eλληνικά (Greek)
1 Barcode_ Staff 中文 (Chinese) 90 theymos Administrator Bitcoin Discussion
46 HairyMaclairy Hero Member Economics
26 Pmalek Hero Member Beginners & Help
23 eddie13 Hero Member Serious discussion
22 hilariousetc Legendary Meta
21 iGotSpots Legendary Announcements (Altcoins)
21 Ticked Sr. Member Marketplace
21 ArticMine Legendary Speculation (Altcoins)
21 khaled0111 Full Member Trading Discussion
20 Coding Enthusiast Sr. Member Development & Technical Discussion
19 arulbero Hero Member Italiano (Italian)
17 meph Sr. Member Deutsch (German)
13 igor72 Member Pyccкий (Russian)
10 MoonCrypt Jr. Member Politics & Society
9 Nwankwobtt Jr. Member Altcoin Discussion
9 asche Full Member Français
9 miyav Member Türkçe (Turkish)
8 VB1001 Member Español (Spanish)
8 kopipe Full Member Pilipinas
7 LoyceV Legendary Bitcoin Technical Support
7 Ukraine2020 Sr. Member Other languages/locations
6 ETFbitcoin Legendary Bahasa Indonesia (Indonesian)
6 Pmalek Hero Member Hrvatski (Croatian)
6 philipma1957 Legendary Mining
6 mikeywith Member Mining (Altcoins)
5 stompix Hero Member
3 sabotag3x Hero Member Português (Portuguese)
3 Kavelj22 Newbie العربية (Arabic)
2 Crypto-Info Newbie Marketplace (Altcoins)
2 sbogovac Legendary Nederlands (Dutch)
2 BADecker Legendary Off-topic
2 hakka Member 日本語 (Japanese)
1 avikz Legendary India
1 Jet Cash Legendary Project Development
1 chek2fire Legendary Eλληνικά (Greek)
1 baobao2000 Member 中文 (Chinese) 12 Polski
3 العربية (Arabic)
10 Pilipinas
30
52 Altcoin Discussion
209 Announcements (Altcoins)
60 Bahasa Indonesia (Indonesian)
90 Beginners & Help
83 Bitcoin Discussion
15 Bitcoin Technical Support
113 Deutsch (German)
285 Development & Technical Discussion
463 Economics
18 Español (Spanish)
70 Français
6 Hrvatski (Croatian)
1 India
34 Italiano (Italian)
243 Marketplace
20 Marketplace (Altcoins)
216 Meta
60 Mining
34 Mining (Altcoins)
5 Nederlands (Dutch)
9 Off-topic
8 Other languages/locations
27 Politics & Society
16 Português (Portuguese)
9 Project Development
1 Română (Romanian)
76 Serious discussion
33 Speculation (Altcoins)
152 Trading Discussion
41 Türkçe (Turkish)
1 Eλληνικά (Greek)
464 Pyccкий (Russian)
3 中文 (Chinese)
6 日本語 (Japanese) Administrator 16
Copper Member 72
Donator 11
Full Member 302
Global Moderator 3
Hero Member 347
Jr. Member 94
Legendary 1304
Member 165
Newbie 51
Sr. Member 257
Staff 158
VIP 3 Administrator 128
Copper Member 56
Donator 8
Founder 1
Full Member 304
Global Moderator 3
Hero Member 364
Jr. Member 145
Legendary 618
Member 233
Newbie 89
Sr. Member 393
Staff 55
VIP 6
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on January 13, 2019, 01:46:00 PM
The tool is now updated with the latest data from today Friday 11th of January Here is the usual snapshot about the last week: Top Sender per board last week202 chimk Full Member Pyccкий (Russian)
182 TMAN Hero Member Meta
153 qwk Donator Deutsch (German)
127 marcus_of_augustus Legendary Economics
90 suchmoon Legendary Trading Discussion
84 frodocooper Staff Mining
54 dbshck Staff Bitcoin Discussion
54 EFS Staff Türkçe (Turkish)
53 bones261 Legendary Development & Technical Discussion
52 Flying Hellfish Staff Marketplace
50 BldSwtTrs Legendary Bitcoin Technical Support
43 Halab Staff Français
42 sapta Staff Bahasa Indonesia (Indonesian)
33 suchmoon Legendary Beginners & Help
33 paxmao Sr. Member Español (Spanish)
32 Vlad2Vlad Legendary Altcoin Discussion
32 suchmoon Legendary Serious discussion
28 suchmoon Legendary Announcements (Altcoins)
25 dbshck Staff Politics & Society
21 suchmoon Legendary Mining (Altcoins)
21 Anon11073 Staff 日本語 (Japanese)
20 TMAN Hero Member Off-topic
18 Micio Legendary Italiano (Italian)
12 RegulusHr Full Member Hrvatski (Croatian)
12 Vod Legendary Project Development
7 Globb0 Legendary Speculation (Altcoins)
6 #BitcoinCore Sr. Member Português (Portuguese)
5 frodocooper Staff
5 rDieminger Member Marketplace (Altcoins)
5 Partizant Sr. Member Polski
4 omer-jamal Member العربية (Arabic)
3 LoyceV Legendary Nederlands (Dutch)
2 Heisenberg_Hunter Full Member India
2 Cyrus Administrator Română (Romanian)
1 HARDCRACKERS Full Member Archival
1 bitart Hero Member Other languages/locations
1 cabalism13 Member Pilipinas
1 Barcode_ Staff 中文 (Chinese)
124 The Pharmacist Legendary Meta
84 micgoossens Sr. Member Economics
70 Coding Enthusiast Sr. Member Bitcoin Technical Support
45 cestmoi Newbie Beginners & Help
36 Lafu Hero Member Deutsch (German)
35 achow101 Staff Development & Technical Discussion
31 theymos Administrator Bitcoin Discussion
30 Nasakioto Full Member Altcoin Discussion
26 TheNewAnon135246 Legendary Off-topic
25 Gunthar Hero Member Marketplace (Altcoins)
24 LoyceV Legendary Trading Discussion
23 zororaka Copper Member Bahasa Indonesia (Indonesian)
23 1Dq Copper Member Marketplace
21 fillippone Member Italiano (Italian)
20 mikeywith Member Mining
19 esmanthra Sr. Member Pyccкий (Russian)
17 Nasakioto Full Member Announcements (Altcoins)
16 DdmrDdmr Sr. Member Español (Spanish)
16 asche Full Member Français
15 forumalacali Newbie Türkçe (Turkish)
14 waterman Full Member Serious discussion
11 MbyzIco Member Politics & Society
9 Pmalek Hero Member Hrvatski (Croatian)
7 mikeywith Member Mining (Altcoins)
7 hakka Member 日本語 (Japanese)
6 Kavelj22 Newbie العربية (Arabic)
5 NotFuzzyWarm Legendary
5 ibminer Legendary Project Development
3 sabotag3x Hero Member Português (Portuguese)
2 Tytanowy Janusz Member Polski
2 kurious Legendary Speculation (Altcoins)
1 xenon131 Full Member Archival
1 amishmanish Sr. Member India
1 MissionPhailed Hero Member Nederlands (Dutch)
1 Fenya96 Jr. Member Other languages/locations
1 NavI_027 Full Member Pilipinas
1 jonsi Legendary Română (Romanian)
1 baobao2000 Member 中文 (Chinese)
28 日本語 (Japanese)
33
103 Altcoin Discussion
174 Announcements (Altcoins)
2 Archival
168 Bahasa Indonesia (Indonesian)
247 Beginners & Help
234 Bitcoin Discussion
74 Bitcoin Technical Support
342 Deutsch (German)
475 Development & Technical Discussion
848 Economics
72 Español (Spanish)
93 Français
19 Hrvatski (Croatian)
2 India
50 Italiano (Italian)
418 Marketplace
48 Marketplace (Altcoins)
1033 Meta
100 Mining
34 Mining (Altcoins)
5 Nederlands (Dutch)
35 Off-topic
2 Other languages/locations
1 Pilipinas
56 Politics & Society
11 Polski
17 Português (Portuguese)
34 Project Development
2 Română (Romanian)
96 Serious discussion
10 Speculation (Altcoins)
290 Trading Discussion
143 Türkçe (Turkish)
349 Pyccкий (Russian)
15 العربية (Arabic)
1 中文 (Chinese)
Administrator 4
Copper Member 121
Donator 215
Full Member 430
Global Moderator 14
Hero Member 531
Jr. Member 79
Legendary 2809
Member 191
Newbie 43
Sr. Member 503
Staff 588
VIP. 1
Administrator 178
Copper Member 245
Donator 47
Founder 2
Full Member 601
Global Moderator 5
Hero Member 635
Jr. Member 260
Legendary 1372
Member 572
Newbie 262
Sr. Member 868
Staff 115
VIP 28
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on January 18, 2019, 07:53:08 AM
The tool is now updated with the latest data from today Friday 18th of January Here is the usual snapshot about the last week: Top Sender per board last week227 chimk Full Member Pyccкий (Russian)
179 suchmoon Legendary Meta
156 Flying Hellfish Staff Marketplace
124 suchmoon Legendary Trading Discussion
122 dbshck Staff Bahasa Indonesia (Indonesian)
104 Micio Legendary Italiano (Italian)
97 Globb0 Legendary Economics
73 Welsh Staff Development & Technical Discussion
59 Welsh Staff Serious discussion
55 frodocooper Staff Mining
54 Halab Staff Français
50 bastilar Hero Member Announcements (Altcoins)
50 MaoChao Legendary Bitcoin Discussion
36 TMAN Hero Member Beginners & Help
27 EFS Staff Türkçe (Turkish)
22 TECSHARE Legendary Politics & Society
20 rorschach1 Hero Member Altcoin Discussion
20 suchmoon Legendary Project Development
17 qwk Donator Deutsch (German)
15 OgNasty Donator Mining (Altcoins)
13 DdmrDdmr Sr. Member Español (Spanish)
13 Vod Legendary Off-topic
12 hugeblack Sr. Member العربية (Arabic)
10 Skeptical One Sr. Member
9 bones261 Legendary Bitcoin Technical Support
9 HasHe Hero Member Pilipinas
8 kotwica666 Legendary Polski
5 Globb0 Legendary Speculation (Altcoins)
4 peterspijzer Sr. Member Nederlands (Dutch)
3 Daniel91 Legendary Hrvatski (Croatian)
3 sabotag3x Hero Member Português (Portuguese)
3 Anon11073 Staff 日本語 (Japanese)
2 European Central Bank Legendary Marketplace (Altcoins)
1 Coolcryptovator Copper Member Archival
1 amishmanish Sr. Member India
1 boltz Legendary Română (Romanian)
1 Clearstream Jr. Member 中文 (Chinese) 138 theymos Administrator Meta
100 satoshi Founder Bitcoin Discussion
62 OneNattyLitecoin Full Member Marketplace
61 Micio Legendary Italiano (Italian)
57 micgoossens Sr. Member Economics
50 michnkeks Jr. Member Announcements (Altcoins)
47 aliashraf Sr. Member Development & Technical Discussion
44 Husna QA Full Member Bahasa Indonesia (Indonesian)
38 S_Therapist Newbie Beginners & Help
34 1miau Full Member Deutsch (German)
31 MadZ Hero Member Trading Discussion
30 Vod Legendary Project Development
30 xenon131 Full Member Pyccкий (Russian)
23 teramit Legendary Türkçe (Turkish)
21 asche Full Member Français
21 eddie13 Hero Member Serious discussion
20 CryptonikaTrade Member Altcoin Discussion
20 mikeywith Member Mining
20 RidleyReport Jr. Member Politics & Society
18 achow101 Staff Bitcoin Technical Support
18 cabalism13 Member Pilipinas
10 Lovehacked Full Member
8 Zarg0n Member Español (Spanish)
8 turingox Jr. Member Polski
7 64dimensions Hero Member Mining (Altcoins)
7 herzmeister Legendary Off-topic
7 omer-jamal Member العربية (Arabic)
5 BayAreaCoins Legendary Speculation (Altcoins)
4 Rafaela Romano Newbie Português (Portuguese)
3 Trofo Sr. Member Hrvatski (Croatian)
3 hakka Member 日本語 (Japanese)
2 AlexSimion Full Member Marketplace (Altcoins)
1 merclyn Newbie Archival
1 bharathve Jr. Member India
1 JorisK Full Member Nederlands (Dutch)
1 Vlad.Sas Jr. Member Română (Romanian)
1 todayin Jr. Member 中文 (Chinese) 5 Speculation (Altcoins)
53
72 Altcoin Discussion
309 Announcements (Altcoins)
2 Archival
192 Bahasa Indonesia (Indonesian)
228 Beginners & Help
289 Bitcoin Discussion
24 Bitcoin Technical Support
159 Deutsch (German)
293 Development & Technical Discussion
562 Economics
30 Español (Spanish)
141 Français
12 Hrvatski (Croatian)
2 India
227 Italiano (Italian)
754 Marketplace
10 Marketplace (Altcoins)
1420 Meta
119 Mining
50 Mining (Altcoins)
6 Nederlands (Dutch)
32 Off-topic
38 Pilipinas
93 Politics & Society
19 Polski
12 Português (Portuguese)
55 Project Development
2 Română (Romanian)
86 Serious discussion
536 Trading Discussion
83 Türkçe (Turkish)
454 Pyccкий (Russian)
24 العربية (Arabic)
1 中文 (Chinese)
6 日本語 (Japanese) Administrator 52
Copper Member 164
Donator 231
Full Member 561
Global Moderator 31
Hero Member 761
Jr. Member 132
Legendary 2657
Member 265
Newbie 117
Sr. Member 523
Staff 906 Administrator 190
Copper Member 329
Donator 103
Founder 102
Full Member 724
Global Moderator 5
Hero Member 699
Jr. Member 433
Legendary 1480
Member 647
Newbie 491
Sr. Member 1055
Staff 99
VIP 43
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on January 25, 2019, 09:08:11 AM
The tool is now updated with the latest data from today Friday 25th of January Here is the usual snapshot about the last week: Top Sender per board last week248 chimk Full Member ??????? (Russian)
192 dbshck Staff Bahasa Indonesia (Indonesian)
146 suchmoon Legendary Meta
94 Flying Hellfish Staff Marketplace
90 suchmoon Legendary Trading Discussion
82 dbshck Staff Bitcoin Discussion
80 dbshck Staff Beginners & Help
73 Halab Staff Français
70 frodocooper Staff Mining
60 suchmoon Legendary Development & Technical Discussion
37 JayJuanGee Legendary Economics
32 o_solo_miner Legendary Deutsch (German)
28 paxmao Sr. Member Español (Spanish)
27 suchmoon Legendary Announcements (Altcoins)
26 dbshck Staff Politics & Society
24 dbshck Staff Bitcoin Technical Support
16 sabotag3x Hero Member Português (Portuguese)
12 dbshck Staff Project Development
12 EFS Staff Türkçe (Turkish)
11 Micio Legendary Italiano (Italian)
11 suchmoon Legendary Mining (Altcoins)
11 cryptovigi Member Polski
11 hugeblack Sr. Member ??????? (Arabic)
9 TMAN Hero Member
9 dbshck Staff Off-topic
9 dbshck Staff Serious discussion
6 S_Therapist Newbie Marketplace (Altcoins)
5 bL4nkcode Copper Member Pilipinas
5 hulla Hero Member Speculation (Altcoins)
4 Questat Hero Member Altcoin Discussion
4 Cyrus Administrator Româna (Romanian)
3 freigeist Hero Member Hrvatski (Croatian)
3 Crypto S Copper Member ???????? (Greek)
2 The Pharmacist Legendary Archival
1 RJX Legendary Nederlands (Dutch)
1 Fenya96 Jr. Member Other languages/locations 75 LoyceV Legendary Meta
45 LoyceV Legendary Trading Discussion
41 HairyMaclairy Hero Member Economics
39 taikuri13 Full Member ??????? (Russian)
30 joniboini Sr. Member Bahasa Indonesia (Indonesian)
27 Hhampuz Hero Member Marketplace
26 mixoftix Newbie Development & Technical Discussion
20 asche Full Member Français
18 Hal VIP Bitcoin Discussion
18 lassdas Legendary Deutsch (German)
18 Gothorum Sr. Member Español (Spanish)
16 S_Therapist Newbie Beginners & Help
13 jackg Copper Member Bitcoin Technical Support
11 Plutosky Member Italiano (Italian)
11 philipma1957 Legendary Mining
11 coins4commies Member Politics & Society
11 Tytanowy Janusz Member Polski
10 LFC_Bitcoin Copper Member Announcements (Altcoins)
9 dumbhack3r Jr. Member Marketplace (Altcoins)
8 TimtheYoutuber Member Project Development
7 Domchi Full Member Hrvatski (Croatian)
7 realbminer Member Mining (Altcoins)
7 tg88 Full Member Português (Portuguese)
7 Palpatinee Member Türkçe (Turkish)
6 Avirunes Copper Member
6 tmfp Legendary Off-topic
6 Mohammad alsmadi Jr. Member ??????? (Arabic)
5 mikeywith Member Serious discussion
5 posi Sr. Member Speculation (Altcoins)
3 Japinat Hero Member Altcoin Discussion
3 Muzika Sr. Member Pilipinas
3 Naida_BR Member ???????? (Greek)
2 bill gator Copper Member Archival
2 QuadsPoker Copper Member Nederlands (Dutch)
2 3dOOm Copper Member Româna (Romanian)
1 bitart Hero Member Other languages/locations 3 ???????? (Greek)
2 Nederlands (Dutch)
47
34 Altcoin Discussion
184 Announcements (Altcoins)
252 Bahasa Indonesia (Indonesian)
195 Beginners & Help
209 Bitcoin Discussion
82 Bitcoin Technical Support
111 Deutsch (German)
206 Development & Technical Discussion
436 Economics
64 Español (Spanish)
137 Français
22 Hrvatski (Croatian)
41 Italiano (Italian)
529 Marketplace
28 Marketplace (Altcoins)
965 Meta
110 Mining
24 Mining (Altcoins)
17 Off-topic
2 Other languages/locations
13 Pilipinas
74 Politics & Society
20 Polski
28 Português (Portuguese)
27 Project Development
5 Româna (Romanian)
18 Serious discussion
18 Speculation (Altcoins)
452 Trading Discussion
60 Türkçe (Turkish)
498 ??????? (Russian)
24 ??????? (Arabic) Administrator 15
Copper Member 159
Donator 57
Full Member 426
Global Moderator 15
Hero Member 569
Jr. Member 119
Legendary 1675
Member 236
Newbie 71
Sr. Member 470
Staff 1073
VIP 2 Administrator 54
Copper Member 278
Donator 16
Founder 4
Full Member 512
Global Moderator 9
Hero Member 543
Jr. Member 298
Legendary 1276
Member 587
Newbie 233
Sr. Member 746
Staff 88
VIP 21
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on February 01, 2019, 08:35:32 AM
The tool is now updated with the latest data from today Friday 1st of February Here is the usual snapshot about the last week: Top Sender per board last week192 chimk Full Member Pyccкий (Russian)
147 dbshck Staff Bahasa Indonesia (Indonesian)
88 suchmoon Legendary Meta
85 Flying Hellfish Staff Marketplace
70 Halab Staff Français
69 Foxpup Legendary Development & Technical Discussion
59 Flying Hellfish Staff Politics & Society
56 suchmoon Legendary Trading Discussion
52 suchmoon Legendary Serious discussion
50 suchmoon Legendary Bitcoin Discussion
46 BobLawblaw Legendary Economics
37 tyz Legendary Deutsch (German)
32 suchmoon Legendary Beginners & Help
28 suchmoon Legendary Announcements (Altcoins)
28 frodocooper Staff Mining
16 paxmao Sr. Member Español (Spanish)
14 vapourminer Legendary Mining (Altcoins)
14 sabotag3x Hero Member Português (Portuguese)
11 BitBitCoin Legendary Italiano (Italian)
10 ChekaZ Legendary Marketplace (Altcoins)
10 phishead Hero Member Speculation (Altcoins)
9 Vod Legendary Project Development
9 Zz Legendary Türkçe (Turkish)
8 Foxpup Legendary
8 criptix Legendary Altcoin Discussion
8 bones261 Legendary Bitcoin Technical Support
6 hugeblack Sr. Member العربية (Arabic)
4 marlboroza Hero Member Hrvatski (Croatian)
4 Foxpup Legendary Off-topic
2 eddie13 Hero Member Archival
2 cabalism13 Member Pilipinas
2 SastraID Sr. Member 日本語 (Japanese)
1 friends1980 Full Member Nederlands (Dutch)
1 Indymoney Jr. Member Other languages/locations
1 BitCryptex Sr. Member Polski
1 Barcode_ Staff 中文 (Chinese) 66 LoyceV Legendary Meta
52 satoshi Founder Bitcoin Discussion
45 Hhampuz Hero Member Marketplace
44 ryzaadit Full Member Bahasa Indonesia (Indonesian)
44 achow101 Staff Development & Technical Discussion
35 Artemis3 Jr. Member Politics & Society
27 TheFuzzStone Hero Member Pyccкий (Russian)
25 Last of the V8s Legendary Economics
22 asche Full Member Français
22 The Pharmacist Legendary Trading Discussion
20 Pmalek Hero Member Beginners & Help
19 Cryptotourist Jr. Member Announcements (Altcoins)
17 HairyMaclairy Hero Member Speculation (Altcoins)
13 Bonwin Jr. Member Altcoin Discussion
13 qwk Donator Deutsch (German)
12 Plutosky Member Italiano (Italian)
11 mocacinno Legendary Bitcoin Technical Support
11 mikeywith Member Mining
11 mikeywith Member Serious discussion
10 fairglu Legendary Marketplace (Altcoins)
10 pinpins Jr. Member Mining (Altcoins)
9 alegotardo Full Member Português (Portuguese)
8 gospodin Member Türkçe (Turkish)
6 VB1001 Member Español (Spanish)
6 mikeywith Member العربية (Arabic)
5 Timelord2067 Legendary
5 Domchi Full Member Hrvatski (Croatian)
5 tactac Member 日本語 (Japanese)
4 odolvlobo Legendary Off-topic
2 The Pharmacist Legendary Archival
2 AdolfinWolf Hero Member Project Development
1 QuadsPoker Copper Member Nederlands (Dutch)
1 blokklanc Jr. Member Other languages/locations
1 NavI_027 Full Member Pilipinas
1 cryptovigi Member Polski
1 baobao2000 Member 中文 (Chinese) 61 Serious discussion
40
76 Altcoin Discussion
143 Announcements (Altcoins)
8 Archival
271 Bahasa Indonesia (Indonesian)
138 Beginners & Help
212 Bitcoin Discussion
54 Bitcoin Technical Support
150 Deutsch (German)
191 Development & Technical Discussion
396 Economics
22 Español (Spanish)
124 Français
12 Hrvatski (Croatian)
36 Italiano (Italian)
611 Marketplace
23 Marketplace (Altcoins)
637 Meta
59 Mining
44 Mining (Altcoins)
1 Nederlands (Dutch)
8 Off-topic
3 Other languages/locations
3 Pilipinas
193 Politics & Society
2 Polski
38 Português (Portuguese)
31 Project Development
59 Speculation (Altcoins)
303 Trading Discussion
35 Türkçe (Turkish)
413 Pyccкий (Russian)
13 العربية (Arabic)
1 中文 (Chinese)
8 日本語 (Japanese) Administrator 58
Copper Member 112
Donator 82
Full Member 435
Global Moderator 10
Hero Member 441
Jr. Member 98
Legendary 1811
Member 212
Newbie 40
Sr. Member 424
Staff 587
VIP 1 Administrator 83
Copper Member 173
Donator 45
Founder 53
Full Member 475
Global Moderator 9
Hero Member 537
Jr. Member 320
Legendary 1099
Member 560
Newbie 111
Sr. Member 517
Staff 118
VIP 5
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on February 08, 2019, 11:42:32 AM
The tool is now updated with the latest data from today Friday 8th of February Here is the usual snapshot about the last week: Top Sender per board last week168 chimk Full Member Pyccкий (Russian)
125 qwk Donator Deutsch (German)
102 DdmrDdmr Sr. Member Beginners & Help
102 DdmrDdmr Sr. Member Meta
86 dbshck Staff Bahasa Indonesia (Indonesian)
84 suchmoon Legendary Trading Discussion
74 ETFbitcoin Legendary Development & Technical Discussion
61 frodocooper Staff Mining
58 Vlad2Vlad Legendary Announcements (Altcoins)
45 EFS Staff Türkçe (Turkish)
42 DdmrDdmr Sr. Member Español (Spanish)
37 Halab Staff Français
36 Flying Hellfish Staff Politics & Society
35 Flying Hellfish Staff Marketplace
33 Pamoldar Hero Member Economics
25 girino Legendary Português (Portuguese)
22 dbshck Staff Serious discussion
20 Vlad2Vlad Legendary Bitcoin Discussion
13 Vod Legendary Project Development
12 suchmoon Legendary Speculation (Altcoins)
11 vapourminer Legendary Mining (Altcoins)
9 Foxpup Legendary
9 stingers Legendary Marketplace (Altcoins)
9 dbshck Staff Off-topic
8 iCEBREAKER Legendary Altcoin Discussion
8 ETFbitcoin Legendary Bitcoin Technical Support
7 theyoungmillionaire Full Member Pilipinas
6 Micio Legendary Italiano (Italian)
4 Mr Airdrops Newbie العربية (Arabic)
2 Tytanowy Janusz Member Polski
1 Daniel91 Legendary Hrvatski (Croatian)
1 DdmrDdmr Sr. Member India
1 friends1980 Full Member Nederlands (Dutch)
1 Cyrus Administrator Română (Romanian)
1 tactac Member 日本語 (Japanese) 60 xhomerx10 Legendary Economics
55 theymos Administrator Meta
50 d5000 Legendary Announcements (Altcoins)
34 qwk Donator Deutsch (German)
30 ICOEthics Full Member Trading Discussion
29 polymerbit Full Member Marketplace
27 ryzaadit Full Member Bahasa Indonesia (Indonesian)
25 Pamoldar Hero Member Development & Technical Discussion
24 PHI1618 Sr. Member Türkçe (Turkish)
23 tranthidung Member Beginners & Help
23 Artemis3 Jr. Member Politics & Society
22 sabotag3x Hero Member Português (Portuguese)
20 Hal VIP Bitcoin Discussion
16 HeRetiK Hero Member Bitcoin Technical Support
16 Xal0lex Staff Pyccкий (Russian)
14 HagssFIN Legendary Mining
13 Vlad2Vlad Legendary Altcoin Discussion
10 Torontello Jr. Member Marketplace (Altcoins)
8 asche Full Member Français
6 bones261 Legendary
6 VB1001 Member Español (Spanish)
6 h311m4n Sr. Member Mining (Altcoins)
6 theymos Administrator Off-topic
5 Jet Cash Legendary Serious discussion
5 HairyMaclairy Hero Member Speculation (Altcoins)
4 nakamura12 Member Pilipinas
4 cryptovigi Member Polski
4 sarah7912 Full Member العربية (Arabic)
3 Pmalek Hero Member Hrvatski (Croatian)
3 Salauddin1994 Jr. Member Other languages/locations
3 Vod Legendary Project Development
2 Paolo.Demidov Member Italiano (Italian)
1 deadley Legendary India
1 sbogovac Legendary Nederlands (Dutch)
1 Laskoo Jr. Member Română (Romanian)
1 kazuki.t Member 日本語 (Japanese) 4 Polski
3 Other languages/locations
22 Project Development
26
73 Altcoin Discussion
318 Announcements (Altcoins)
183 Bahasa Indonesia (Indonesian)
249 Beginners & Help
137 Bitcoin Discussion
23 Bitcoin Technical Support
285 Deutsch (German)
339 Development & Technical Discussion
476 Economics
55 Español (Spanish)
64 Français
17 Hrvatski (Croatian)
1 India
10 Italiano (Italian)
484 Marketplace
46 Marketplace (Altcoins)
624 Meta
124 Mining
57 Mining (Altcoins)
1 Nederlands (Dutch)
23 Off-topic
13 Pilipinas
60 Politics & Society
42 Português (Portuguese)
1 Română (Romanian)
34 Serious discussion
30 Speculation (Altcoins)
551 Trading Discussion
99 Türkçe (Turkish)
327 Pyccкий (Russian)
11 العربية (Arabic)
1 日本語 (Japanese) Administrator 11
Copper Member 127
Donator 189
Full Member 406
Global Moderator 6
Hero Member 465
Jr. Member 113
Legendary 1842
Member 183
Newbie 30
Sr. Member 681
Staff 562 Administrator 93
Copper Member 200
Donator 100
Founder 1
Full Member 579
Global Moderator 17
Hero Member 577
Jr. Member 344
Legendary 1217
Member 487
Newbie 97
Sr. Member 553
Staff 81
VIP 20
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on February 19, 2019, 07:53:47 AM
The tool is now updated with the latest data from Friday 15th of February Here is the usual snapshot about the last week: Top Sender per board last week237 chimk Full Member Pyccкий (Russian)
135 dbshck Staff Bahasa Indonesia (Indonesian)
79 qwk Donator Deutsch (German)
72 ETFbitcoin Legendary Development & Technical Discussion
66 Foxpup Legendary Meta
56 suchmoon Legendary Beginners & Help
56 suchmoon Legendary Trading Discussion
53 Halab Staff Français
50 paxmao Sr. Member Español (Spanish)
43 frodocooper Staff Mining
41 JayJuanGee Legendary Economics
38 EFS Staff Türkçe (Turkish)
30 Zebedee23 Legendary Announcements (Altcoins)
29 Flying Hellfish Staff Marketplace
19 bones261 Legendary Bitcoin Technical Support
18 Foxpup Legendary Bitcoin Discussion
16 Flying Hellfish Staff Politics & Society
13 hugeblack Sr. Member العربية (Arabic)
12 babo Legendary Italiano (Italian)
12 jovan85 Hero Member Marketplace (Altcoins)
11 citronick Legendary Mining (Altcoins)
11 Neelix Member Off-topic
10 d57heinz Legendary
10 Leonard2016 Hero Member Other languages/locations
10 mitzie Staff Eλληνικά (Greek)
7 mirakal Legendary Altcoin Discussion
6 sabotag3x Hero Member Português (Portuguese)
5 bones261 Legendary Speculation (Altcoins)
4 cryptovigi Member Polski
4 zororaka Copper Member Project Development
4 paxmao Sr. Member Serious discussion
4 Anon11073 Staff 日本語 (Japanese)
3 Barcode_ Staff 中文 (Chinese)
2 Daniel91 Legendary Hrvatski (Croatian)
2 theyoungmillionaire Full Member Pilipinas
1 QuadsPoker Copper Member Nederlands (Dutch)
1 NeuroticFish Legendary Română (Romanian) 60 1miau Full Member Deutsch (German)
44 logfiles Copper Member Beginners & Help
40 roycilik Sr. Member Bahasa Indonesia (Indonesian)
40 micgoossens Sr. Member Economics
37 gmaxwell Staff Development & Technical Discussion
36 Cĝbra Member Meta
31 buzzkillb Sr. Member Announcements (Altcoins)
30 tvplus006 Full Member Trading Discussion
25 victorhing Legendary Marketplace
20 philipma1957 Legendary Mining
18 gmaxwell Staff Bitcoin Discussion
18 Polkeins Member Pyccкий (Russian)
17 coins4commies Member Politics & Society
15 ChiNgadOr Full Member Español (Spanish)
15 TomCrypto Member Français
12 sunce33 Hero Member Marketplace (Altcoins)
12 HARDCRACKERS Full Member Türkçe (Turkish)
11 DireWolfM14 Member
11 VoskCoin Sr. Member Mining (Altcoins)
11 omer-jamal Member العربية (Arabic)
10 achow101 Staff Bitcoin Technical Support
8 theymos Administrator Off-topic
7 cheezcarls Sr. Member Altcoin Discussion
7 Micio Legendary Italiano (Italian)
6 #BitcoinCore Sr. Member Português (Portuguese)
6 Pmalek Hero Member Serious discussion
5 sheenshane Full Member Pilipinas
5 Dimitris Full Member Eλληνικά (Greek)
4 tactac Member 日本語 (Japanese)
3 cornl Copper Member Polski
3 Cryptotourist Jr. Member Speculation (Altcoins)
2 Ridwan Fauzi Member Project Development
1 eroejoe Member Hrvatski (Croatian)
1 sbogovac Legendary Nederlands (Dutch)
1 blokklanc Jr. Member Other languages/locations
1 coin8coin8 Member 中文 (Chinese) 10 Eλληνικά (Greek)
9 日本語 (Japanese)
56
72 Altcoin Discussion
191 Announcements (Altcoins)
271 Bahasa Indonesia (Indonesian)
150 Beginners & Help
133 Bitcoin Discussion
49 Bitcoin Technical Support
310 Deutsch (German)
297 Development & Technical Discussion
446 Economics
63 Español (Spanish)
93 Français
8 Hrvatski (Croatian)
26 Italiano (Italian)
386 Marketplace
29 Marketplace (Altcoins)
535 Meta
122 Mining
12 Mining (Altcoins)
1 Nederlands (Dutch)
24 Off-topic
11 Other languages/locations
11 Pilipinas
36 Politics & Society
5 Polski
19 Português (Portuguese)
9 Project Development
1 Română (Romanian)
5 Serious discussion
15 Speculation (Altcoins)
361 Trading Discussion
86 Türkçe (Turkish)
380 Pyccкий (Russian)
26 العربية (Arabic)
3 中文 (Chinese) Administrator 4
Copper Member 148
Donator 112
Full Member 467
Global Moderator 9
Hero Member 324
Jr. Member 109
Legendary 1831
Member 224
Newbie 32
Sr. Member 437
Staff 470 Administrator 35
Copper Member 236
Donator 74
Founder 2
Full Member 487
Hero Member 446
Jr. Member 326
Legendary 913
Member 502
Newbie 99
Sr. Member 614
Staff 101
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on February 22, 2019, 07:36:08 AM
The tool is now updated with the latest data from Friday 22th of February Here is the usual snapshot about the last week: Top Sender per board last week215 chimk Full Member Pyccкий (Russian)
152 dbshck Staff Bahasa Indonesia (Indonesian)
126 suchmoon Legendary Meta
115 qwk Donator Deutsch (German)
80 suchmoon Legendary Trading Discussion
65 Flying Hellfish Staff Marketplace
60 marcus_of_augustus Legendary Economics
59 frodocooper Staff Mining
47 bones261 Legendary Development & Technical Discussion
43 Halab Staff Français
32 teramit Legendary Türkçe (Turkish)
30 Micio Legendary Italiano (Italian)
24 dbshck Staff Beginners & Help
20 TimC Legendary Announcements (Altcoins)
16 dbshck Staff Bitcoin Discussion
12 bones261 Legendary Bitcoin Technical Support
12 suchmoon Legendary Mining (Altcoins)
12 sabotag3x Hero Member Português (Portuguese)
9 DdmrDdmr Sr. Member Español (Spanish)
8 hugeblack Sr. Member العربية (Arabic)
6 minersday Hero Member Altcoin Discussion
6 marlboroza Hero Member Hrvatski (Croatian)
6 Cyrus Administrator Off-topic
6 OmegaStarScream Staff Project Development
5 HasHe Hero Member Marketplace (Altcoins)
5 Flying Hellfish Staff Politics & Society
5 Tytanowy Janusz Member Polski
5 Cyrus Administrator Română (Romanian)
5 The Pharmacist Legendary Serious discussion
4 rickbig41 Global Moderator
3 cAPSLOCK Legendary Speculation (Altcoins)
2 BitMaxz Legendary Archival
2 amishmanish Sr. Member India
2 friends1980 Full Member Nederlands (Dutch)
2 cabalism13 Member Pilipinas
2 servicelabs Legendary 中文 (Chinese) 64 HairyMaclairy Hero Member Economics
55 DdmrDdmr Sr. Member Meta
43 Coolcryptovator Copper Member Trading Discussion
35 kawetsriyanto Jr. Member Bahasa Indonesia (Indonesian)
31 theymos Administrator Marketplace
28 Wind_FURY Hero Member Development & Technical Discussion
23 achow101 Staff Bitcoin Technical Support
20 ACP Hero Member Announcements (Altcoins)
19 MaoChao Legendary Pyccкий (Russian)
17 1miau Full Member Deutsch (German)
14 DdmrDdmr Sr. Member Beginners & Help
14 Artemis3 Jr. Member Mining
14 vycl87 Member Türkçe (Turkish)
13 cestmoi Newbie Français
11 cryptofrka Member Hrvatski (Croatian)
9 coinlocket$ Sr. Member Italiano (Italian)
8 figmentofmyass Hero Member Bitcoin Discussion
8 Lolliedieb Member Mining (Altcoins)
7 VB1001 Member Español (Spanish)
5 fortunecrypto Legendary Altcoin Discussion
5 Batalo Jr. Member Marketplace (Altcoins)
5 theymos_away Member Off-topic
5 coins4commies Member Politics & Society
5 3dOOm Copper Member Română (Romanian)
4 mprep Global Moderator Project Development
4 omer-jamal Member العربية (Arabic)
3 The Pharmacist Legendary
3 sheenshane Full Member Pilipinas
3 Tytanowy Janusz Member Polski
3 DeltaX_Slayer Full Member Português (Portuguese)
3 Foxpup Legendary Serious discussion
3 phishead Hero Member Speculation (Altcoins)
2 LoyceV Legendary Archival
2 QuadsPoker Copper Member Nederlands (Dutch)
1 avikz Legendary India
1 coly20032003 Member 中文 (Chinese) 5 Română (Romanian)
47 Archival
2 Nederlands (Dutch)
22
45 Altcoin Discussion
115 Announcements (Altcoins)
288 Bahasa Indonesia (Indonesian)
106 Beginners & Help
150 Bitcoin Discussion
54 Bitcoin Technical Support
288 Deutsch (German)
149 Development & Technical Discussion
612 Economics
20 Español (Spanish)
87 Français
31 Hrvatski (Croatian)
2 India
43 Italiano (Italian)
483 Marketplace
18 Marketplace (Altcoins)
499 Meta
129 Mining
50 Mining (Altcoins)
20 Off-topic
11 Pilipinas
19 Politics & Society
10 Polski
24 Português (Portuguese)
21 Project Development
19 Serious discussion
6 Speculation (Altcoins)
381 Trading Discussion
85 Türkçe (Turkish)
423 Pyccкий (Russian)
12 العربية (Arabic)
4 中文 (Chinese) Administrator 19
Copper Member 87
Donator 145
Full Member 505
Global Moderator 33
Hero Member 335
Jr. Member 81
Legendary 1752
Member 190
Newbie 22
Sr. Member 338
Staff 652 Administrator 85
Copper Member 223
Donator 18
Founder 5
Full Member 548
Global Moderator 38
Hero Member 495
Jr. Member 240
Legendary 910
Member 515
Newbie 81
Sr. Member 590
Staff 93
VIP 7
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on March 01, 2019, 08:59:03 AM
The tool is now updated with the latest data from Friday 1st of March Here is the usual snapshot about the last week: Top Sender per board last week 220 chimk Full Member Pyccкий (Russian)
151 dbshck Staff Bahasa Indonesia (Indonesian)
131 suchmoon Legendary Meta
117 Flying Hellfish Staff Marketplace
73 dbshck Staff Beginners & Help
69 qwk Donator Deutsch (German)
64 suchmoon Legendary Trading Discussion
63 frodocooper Staff Mining
56 suchmoon Legendary Serious discussion
50 romanornr Hero Member Project Development
43 bones261 Legendary Economics
43 Halab Staff Français
40 dbshck Staff Development & Technical Discussion
38 LoyceV Legendary Bitcoin Discussion
38 teramit Legendary Türkçe (Turkish)
33 Foxpup Legendary Politics & Society
24 ACP Hero Member Announcements (Altcoins)
12 hugeblack Sr. Member العربية (Arabic)
11 DdmrDdmr Sr. Member Español (Spanish)
11 malevolent Staff Polski
10 dbshck Staff Bitcoin Technical Support
10 sabotag3x Hero Member Português (Portuguese)
9 kenanzz Legendary Altcoin Discussion
6 Vod Legendary Off-topic
5 DdmrDdmr Sr. Member null
5 citronick Legendary Mining (Altcoins)
4 xandry Staff Română (Romanian)
3 Daniel91 Legendary Hrvatski (Croatian)
3 Piggy Hero Member Italiano (Italian)
3 theyoungmillionaire Full Member Pilipinas
3 Hueristic Legendary Speculation (Altcoins)
2 mu_enrico Copper Member 日本語 (Japanese)
1 jacktheking Legendary Archival
1 Heisenberg_Hunter Full Member India
1 Fredii Sr. Member Marketplace (Altcoins)
1 Raja_MBZ Hero Member Other languages/locations
1 Barcode_ Staff 中文 (Chinese)
142 TheNewAnon135246 Legendary Marketplace
96 Vtools Member Announcements (Altcoins)
65 theymos Administrator Meta
51 TheNewAnon135246 Legendary Project Development
41 LoyceV Legendary Trading Discussion
37 pandukelana2712 Sr. Member Bahasa Indonesia (Indonesian)
34 lulucrypto Member Français
29 Balthazar Legendary Politics & Society
23 Artemis3 Jr. Member Mining
22 qwk Donator Deutsch (German)
20 gmaxwell Staff Bitcoin Discussion
20 chimk Full Member Pyccкий (Russian)
19 HairyMaclairy Hero Member Economics
16 achow101 Staff Development & Technical Discussion
15 Jet Cash Legendary Serious discussion
13 Quintrix Newbie Altcoin Discussion
13 BitCryptex Sr. Member Bitcoin Technical Support
12 pooya87 Legendary Beginners & Help
11 mistersehmuz Jr. Member Türkçe (Turkish)
8 LUCKMCFLY Full Member Español (Spanish)
7 cryptovigi Member Polski
6 vit05 Sr. Member Português (Portuguese)
6 Kavelj22 Newbie العربية (Arabic)
5 tytanick Legendary Mining (Altcoins)
5 traderethereum Hero Member Off-topic
5 efrenbilantok Jr. Member Pilipinas
4 Paolo.Demidov Member Italiano (Italian)
4 3dOOm Copper Member Română (Romanian)
3 mocacinno Legendary null
2 Dzeronimo Member Hrvatski (Croatian)
2 Nestade Full Member Speculation (Altcoins)
2 tactac Member 日本語 (Japanese)
1 hugeblack Sr. Member Archival
1 eaLiTy Hero Member India
1 Alekseek Member Marketplace (Altcoins)
1 epidemia Jr. Member Other languages/locations
1 baobao2000 Member 中文 (Chinese)
4 Română (Romanian)
2 日本語 (Japanese)
23 null
78 Altcoin Discussion
207 Announcements (Altcoins)
313 Bahasa Indonesia (Indonesian)
240 Beginners & Help
165 Bitcoin Discussion
57 Bitcoin Technical Support
224 Deutsch (German)
122 Development & Technical Discussion
393 Economics
23 Español (Spanish)
116 Français
12 Hrvatski (Croatian)
1 India
9 Italiano (Italian)
509 Marketplace
7 Marketplace (Altcoins)
478 Meta
107 Mining
7 Mining (Altcoins)
20 Off-topic
2 Other languages/locations
12 Pilipinas
157 Politics & Society
15 Polski
21 Português (Portuguese)
62 Project Development
63 Serious discussion
13 Speculation (Altcoins)
511 Trading Discussion
78 Türkçe (Turkish)
430 Pyccкий (Russian)
24 العربية (Arabic)
1 中文 (Chinese)
Administrator 14
Copper Member 113
Donator 97
Full Member 535
Global Moderator 22
Hero Member 466
Jr. Member 99
Legendary 1661
Member 179
Newbie 20
Sr. Member 388
Staff 729
Administrator 70
Copper Member 214
Donator 33
Full Member 495
Global Moderator 10
Hero Member 364
Jr. Member 247
Legendary 1188
Member 572
Newbie 95
Sr. Member 676
Staff 102
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on March 08, 2019, 07:19:05 AM
The tool is now updated with the latest data from Friday 8th of March Here is the usual snapshot about the last week: Top Sender per board last week 249 dbshck Staff Bahasa Indonesia (Indonesian)
216 chimk Full Member Pyccкий (Russian)
140 suchmoon Legendary Development & Technical Discussion
140 suchmoon Legendary Meta
67 suchmoon Legendary Marketplace
59 JayJuanGee Legendary Economics
56 Halab Staff Français
55 frodocooper Staff Mining
50 BTCspace Hero Member Announcements (Altcoins)
50 Milquetoast Legendary Deutsch (German)
50 Antuam Legendary Español (Spanish)
44 suchmoon Legendary Bitcoin Discussion
39 suchmoon Legendary Project Development
36 dbshck Staff Beginners & Help
36 Micio Legendary Italiano (Italian)
33 suchmoon Legendary Politics & Society
25 suchmoon Legendary Trading Discussion
24 suchmoon Legendary Bitcoin Technical Support
21 EFS Staff Türkçe (Turkish)
20 BitCryptex Sr. Member Polski
12 suchmoon Legendary null
11 mitzie Staff Eλληνικά (Greek)
10 Hatuferu Legendary Speculation (Altcoins)
9 hugeblack Sr. Member العربية (Arabic)
7 Welsh Staff Serious discussion
5 TryNinja Hero Member Português (Portuguese)
4 dbshck Staff Altcoin Discussion
4 Coin-Desk Newbie Marketplace (Altcoins)
4 OgNasty Donator Mining (Altcoins)
4 suchmoon Legendary Pilipinas
4 Anon11073 Staff 日本語 (Japanese)
3 slackovic Full Member Hrvatski (Croatian)
2 Halab Staff India
1 leowonderful Legendary Archival
1 Jating Hero Member Off-topic
88 TheNewAnon135246 Legendary Marketplace
71 LoyceV Legendary Meta
63 nullCoiner Sr. Member Deutsch (German)
57 gmaxwell Staff Development & Technical Discussion
50 Roman1974 Hero Member Español (Spanish)
42 abhiseshakana Full Member Bahasa Indonesia (Indonesian)
38 CryptopreneurBrainboss Member Beginners & Help
29 SaltySpitoon Legendary Politics & Society
29 cryptovigi Member Polski
28 Vod Legendary Project Development
23 A-Bolt Hero Member Pyccкий (Russian)
22 fillippone Member Economics
22 rig4hodlers Full Member Marketplace (Altcoins)
21 mikeywith Member Mining
20 Halab Staff null
18 HCP Hero Member Bitcoin Technical Support
15 lulucrypto Member Français
14 gospodin Member Türkçe (Turkish)
13 suchmoon Legendary Trading Discussion
12 o_e_l_e_o Sr. Member Bitcoin Discussion
12 duesoldi Sr. Member Italiano (Italian)
10 Verdell Full Member Announcements (Altcoins)
7 Kavelj22 Newbie العربية (Arabic)
6 Heisenberg_Hunter Full Member Serious discussion
5 mindrust Legendary Speculation (Altcoins)
4 dumplingsandsushi Member Altcoin Discussion
4 I.Grozni Sr. Member Hrvatski (Croatian)
4 trexminer Jr. Member Mining (Altcoins)
4 nc50lc Full Member Pilipinas
3 Loganota Hero Member Português (Portuguese)
2 rangnatht Full Member India
2 Satosi Nakyamoto Newbie 日本語 (Japanese)
1 TheNewAnon135246 Legendary Archival
1 rdbase Full Member Off-topic
68 null
51 Altcoin Discussion
108 Announcements (Altcoins)
1 Archival
354 Bahasa Indonesia (Indonesian)
203 Beginners & Help
213 Bitcoin Discussion
113 Bitcoin Technical Support
216 Deutsch (German)
254 Development & Technical Discussion
354 Economics
103 Español (Spanish)
76 Français
14 Hrvatski (Croatian)
3 India
65 Italiano (Italian)
484 Marketplace
48 Marketplace (Altcoins)
785 Meta
122 Mining
21 Mining (Altcoins)
2 Off-topic
9 Pilipinas
82 Politics & Society
81 Polski
9 Português (Portuguese)
100 Project Development
18 Serious discussion
28 Speculation (Altcoins)
246 Trading Discussion
55 Türkçe (Turkish)
11 Eλληνικά (Greek)
459 Pyccкий (Russian)
35 العربية (Arabic)
5 日本語 (Japanese)
Administrator 6
Copper Member 87
Donator 62
Full Member 436
Global Moderator 13
Hero Member 401
Jr. Member 71
Legendary 1930
Member 208
Newbie 32
Sr. Member 485
Staff 919
Administrator 16
Copper Member 134
Donator 20
Full Member 640
Global Moderator 9
Hero Member 535
Jr. Member 259
Legendary 1134
Member 568
Newbie 72
Sr. Member 833
Staff 162
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on March 15, 2019, 08:09:59 AM
The tool is now updated with the latest data from Friday 15th of March Here is the usual snapshot about the last week: Top Sender per board last week 220 chimk Full Member Pyccкий (Russian)
151 dbshck Staff Bahasa Indonesia (Indonesian)
131 suchmoon Legendary Meta
117 Flying Hellfish Staff Marketplace
73 dbshck Staff Beginners & Help
69 qwk Donator Deutsch (German)
64 suchmoon Legendary Trading Discussion
63 frodocooper Staff Mining
56 suchmoon Legendary Serious discussion
50 romanornr Hero Member Project Development
43 bones261 Legendary Economics
43 Halab Staff Français
40 dbshck Staff Development & Technical Discussion
38 LoyceV Legendary Bitcoin Discussion
38 teramit Legendary Türkçe (Turkish)
33 Foxpup Legendary Politics & Society
24 ACP Hero Member Announcements (Altcoins)
12 hugeblack Sr. Member العربية (Arabic)
11 DdmrDdmr Sr. Member Español (Spanish)
11 malevolent Staff Polski
10 dbshck Staff Bitcoin Technical Support
10 sabotag3x Hero Member Português (Portuguese)
9 kenanzz Legendary Altcoin Discussion
6 Vod Legendary Off-topic
5 DdmrDdmr Sr. Member null
5 citronick Legendary Mining (Altcoins)
4 xandry Staff Română (Romanian)
3 Daniel91 Legendary Hrvatski (Croatian)
3 Piggy Hero Member Italiano (Italian)
3 theyoungmillionaire Full Member Pilipinas
3 Hueristic Legendary Speculation (Altcoins)
2 mu_enrico Copper Member 日本語 (Japanese)
1 jacktheking Legendary Archival
1 Heisenberg_Hunter Full Member India
1 Fredii Sr. Member Marketplace (Altcoins)
1 Raja_MBZ Hero Member Other languages/locations
1 Barcode_ Staff 中文 (Chinese)
142 TheNewAnon135246 Legendary Marketplace
96 Vtools Member Announcements (Altcoins)
65 theymos Administrator Meta
51 TheNewAnon135246 Legendary Project Development
41 LoyceV Legendary Trading Discussion
37 pandukelana2712 Sr. Member Bahasa Indonesia (Indonesian)
34 lulucrypto Member Français
29 Balthazar Legendary Politics & Society
23 Artemis3 Jr. Member Mining
22 qwk Donator Deutsch (German)
20 gmaxwell Staff Bitcoin Discussion
20 chimk Full Member Pyccкий (Russian)
19 HairyMaclairy Hero Member Economics
16 achow101 Staff Development & Technical Discussion
15 Jet Cash Legendary Serious discussion
13 Quintrix Newbie Altcoin Discussion
13 BitCryptex Sr. Member Bitcoin Technical Support
12 pooya87 Legendary Beginners & Help
11 mistersehmuz Jr. Member Türkçe (Turkish)
8 LUCKMCFLY Full Member Español (Spanish)
7 cryptovigi Member Polski
6 vit05 Sr. Member Português (Portuguese)
6 Kavelj22 Newbie العربية (Arabic)
5 tytanick Legendary Mining (Altcoins)
5 traderethereum Hero Member Off-topic
5 efrenbilantok Jr. Member Pilipinas
4 Paolo.Demidov Member Italiano (Italian)
4 3dOOm Copper Member Română (Romanian)
3 mocacinno Legendary null
2 Dzeronimo Member Hrvatski (Croatian)
2 Nestade Full Member Speculation (Altcoins)
2 tactac Member 日本語 (Japanese)
1 hugeblack Sr. Member Archival
1 eaLiTy Hero Member India
1 Alekseek Member Marketplace (Altcoins)
1 epidemia Jr. Member Other languages/locations
1 baobao2000 Member 中文 (Chinese)
4 Română (Romanian)
2 日本語 (Japanese)
23 null
78 Altcoin Discussion
207 Announcements (Altcoins)
313 Bahasa Indonesia (Indonesian)
240 Beginners & Help
165 Bitcoin Discussion
57 Bitcoin Technical Support
224 Deutsch (German)
122 Development & Technical Discussion
393 Economics
23 Español (Spanish)
116 Français
12 Hrvatski (Croatian)
1 India
9 Italiano (Italian)
509 Marketplace
7 Marketplace (Altcoins)
478 Meta
107 Mining
7 Mining (Altcoins)
20 Off-topic
2 Other languages/locations
12 Pilipinas
157 Politics & Society
15 Polski
21 Português (Portuguese)
62 Project Development
63 Serious discussion
13 Speculation (Altcoins)
511 Trading Discussion
78 Türkçe (Turkish)
430 Pyccкий (Russian)
24 العربية (Arabic)
1 中文 (Chinese)
Administrator 14
Copper Member 113
Donator 97
Full Member 535
Global Moderator 22
Hero Member 466
Jr. Member 99
Legendary 1661
Member 179
Newbie 20
Sr. Member 388
Staff 729
Administrator 70
Copper Member 214
Donator 33
Full Member 495
Global Moderator 10
Hero Member 364
Jr. Member 247
Legendary 1188
Member 572
Newbie 95
Sr. Member 676
Staff 102
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on March 22, 2019, 07:16:13 AM
The tool is now updated with the latest data from Friday 22th of March Here is the usual snapshot about the last week: Top Sender per board last week 171 chimk Full Member Pyccкий (Russian)
113 dbshck Staff Bahasa Indonesia (Indonesian)
90 suchmoon Legendary Bitcoin Technical Support
73 frodocooper Staff Mining
60 suchmoon Legendary Trading Discussion
58 Foxpup Legendary Meta
53 Welsh Staff Development & Technical Discussion
50 Jonesd Legendary Announcements (Altcoins)
46 JayJuanGee Legendary Economics
36 suchmoon Legendary Marketplace
29 trumpc2016 Sr. Member Beginners & Help
29 Halab Staff Français
29 Welsh Staff Serious discussion
28 paxmao Sr. Member Español (Spanish)
24 dbshck Staff Off-topic
20 Claymore Donator Mining (Altcoins)
18 1miau Full Member Deutsch (German)
18 BitCryptex Sr. Member Polski
13 hugeblack Sr. Member العربية (Arabic)
12 suchmoon Legendary Politics & Society
12 Vod Legendary Project Development
11 shimbark123 Sr. Member Altcoin Discussion
10 minersday Hero Member Bitcoin Discussion
10 Rahman11 Sr. Member Marketplace (Altcoins)
8 babo Legendary Italiano (Italian)
8 sabotag3x Hero Member Português (Portuguese)
7 hunterwolf Legendary Türkçe (Turkish)
5 mirakal Legendary null
5 kenanzz Legendary Pilipinas
4 Russlenat Hero Member Speculation (Altcoins)
4 tactac Member 日本語 (Japanese)
3 Barcode_ Staff 中文 (Chinese)
2 big_daddy Full Member Hrvatski (Croatian)
1 LoyceV Legendary Nederlands (Dutch)
84 monkeynuts Legendary Marketplace
61 micgoossens Sr. Member Economics
52 mikeywith Member Mining
50 romanornr Hero Member Announcements (Altcoins)
35 roycilik Sr. Member Bahasa Indonesia (Indonesian)
33 blockchain2k Jr. Member Beginners & Help
33 The Pharmacist Legendary Trading Discussion
32 LoyceV Legendary Meta
31 mocacinno Legendary Bitcoin Technical Support
24 ETFbitcoin Legendary Development & Technical Discussion
21 StartupAnalyst Jr. Member Pyccкий (Russian)
18 Tytanowy Janusz Member Polski
16 Lafu Hero Member Deutsch (German)
12 DdmrDdmr Sr. Member Español (Spanish)
10 Hellmouth42 Full Member Français
10 RuMiner Jr. Member Mining (Altcoins)
10 o_e_l_e_o Sr. Member Off-topic
9 omer-jamal Member العربية (Arabic)
8 coinlocket$ Sr. Member Italiano (Italian)
8 sabotag3x Hero Member Português (Portuguese)
8 Jet Cash Legendary Serious discussion
7 Quickseller Copper Member null
6 o_e_l_e_o Sr. Member Bitcoin Discussion
6 sheenshane Full Member Pilipinas
6 theymos Administrator Politics & Society
6 hatshepsut93 Hero Member Project Development
6 wumBowo Sr. Member Speculation (Altcoins)
6 ekiller Hero Member Türkçe (Turkish)
5 Nestade Full Member Altcoin Discussion
4 Hhampuz Hero Member Marketplace (Altcoins)
2 Pmalek Hero Member Hrvatski (Croatian)
2 kazuki.t Member 日本語 (Japanese)
1 bit my coin Newbie Nederlands (Dutch)
1 baobao2000 Member 中文 (Chinese)
36 null
85 Altcoin Discussion
173 Announcements (Altcoins)
246 Bahasa Indonesia (Indonesian)
114 Beginners & Help
126 Bitcoin Discussion
164 Bitcoin Technical Support
138 Deutsch (German)
316 Development & Technical Discussion
507 Economics
42 Español (Spanish)
54 Français
4 Hrvatski (Croatian)
18 Italiano (Italian)
512 Marketplace
29 Marketplace (Altcoins)
484 Meta
209 Mining
40 Mining (Altcoins)
1 Nederlands (Dutch)
30 Off-topic
29 Pilipinas
38 Politics & Society
55 Polski
20 Português (Portuguese)
38 Project Development
24 Serious discussion
21 Speculation (Altcoins)
377 Trading Discussion
20 Türkçe (Turkish)
392 Pyccкий (Russian)
35 العربية (Arabic)
4 中文 (Chinese)
6 日本語 (Japanese)
Administrator 27
Copper Member 109
Donator 50
Full Member 414
Global Moderator 4
Hero Member 417
Jr. Member 76
Legendary 1706
Member 267
Newbie 24
Sr. Member 473
Staff 609
Administrator 12
Copper Member 171
Donator 30
Founder 12
Full Member 546
Global Moderator 10
Hero Member 482
Jr. Member 239
Legendary 990
Member 602
Newbie 90
Sr. Member 592
Staff 82
VIP 1
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: cryptovigi on March 31, 2019, 01:49:01 AM
Hey Piggy - have you abandoned this project? Every Friday I fall into https://albertoit.github.io/Merit-Explorer-SQL/ checking local subboard statistics to see how the merit situation looks on our local subboard looks like, and this week there are no new statistics ...
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on March 31, 2019, 05:23:29 AM
Hi, i was not able to update it this weekend, but i'll do it tomorrow morning.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on April 02, 2019, 06:30:03 AM
The tool is now updated with the latest data from Friday 29th of March Here is the usual snapshot about the last week: Top Sender per board last week 179 chimk Full Member Pyccкий (Russian)
150 qwk Donator Deutsch (German)
120 TMAN Hero Member Marketplace
119 suchmoon Legendary Meta
76 dbshck Staff Bahasa Indonesia (Indonesian)
76 EFS Staff Türkçe (Turkish)
55 tk808 Hero Member Altcoin Discussion
54 suchmoon Legendary Beginners & Help
48 Foxpup Legendary Bitcoin Discussion
47 frodocooper Staff Mining (Altcoins)
46 suchmoon Legendary Trading Discussion
42 bones261 Legendary Development & Technical Discussion
40 frodocooper Staff Mining
39 JayJuanGee Legendary Economics
27 Halab Staff Français
27 suchmoon Legendary Politics & Society
25 frodocooper Staff null
21 Vlad2Vlad Legendary Announcements (Altcoins)
20 Dobrii Sr. Member Marketplace (Altcoins)
20 Vod Legendary Project Development
19 suchmoon Legendary Italiano (Italian)
18 Tytanowy Janusz Member Polski
15 Foxpup Legendary Off-topic
13 hugeblack Sr. Member العربية (Arabic)
12 Foxpup Legendary Bitcoin Technical Support
12 DdmrDdmr Sr. Member Español (Spanish)
11 Ryker1 Sr. Member Pilipinas
9 suchmoon Legendary Serious discussion
8 dbshck Staff Archival
6 sabotag3x Hero Member Português (Portuguese)
4 Natalim Hero Member Speculation (Altcoins)
2 big_daddy Full Member Hrvatski (Croatian)
2 Nozomu Nakazato Jr. Member 日本語 (Japanese)
1 amishmanish Sr. Member India
1 Barcode_ Staff 中文 (Chinese)
177 BitcoinPenny Legendary Marketplace
80 tk808 Hero Member Meta
61 LoyceV Legendary Trading Discussion
56 Eliovp Legendary Mining (Altcoins)
50 korvas128 Hero Member Announcements (Altcoins)
50 Aerys2 Sr. Member Marketplace (Altcoins)
39 FontSeli Jr. Member Pyccкий (Russian)
31 Quickseller Copper Member Beginners & Help
29 micgoossens Sr. Member Economics
27 tk808 Hero Member Altcoin Discussion
26 1miau Full Member Deutsch (German)
24 roycilik Sr. Member Bahasa Indonesia (Indonesian)
24 PHI1618 Sr. Member Türkçe (Turkish)
23 achow101 Staff Development & Technical Discussion
21 fillippone Member Italiano (Italian)
20 odolvlobo Legendary Off-topic
19 theyoungmillionaire Full Member Pilipinas
18 squatz1 Hero Member Politics & Society
15 cryptovigi Member Polski
14 ETFbitcoin Legendary Bitcoin Discussion
13 stompix Hero Member null
13 sarcheer Copper Member Mining
12 GrosWesh Jr. Member Français
11 nc50lc Full Member Bitcoin Technical Support
11 Vod Legendary Project Development
9 bitperson Member Serious discussion
9 omer-jamal Member العربية (Arabic)
6 Royse777 Hero Member Archival
6 DdmrDdmr Sr. Member Español (Spanish)
5 Loganota Hero Member Português (Portuguese)
2 Remainder Hero Member Speculation (Altcoins)
1 Keeshan Member Hrvatski (Croatian)
1 smileflowers Jr. Member 中文 (Chinese)
2 日本語 (Japanese)
96 null
174 Altcoin Discussion
169 Announcements (Altcoins)
13 Archival
221 Bahasa Indonesia (Indonesian)
185 Beginners & Help
171 Bitcoin Discussion
29 Bitcoin Technical Support
267 Deutsch (German)
209 Development & Technical Discussion
419 Economics
29 Español (Spanish)
63 Français
5 Hrvatski (Croatian)
1 India
43 Italiano (Italian)
726 Marketplace
207 Marketplace (Altcoins)
573 Meta
93 Mining
137 Mining (Altcoins)
12 Off-topic
68 Pilipinas
107 Politics & Society
64 Polski
17 Português (Portuguese)
41 Project Development
41 Serious discussion
11 Speculation (Altcoins)
386 Trading Discussion
129 Türkçe (Turkish)
398 Pyccкий (Russian)
37 العربية (Arabic)
1 中文 (Chinese)
Administrator 5
Copper Member 128
Donator 204
Full Member 417
Global Moderator 23
Hero Member 605
Jr. Member 115
Legendary 1957
Member 299
Newbie 42
Sr. Member 416
Staff 561
Administrator 5
Copper Member 135
Donator 31
Full Member 618
Global Moderator 8
Hero Member 693
Jr. Member 296
Legendary 1320
Member 603
Newbie 118
Sr. Member 699
Staff 135
VIP 1
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: jademaxsuy on April 03, 2019, 06:20:10 AM
Nice job being done with OP, The circulation of merits has seen visible over time. The good thing is that my country the Philippines has been involve and some of the locals has started to circulate and run the merit. This is better now compared to before that most usera were hoarding smerits.
Just because of the statistical data presented more users will going to encourage to send reward merits on those deserving post to be merited.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: coinluck43 on April 03, 2019, 09:28:29 AM
When again upcoming update
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on April 03, 2019, 09:33:08 AM
When again upcoming update
Ideally every friday, when the merit data file get released.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on April 08, 2019, 10:23:01 AM
The tool is now updated with the latest data from Friday 5th of April Here is the usual snapshot about the last week: Top Sender per board last week 407 chimk Full Member Pyccкий (Russian)
261 Flying Hellfish Staff Marketplace
182 dbshck Staff Bahasa Indonesia (Indonesian)
101 frodocooper Staff Mining
95 Foxpup Legendary Meta
66 dbshck Staff Beginners & Help
65 600watt Legendary Economics
62 suchmoon Legendary Trading Discussion
55 crazyearner Legendary Announcements (Altcoins)
50 theymos Administrator null
40 Foxpup Legendary Altcoin Discussion
40 qwk Donator Deutsch (German)
36 Halab Staff Français
32 Micio Legendary Italiano (Italian)
23 dbshck Staff Development & Technical Discussion
23 CjMapope Legendary Mining (Altcoins)
22 paxmao Sr. Member Español (Spanish)
21 PHI1618 Sr. Member Türkçe (Turkish)
18 HCP Hero Member Bitcoin Technical Support
18 dbshck Staff Serious discussion
17 Foxpup Legendary Bitcoin Discussion
16 dbshck Staff Pilipinas
15 hugeblack Sr. Member العربية (Arabic)
13 af_newbie Legendary Politics & Society
11 Zeta0S Legendary Nederlands (Dutch)
11 sabotag3x Hero Member Português (Portuguese)
11 LoyceV Legendary Project Development
7 dzyk Legendary Off-topic
4 adamvp Hero Member Polski
3 Daniel91 Legendary Hrvatski (Croatian)
3 amishmanish Sr. Member India
2 CjMapope Legendary Marketplace (Altcoins)
2 Remainder Hero Member Speculation (Altcoins)
2 mitzie Staff Eλληνικά (Greek)
2 Rami84 Full Member 中文 (Chinese)
2 Anon11073 Staff 日本語 (Japanese)
1 Raja_MBZ Hero Member Other languages/locations
95 theymos Administrator Meta
61 Halab Staff null
60 BitcoinPenny Legendary Marketplace
47 VB1001 Member Economics
47 Artemis3 Jr. Member Mining
37 elda34b Member Bahasa Indonesia (Indonesian)
34 Coding Enthusiast Sr. Member Bitcoin Technical Support
29 igor72 Member Pyccкий (Russian)
27 TalkStar Copper Member Beginners & Help
27 lovesmayfamilis Member Trading Discussion
23 qwk Donator Deutsch (German)
22 achow101 Staff Development & Technical Discussion
21 Micio Legendary Italiano (Italian)
18 Artemis3 Jr. Member Politics & Society
16 nlaara12 Jr. Member Altcoin Discussion
13 Saint-loup Sr. Member Français
12 stompix Hero Member Bitcoin Discussion
12 AdoboCandies Member Pilipinas
12 Vod Legendary Project Development
11 Yoshi Livo Sr. Member Nederlands (Dutch)
10 VeilDango Copper Member Announcements (Altcoins)
9 DdmrDdmr Sr. Member Español (Spanish)
8 mikeywith Member العربية (Arabic)
5 adamvp Hero Member Polski
5 Btcturk.com Sr. Member Türkçe (Turkish)
4 Pmalek Hero Member Hrvatski (Croatian)
4 LTU_btc Hero Member Serious discussion
3 Coinbaker_criptobakery Newbie Mining (Altcoins)
3 Lucasgabd Full Member Português (Portuguese)
2 BitMaxz Legendary Marketplace (Altcoins)
2 Last of the V8s Legendary Off-topic
2 CryptopreneurBrainboss Member Other languages/locations
2 richminded Sr. Member Speculation (Altcoins)
2 hakka Member 日本語 (Japanese)
1 JSRAW Jr. Member India
2 Eλληνικά (Greek)
2 中文 (Chinese)
106 null
152 Altcoin Discussion
134 Announcements (Altcoins)
327 Bahasa Indonesia (Indonesian)
194 Beginners & Help
120 Bitcoin Discussion
102 Bitcoin Technical Support
190 Deutsch (German)
144 Development & Technical Discussion
665 Economics
59 Español (Spanish)
79 Français
4 Hrvatski (Croatian)
4 India
87 Italiano (Italian)
713 Marketplace
24 Marketplace (Altcoins)
800 Meta
244 Mining
42 Mining (Altcoins)
12 Nederlands (Dutch)
16 Off-topic
3 Other languages/locations
44 Pilipinas
100 Politics & Society
19 Polski
11 Português (Portuguese)
20 Project Development
20 Serious discussion
15 Speculation (Altcoins)
314 Trading Discussion
45 Türkçe (Turkish)
613 Pyccкий (Russian)
42 العربية (Arabic)
3 日本語 (Japanese)
Administrator 118
Copper Member 199
Donator 117
Full Member 753
Global Moderator 37
Hero Member 515
Jr. Member 85
Legendary 1778
Member 307
Newbie 31
Sr. Member 460
Staff 907
Administrator 97
Copper Member 258
Donator 35
Founder 9
Full Member 637
Global Moderator 20
Hero Member 550
Jr. Member 344
Legendary 1124
Member 670
Newbie 95
Sr. Member 823
Staff 234
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on April 12, 2019, 09:03:12 AM
The tool is now updated with the latest data from Friday 12th of April Here is the usual snapshot about the last week: Top Sender per board last week 165 StarenseN Legendary Français
127 suchmoon Legendary Beginners & Help
115 Flying Hellfish Staff Marketplace
103 chimk Full Member Pyccкий (Russian)
98 dbshck Staff Bahasa Indonesia (Indonesian)
89 ETFbitcoin Legendary Development & Technical Discussion
74 Foxpup Legendary Meta
61 frodocooper Staff Mining
56 JayJuanGee Legendary Economics
36 suchmoon Legendary Politics & Society
27 Foxpup Legendary Bitcoin Discussion
27 suchmoon Legendary Trading Discussion
22 Welsh Staff Serious discussion
20 Claymore Donator Mining (Altcoins)
18 suchmoon Legendary Altcoin Discussion
18 malevolent Staff Polski
18 EFS Staff Türkçe (Turkish)
16 thandie Legendary Deutsch (German)
13 julerz12 Sr. Member Pilipinas
12 paxmao Sr. Member Español (Spanish)
11 Foxpup Legendary Bitcoin Technical Support
10 pallas Legendary Announcements (Altcoins)
10 amishmanish Sr. Member Off-topic
9 Plutosky Member Italiano (Italian)
9 Vod Legendary Project Development
6 marlboroza Hero Member Hrvatski (Croatian)
6 mikeywith Member العربية (Arabic)
5 Sharon121212 Newbie null
3 avikz Legendary India
3 TryNinja Hero Member Português (Portuguese)
3 tactac Member 日本語 (Japanese)
2 Ini35 Jr. Member Marketplace (Altcoins)
2 dumplingsandsushi Member Speculation (Altcoins)
1 ChiBitCTy Sr. Member Archival
1 cryptofarid10 Jr. Member Other languages/locations
89 nopara73 Newbie Development & Technical Discussion
75 LoyceV Legendary Meta
68 cestmoi Newbie Français
61 abhiseshakana Full Member Bahasa Indonesia (Indonesian)
38 Toxic2040 Sr. Member Economics
36 Spazzer Full Member Marketplace
31 Eliovp Legendary Mining (Altcoins)
25 tmfp Legendary Trading Discussion
21 CryptopreneurBrainboss Member Beginners & Help
20 achow101 Staff Bitcoin Technical Support
19 Xal0lex Staff Pyccкий (Russian)
18 fronti Legendary Deutsch (German)
14 squatter Hero Member Bitcoin Discussion
14 darklus123 Hero Member Politics & Society
13 nlaara12 Jr. Member Altcoin Discussion
13 Tytanowy Janusz Member Polski
12 Plutosky Member Italiano (Italian)
12 stompix Hero Member Mining
11 sidehack Legendary Announcements (Altcoins)
11 Carlton Banks Legendary Serious discussion
10 QuestionAuthority Legendary Off-topic
10 GreatArkansas Full Member Pilipinas
10 trendcoin Jr. Member Türkçe (Turkish)
9 Kavelj22 Newbie العربية (Arabic)
7 VB1001 Member Español (Spanish)
7 yegor256 Newbie Project Development
5 Husna QA Full Member null
3 Hhampuz Hero Member Archival
3 Daniel91 Legendary Hrvatski (Croatian)
3 Jadesola Newbie Marketplace (Altcoins)
3 schiavonxv Hero Member Português (Portuguese)
3 sana54210 Legendary Speculation (Altcoins)
3 Anon11073 Staff 日本語 (Japanese)
2 Guvn0r Sr. Member India
31 Off-topic
38 null
97 Altcoin Discussion
97 Announcements (Altcoins)
5 Archival
262 Bahasa Indonesia (Indonesian)
226 Beginners & Help
85 Bitcoin Discussion
94 Bitcoin Technical Support
120 Deutsch (German)
382 Development & Technical Discussion
470 Economics
25 Español (Spanish)
306 Français
15 Hrvatski (Croatian)
6 India
55 Italiano (Italian)
500 Marketplace
15 Marketplace (Altcoins)
635 Meta
115 Mining
75 Mining (Altcoins)
1 Other languages/locations
51 Pilipinas
62 Politics & Society
53 Polski
6 Português (Portuguese)
31 Project Development
27 Serious discussion
11 Speculation (Altcoins)
285 Trading Discussion
43 Türkçe (Turkish)
320 Pyccкий (Russian)
28 العربية (Arabic)
4 日本語 (Japanese)
Administrator 35
Copper Member 121
Donator 79
Full Member 348
Global Moderator 35
Hero Member 375
Jr. Member 94
Legendary 1989
Member 248
Newbie 48
Sr. Member 456
Staff 631
Administrator 49
Copper Member 214
Donator 14
Full Member 563
Global Moderator 6
Hero Member 502
Jr. Member 218
Legendary 1047
Member 508
Newbie 245
Sr. Member 603
Staff 162
VIP 2
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on April 19, 2019, 06:55:46 AM
Usual data updates across all tools are going to be late and posponed to the next week due to easter holidays.
I will update everything next Wednesday.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on April 26, 2019, 06:10:08 AM
The tool is now updated with the latest data from Friday 26th of April Here is the usual snapshot about the last week: Top Sender per board last week 124 chimk Full Member Pyccкий (Russian)
105 dbshck Staff Bahasa Indonesia (Indonesian)
64 suchmoon Legendary Trading Discussion
59 JayJuanGee Legendary Economics
57 Foxpup Legendary Marketplace
57 frodocooper Staff Mining
53 Welsh Staff Development & Technical Discussion
46 dbshck Staff Meta
45 Halab Staff Français
29 paxmao Sr. Member Español (Spanish)
28 suchmoon Legendary Politics & Society
27 Vlad2Vlad Legendary Announcements (Altcoins)
25 EFS Staff Türkçe (Turkish)
19 DdmrDdmr Sr. Member Beginners & Help
19 DoublerHunter Hero Member Pilipinas
18 bones261 Legendary Bitcoin Technical Support
18 Bojcha Hero Member Mining (Altcoins)
17 mikeywith Member العربية (Arabic)
15 Micio Legendary null
12 Micio Legendary Italiano (Italian)
11 1miau Full Member Deutsch (German)
10 sabotag3x Hero Member Português (Portuguese)
9 Welsh Staff Serious discussion
8 DarkStar_ Legendary Polski
7 Vladdirescu87 Sr. Member Bitcoin Discussion
6 tyz Legendary Marketplace (Altcoins)
5 xxxgbxxx Member Hrvatski (Croatian)
5 sunce33 Hero Member Off-topic
4 bonker Hero Member Altcoin Discussion
2 QWeB Member Archival
2 IconFirm Hero Member Project Development
2 Bitcotalk Hero Member Speculation (Altcoins)
1 avikz Legendary India
1 bitart Hero Member Other languages/locations
77 theymos Administrator Meta
71 AdolfinWolf Hero Member Trading Discussion
67 abhiseshakana Full Member Bahasa Indonesia (Indonesian)
58 coinlocket$ Sr. Member null
50 btctrad0r Member Development & Technical Discussion
50 TheNewAnon135246 Legendary Marketplace
30 tbct_mt2 Full Member Beginners & Help
30 theymos Administrator Politics & Society
26 Toxic2040 Sr. Member Economics
26 sheenshane Full Member Pilipinas
26 IeSua Hero Member Pyccкий (Russian)
23 Limx Dev Copper Member Announcements (Altcoins)
22 1miau Full Member Deutsch (German)
21 Eliovp Legendary Mining (Altcoins)
18 DdmrDdmr Sr. Member Español (Spanish)
17 HCP Hero Member Bitcoin Technical Support
14 Artemis3 Jr. Member Mining
12 Bokile Jr. Member Hrvatski (Croatian)
12 Zwei Member العربية (Arabic)
11 Prott Jr. Member Türkçe (Turkish)
10 GrosWesh Jr. Member Français
10 amicrypto Newbie Off-topic
9 Tytanowy Janusz Member Polski
8 fillippone Member Italiano (Italian)
7 Korkorjkk Jr. Member Altcoin Discussion
5 odolvlobo Legendary Bitcoin Discussion
5 Ayms Member Marketplace (Altcoins)
5 Heisenberg_Hunter Full Member Serious discussion
2 Loganota Hero Member Português (Portuguese)
2 TryNinja Hero Member Project Development
2 fullhdpixel Hero Member Speculation (Altcoins)
1 A-Bolt Hero Member Archival
1 SaShiRaJaVu Hero Member India
1 Uhu77miner Newbie Other languages/locations
17 Serious discussion
160 null
50 Altcoin Discussion
147 Announcements (Altcoins)
3 Archival
337 Bahasa Indonesia (Indonesian)
195 Beginners & Help
56 Bitcoin Discussion
82 Bitcoin Technical Support
141 Deutsch (German)
271 Development & Technical Discussion
378 Economics
57 Español (Spanish)
94 Français
65 Hrvatski (Croatian)
1 India
34 Italiano (Italian)
590 Marketplace
16 Marketplace (Altcoins)
383 Meta
109 Mining
52 Mining (Altcoins)
26 Off-topic
1 Other languages/locations
70 Pilipinas
198 Politics & Society
29 Polski
13 Português (Portuguese)
6 Project Development
7 Speculation (Altcoins)
388 Trading Discussion
47 Türkçe (Turkish)
349 Pyccкий (Russian)
65 العربية (Arabic)
Administrator 10
Copper Member 120
Donator 36
Full Member 448
Global Moderator 44
Hero Member 456
Jr. Member 109
Legendary 1562
Member 278
Newbie 44
Sr. Member 410
Staff 626
Administrator 109
Copper Member 233
Donator 17
Founder 8
Full Member 586
Global Moderator 7
Hero Member 537
Jr. Member 265
Legendary 852
Member 539
Newbie 107
Sr. Member 529
Staff 57
VIP 1
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on May 06, 2019, 05:53:18 AM
The tool is now updated with the latest data from Friday 3th of May Here is the usual snapshot about the last week: Top Sender per board last week 430 chimk Full Member Pyccкий (Russian)
131 qwk Donator Deutsch (German)
102 dbshck Staff Bahasa Indonesia (Indonesian)
99 suchmoon Legendary Trading Discussion
74 frodocooper Staff Mining
62 Foxpup Legendary Meta
58 Welsh Staff Beginners & Help
58 DarkStar_ Legendary Marketplace
50 AngusCanine Legendary Altcoin Discussion
46 Halab Staff Français
46 squatz1 Hero Member Politics & Society
40 theymos Administrator null
36 JayJuanGee Legendary Economics
29 DarkStar_ Legendary Development & Technical Discussion
21 crwth Sr. Member Pilipinas
20 supercops Hero Member Announcements (Altcoins)
17 AverageGlabella Full Member Serious discussion
12 Mr.Ease Hero Member Project Development
10 Claymore Donator Mining (Altcoins)
10 sabotag3x Hero Member Português (Portuguese)
8 DdmrDdmr Sr. Member Español (Spanish)
8 hugeblack Sr. Member العربية (Arabic)
6 Jet Cash Legendary Bitcoin Technical Support
6 pickupcoin Legendary Hrvatski (Croatian)
5 BitHodler Legendary Bitcoin Discussion
5 babo Legendary Italiano (Italian)
5 cintrondigital Hero Member Marketplace (Altcoins)
5 peterspijzer Sr. Member Nederlands (Dutch)
5 Hhampuz Hero Member Off-topic
5 moofie Jr. Member Speculation (Altcoins)
5 BitcoinTurk Sr. Member Türkçe (Turkish)
4 malevolent Staff Polski
1 Heisenberg_Hunter Full Member India
1 BitCoinDream Legendary Other languages/locations
1 mo Legendary 中文 (Chinese)
1 hakka Member 日本語 (Japanese)
71 ICOEthics Full Member Trading Discussion
57 Steamtyme Sr. Member Meta
50 The Sound And Fury Jr. Member Altcoin Discussion
50 ChipMixer Full Member Marketplace
42 VB1001 Member Economics
41 coinlocket$ Sr. Member null
35 TheHas Full Member Politics & Society
32 BITCOIN4X Jr. Member Bahasa Indonesia (Indonesian)
30 aundroid Full Member Deutsch (German)
30 gmaxwell Staff Development & Technical Discussion
27 taikuri13 Full Member Pyccкий (Russian)
24 Zedpastin Jr. Member Beginners & Help
15 yazher Member Pilipinas
13 philipma1957 Legendary Mining
11 Hellmouth42 Full Member Français
11 Dzeronimo Member Hrvatski (Croatian)
11 Plutosky Member Italiano (Italian)
11 Eliovp Legendary Mining (Altcoins)
11 LoyceV Legendary Project Development
10 Macadonian Member Serious discussion
8 generalizethis Legendary Speculation (Altcoins)
7 NashAmajh Jr. Member Marketplace (Altcoins)
6 heresamemo Member Announcements (Altcoins)
6 satoshi Founder Bitcoin Discussion
6 KingZee Sr. Member Bitcoin Technical Support
6 BitcoinTurk Sr. Member Türkçe (Turkish)
5 khaled0111 Full Member العربية (Arabic)
4 DdmrDdmr Sr. Member Español (Spanish)
3 Airbuxf Jr. Member Polski
3 Lucasgabd Full Member Português (Portuguese)
2 Artemis3 Jr. Member Off-topic
1 eaLiTy Hero Member India
1 JorisK Full Member Nederlands (Dutch)
1 DTalk Newbie Other languages/locations
22 Serious discussion
112 null
100 Altcoin Discussion
88 Announcements (Altcoins)
214 Bahasa Indonesia (Indonesian)
168 Beginners & Help
88 Bitcoin Discussion
30 Bitcoin Technical Support
252 Deutsch (German)
195 Development & Technical Discussion
494 Economics
16 Español (Spanish)
82 Français
17 Hrvatski (Croatian)
1 India
21 Italiano (Italian)
377 Marketplace
25 Marketplace (Altcoins)
554 Meta
133 Mining
32 Mining (Altcoins)
5 Nederlands (Dutch)
17 Off-topic
3 Other languages/locations
106 Pilipinas
170 Politics & Society
14 Polski
16 Português (Portuguese)
46 Project Development
17 Speculation (Altcoins)
497 Trading Discussion
25 Türkçe (Turkish)
632 Pyccкий (Russian)
30 العربية (Arabic)
1 中文 (Chinese)
1 日本語 (Japanese)
Administrator 66
Copper Member 109
Donator 181
Full Member 777
Global Moderator 21
Hero Member 609
Jr. Member 87
Legendary 1433
Member 204
Newbie 39
Sr. Member 441
Staff 500
Administrator 64
Copper Member 158
Donator 40
Founder 6
Full Member 767
Hero Member 355
Jr. Member 312
Legendary 812
Member 649
Newbie 71
Sr. Member 721
Staff 102
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Lakai01 on May 12, 2019, 04:22:05 PM
Hi Piggy!
The merit explorer (https://albertoit.github.io/Merit-Explorer-SQL/) throws an "Uncaught Error: file is not a database" exception. Is there any planned downtime going on? Tried to access the tool for several days now, it keeps showing me the exception :-)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on May 12, 2019, 05:22:06 PM
Hi Piggy!
The merit explorer (https://albertoit.github.io/Merit-Explorer-SQL/) throws an "Uncaught Error: file is not a database" exception. Is there any planned downtime going on? Tried to access the tool for several days now, it keeps showing me the exception :-)
I see, i had few problem on friday and tried to roll back but apparently something went wrong. I'll try to have a look tomorrow.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on May 20, 2019, 05:40:54 AM
The tool is now updated with the latest data from Friday 17th of May Here is the usual snapshot about the last week: Top Sender per board last week 362 Vod Legendary Trading Discussion
261 Vod Legendary Meta
169 DarkStar_ Legendary Polski
168 Flying Hellfish Staff Marketplace
155 chimk Full Member Pyccкий (Russian)
107 dbshck Staff Bahasa Indonesia (Indonesian)
64 frodocooper Staff Mining
58 qwk Donator Deutsch (German)
56 ETFbitcoin Legendary Development & Technical Discussion
53 ETFbitcoin Legendary Bitcoin Technical Support
50 sammy007 Legendary Announcements (Altcoins)
45 Halab Staff Français
44 600watt Legendary Economics
39 dbshck Staff Politics & Society
27 cabalism13 Member Pilipinas
20 Micio Legendary Italiano (Italian)
19 teramit Legendary Türkçe (Turkish)
16 DarkStar_ Legendary العربية (Arabic)
15 Quickseller Copper Member Beginners & Help
14 malevolent Staff null
14 tk808 Hero Member Altcoin Discussion
12 malevolent Staff Project Development
11 Heisenberg_Hunter Full Member India
10 coinscrow Sr. Member Mining (Altcoins)
8 paxmao Sr. Member Bitcoin Discussion
8 paxmao Sr. Member Español (Spanish)
7 valheru Full Member Speculation (Altcoins)
6 dbshck Staff Serious discussion
5 LoyceV Legendary Nederlands (Dutch)
3 Daniel91 Legendary Hrvatski (Croatian)
3 cabalism13 Member Marketplace (Altcoins)
3 Vod Legendary Off-topic
3 Paredao Legendary Português (Portuguese)
3 hakka Member 日本語 (Japanese)
1 Agrawas Copper Member Archival
1 cryptofrka Member Other languages/locations
1 mo Legendary 中文 (Chinese)
76 TMAN Hero Member Trading Discussion
75 anonymousminer Member Marketplace
71 SaltySpitoon Legendary Meta
56 Tytanowy Janusz Member Polski
50 smooth Legendary Announcements (Altcoins)
47 JSRAW Jr. Member Politics & Society
31 Toxic2040 Sr. Member Economics
29 BITCOIN4X Jr. Member Bahasa Indonesia (Indonesian)
29 asu Hero Member Pilipinas
28 bitcoinminer42 Legendary Deutsch (German)
23 HCP Hero Member Bitcoin Technical Support
20 coinlocket$ Sr. Member null
20 mstrozier Newbie Mining
19 TideFoundation Copper Member Development & Technical Discussion
18 GreatArkansas Full Member Beginners & Help
18 witcher_sense Member Pyccкий (Russian)
13 Paolo.Demidov Member Italiano (Italian)
12 Saint-loup Sr. Member Français
12 sega01 Sr. Member Project Development
10 kingcolex Legendary Mining (Altcoins)
10 khaled0111 Full Member العربية (Arabic)
9 Successmaniac4 Jr. Member Altcoin Discussion
9 webtricks Sr. Member India
9 heraware Jr. Member Speculation (Altcoins)
7 gmaxwell Staff Bitcoin Discussion
7 Dzeronimo Member Hrvatski (Croatian)
6 DdmrDdmr Sr. Member Español (Spanish)
6 JSRAW Jr. Member Serious discussion
6 trendcoin Jr. Member Türkçe (Turkish)
4 sbogovac Legendary Nederlands (Dutch)
3 crwth Sr. Member Marketplace (Altcoins)
3 blockman Hero Member Off-topic
3 alegotardo Full Member Português (Portuguese)
3 Anon11073 Staff 日本語 (Japanese)
1 anonymousminer Member Archival
1 sbogovac Legendary Other languages/locations
1 angelenaknepper Jr. Member 中文 (Chinese)
5 Other languages/locations
3 日本語 (Japanese)
79 null
83 Altcoin Discussion
111 Announcements (Altcoins)
1 Archival
294 Bahasa Indonesia (Indonesian)
165 Beginners & Help
105 Bitcoin Discussion
126 Bitcoin Technical Support
258 Deutsch (German)
268 Development & Technical Discussion
459 Economics
22 Español (Spanish)
82 Français
18 Hrvatski (Croatian)
28 India
47 Italiano (Italian)
719 Marketplace
7 Marketplace (Altcoins)
976 Meta
79 Mining
37 Mining (Altcoins)
5 Nederlands (Dutch)
15 Off-topic
100 Pilipinas
41 Politics & Society
240 Polski
14 Português (Portuguese)
34 Project Development
6 Serious discussion
21 Speculation (Altcoins)
808 Trading Discussion
57 Türkçe (Turkish)
382 Pyccкий (Russian)
45 العربية (Arabic)
1 中文 (Chinese)
Administrator 33
Copper Member 180
Donator 112
Full Member 497
Global Moderator 7
Hero Member 505
Jr. Member 94
Legendary 2592
Member 301
Newbie 57
Sr. Member 590
Staff 772
VIP 1
Administrator 56
Brand new 3
Copper Member 486
Donator 60
Founder 5
Full Member 612
Global Moderator 50
Hero Member 781
Jr. Member 427
Legendary 1443
Member 695
Newbie 300
Sr. Member 723
Staff 99
VIP 1
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on May 27, 2019, 06:13:42 AM
The tool is now updated with the latest data from Friday 25th of May Here is the usual snapshot about the last week: Top Sender per board last week 193 chimk Full Member Pyccкий (Russian)
173 dbshck Staff Bahasa Indonesia (Indonesian)
109 qwk Donator Deutsch (German)
88 Foxpup Legendary Meta
87 dbshck Staff Beginners & Help
79 frodocooper Staff Mining
50 DaRude Legendary Marketplace
44 JayJuanGee Legendary Economics
39 Foxpup Legendary Bitcoin Discussion
32 dbshck Staff Trading Discussion
28 dbshck Staff Development & Technical Discussion
28 Halab Staff Français
26 asu Hero Member Pilipinas
24 tk808 Hero Member Altcoin Discussion
20 dbshck Staff Politics & Society
18 SyGambler Legendary العربية (Arabic)
16 bones261 Legendary Bitcoin Technical Support
16 vapourminer Legendary Mining (Altcoins)
16 Tytanowy Janusz Member Polski
14 babo Legendary Italiano (Italian)
13 DdmrDdmr Sr. Member Español (Spanish)
12 dbshck Staff null
11 BossBee Hero Member Announcements (Altcoins)
11 OgNasty Donator Off-topic
8 sabotag3x Hero Member Português (Portuguese)
8 EFS Staff Türkçe (Turkish)
7 Vlad2Vlad Legendary Marketplace (Altcoins)
5 Heisenberg_Hunter Full Member India
5 micgoossens Sr. Member Nederlands (Dutch)
5 subSTRATA Legendary 한국어 (Korean)
4 joniboini Sr. Member Serious discussion
2 Daniel91 Legendary Hrvatski (Croatian)
2 CryptopreneurBrainboss Member Other languages/locations
2 josephdd1 Hero Member Română (Romanian)
2 Aptekary Member Speculation (Altcoins)
1 Quickseller Copper Member Archival
1 DarkStar_ Legendary Project Development
1 vagrom Member 中文 (Chinese)
84 laszlo Full Member Marketplace
73 LoyceV Legendary Meta
45 asu Hero Member Pilipinas
33 abhiseshakana Full Member Bahasa Indonesia (Indonesian)
33 feryjhie Hero Member Beginners & Help
30 aundroid Full Member Deutsch (German)
30 Toxic2040 Sr. Member Economics
27 angel55 Full Member Trading Discussion
23 HCP Hero Member Development & Technical Discussion
19 madnessteat Member Pyccкий (Russian)
18 gmaxwell Staff Bitcoin Discussion
18 mstrozier Newbie Mining
15 fillippone Member Italiano (Italian)
13 Tytanowy Janusz Member Polski
12 philipma1957 Legendary Mining (Altcoins)
11 BossBee Hero Member Announcements (Altcoins)
11 mikeywith Member العربية (Arabic)
10 aundroid Full Member Altcoin Discussion
9 squatz1 Hero Member Politics & Society
7 Halab Staff Français
7 Phinnaeus Gage Legendary Marketplace (Altcoins)
6 Artemis3 Jr. Member Bitcoin Technical Support
5 DdmrDdmr Sr. Member Español (Spanish)
5 legendster Hero Member India
5 alegotardo Full Member Português (Portuguese)
5 Madenci_34 Jr. Member Türkçe (Turkish)
5 koreacryptocurrency Full Member 한국어 (Korean)
4 Spazzer Full Member null
4 rdbase Full Member Off-topic
4 CryptopreneurBrainboss Member Serious discussion
3 iCEBREAKER Legendary Speculation (Altcoins)
2 big_daddy Full Member Hrvatski (Croatian)
2 Mitchell Staff Nederlands (Dutch)
2 ibminer Legendary Project Development
2 IonCreanga Jr. Member Română (Romanian)
1 DireWolfM14 Member Archival
1 Becky666 Newbie Other languages/locations
1 ericz Jr. Member 中文 (Chinese)
5 한국어 (Korean)
50 null
91 Altcoin Discussion
105 Announcements (Altcoins)
1 Archival
271 Bahasa Indonesia (Indonesian)
298 Beginners & Help
212 Bitcoin Discussion
39 Bitcoin Technical Support
285 Deutsch (German)
168 Development & Technical Discussion
492 Economics
21 Español (Spanish)
51 Français
6 Hrvatski (Croatian)
19 India
61 Italiano (Italian)
696 Marketplace
27 Marketplace (Altcoins)
774 Meta
137 Mining
77 Mining (Altcoins)
6 Nederlands (Dutch)
37 Off-topic
3 Other languages/locations
161 Pilipinas
75 Politics & Society
55 Polski
14 Português (Portuguese)
6 Project Development
3 Română (Romanian)
20 Serious discussion
9 Speculation (Altcoins)
268 Trading Discussion
27 Türkçe (Turkish)
393 Pyccкий (Russian)
50 العربية (Arabic)
1 中文 (Chinese)
Administrator 4
Copper Member 218
Donator 170
Full Member 487
Global Moderator 48
Hero Member 611
Jr. Member 96
Legendary 1576
Member 317
Newbie 112
Sr. Member 493
Staff 841
Administrator 62
Copper Member 173
Donator 46
Founder 2
Full Member 722
Global Moderator 18
Hero Member 695
Jr. Member 305
Legendary 1169
Member 495
Newbie 352
Sr. Member 590
Staff 135
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: babo on May 27, 2019, 06:59:15 AM
Given that the recharge period is one month's worth, do you think it makes sense to have weekly statistics?
i mean,
some merit source use all merits in one week, and for other weeks he disappear
I'm not saying they aren't useful..
I'm saying that maybe you should also post the monthly ones.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on May 27, 2019, 07:27:07 AM
Given that the recharge period is one month's worth, do you think it makes sense to have weekly statistics?
i mean,
some merit source use all merits in one week, and for other weeks he disappear
I'm not saying they aren't useful..
I'm saying that maybe you should also post the monthly ones.
This would be the same kind of queries i run weekly but on a monthly time span, April in this case: Top Sender per board for April 731 chimk Full Member Pyccкий (Russian)
471 Flying Hellfish Staff Marketplace
418 dbshck Staff Bahasa Indonesia (Indonesian)
303 frodocooper Staff Mining
264 Foxpup Legendary Meta
261 suchmoon Legendary Trading Discussion
244 qwk Donator Deutsch (German)
200 Halab Staff Français
197 JayJuanGee Legendary Economics
155 suchmoon Legendary Beginners & Help
143 bones261 Legendary Development & Technical Discussion
90 theymos Administrator null
82 suchmoon Legendary Politics & Society
78 Foxpup Legendary Bitcoin Discussion
64 bones261 Legendary Bitcoin Technical Support
63 paxmao Sr. Member Español (Spanish)
55 crazyearner Legendary Announcements (Altcoins)
55 Micio Legendary Italiano (Italian)
54 EFS Staff Türkçe (Turkish)
50 AngusCanine Legendary Altcoin Discussion
50 Bitdonator Legendary Hrvatski (Croatian)
49 hugeblack Sr. Member العربية (Arabic)
40 malevolent Staff Polski
33 rednoW Legendary Mining (Altcoins)
31 theyoungmillionaire Full Member Pilipinas
31 Welsh Staff Serious discussion
21 Vod Legendary Project Development
19 sabotag3x Hero Member Português (Portuguese)
11 Zeta0S Legendary Nederlands (Dutch)
10 Bitdonator Legendary Off-topic
8 Heisenberg_Hunter Full Member India
7 tyz Legendary Marketplace (Altcoins)
5 moofie Jr. Member Speculation (Altcoins)
5 Mr. Burnham Sr. Member Eλληνικά (Greek)
4 Anon11073 Staff 日本語 (Japanese)
2 QWeB Member Archival
2 valentin68 Full Member Română (Romanian)
2 Rami84 Full Member 中文 (Chinese)
1 BitCoinDream Legendary Other languages/locations
239 theymos Administrator Meta
194 abhiseshakana Full Member Bahasa Indonesia (Indonesian)
137 yogg Legendary Marketplace
129 VB1001 Member Economics
104 nopara73 Newbie Development & Technical Discussion
101 ICOEthics Full Member Trading Discussion
94 coinlocket$ Sr. Member null
94 1miau Full Member Deutsch (German)
87 Eliovp Legendary Mining (Altcoins)
83 cestmoi Newbie Français
76 whotookmycrypto Newbie Beginners & Help
73 Artemis3 Jr. Member Mining
65 achow101 Staff Bitcoin Technical Support
60 chimk Full Member Pyccкий (Russian)
52 sheenshane Full Member Pilipinas
50 The Sound And Fury Jr. Member Altcoin Discussion
50 cryptogenerations Jr. Member Announcements (Altcoins)
48 Tytanowy Janusz Member Polski
42 duesoldi Sr. Member Italiano (Italian)
39 theymos Administrator Politics & Society
38 mikeywith Member العربية (Arabic)
32 DdmrDdmr Sr. Member Español (Spanish)
25 bitcoinbcn Full Member Türkçe (Turkish)
21 satoshi Founder Bitcoin Discussion
18 Pmalek Hero Member Hrvatski (Croatian)
12 Carlton Banks Legendary Serious discussion
11 Yoshi Livo Sr. Member Nederlands (Dutch)
11 LoyceV Legendary Project Development
10 QuestionAuthority Legendary Off-topic
8 amishmanish Sr. Member India
8 cryptobaboon Full Member Português (Portuguese)
7 NashAmajh Jr. Member Marketplace (Altcoins)
7 generalizethis Legendary Speculation (Altcoins)
6 hakka Member 日本語 (Japanese)
5 bomberb17 Hero Member Eλληνικά (Greek)
3 Hhampuz Hero Member Archival
2 al1n Member Română (Romanian)
2 leonsnow Copper Member 中文 (Chinese)
1 Abdussamad Legendary Other languages/locations
11 Nederlands (Dutch)
2 Română (Romanian)
7 Eλληνικά (Greek)
2 中文 (Chinese)
422 null
311 Altcoin Discussion
514 Announcements (Altcoins)
13 Archival
1172 Bahasa Indonesia (Indonesian)
882 Beginners & Help
413 Bitcoin Discussion
463 Bitcoin Technical Support
770 Deutsch (German)
1018 Development & Technical Discussion
2100 Economics
160 Español (Spanish)
627 Français
110 Hrvatski (Croatian)
28 India
225 Italiano (Italian)
2592 Marketplace
74 Marketplace (Altcoins)
2653 Meta
709 Mining
227 Mining (Altcoins)
125 Off-topic
6 Other languages/locations
323 Pilipinas
297 Politics & Society
147 Polski
41 Português (Portuguese)
62 Project Development
69 Serious discussion
46 Speculation (Altcoins)
1320 Trading Discussion
182 Türkçe (Turkish)
1597 Pyccкий (Russian)
207 العربية (Arabic)
11 日本語 (Japanese)
Administrator 229
Copper Member 586
Donator 482
Full Member 2165
Global Moderator 126
Hero Member 2045
Jr. Member 475
Legendary 7621
Member 1137
Newbie 334
Sr. Member 1937
Staff 2801
Administrator 293
Brand new 2
Copper Member 1175
Donator 101
Founder 37
Full Member 2781
Global Moderator 38
Hero Member 2156
Jr. Member 1580
Legendary 4182
Member 2545
Newbie 1747
Sr. Member 2734
Staff 562
VIP 5
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: fillippone on May 27, 2019, 07:47:53 AM
I second the idea of monthly statistics, in line with MS refill cycle. It makes a lot of sense IMHO.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: DdmrDdmr on May 27, 2019, 07:54:59 AM
I second the idea of monthly statistics, in line with MS refill cycle. It makes a lot of sense IMHO.
One thing to bear in mind though is that Merit Source allocation is not filled-up to its max. on a single date per month, nor did all Merit Sources being one on the same date. For example, a Merit Source may start being one on the 10th of a given month, and give out (for simplicity) 5 merits per day. That would mean that, 30 days later, the Merit Source will get a refill of 5 sMerits in his allowance, 5 on the following day and so on. The rule being that you get a refill cloned to what you spend on a given day exactly 30 days down the road (down to hour and minute).
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: fillippone on May 27, 2019, 08:05:07 AM
I second the idea of monthly statistics, in line with MS refill cycle. It makes a lot of sense IMHO.
One thing to bear in mind though is that Merit Source allocation is not filled-up to its max. on a single date per month, nor did all Merit Sources being one on the same date. For example, a Merit Source may start being one on the 10th of a given month, and give out (for simplicity) 5 merits per day. That would mean that, 30 days later, the Merit Source will get a refill of 5 sMerits in his allowance, 5 on the following day and so on. The rule being that you get a refill cloned to what you spend on a given day exactly 30 days down the road (down to hour and minute). I didn't know that, this shouldn't be a surprise as I am not a MS, but this reinforces the idea of monthly cycles for this analysis, as meriting patterns and consequently "sMeriting habits" should be smoothed out on a monthly cycle (as the MS allocation is considered a "monthly" allowance..). This are my only 2 cents.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: logfiles on May 27, 2019, 08:26:56 AM
Also, one thing worth noting is that most Members in the latest have ranked up, but they still seem to be listed with the ranks they had 2 - 3 moths ago.
Shouldn't it be necessary to show the latest rank or it's does not matter in this case?
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on May 28, 2019, 04:57:55 AM
Also, one thing worth noting is that most Members in the latest have ranked up, but they still seem to be listed with the ranks they had 2 - 3 moths ago.
Shouldn't it be necessary to show the latest rank or it's does not matter in this case?
the rank is not updated indeed, is not really critical as the main purpose is to see who gets/sends merits, however i can see if i find the script i had to update the users and run it :)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on June 03, 2019, 12:13:36 PM
The tool is now updated with the latest data from Friday 31st of May Here is the usual snapshot about the last week and the monthly recap for May is coming right after: Top Sender per board last week 167 chimk Full Member Pyccкий (Russian)
86 Flying Hellfish Staff Marketplace
79 suchmoon Legendary Meta
75 frodocooper Staff Mining
65 suchmoon Legendary Trading Discussion
57 micgoossens Sr. Member Economics
47 suchmoon Legendary Beginners & Help
45 dbshck Staff Bahasa Indonesia (Indonesian)
42 bones261 Legendary Development & Technical Discussion
42 Micio Legendary Italiano (Italian)
31 asu Hero Member Pilipinas
28 EFS Staff Türkçe (Turkish)
27 Halab Staff Français
26 tk808 Hero Member Altcoin Discussion
23 paxmao Sr. Member Español (Spanish)
21 squatz1 Hero Member Politics & Society
18 SyGambler Legendary العربية (Arabic)
12 iCEBREAKER Legendary Announcements (Altcoins)
11 mole0815 Sr. Member Deutsch (German)
10 bones261 Legendary Bitcoin Technical Support
8 dbshck Staff Mining (Altcoins)
8 suchmoon Legendary Off-topic
7 Mike Mayor Hero Member Bitcoin Discussion
7 Paredao Legendary Português (Portuguese)
6 Halab Staff Project Development
5 Flying Hellfish Staff Archival
5 JSRAW Jr. Member India
5 paxmao Sr. Member Serious discussion
4 OgNasty Donator null
4 adamvp Hero Member Polski
3 S_Therapist Newbie Other languages/locations
2 SISAR Hero Member Hrvatski (Croatian)
2 Cryptogainsairdrop Jr. Member Marketplace (Altcoins)
2 Hueristic Legendary Speculation (Altcoins)
1 mitzie Staff Eλληνικά (Greek)
63 theymos Administrator Meta
50 Halmater Hero Member Türkçe (Turkish)
47 nutildah Legendary Trading Discussion
46 Crypto_Collection Jr. Member Marketplace
41 cAPSLOCK Legendary Economics
28 asu Hero Member Pilipinas
27 viscolex Member Announcements (Altcoins)
27 theymos Administrator Beginners & Help
25 Pieter Wuille Legendary Development & Technical Discussion
25 edgycorner Full Member Project Development
25 Goran_ Sr. Member Pyccкий (Russian)
20 duesoldi Sr. Member Italiano (Italian)
20 Artemis3 Jr. Member Mining
16 masulum Member Bahasa Indonesia (Indonesian)
15 hugeblack Sr. Member Archival
11 Kavelj22 Newbie العربية (Arabic)
10 hornetsnest Member Altcoin Discussion
10 Vishnu.Reang Sr. Member Politics & Society
9 Vegemite Jr. Member Deutsch (German)
6 bob123 Hero Member Bitcoin Technical Support
6 LUCKMCFLY Full Member Español (Spanish)
6 asche Full Member Français
6 joseph32 Jr. Member Mining (Altcoins)
6 tomahawk9 Sr. Member Off-topic
5 gentlemand Legendary Bitcoin Discussion
5 Tytanowy Janusz Member Polski
5 Pumared Sr. Member Português (Portuguese)
2 Lafu Hero Member null
2 Domchi Full Member Hrvatski (Croatian)
2 JSRAW Jr. Member India
2 Jet Cash Legendary Serious discussion
2 7jaka7 Sr. Member Speculation (Altcoins)
1 Kavelj22 Newbie Marketplace (Altcoins)
1 DTalk Newbie Other languages/locations
23 Archival
20 null
71 Altcoin Discussion
128 Announcements (Altcoins)
106 Bahasa Indonesia (Indonesian)
147 Beginners & Help
86 Bitcoin Discussion
74 Bitcoin Technical Support
99 Deutsch (German)
198 Development & Technical Discussion
552 Economics
37 Español (Spanish)
48 Français
5 Hrvatski (Croatian)
8 India
108 Italiano (Italian)
675 Marketplace
9 Marketplace (Altcoins)
617 Meta
103 Mining
30 Mining (Altcoins)
6 Off-topic
6 Other languages/locations
134 Pilipinas
60 Politics & Society
14 Polski
21 Português (Portuguese)
52 Project Development
7 Serious discussion
7 Speculation (Altcoins)
290 Trading Discussion
204 Türkçe (Turkish)
1 Eλληνικά (Greek)
336 Pyccкий (Russian)
47 العربية (Arabic)
Administrator 2
Copper Member 164
Donator 61
Full Member 426
Global Moderator 21
Hero Member 511
Jr. Member 108
Legendary 1562
Member 230
Newbie 90
Sr. Member 535
Staff 526
VIP 1
Administrator 113
Copper Member 220
Donator 35
Founder 3
Full Member 515
Global Moderator 8
Hero Member 574
Jr. Member 284
Legendary 989
Member 458
Newbie 181
Sr. Member 568
Staff 86
VIP 1
Top Sender per board for May 671 chimk Full Member Pyccкий (Russian)
642 dbshck Staff Bahasa Indonesia (Indonesian)
495 Flying Hellfish Staff Marketplace
396 Vod Legendary Trading Discussion
318 Foxpup Legendary Meta
271 frodocooper Staff Mining
266 qwk Donator Deutsch (German)
218 DarkStar_ Legendary Polski
215 dbshck Staff Beginners & Help
159 JayJuanGee Legendary Economics
144 Halab Staff Français
134 bones261 Legendary Development & Technical Discussion
96 squatz1 Hero Member Politics & Society
82 asu Hero Member Pilipinas
67 teramit Legendary Türkçe (Turkish)
64 tk808 Hero Member Altcoin Discussion
63 Vlad2Vlad Legendary Announcements (Altcoins)
63 bones261 Legendary Bitcoin Technical Support
62 Micio Legendary Italiano (Italian)
58 suchmoon Legendary Bitcoin Discussion
57 paxmao Sr. Member Español (Spanish)
47 hugeblack Sr. Member العربية (Arabic)
38 dbshck Staff null
37 vapourminer Legendary Mining (Altcoins)
29 Vod Legendary Project Development
27 sabotag3x Hero Member Português (Portuguese)
21 Heisenberg_Hunter Full Member India
14 OgNasty Donator Off-topic
12 Jet Cash Legendary Serious discussion
12 Hueristic Legendary Speculation (Altcoins)
11 micgoossens Sr. Member Nederlands (Dutch)
10 Daniel91 Legendary Hrvatski (Croatian)
7 Vlad2Vlad Legendary Marketplace (Altcoins)
6 Anon11073 Staff 日本語 (Japanese)
5 Flying Hellfish Staff Archival
5 subSTRATA Legendary 한국어 (Korean)
3 CryptopreneurBrainboss Member Other languages/locations
2 josephdd1 Hero Member Română (Romanian)
2 mo Legendary 中文 (Chinese)
1 mitzie Staff Eλληνικά (Greek)
193 LoyceV Legendary Meta
119 ICOEthics Full Member Trading Discussion
116 ryzaadit Full Member Bahasa Indonesia (Indonesian)
114 Toxic2040 Sr. Member Economics
112 qwk Donator Deutsch (German)
109 asu Hero Member Pilipinas
101 Hhampuz Hero Member Marketplace
82 Tytanowy Janusz Member Polski
75 JSRAW Jr. Member Politics & Society
72 Goran_ Sr. Member Pyccкий (Russian)
56 theymos Administrator Beginners & Help
55 Videlicet Legendary Announcements (Altcoins)
55 HCP Hero Member Development & Technical Discussion
52 Hal VIP Bitcoin Discussion
51 Matthias9515 Hero Member Türkçe (Turkish)
50 mstrozier Newbie Mining
39 duesoldi Sr. Member Italiano (Italian)
39 khaled0111 Full Member العربية (Arabic)
38 Eliovp Legendary Mining (Altcoins)
33 coinlocket$ Sr. Member null
33 achow101 Staff Bitcoin Technical Support
33 Saint-loup Sr. Member Français
25 edgycorner Full Member Project Development
24 DdmrDdmr Sr. Member Español (Spanish)
16 hornetsnest Member Altcoin Discussion
16 hugeblack Sr. Member Archival
16 Dzeronimo Member Hrvatski (Croatian)
14 alegotardo Full Member Português (Portuguese)
13 webtricks Sr. Member India
10 John Kreese Newbie Off-topic
9 heraware Jr. Member Speculation (Altcoins)
8 sbogovac Legendary Nederlands (Dutch)
8 hakka Member 日本語 (Japanese)
7 NashAmajh Jr. Member Marketplace (Altcoins)
6 CryptopreneurBrainboss Member Serious discussion
5 koreacryptocurrency Full Member 한국어 (Korean)
2 James_CRYPTOSTAR.MONEY Newbie Other languages/locations
2 IonCreanga Jr. Member Română (Romanian)
1 SergeyP77 Jr. Member 中文 (Chinese)
5 한국어 (Korean)
273 null
344 Altcoin Discussion
565 Announcements (Altcoins)
3 Archival
1269 Bahasa Indonesia (Indonesian)
684 Beginners & Help
522 Bitcoin Discussion
224 Bitcoin Technical Support
1012 Deutsch (German)
1078 Development & Technical Discussion
2179 Economics
159 Español (Spanish)
284 Français
50 Hrvatski (Croatian)
61 India
261 Italiano (Italian)
2582 Marketplace
63 Marketplace (Altcoins)
2824 Meta
422 Mining
206 Mining (Altcoins)
25 Nederlands (Dutch)
83 Off-topic
11 Other languages/locations
510 Pilipinas
667 Politics & Society
371 Polski
79 Português (Portuguese)
144 Project Development
3 Română (Romanian)
29 Serious discussion
132 Speculation (Altcoins)
1906 Trading Discussion
415 Türkçe (Turkish)
1 Eλληνικά (Greek)
1644 Pyccкий (Russian)
207 العربية (Arabic)
3 中文 (Chinese)
14 日本語 (Japanese)
Administrator 53
Copper Member 703
Donator 522
Full Member 1945
Global Moderator 94
Hero Member 2167
Jr. Member 450
Legendary 8290
Member 1152
Newbie 340
Sr. Member 2238
Staff 3225
VIP 2
Administrator 332
Brand new 13
Copper Member 1154
Donator 234
Founder 23
Full Member 2721
Global Moderator 81
Hero Member 2677
Jr. Member 1518
Legendary 4903
Member 2544
Newbie 1253
Sr. Member 2750
Staff 514
VIP 53
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Lakai01 on June 05, 2019, 06:36:29 PM
Hi Piggy!
I saw the that TitleThread column is missing from the MeritData-table. I wonder if thats intentional? We did some very nice statistics with this info in the German local board ;)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on June 06, 2019, 04:53:41 AM
Hi Piggy!
I saw the that TitleThread column is missing from the MeritData-table. I wonder if thats intentional? We did some very nice statistics with this info in the German local board ;)
I had to rebuild the database a couple of weeks ago and it may have been accidentally left out in fact. I'll see to add it back on the next update. :)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Lakai01 on June 06, 2019, 06:47:17 PM
Thank you very much Piggy!
Btw. I host a thread in the German local board which contains a lot of statistics (and sql-statements to get that info) how merits are used in our board on a monthly basis (top spender per month, top receiver, top merited thread, ...). If someone would be interested to do the same for his/her local board and needs some help/advice or some tailored sql-statements please let me know, would love to share them.
Here is the thread in our German board if someone wants to have a look: https://bitcointalk.org/index.php?topic=4657305.0
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on June 07, 2019, 07:58:45 AM
The tool is now updated with the latest data from Friday 7th of June The title of the thread merited was put back into the database Lakai01. Here is the usual snapshot about the last week and the monthly recap for May is coming right after: Top Sender per board last week 318 chimk Hero Member Pyccкий (Russian)
130 qwk Donator Deutsch (German)
94 DarkStar_ Legendary Türkçe (Turkish)
75 Flying Hellfish Staff Marketplace
66 Foxpup Legendary Meta
54 micgoossens Hero Member Economics
50 MicroGuy Legendary null
50 NutMasterTardd Legendary Announcements (Altcoins)
50 fr4nkthetank Legendary Mining (Altcoins)
44 paxmao Sr. Member Español (Spanish)
44 Halab Staff Français
39 frodocooper Staff Mining
34 dbshck Staff Development & Technical Discussion
28 suchmoon Legendary Trading Discussion
27 TMAN Legendary Beginners & Help
26 dbshck Staff Bahasa Indonesia (Indonesian)
25 SyGambler Legendary العربية (Arabic)
24 Micio Legendary Italiano (Italian)
23 dbshck Staff Pilipinas
21 btcdiggingmaster Hero Member Speculation (Altcoins)
20 dbshck Staff Politics & Society
17 tk808 Hero Member Altcoin Discussion
16 LoyceV Legendary Bitcoin Technical Support
13 sabotag3x Hero Member Português (Portuguese)
12 Tytanowy Janusz Sr. Member Polski
10 DdmrDdmr Hero Member Bitcoin Discussion
10 crazyearner Legendary Marketplace (Altcoins)
7 paxmao Sr. Member Serious discussion
5 TECSHARE Legendary Off-topic
5 eckmar Legendary Project Development
3 Foxpup Legendary Archival
3 Alohadanc3 Member India
3 friends1980 Sr. Member Nederlands (Dutch)
3 popcoins Hero Member 中文 (Chinese)
2 big_daddy Full Member Hrvatski (Croatian)
1 DTalk Member Other languages/locations
1 hakka Full Member 日本語 (Japanese)
97 Matthias9515 Hero Member Türkçe (Turkish)
71 micgoossens Hero Member Economics
52 XEL-project Copper Member Announcements (Altcoins)
50 Jimmy Crypto Jr. Member null
50 Eliovp Legendary Mining (Altcoins)
41 FontSeli Full Member Pyccкий (Russian)
35 nutildah Legendary Trading Discussion
28 asu Hero Member Pilipinas
26 suchmoon Legendary Meta
24 qwk Donator Deutsch (German)
21 coingrowth Member Speculation (Altcoins)
18 Plutosky Sr. Member Italiano (Italian)
17 Hhampuz Legendary Marketplace
15 Steamtyme Hero Member Mining
15 cryptovigi Sr. Member Polski
14 bob123 Hero Member Development & Technical Discussion
14 khaled0111 Sr. Member العربية (Arabic)
12 theymos Administrator Politics & Society
10 masulum Member Bahasa Indonesia (Indonesian)
10 bitcoinzen Jr. Member Bitcoin Discussion
10 cryptogendrop Newbie Marketplace (Altcoins)
9 Redemption59 Jr. Member Altcoin Discussion
9 DdmrDdmr Hero Member Español (Spanish)
9 F2b Full Member Français
8 CryptopreneurBrainboss Sr. Member Beginners & Help
6 LoyceV Legendary Bitcoin Technical Support
5 TheCreationStation Newbie Off-topic
5 LoyceV Legendary Project Development
4 sabotag3x Hero Member Português (Portuguese)
3 o_e_l_e_o Hero Member Archival
3 deadley Legendary India
3 Ber86 Member 中文 (Chinese)
2 SISAR Hero Member Hrvatski (Croatian)
2 Carlton Banks Legendary Serious discussion
1 AdolfinWolf Hero Member Nederlands (Dutch)
1 Review Master Jr. Member Other languages/locations
1 kazuki.t Member 日本語 (Japanese)
86 null
89 Altcoin Discussion
147 Announcements (Altcoins)
56 Bahasa Indonesia (Indonesian)
130 Beginners & Help
81 Bitcoin Discussion
102 Bitcoin Technical Support
226 Deutsch (German)
83 Development & Technical Discussion
446 Economics
66 Español (Spanish)
68 Français
8 Hrvatski (Croatian)
6 India
98 Italiano (Italian)
288 Marketplace
23 Marketplace (Altcoins)
427 Meta
85 Mining
82 Mining (Altcoins)
4 Nederlands (Dutch)
16 Off-topic
1 Other languages/locations
118 Pilipinas
39 Politics & Society
28 Polski
25 Português (Portuguese)
14 Project Development
6 Serious discussion
29 Speculation (Altcoins)
252 Trading Discussion
409 Türkçe (Turkish)
585 Pyccкий (Russian)
56 العربية (Arabic)
4 中文 (Chinese)
1 日本語 (Japanese)
Administrator 13
Copper Member 96
Donator 141
Full Member 214
Global Moderator 45
Hero Member 1100
Jr. Member 30
Legendary 1450
Member 104
Newbie 20
Sr. Member 459
Staff 512
Administrator 51
Copper Member 200
Donator 41
Founder 2
Full Member 380
Global Moderator 27
Hero Member 1014
Jr. Member 265
Legendary 898
Member 380
Newbie 179
Sr. Member 667
Staff 80
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on June 14, 2019, 06:50:32 AM
The tool is now updated with the latest data from Friday 14th of June The users ranks has been updated (this was happening already the last week but i forgot to mention it). Here is the usual snapshot about the last week: Top Sender per board last week 278 DarkStar_ Legendary Pilipinas
256 suchmoon Legendary Meta
233 chimk Hero Member Pyccкий (Russian)
192 Flying Hellfish Staff Marketplace
108 ETFbitcoin Legendary Development & Technical Discussion
105 suchmoon Legendary Trading Discussion
87 dbshck Staff Türkçe (Turkish)
78 dbshck Staff Bahasa Indonesia (Indonesian)
62 qwk Donator Deutsch (German)
50 bones261 Legendary Beginners & Help
46 frodocooper Staff Mining
40 suchmoon Legendary Politics & Society
37 ETFbitcoin Legendary Bitcoin Technical Support
32 Halab Staff Français
29 JayJuanGee Legendary Economics
27 Vlad2Vlad Legendary Announcements (Altcoins)
24 dbshck Staff Bitcoin Discussion
23 Micio Legendary Italiano (Italian)
16 Vlad2Vlad Legendary Altcoin Discussion
16 DdmrDdmr Hero Member Español (Spanish)
10 mixerxxpasc Sr. Member null
10 BldSwtTrs Legendary Speculation (Altcoins)
9 khaled0111 Sr. Member العربية (Arabic)
8 OgNasty Donator Off-topic
8 malevolent Staff Polski
7 frodocooper Staff Mining (Altcoins)
5 Lauda Legendary Serious discussion
4 finaleshot2016 Sr. Member Hrvatski (Croatian)
4 triangles Full Member Marketplace (Altcoins)
3 MattLeBlanc Member India
2 friends1980 Sr. Member Nederlands (Dutch)
2 Paredao Legendary Português (Portuguese)
2 OgNasty Donator Project Development
1 kazuki.t Member 日本語 (Japanese)
157 theymos Administrator Meta
77 finaleshot2016 Sr. Member Pilipinas
62 ICOEthics Sr. Member Trading Discussion
40 Matthias9515 Hero Member Türkçe (Turkish)
37 masulum Member Bahasa Indonesia (Indonesian)
28 taikuri13 Sr. Member Pyccкий (Russian)
26 bible_pay Full Member Announcements (Altcoins)
26 frankbitcoin Full Member Marketplace
21 aundroid Sr. Member Deutsch (German)
20 selo Copper Member Mining
19 micgoossens Hero Member Economics
19 gbianchi Legendary Italiano (Italian)
18 gmaxwell Staff Development & Technical Discussion
14 hd49728 Member Beginners & Help
13 wwzsocki Hero Member Polski
12 iamsheikhadil Copper Member Politics & Society
11 LoyceV Legendary Bitcoin Technical Support
11 joroz Jr. Member Speculation (Altcoins)
10 Traxo Full Member Altcoin Discussion
7 khaled0111 Sr. Member Bitcoin Discussion
7 coinscrow Sr. Member Mining (Altcoins)
6 RHavar Legendary null
6 DdmrDdmr Hero Member Español (Spanish)
5 Foxpup Legendary Serious discussion
5 khaled0111 Sr. Member العربية (Arabic)
4 GrosWesh Full Member Français
3 deadley Legendary India
3 roughswap Jr. Member Marketplace (Altcoins)
3 dkdaniz Newbie Português (Portuguese)
2 notbatman Legendary Off-topic
2 BitCryptex Hero Member Project Development
1 Bokile Member Hrvatski (Croatian)
1 JorisK Full Member Nederlands (Dutch)
1 tactac Full Member 日本語 (Japanese)
35 Polski
53 Serious discussion
44 null
56 Altcoin Discussion
87 Announcements (Altcoins)
181 Bahasa Indonesia (Indonesian)
146 Beginners & Help
124 Bitcoin Discussion
110 Bitcoin Technical Support
164 Deutsch (German)
233 Development & Technical Discussion
265 Economics
26 Español (Spanish)
50 Français
6 Hrvatski (Croatian)
9 India
77 Italiano (Italian)
434 Marketplace
19 Marketplace (Altcoins)
1207 Meta
103 Mining
19 Mining (Altcoins)
5 Nederlands (Dutch)
21 Off-topic
521 Pilipinas
101 Politics & Society
7 Português (Portuguese)
16 Project Development
17 Speculation (Altcoins)
500 Trading Discussion
297 Türkçe (Turkish)
536 Pyccкий (Russian)
28 العربية (Arabic)
1 日本語 (Japanese)
Administrator 19
Copper Member 130
Donator 117
Full Member 155
Global Moderator 59
Hero Member 904
Jr. Member 32
Legendary 2494
Member 131
Newbie 12
Sr. Member 451
Staff 965
Administrator 166
Copper Member 289
Donator 14
Founder 5
Full Member 459
Global Moderator 35
Hero Member 995
Jr. Member 134
Legendary 1454
Member 481
Newbie 68
Sr. Member 1058
Staff 129
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on June 24, 2019, 08:58:38 AM
The tool is now updated with the latest data from Friday 21st of June Here is the usual snapshot about the last week: Top Sender per board last week 76 suchmoon Legendary Meta
68 suchmoon Legendary Beginners & Help
68 chimk Hero Member Pyccкий (Russian)
67 paxmao Sr. Member Español (Spanish)
64 suchmoon Legendary Politics & Society
61 dbshck Staff Bahasa Indonesia (Indonesian)
58 Flying Hellfish Staff Marketplace
49 suchmoon Legendary Trading Discussion
48 cabalism13 Sr. Member Pilipinas
46 frodocooper Staff Mining
44 suchmoon Legendary Serious discussion
44 Vispilio Sr. Member Türkçe (Turkish)
43 JayJuanGee Legendary Economics
35 ETFbitcoin Legendary Development & Technical Discussion
34 Halab Staff Français
21 tk808 Hero Member Altcoin Discussion
20 marcetin Legendary Announcements (Altcoins)
15 OgNasty Donator Bitcoin Technical Support
12 Carlton Banks Legendary Bitcoin Discussion
12 qwk Donator Deutsch (German)
12 babo Legendary Italiano (Italian)
10 Metroid Sr. Member Mining (Altcoins)
10 xandry Staff Polski
10 bitmover Hero Member Português (Portuguese)
8 suchmoon Legendary Off-topic
7 micgoossens Hero Member Nederlands (Dutch)
6 bones261 Legendary null
6 Heisenberg_Hunter Sr. Member India
6 4rzun4 Sr. Member Speculation (Altcoins)
6 OmegaStarScream Staff العربية (Arabic)
3 jonathan6655321 Member Marketplace (Altcoins)
2 xandry Staff Archival
2 o_e_l_e_o Hero Member Project Development
1 Daniel91 Legendary Hrvatski (Croatian)
1 S_Therapist Full Member Other languages/locations
1 dwminer1 Hero Member 한국어 (Korean)
95 Vispilio Sr. Member Meta
56 bitmover Hero Member Beginners & Help
51 witcher_sense Sr. Member Pyccкий (Russian)
50 WhyFhy Member Marketplace
33 roycilik Hero Member Bahasa Indonesia (Indonesian)
32 Toxic2040 Hero Member Economics
32 nutildah Legendary Trading Discussion
31 trendcoin Member Türkçe (Turkish)
27 HagssFIN Legendary Mining
26 asu Hero Member Pilipinas
23 satoshi Founder Development & Technical Discussion
23 DdmrDdmr Hero Member Español (Spanish)
15 bitbollo Legendary Italiano (Italian)
15 JaredKaragen Legendary Politics & Society
12 Scheede Sr. Member Deutsch (German)
12 CryptopreneurBrainboss Sr. Member Serious discussion
11 khaled0111 Sr. Member العربية (Arabic)
10 jbreher Legendary Announcements (Altcoins)
10 satoshi Founder Bitcoin Discussion
10 Eliovp Legendary Mining (Altcoins)
10 wwzsocki Hero Member Polski
7 Royse777 Hero Member Bitcoin Technical Support
7 F2b Full Member Français
7 Bitlover10 Newbie India
7 johnjimjack Jr. Member Marketplace (Altcoins)
6 tonych Hero Member Altcoin Discussion
6 bitmover Hero Member Português (Portuguese)
6 adrianto1995 Full Member Speculation (Altcoins)
5 bones261 Legendary null
4 friends1980 Sr. Member Nederlands (Dutch)
4 Jet Cash Legendary Off-topic
2 buwaytress Hero Member Project Development
1 igor72 Sr. Member Archival
1 Keeshan Member Hrvatski (Croatian)
1 Mpamaegbu Sr. Member Other languages/locations
48 null
127 Altcoin Discussion
145 Announcements (Altcoins)
2 Archival
132 Bahasa Indonesia (Indonesian)
371 Beginners & Help
127 Bitcoin Discussion
45 Bitcoin Technical Support
97 Deutsch (German)
153 Development & Technical Discussion
508 Economics
90 Español (Spanish)
57 Français
2 Hrvatski (Croatian)
19 India
80 Italiano (Italian)
598 Marketplace
23 Marketplace (Altcoins)
666 Meta
135 Mining
29 Mining (Altcoins)
11 Nederlands (Dutch)
17 Off-topic
3 Other languages/locations
195 Pilipinas
87 Politics & Society
33 Polski
23 Português (Portuguese)
6 Project Development
80 Serious discussion
23 Speculation (Altcoins)
350 Trading Discussion
231 Türkçe (Turkish)
269 Pyccкий (Russian)
25 العربية (Arabic)
1 한국어 (Korean)
Administrator 17
Copper Member 185
Donator 71
Full Member 163
Global Moderator 47
Hero Member 777
Jr. Member 40
Legendary 1900
Member 139
Newbie 14
Sr. Member 612
Staff 697
Administrator 30
Copper Member 231
Donator 5
Founder 33
Full Member 330
Global Moderator 42
Hero Member 893
Jr. Member 103
Legendary 1216
Member 551
Newbie 73
Sr. Member 849
Staff 74
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on June 28, 2019, 07:33:12 AM
The tool is now updated with the latest data from Friday 28th of June Here is the usual snapshot about the last week: Top Sender per board last week 152 chimk Hero Member Pyccкий (Russian)
144 Welsh Staff Meta
98 teramit Legendary Türkçe (Turkish)
95 micgoossens Hero Member Economics
75 TMAN Legendary Beginners & Help
68 frodocooper Staff Mining
65 Welsh Staff Serious discussion
53 killyou72 Copper Member Marketplace
52 suchmoon Legendary Trading Discussion
50 aigeezer Legendary Bitcoin Discussion
46 dbshck Staff Bahasa Indonesia (Indonesian)
44 tk808 Hero Member Altcoin Discussion
34 qwk Donator Deutsch (German)
31 Halab Staff Français
29 KeyJockey Hero Member Speculation (Altcoins)
28 paxmao Sr. Member Español (Spanish)
25 cabalism13 Sr. Member Pilipinas
24 Foxpup Legendary Politics & Society
20 Vlad2Vlad Legendary Announcements (Altcoins)
18 Foxpup Legendary Bitcoin Technical Support
18 fillippone Sr. Member Italiano (Italian)
18 cryptovigi Sr. Member Polski
14 HCP Legendary Development & Technical Discussion
14 Heisenberg_Hunter Sr. Member India
11 SyGambler Legendary العربية (Arabic)
10 vapourminer Legendary Mining (Altcoins)
10 TryNinja Legendary Português (Portuguese)
5 Welsh Staff Marketplace (Altcoins)
5 OgNasty Donator Off-topic
4 dbshck Staff null
3 friends1980 Sr. Member Nederlands (Dutch)
2 Sharon121212 Full Member Other languages/locations
2 LoyceV Legendary Project Development
1 marlboroza Legendary Hrvatski (Croatian)
1 NeuroticFish Legendary Română (Romanian)
81 1miau Sr. Member Meta
69 Macadonian Member Serious discussion
55 Carlton Banks Legendary Bitcoin Discussion
55 cryptjh Full Member Economics
52 Agrawas Full Member Marketplace
50 0n0t0le Legendary Pyccкий (Russian)
44 fillippone Sr. Member Beginners & Help
38 Quite Full Member Türkçe (Turkish)
34 marlboroza Legendary Trading Discussion
29 cAPSLOCK Legendary Speculation (Altcoins)
23 Forsyth Jones Sr. Member Português (Portuguese)
22 Flying Hellfish Staff Politics & Society
21 masulum Member Bahasa Indonesia (Indonesian)
20 Limx Dev Copper Member Announcements (Altcoins)
20 Scheede Sr. Member Deutsch (German)
20 MagicByt3 Full Member Mining
18 bob123 Hero Member Bitcoin Technical Support
17 fillippone Sr. Member Italiano (Italian)
16 mikeywith Sr. Member العربية (Arabic)
14 BitCryptex Hero Member Development & Technical Discussion
14 Bitlover10 Newbie India
14 adamvp Hero Member Polski
10 DdmrDdmr Hero Member Español (Spanish)
10 theyoungmillionaire Sr. Member Pilipinas
8 asche Hero Member Français
7 thd26bct Member Altcoin Discussion
6 mikeywith Sr. Member Mining (Altcoins)
5 Gunthar Hero Member Marketplace (Altcoins)
4 Whaleagent Jr. Member null
4 micgoossens Hero Member Nederlands (Dutch)
3 CryptopreneurBrainboss Sr. Member Other languages/locations
2 turtletime Jr. Member Off-topic
2 BitCryptex Hero Member Project Development
1 Trofo Sr. Member Hrvatski (Croatian)
1 Danezu Jr. Member Română (Romanian)
26 null
104 Altcoin Discussion
117 Announcements (Altcoins)
79 Bahasa Indonesia (Indonesian)
479 Beginners & Help
174 Bitcoin Discussion
119 Bitcoin Technical Support
154 Deutsch (German)
151 Development & Technical Discussion
759 Economics
54 Español (Spanish)
39 Français
1 Hrvatski (Croatian)
33 India
83 Italiano (Italian)
432 Marketplace
9 Marketplace (Altcoins)
419 Meta
110 Mining
27 Mining (Altcoins)
5 Nederlands (Dutch)
28 Off-topic
4 Other languages/locations
62 Pilipinas
46 Politics & Society
44 Polski
47 Português (Portuguese)
17 Project Development
1 Română (Romanian)
164 Serious discussion
46 Speculation (Altcoins)
318 Trading Discussion
301 Türkçe (Turkish)
435 Pyccкий (Russian)
33 العربية (Arabic)
Administrator 5
Copper Member 183
Donator 48
Full Member 192
Global Moderator 6
Hero Member 906
Jr. Member 33
Legendary 1932
Member 141
Newbie 14
Sr. Member 641
Staff 742
Administrator 9
Brand new 9
Copper Member 179
Donator 4
Founder 4
Full Member 627
Global Moderator 6
Hero Member 872
Jr. Member 142
Legendary 1186
Member 527
Newbie 47
Sr. Member 884
Staff 112
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: fillippone on June 28, 2019, 08:43:23 AM
So proud of this! Top Sender per board last week 18 fillippone Sr. Member Italiano (Italian)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Piggy on July 05, 2019, 11:12:54 AM
The tool is now updated with the latest data from Friday 5th of July Here is the usual snapshot about the last week: Top Sender per board last week 178 chimk Hero Member Pyccкий (Russian)
110 teramit Legendary Türkçe (Turkish)
103 Flying Hellfish Staff Marketplace
83 iCEBREAKER Legendary Announcements (Altcoins)
80 TMAN Legendary Meta
76 suchmoon Legendary Beginners & Help
65 micgoossens Hero Member Economics
50 frodocooper Staff Mining
48 Foxpup Legendary Bitcoin Discussion
43 Halab Staff Français
42 dbshck Staff Development & Technical Discussion
36 suchmoon Legendary Trading Discussion
20 dbshck Staff Bahasa Indonesia (Indonesian)
20 davide72 Legendary Italiano (Italian)
20 Forsyth Jones Sr. Member Português (Portuguese)
18 tk808 Hero Member Altcoin Discussion
14 1miau Sr. Member Deutsch (German)
13 DdmrDdmr Hero Member Español (Spanish)
12 LoyceV Legendary Bitcoin Technical Support
7 OgNasty Donator Off-topic
6 cabalism13 Sr. Member Pilipinas
6 Foxpup Legendary Politics & Society
6 wwzsocki Hero Member Polski
6 Macadonian Member Serious discussion
5 Heisenberg_Hunter Sr. Member India
5 arbitragecryptotrader Full Member Marketplace (Altcoins)
5 TheUltraElite Hero Member Project Development
5 Globb0 Legendary Speculation (Altcoins)
5 khaled0111 Sr. Member العربية (Arabic)
4 numanoid Legendary null
4 Anon11073 Staff 日本語 (Japanese)
2 JFoxOne Member Mining (Altcoins)
1 Gyrsur Legendary Archival
1 big_daddy Full Member Hrvatski (Croatian)
72 CryptopreneurBrainboss Sr. Member Meta
44 micgoossens Hero Member Economics
35 sportsbet.io Hero Member Marketplace
31 taikuri13 Sr. Member Pyccкий (Russian)
26 gospodin Full Member Türkçe (Turkish)
25 BitCryptex Hero Member Development & Technical Discussion
23 charlie137 Full Member Announcements (Altcoins)
23 morvillz7z Sr. Member Trading Discussion
21 1miau Sr. Member Deutsch (German)
18 bitmover Hero Member Beginners & Help
18 PassThePopcorn Full Member Mining
17 masulum Member Bahasa Indonesia (Indonesian)
17 Ale88 Sr. Member Italiano (Italian)
16 squatter Hero Member Bitcoin Discussion
13 o_e_l_e_o Hero Member Bitcoin Technical Support
13 BitcoinFX Legendary Off-topic
10 Adeilton Newbie Português (Portuguese)
9 Mighty_crypt Jr. Member Altcoin Discussion
8 DdmrDdmr Hero Member Español (Spanish)
8 Macadonian Member Serious discussion
7 Saint-loup Hero Member Français
6 Krsps Newbie Politics & Society
6 cryptovigi Sr. Member Polski
5 josephdd1 Hero Member Project Development
5 arpon11 Sr. Member Speculation (Altcoins)
5 mikeywith Sr. Member العربية (Arabic)
4 Bitlover10 Newbie India
3 Akonobea Jr. Member null
3 Bttzed03 Member Pilipinas
2 LoyceV Legendary Archival
2 CryptoBry Sr. Member Marketplace (Altcoins)
2 coinscrow Sr. Member Mining (Altcoins)
2 hakka Full Member 日本語 (Japanese)
1 Domchi Full Member Hrvatski (Croatian)
29 null
74 Altcoin Discussion
238 Announcements (Altcoins)
1 Archival
63 Bahasa Indonesia (Indonesian)
320 Beginners & Help
178 Bitcoin Discussion
61 Bitcoin Technical Support
129 Deutsch (German)
138 Development & Technical Discussion
461 Economics
28 Español (Spanish)
59 Français
2 Hrvatski (Croatian)
5 India
73 Italiano (Italian)
483 Marketplace
14 Marketplace (Altcoins)
344 Meta
73 Mining
11 Mining (Altcoins)
29 Off-topic
24 Pilipinas
43 Politics & Society
23 Polski
46 Português (Portuguese)
15 Project Development
31 Serious discussion
16 Speculation (Altcoins)
293 Trading Discussion
273 Türkçe (Turkish)
483 Pyccкий (Russian)
15 العربية (Arabic)
5 日本語 (Japanese)
Administrator 14
Copper Member 114
Donator 45
Full Member 197
Global Moderator 36
Hero Member 858
Jr. Member 68
Legendary 1621
Member 217
Newbie 11
Sr. Member 407
Staff 427
Administrator 20
Copper Member 146
Donator 4
Full Member 431
Global Moderator 17
Hero Member 836
Jr. Member 206
Legendary 887
Member 421
Newbie 54
Sr. Member 728
Staff 54
VIP 5
Here is the data for the whole month of June: Top Sender per board last month 695 chimk Hero Member ??????? (Russian)
438 suchmoon Legendary Meta
373 Flying Hellfish Staff Marketplace
293 DarkStar_ Legendary Pilipinas
238 qwk Donator Deutsch (German)
230 suchmoon Legendary Trading Discussion
223 dbshck Staff Bahasa Indonesia (Indonesian)
221 teramit Legendary Türkçe (Turkish)
213 micgoossens Hero Member Economics
174 frodocooper Staff Mining
144 ETFbitcoin Legendary Development & Technical Discussion
139 paxmao Sr. Member Español (Spanish)
138 Halab Staff Français
105 tk808 Hero Member Altcoin Discussion
104 suchmoon Legendary Politics & Society
102 TMAN Legendary Beginners & Help
81 Vlad2Vlad Legendary Announcements (Altcoins)
65 Welsh Staff Serious discussion
63 Micio Legendary Italiano (Italian)
50 MicroGuy Legendary null
50 aigeezer Legendary Bitcoin Discussion
50 fr4nkthetank Legendary Mining (Altcoins)
45 SyGambler Legendary ??????? (Arabic)
40 ETFbitcoin Legendary Bitcoin Technical Support
29 KeyJockey Hero Member Speculation (Altcoins)
25 Heisenberg_Hunter Sr. Member India
24 wwzsocki Hero Member Polski
24 sabotag3x Hero Member Português (Portuguese)
20 OgNasty Donator Off-topic
10 crazyearner Legendary Marketplace (Altcoins)
9 micgoossens Hero Member Nederlands (Dutch)
5 eckmar Legendary Project Development
4 finaleshot2016 Sr. Member Hrvatski (Croatian)
4 Anon11073 Staff ??? (Japanese)
3 popcoins Hero Member ?? (Chinese)
2 xandry Staff Archival
2 Sharon121212 Full Member Other languages/locations
1 NeuroticFish Legendary Româna (Romanian)
1 dwminer1 Hero Member ??? (Korean)
208 suchmoon Legendary Meta
132 micgoossens Hero Member Economics
132 asu Hero Member Pilipinas
123 gospodin Full Member Türkçe (Turkish)
118 suchmoon Legendary Trading Discussion
101 masulum Member Bahasa Indonesia (Indonesian)
92 witcher_sense Sr. Member ??????? (Russian)
79 bitmover Hero Member Beginners & Help
77 Agrawas Full Member Marketplace
70 Macadonian Member Serious discussion
60 Eliovp Legendary Mining (Altcoins)
58 Carlton Banks Legendary Bitcoin Discussion
53 XEL-project Copper Member Announcements (Altcoins)
52 Scheede Sr. Member Deutsch (German)
50 Jimmy Crypto Jr. Member null
49 DdmrDdmr Hero Member Español (Spanish)
45 Plutosky Sr. Member Italiano (Italian)
39 HCP Legendary Development & Technical Discussion
37 khaled0111 Sr. Member ??????? (Arabic)
35 LoyceV Legendary Bitcoin Technical Support
33 HagssFIN Legendary Mining
33 wwzsocki Hero Member Polski
30 cAPSLOCK Legendary Speculation (Altcoins)
26 Flying Hellfish Staff Politics & Society
25 Bitlover10 Newbie India
23 Forsyth Jones Sr. Member Português (Portuguese)
18 F2b Full Member Français
10 HCP Legendary Altcoin Discussion
10 cryptogendrop Newbie Marketplace (Altcoins)
10 BitcoinFX Legendary Off-topic
7 micgoossens Hero Member Nederlands (Dutch)
5 LoyceV Legendary Project Development
3 SISAR Hero Member Hrvatski (Croatian)
3 CryptopreneurBrainboss Sr. Member Other languages/locations
3 Ber86 Member ?? (Chinese)
2 hakka Full Member ??? (Japanese)
1 igor72 Sr. Member Archival
1 Danezu Jr. Member Româna (Romanian)
210 null
389 Altcoin Discussion
567 Announcements (Altcoins)
2 Archival
455 Bahasa Indonesia (Indonesian)
871 Beginners & Help
485 Bitcoin Discussion
478 Bitcoin Technical Support
661 Deutsch (German)
605 Development & Technical Discussion
2064 Economics
243 Español (Spanish)
211 Français
16 Hrvatski (Croatian)
72 India
356 Italiano (Italian)
1937 Marketplace
83 Marketplace (Altcoins)
2920 Meta
421 Mining
168 Mining (Altcoins)
24 Nederlands (Dutch)
90 Off-topic
7 Other languages/locations
895 Pilipinas
511 Politics & Society
141 Polski
114 Português (Portuguese)
47 Project Development
1 Româna (Romanian)
191 Serious discussion
109 Speculation (Altcoins)
1364 Trading Discussion
1219 Türkçe (Turkish)
1759 ??????? (Russian)
138 ??????? (Arabic)
4 ?? (Chinese)
6 ??? (Japanese)
1 ??? (Korean)
Administrator 52
Copper Member 601
Donator 388
Full Member 743
Global Moderator 156
Hero Member 3695
Jr. Member 132
Legendary 7990
Member 549
Newbie 63
Sr. Member 2245
Staff 2943
Administrator 249
Brand new 9
Copper Member 909
Donator 65
Founder 44
Full Member 1877
Global Moderator 102
Hero Member 3727
Jr. Member 662
Legendary 4873
Member 2017
Newbie 359
Sr. Member 3549
Staff 393
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Lakai01 on August 08, 2019, 04:14:38 AM
Hi piggy!
Hope you didnt stop maintaining your database? I am keenly awaiting the July-statistics ;)
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Saint-loup on August 18, 2019, 11:26:28 AM
No more updates? :-\
Piggy should be on holiday I guess.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Lakai01 on August 19, 2019, 02:30:41 PM
No more updates? :-\
Piggy should be on holiday I guess.
I think so, too. At least Piggy hasnt been online since 7th of August. Hopefully, he is back soon, would definitly miss his updates and statistics. Edit: The last update of Piggys database was on 2nd of August, so all data until that day is available and queryable.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Lakai01 on October 19, 2019, 03:10:58 PM
Because Piggy hasn't updated his database since July I decided to develop the tools necessary to get those infos by myself. I sticked to Piggys database schema, so anyone interested can simply download the following csv-file, import it into any database (sqlite for example) and run his/her statements.
This is the data for August, I will upload the data of September asap.
http://s000.tinyupload.com/?file_id=26186164095264151782 (http://s000.tinyupload.com/?file_id=26186164095264151782)
-> File was checked with Virustotal (Virustotal-Report (https://www.virustotal.com/gui/file/175dc9630ed5a40e116461a349a9526b0db42b1474292aa40d9b6db52c473535/detection))
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: DdmrDdmr on October 19, 2019, 03:56:42 PM
<
>
@Laika, Ive seen the file youve uploaded (McAffee WebAdvisor gave me a warning for some reason that was not very specific). It seems to be lacking the first week of august, and an equivalent to the UserData file to fully mimic @Piggys database info set. It may be interesting to get a feel of how many people would be interested before you commit to regular updates and make the effort to go over all past TXs. Sometime ago, I gave it a go at looking into SQL Queries on Google Sheets, to see if that was a viable alternative (see for example https://blog.sheetgo.com/google-sheets-formulas/query-formula-google-sheets/). Nevertheless, when I loaded my full database it was too slow for my liking, and it does not accept joins between tables. I then denormalized the data, adding the user names and such to the TX table, but Google Sheets then became even slower and the 5M cell limit was a challenge. Note: It may be interesting to create your own thread from this point onwards, so as to place your updates in a thread to that effect.
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Lakai01 on October 19, 2019, 05:41:18 PM
<
>
@Laika, Ive seen the file youve uploaded (McAffee WebAdvisor gave me a warning for some reason that was not very specific). It seems to be lacking the first week of august, and an equivalent to the UserData file to fully mimic @Piggys database info set. -snip- Note: It may be interesting to create your own thread from this point onwards, so as to place your updates in a thread to that effect. Thanks for the review DdmrDdmr! Piggy uploaded his data til the first week of August, so I decided to start from this date onwards. I will recheck if I any data is missing! The userdata table is missing on purpose, if someone needs the data I will upload it, too, of course!
Title: Re: Tool to run online SQL queries over Full Merit Data
Post by: Lakai01 on October 27, 2019, 06:05:57 PM
Due to the fact that no one (except DdmrDdmr) downloaded the csv for August I don't think that anyone - except me ;) - needs and uses the data (https://bitcointalk.org/index.php?topic=4657305.msg52897902#msg52897902). If someone still wants to have the data please send me a PM, I will upload and share it of course :)
|
