[neotoxic]

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!