select community_id, dotlrn_class_instances_full.pretty_name, dotlrn_class_instances_full.url, acs_permission.permission_p(community_id, :user_id, 'admin') as admin_p from dotlrn_class_instances_full, dotlrn_member_rels_full where dotlrn_member_rels_full.user_id = :user_id and dotlrn_member_rels_full.community_id = dotlrn_class_instances_full.class_instance_id select community_id, dotlrn_clubs_full.pretty_name, dotlrn_clubs_full.url, acs_permission.permission_p(community_id, :user_id, 'admin') as admin_p from dotlrn_clubs_full, dotlrn_member_rels_full where dotlrn_member_rels_full.user_id = :user_id and dotlrn_member_rels_full.community_id = dotlrn_clubs_full.club_id