Announcement

Collapse
No announcement yet.

SQL query help

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL query help

    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.

  • #2
    This should do it:

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

    Comment


    • #3
      Thank you very much.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X