1 delete from forum where posted_by in
2 (select user_id from users where status='D');
4 delete from project_messages where posted_by in
5 (select user_id from users where status='D');
7 delete from user_group where user_id in
8 (select user_id from users where status='D');
10 delete from artifact_history where artifact_id in (select artifact_id from artifact where assigned_to in
11 (select user_id from users where status='D'));
13 delete from artifact_history where mod_by in
14 (select user_id from users where status='D');
17 delete from artifact_file where artifact_id in (select artifact_id from artifact where assigned_to in
18 (select user_id from users where status='D'));
20 delete from artifact_message where artifact_id in (select artifact_id from artifact where assigned_to in
21 (select user_id from users where status='D'));
23 delete from artifact where assigned_to in
24 (select user_id from users where status='D');
26 delete from artifact where submitted_by in
27 (select user_id from users where status='D');
29 delete from users where status='D';