How To Search For Sub Account Members In The Database

Link: https://support.brilliantdirectories.com/support/solutions/articles/12000060081-how-to-search-for-sub-account-members-in-the-database

To see the list of members who have been added as a sub account, Navigate to Developers --> MySQL Database:





Click on the database that ends with wording "directory":





Conduct a search for the table users_data and open it by clicking on it:





Click on SQL:





Paste the specified SQL code and click Go:






This is the SQL code needed to run: 


SELECT * FROM `users_data` WHERE parent_id > 0


Which will display your members that are added as sub accounts: