Re: [Merit Analysis] Users ranked Sr. Member & up that have not earned any merit
I think your list might be incomplete. See https://bitcointalk.org/index.php?action=profile;u=357263 a hero user who has not received any merit but is not on the list.
I suspect the number is far greater than what you say. If memory serves me correctly, well under 1% of all active accounts have received at least one merit as of a month or two ago.
Yeah, please refer to the previous posts. I suspect the number is far greater than what you say. If memory serves me correctly, well under 1% of all active accounts have received at least one merit as of a month or two ago.
I have checked the UserData table, as DdmrDdmr said, it has only 29039 records which is a lot less that the current 2 mil members. @Piggy, any chance we could have a more detailed UserData table to be able to extract more information? I can also help with this task.
So, indeed, a lot of users are missing from the DB and this could only reflect a small portion of the users. I have updated the disclaimer.
Man you are great!!! As I see you are really fan of stats!!!
Anyway great work and thanks for taking my challenge... I find this results quite interesting...
I'd like to play myself with such database... Few days ago i fonud only Bitcointalk Merit Dashboard by DdmrDdmr but the problem was i could download data to make some analysis on my own only in pdf format ;-( (which sucks for such purposes).
Today I read here about Piggy's SQL https://albertoit.github.io/Merit-Explorer-SQL/ - I understand that this is the source of your analysys?
Thanks a lot! Yes, that's where I'm getting the stats from.Anyway great work and thanks for taking my challenge... I find this results quite interesting...
I'd like to play myself with such database... Few days ago i fonud only Bitcointalk Merit Dashboard by DdmrDdmr but the problem was i could download data to make some analysis on my own only in pdf format ;-( (which sucks for such purposes).
Today I read here about Piggy's SQL https://albertoit.github.io/Merit-Explorer-SQL/ - I understand that this is the source of your analysys?
What you are really listing:
Members in the UserData table, that have not earned a single merit. Now the key is in understanding what is in the UserData table:
I use a very similar table as @Piggys, with exactly the same number of records: 29.039.Those 29.039 people in the table are those involved in a sMerit TX at any point in history. That is, those that have either sent sMerit, receives sMerit, or both.
Any user that has never sent nor received sMerit is not in the UserData table, which is likely the majority of cases that you are looking for.
So my point is that you are listing a different set of users to the intended objective (a subset really).
Note: Theres nothing wrong with Piggys database (it's rather similar to mine). Its a good starting point for people that want to query and not download data themselves, buy we need to understand exactly what the tables hold. It is not a SQL issue, but a comprehension on the data in the DB.
Ok, I understand what you're saying now and yes, you are correct. The SQL is correct but the DB is not listing every user, I wasn't aware of this. Members in the UserData table, that have not earned a single merit. Now the key is in understanding what is in the UserData table:
I use a very similar table as @Piggys, with exactly the same number of records: 29.039.Those 29.039 people in the table are those involved in a sMerit TX at any point in history. That is, those that have either sent sMerit, receives sMerit, or both.
Any user that has never sent nor received sMerit is not in the UserData table, which is likely the majority of cases that you are looking for.
So my point is that you are listing a different set of users to the intended objective (a subset really).
Note: Theres nothing wrong with Piggys database (it's rather similar to mine). Its a good starting point for people that want to query and not download data themselves, buy we need to understand exactly what the tables hold. It is not a SQL issue, but a comprehension on the data in the DB.
Anyways, even if this is a subset of the data here, we still have an idea on what is going on.
You know what is more interesting? Demoting them back to newbie 
I wouldn't go that far... They hanged on here for years and raised the activity. That has to be worth something.