Skip to:
Content
Pages
Categories
Search
Top
Bottom

Reply To: Find an delete users without topic and or replies

@wpturk

Participant

Hi Diana,

you can get this info from mysql DB in case you have access: (ex. via phpmyadmin)

SELECT user_login FROM wp_users WHERE id not in (SELECT DISTINCT post_author FROM wp_posts) AND id not in (SELECT DISTINCT user_id FROM wp_comments) ORDER BY user_registered ASC;

You need to change wp_ if you have another prefix for your mysql tables.

After you’ve checked the list, you can change the sql statement and DELETE.

I hope this helps.

Skip to toolbar