-delete from forum where posted_by in
+delete from forum where posted_by in
(select user_id from users where status='D');
-delete from project_messages where posted_by in
+delete from project_messages where posted_by in
(select user_id from users where status='D');
-delete from user_group where user_id in
+delete from user_group where user_id in
(select user_id from users where status='D');
delete from artifact_history where artifact_id in (select artifact_id from artifact where assigned_to in