<
>I understand your concerns but I believe my queries are correct. I'm using a more complicated approach, research SQL JOINS.<...>
Maybe I didnt explain my point clear enough. Lets put it this way:
What your OP wants to list:
Ranked Members - Member and above who was given merit airdrop (while introducing merit system) according to their ranks and didn't earn even one "by themself" this one maybe interesting!!!
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.