postgresql7.1 select b.bug_id, b.bug_number, b.summary, b.project_id, o.creation_user as submitter_user_id, submitter.first_names as submitter_first_names, submitter.last_name as submitter_last_name, submitter.email as submitter_email, b.component_id, c.component_name, o.creation_date, to_char(o.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty, st.pretty_name as status, b.resolution, b.user_agent, b.found_in_version, b.fix_for_version, b.fixed_in_version, to_char(now(), 'fmMon/DDfm/YYYY') as now_pretty from bt_bugs b, acs_objects o, bt_components c, cc_users submitter, workflow_cases cas, workflow_case_fsm cfsm, workflow_fsm_states st where b.bug_id = :bug_id and b.project_id = :package_id and o.object_id = b.bug_id and c.component_id = b.component_id and submitter.user_id = o.creation_user and cas.object_id = b.bug_id and cfsm.case_id = cas.case_id and cfsm.current_state = st.state_id select pck.instance_name as project_name, prj.description as project_description, prj.folder_id as project_folder_id, prj.root_keyword_id as project_root_keyword_id, ver.version_id as current_version_id, coalesce(ver.version_name, 'None') as current_version_name from apm_packages pck, bt_projects prj left outer join bt_versions ver on (ver.project_id = prj.project_id and active_version_p = 't') where pck.package_id = :package_id and prj.project_id = pck.package_id select 1 from bt_bugs where project_id = :package_id limit 1 select u.first_names as user_first_names, u.last_name as user_last_name, u.email as user_email, ver.version_id as user_version_id, coalesce(ver.version_name, 'None') as user_version_name from cc_users u, bt_user_prefs up left outer join bt_versions ver on (ver.version_id = up.user_version) where u.user_id = :user_id and up.user_id = u.user_id and up.project_id = :package_id select bt_project__keywords_delete(:package_id, 'f') select acs_object__name(party_id) from parties where party_id = :filter_assignee age(b.creation_date) < interval '$filter_n_days days' content_keyword__is_assigned(b.bug_id, $keyword_id, 'none') left outer join cr_item_keyword_map km_order on (km_order.item_id = b.bug_id) join cr_keywords kw_order on (km_order.keyword_id = kw_order.keyword_id and kw_order.parent_id = :filter_orderby) 1=1 select bt_project__delete(:project_id); select bt_project__new(:project_id); select workflow_case__delete(:case_id); select notification__delete(:notification_id); select content_item__delete(:bug_id);