Hey i wanted to clean up my forum, i have seen few of the spam threads are getting good hits from search engine.

Like few of them have more than 30 views which i don't want to delete.

Is there any query which i can run directly through phpmyadmin so that it will ban that user and will only remove threads which has less than 30 views or so.

My forum is on vb3.8.x.
devilboy23 Reviewed by devilboy23 on . removing threads based on views Hey i wanted to clean up my forum, i have seen few of the spam threads are getting good hits from search engine. Like few of them have more than 30 views which i don't want to delete. :| Is there any query which i can run directly through phpmyadmin so that it will ban that user and will only remove threads which has less than 30 views or so. ;) My forum is on vb3.8.x. Rating: 5