phpBB2 大量殺未啟用帳號sql

查看有多少
SELECT u.user_id, u.username, u.user_active, ug.group_id
FROM `phpbb_users` u, `phpbb_user_group` ug, `phpbb_groups` g
WHERE u.user_id = ug.user_id
AND ug.group_id = g.group_id
AND u.user_id != -1
AND u.user_active =0
AND u.user_session_time =0




刪除
DELETE `phpbb_users` u, `phpbb_user_group` ug, `phpbb_groups` g
FROM `phpbb_users` u, `phpbb_user_group` ug, `phpbb_groups` g
WHERE u.user_id = ug.user_id
AND ug.group_id = g.group_id
AND u.user_id != -1
AND u.user_active =0
AND u.user_session_time =0

看結果
SELECT u.user_id, u.username, u.user_active, ug.group_id, g.group_name
FROM `phpbb_users` u, `phpbb_user_group` ug, `phpbb_groups` g
WHERE u.user_id = ug.user_id
AND ug.group_id = g.group_id
AND u.user_id != -1