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