批量删除Discuz等待审核的主题和等待审核的回复的帖子方法

一段时间没登录后台，惊讶发现广告帖子已经达到2万多条了，要是一个个删除太麻烦了，所以还是拿出了phpmyadmin的sql命令功能:

DZ X2.0版本，批量删除未审核通过的帖子和主题【操作前请备份】

delete from pre_forum_thread where displayorder=-2;

delete from pre_forum_post where invisible=-2;

DZ X2.5版本，批量删除未审核通过的帖子和主题【操作前请备份】

delete from pre_forum_thread_moderate where 1

delete from pre_forum_post_moderate where 1