Bulk remove users

[firstrebel]

I have a large number of old user account, mostly unregistered, with 0 views and 0 posts. The usernames and email addresses are clearly not genuine Is there a way with some SQL that I can remove all of them that have 0 views and 0 posts?

Thanks

Bob

[Chuck S]

well maybe

DELETE FROM pp_users WHERE posts=0 AND views=0;

[firstrebel]

Yes of course, so simple. Thanks.

Bob

[Chuck S]

Yep simple mysql query based off what you wanted.