1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to create email list for 95,000+ users?

Discussion in 'XenForo Questions and Support' started by Coop1979, Apr 5, 2013.

  1. Coop1979

    Coop1979 Well-Known Member

    My forum has close to 100,000 members on it, and I'd like to create an email list to give to Sendy (http://sendy.co), but every time I try to create a list with my main user group, I just get a 500 Internal Error page.

    I can do a small user group (like the admins) without any problem.

    Is there a good way to perhaps do this via SQL?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    SELECT * FROM `xf_user` WHERE user_group_id = 2 will give you a complete list of all members in user group 2 as the primary.

    Then just export the result in .csv format.
    Coop1979 likes this.
  3. Coop1979

    Coop1979 Well-Known Member

    Brogan - one last question. I'm not great with MySQL syntax, so how do I cross reference that query with "receive_admin_email" from xf_user_option?
  4. MattW

    MattW Well-Known Member

    This should do it:

    SELECT xf_user.user_id, xf_user.username, xf_user.email, xf_user_option.user_id, xf_user_option.receive_admin_email
    FROM xf_user
    LEFT JOIN xf_user_option ON
    (xf_user.user_id = xf_user_option.user_id)
    WHERE xf_user.user_group_id = 2 AND xf_user_option.receive_admin_email = 1
    Claudio and Coop1979 like this.

Share This Page