Limited Support
Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed.
We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.
Aug 23, 2025 6:39 pm
It is trivial to export Wordpress users. What I need is the ability to identify Wordpress users who have not posted in wpForo. The posts count is not in a core Wordpress table. Is it possible to obtain the query that produces the wpForo members list?
[domain]/wp-admin/admin.php?page=wpforo-members
Aug 23, 2025 10:45 pm
I have tried it, and it works, but without any guarantee.
SELECT u.ID, u.user_login, u.user_email, u.user_registered, u.user_status, u.display_name, p.title, p.groupid, p.secondary_groupids, p.avatar, p.cover, p.posts, p.topics, p.questions, p.answers, p.comments, p.reactions_in, p.reactions_out, p.points, p.custom_points, p.online_time, p.timezone, p.location, p.signature, p.about, p.occupation, p.status AS wpforo_status, p.is_email_confirmed, p.is_mention_muted FROM wp_users AS u LEFT JOIN wp_wpforo_profiles AS p ON p.userid = u.ID;
1. Change the prefix of the tables !! wp_ in ??_
2. After running it, click on “Export” at the bottom
3. Select CSV for Excel
4. OK
Page 2 / 2
Prev