Hi
I wonder how to 'safely' delete an user in SQL command ?
My site have thousands of inactive users , that is , no post , no PMs ... I want to delete these users , but not by web GUI (it is too inefficient)
I want to find user with ubbt_USER_PROFILE.USER_TOTAL_POSTS = 0 and ubbt_USER_PROFILE.USER_TOTAL_PM = 0 ,
Can I safely delete him just in ubbt_USERS ?
select USER_ID ,
USER_LOGIN_NAME ,
USER_DISPLAY_NAME ,
USER_REGISTRATION_EMAIL ,
count(USER_REGISTRATION_EMAIL) as c
from ubbt_USERS
join ubbt_USER_PROFILE using (USER_ID)
where ubbt_USER_PROFILE.USER_TOTAL_POSTS = 0
and ubbt_USER_PROFILE.USER_TOTAL_PM = 0
group by USER_REGISTRATION_EMAIL
having ( count(USER_REGISTRATION_EMAIL) > 1)
order by USER_ID;
UBBT 7.5.2