SQL query help

[Doug Nelson]

This is almost certainly the wrong forum for this, so my apologies and please move it as appropriate.

I'm looking for the SQL query to output a list of user email addresses from only registered and awaiting confirmation users that have opted out of admin emails.

Thanks in advance.

[Jake Bunce]

This should do it:

SELECT email
FROM user
WHERE (usergroupid = 2 OR usergroupid = 3)
AND NOT(options & 16)

[Doug Nelson]

Thank you very much.