delete from phpbb_users where user_actkey<>'';
delete from phpbb_user_group where user_id not in (SELECT user_id FROM phpbb_users);
delete from phpbb_profile_fields_data where user_id not in (select user_id from phpbb_users);