DELETE FROM phpbb_users WHERE user_email LIKE '%.info'; DELETE FROM phpbb_user_group WHERE user_id NOT IN (SELECT user_id FROM phpbb_users);