Forums
-
- Forum
- Posts
-
- Installation
- 28,255
- Troubleshooting
- 61,798
- Themes
- 10,301
- Plugins
- 15,221
- Requests & Feedback
- 14,830
- Showcase
- 3,252
-
This will show in you in PHPMYADMIN all users older than at least a month who have never posted:
SELECT ID,user_login,user_registered FROM wp_users
LEFT JOIN bb_posts ON ID=poster_id
WHERE user_registered<DATE_SUB(CURDATE(),INTERVAL 30 DAY)
AND poster_id is NULL
See also: WordPress.org • bbPress.org • BuddyPress.org • Matt • Blog RSS