Reply To: Wrong User counting
You should create your own topic with specificity to your situation, instead of making comments on topics that are outdated and quite possibly irrelevant.
Closing this topic due to the nature of it’s age (6 years old).
FWIW: “Last Active” comes from an entry within the “bp_activity” table with the “type” field/column equal to “last_activity” of which the date is taken from the “date_recorded” field/column and this entry (last_active) is, typically required for a user/member to show within the “members directory” page. Thus, at this point, it doesn’t make sense that these imported users show with the “Alphabetical” filter and not with the other indicated filters. However, there is the possibility of a plugin or custom code that might be interfering with the query results.
The “Newest Registered” comes from the “user_registered” field/column of the WordPress “user” table.