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

[Coop1979]

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?

 

[Paul B]

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]

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]

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:

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