先查询一下与后台的未审核的主题数是否一致

SELECT count( * )

FROM `表前缀_threads`

WHERE displayorder = -2;

批量删除未审核的主题

delete from 表前缀_threads where displayorder=-2;

先查询一下与后台的未审核的回复数是否一致

SELECT count( * )

FROM `表前缀_threads`

WHERE displayorder = -2;

批量删除未审核的回复

delete from 表前缀_posts where invisible=-2;

 

SELECT count( * ) FROM cdb_threads WHERE displayorder = -2;

delete from cdb_threads where displayorder=-2;