常用 SQL

懶得每次重打，
雖然SQL的指令是滿簡單的
1.統計來亂的IP(2011-04-10 修改，只捉出 ip 數大於3 的IP即可)

select user_ip from (
select user_ip, count(user_ip) bbb
from phpbb_users
group by user_ip
order by bbb desc) testTable
where bbb >3
order by user_ip

2.砍掉一堆來亂的帳號
delete FROM `phpbb_users`
where user_id > 20000