select project_id, name, description, active_p, project_lead from logger_projects where project_id = :project_id insert into logger_project_var_map (project_id, variable_id, primary_p) values (:project_id, :variable_id, :primary_p) delete from logger_project_var_map where project_id = :project_id and variable_id = :variable_id update logger_project_var_map set primary_p = 'f' where project_id = :project_id update logger_project_var_map set primary_p = 't' where project_id = :project_id and variable_id = :variable_id select count(*) from logger_project_var_map where project_id = :project_id and primary_p = 't' select variable_id from logger_project_var_map where project_id = :project_id and primary_p = 't' select variable_id from logger_project_var_map where project_id = :project_id update logger_projects set name = :name, description = :description, project_lead = :project_lead, active_p = :active_p where project_id = :project_id update logger_projects set active_p = :active_p where project_id = :project_id select uouter.first_names || ' ' || uouter.last_name, uouter.user_id from cc_users uouter where uouter.user_id in (select distinct u.user_id from cc_users u where u.user_id in (select p.project_lead from logger_projects p, logger_project_pkg_map ppm where ppm.project_id = p.project_id and ppm.package_id = :package_id) or u.user_id = :user_id) order by lower(uouter.first_names), lower(uouter.last_name)