1 delete from forum where group_forum_id in
2 (select group_forum_id from forum_group_list where group_id in
3 (select group_id from groups where status='D')
6 delete from forum_group_list where group_id in ( select group_id from groups where status='D');
8 delete from user_group where group_id in (select group_id from groups where status = 'D');
10 delete from artifact_message where artifact_id in (select artifact_id from artifact where group_artifact_id in (select group_artifact_id from artifact_group_list where group_id in (select group_id from groups where status = 'D')));
11 delete from artifact where group_artifact_id in (select group_artifact_id from artifact_group_list where group_id in (select group_id from groups where status = 'D'));
12 delete from artifact_group where group_artifact_id in (select group_artifact_id from artifact_group_list where group_id in (select group_id from groups where status = 'D'));
13 delete from artifact_category where group_artifact_id in (select group_artifact_id from artifact_group_list where group_id in (select group_id from groups where status = 'D'));
14 delete from artifact_group_list where group_id in (select group_id from groups where status = 'D');
17 delete from frs_file where release_id in ( select release_id from frs_release where package_id in ( select package_id from frs_package where group_id in (select group_id from groups where status = 'D')));
20 delete from frs_release where package_id in ( select package_id from frs_package where group_id in (select group_id from groups where status = 'D'));
22 delete from frs_package where group_id in (select group_id from groups where status = 'D');
24 delete from project_task where group_project_id in (select group_project_id from project_group_list where group_id in (select group_id from groups where status = 'D'));
26 delete from group_plugin where group_id in (select group_id from groups where status = 'D');
28 delete from project_group_list where group_id in (select group_id from groups where status = 'D');
30 delete from groups where status = 'D' ;