• 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?

Coop1979

Well-known member
#1
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?
 

Brogan

XenForo moderator
Staff member
#2
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

Well-known member
#3
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?
 

MattW

Well-known member
#4
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?
This should do it:

Code:
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