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