select case_id from workflow_cases where object_id = :bug_id select notification_id from notifications where response_id = :bug_id update cr_items set live_revision = null, latest_revision = null where item_id = :bug_id select ba.action_id, ba.action as loop_action, ba.resolution, ba.actor as actor_user_id, actor.first_names as actor_first_names, actor.last_name as actor_last_name, actor.email as actor_email, ba.action_date, to_char(ba.action_date, 'fmMM/DDfm/YYYY') as action_date_pretty, ba.comment_s, ba.comment_format from bt_bug_actions ba, cc_users actor where ba.bug_id = :bug_id and actor.user_id = ba.actor order by action_date select resolution from bt_bugs where bug_id = :object_id select c.maintainer from bt_components c, bt_bugs b where b.bug_id = :object_id and c.component_id = b.component_id select p.maintainer from bt_projects p, bt_bugs b where b.bug_id = :object_id and p.project_id = b.project_id select email_subject_name from bt_projects p, bt_bugs b where b.bug_id = :object_id and p.project_id = b.project_id select st.pretty_name, st.state_id, count(b.bug_id) from workflow_fsm_states st, bt_bugs b, workflow_cases cas, workflow_case_fsm cfsm where st.workflow_id = :workflow_id and b.project_id = :package_id and cas.workflow_id = :workflow_id and cas.object_id = b.bug_id and cfsm.case_id = cas.case_id and st.state_id = cfsm.current_state group by st.state_id, st.pretty_name, st.sort_order order by st.sort_order select c.component_name, c.component_id, count(b.bug_id) as num_bugs from bt_bugs b, bt_components c where b.project_id = :package_id and c.component_id = b.component_id group by c.component_name, c.component_id order by c.component_name exists (select 1 from workflow_case_assigned_actions aa, workflow_case_role_user_map crum where aa.case_id = cas.case_id and aa.action_id = $action_id and crum.case_id = aa.case_id and crum.role_id = aa.role_id and crum.user_id = :f_action_$action_id )