Add the query to get a list of all users who are not operators
Only display approved roles in API
Fix sql errors
Add a test for the pending roles list