discuz7.2与discuz x1.0批量删除待审核的帖子的SQL语句

天狼晓月

discuz7.2的语句

1. 
   
2. delete from cdb_threads  where displayorder=-2;
   
3. delete from cdb_posts  where invisible=-2;
   

复制代码

discuz x1.0的语句

1. 
   
2. delete from pre_forum_thread where displayorder=-2;
   
3. delete from pre_forum_post where invisible=-2;
   
4. delete from pre_forum_thread  where `displayorder` = '-1';
   

复制代码

x1的最后一句是删回收站的。