Index: openacs-4/packages/dotlrn/www/communities-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/communities-chunk-postgresql.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/dotlrn/www/communities-chunk-postgresql.xql	8 Aug 2002 13:34:30 -0000	1.2
+++ openacs-4/packages/dotlrn/www/communities-chunk-postgresql.xql	27 Jan 2018 17:58:19 -0000	1.3
@@ -10,35 +10,6 @@
         </querytext>
     </fullquery>
 
-    <fullquery name="select_current_memberships">
-        <querytext>
-            select dotlrn_communities.community_id,
-                   dotlrn_communities.community_type,
-                   dotlrn_communities.pretty_name,
-                   dotlrn_communities.description,
-                   dotlrn_communities.package_id,
-                   dotlrn_community__url(dotlrn_communities.community_id) as url,
-                   1 as member_p,
-                   CASE
-                      WHEN acs_permission__permission_p(:user_id, 
-                                                        dotlrn_communities.community_id, 
-                                                        'admin') = 'f'
-                      THEN 0
-                      ELSE 1
-                   END as admin_p,
-                   (select dotlrn_community_types.community_type
-                    from dotlrn_community_types
-                    where dotlrn_community_types.tree_sortkey = tree_ancestor_key(dotlrn_communities.tree_sortkey, 1)) as root_community_type
-            from dotlrn_active_communities dotlrn_communities,
-                 dotlrn_member_rels_approved
-            where dotlrn_member_rels_approved.user_id = :user_id
-            and dotlrn_member_rels_approved.community_id = dotlrn_communities.community_id
-            order by root_community_type,
-                     dotlrn_communities.community_type,
-                     dotlrn_communities.pretty_name
-        </querytext>
-    </fullquery>
-
     <fullquery name="select_all_memberships">
         <querytext>
             select dotlrn_communities.community_id,