update bt_projects
set description = :description,
email_subject_name = :email_subject_name,
maintainer = :maintainer
where project_id = :package_id
select pa.instance_name as name,
pr.description,
pr.email_subject_name,
pr.maintainer
from bt_projects pr,
apm_packages pa
where pr.project_id = :package_id
and pa.package_id = pr.project_id
select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id
from cc_users u
where upper(coalesce(u.first_names || ' ', '') ||
coalesce(u.last_name || ' ', '') ||
u.email || ' ' ||
coalesce(u.screen_name, '')) like upper('%'||:value||'%')
order by name