SELECT t.name as cat_name,
t.category_id as cat_id,
tm.tree_id,
tt.name as tree_name
FROM category_tree_map tm,
categories c,
category_translations t,
category_tree_translations tt
WHERE c.tree_id = tm.tree_id and
c.category_id = t.category_id and
tm.object_id = :package_id and
tm.tree_id = tt.tree_id and
c.deprecated_p = 'f'
ORDER BY tt.name,
t.name
SELECT package_id
FROM cr_folders
WHERE description = 'Project Repository'
SELECT DISTINCT
p.first_names || ' ' || p.last_name as name,
p.person_id
FROM
persons p,
acs_rels r,
membership_rels mr
WHERE
r.object_id_one = :user_group_id and
mr.rel_id = r.rel_id and
p.person_id = r.object_id_two and
member_state = 'approved'
ORDER BY name
insert into general_comments
(comment_id,
object_id,
category)
values
(:comment_id,
:object_id,
null)
select email from parties where party_id = :user_id