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)