postgresql7.1 select bt_project__keywords_delete(:package_id, 'f') select acs_object__name(party_id) from parties where party_id = :filter_assignee 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 acs_object__name(p.party_id) || ' (' || p.email || ')' as label, party_id from parties p where party_id in (select distinct(party_id) from workflow_case_role_party_map, workflow_cases where workflow_case_role_party_map.case_id = workflow_cases.case_id and workflow_cases.workflow_id = :workflow_id)