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.
SELECT xf_user.user_id, xf_user.username, xf_user.email, xf_user_option.user_id, xf_user_option.receive_admin_email
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