DedeCMS 大量刪除垃圾註冊使用者和垃圾文檔

1)尋找垃圾使用者(需要根據垃圾使用者的特徵來判斷).
select logintime,userid,sex from hfpet_member where sex='' order by logintime desc;
delete from hfpet_member where sex='' and mid> 8000;

2)尋找文檔微表中member id 不為空白且member id 不是註冊使用者的文檔
文檔微表,用於一些輕量的查詢！
select * from  hfpet_arctiny where mid !='' and mid not in (select mid from hfpet_member) order by id asc;

3)尋找沒有被審核，且member id 不為空白且member id 不是註冊使用者的文檔
select title,mid,ismake from hfpet_archives where ismake='' and mid !='' and mid not in (select mid from hfpet_member);

4)尋找沒有文檔id 的 addonarticle
select * from hfpet_addonarticle where aid not in (select id from hfpet_archives);

刪除順序：
delete from hfpet_member where sex='' and mid> 12000;
delete from  hfpet_arctiny where mid !='' and mid not in (select mid from hfpet_member);
delete from  hfpet_archives where ismake='' and mid !='' and mid not in (select mid from hfpet_member);
delete from hfpet_addonarticle where aid not in (select id from hfpet_archives);