exporting email address

[SEOvB]

I need to get all my forums members email address from the vBulletin database into a list whats the SQL query to select them all.;

Thanks

[MoT3rror]

You can generate it by the Admin CP by
Users -> Generate Mailing List

Here is the SQL to select all
SELECT userid, email FROM users

[SEOvB]

Thanks :)