bbPress

Info

• 1 post
• 1 voice
• Started 1 year ago by nikeshoes2a
• This topic is not resolved

Tags

• groups
• SQL
• users

• Posts in this topic

Help with SQL Query

1. • 
   • neotoxic
   • Member

   • Posted 1 year ago #

   I need an SQL Query that will give me the user ID and email address of all the users who are in the following groups: -

   Memeber
   Modorator
   Administrator
   Key master

   I have this query that gives me all my user (including user of my WordPress site that don't have access to my forum)

   '
   $all_users = $bbdb->get_results("SELECT ID, user_email FROM $bbdb->users WHERE user_status=0");
   '

   Oh.. also the USER name would be really good as well.. (sorry I forgot to add that to my original post)

   Any help here would be awesome!

2. You must log in to post.