postgresql7.3 select dotlrn_communities_all.pretty_name, dotlrn_communities_all.community_id, dotlrn_community__url(dotlrn_communities_all.community_id) as url from dotlrn_communities_all, dotlrn_member_rels_approved, dotlrn_classes where dotlrn_communities_all.community_id = dotlrn_member_rels_approved.community_id and dotlrn_communities_all.community_type = dotlrn_classes.class_key and dotlrn_member_rels_approved.user_id = :user_id and acs_permission__permission_p(dotlrn_communities_all.community_id, :user_id, 'admin') = true and dotlrn_communities_all.community_id <> [dotlrn_community::get_community_id] order by dotlrn_communities_all.pretty_name select eg.grade_item_id as to_grade_item_id from evaluation_gradesx eg, acs_objects ao where content_revision__is_live(eg.grade_id) = true and eg.item_id = ao.object_id and ao.context_id = :community_package_id and lower(eg.grade_name) = '[string tolower $grade_name]' select et.task_name, eg.grade_name from evaluation_grades eg, evaluation_tasks et where et.grade_item_id = eg.grade_item_id and et.task_id = :task_id and content_revision__is_live(eg.grade_id) = true