How To Search For Sub Account Members In The Database

Written by Chan Nier
Updated on February 19, 2025

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:

For additional assistance:
Email support@brilliantdirectories.com or create a ticket Inside Your Account Dashboard.

Was this article helpful and accurate? Yes No