Index: openacs-4/packages/dotlrn/www/dotlrn-main-portlet-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/dotlrn-main-portlet-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn/www/dotlrn-main-portlet-postgresql.xql	15 Jul 2002 20:12:46 -0000	1.1
+++ openacs-4/packages/dotlrn/www/dotlrn-main-portlet-postgresql.xql	3 Jun 2003 18:35:47 -0000	1.2
@@ -5,26 +5,26 @@
 
     <fullquery name="select_communities">
         <querytext>
-            select dotlrn_communities.*,
-                   dotlrn_community__url(dotlrn_communities.community_id) as url,
+            select dotlrn_communities_all.*,
+                   dotlrn_community__url(dotlrn_communities_all.community_id) as url,
                    (CASE
                       WHEN
-                         dotlrn_communities.community_type = 'dotlrn_community'
+                         dotlrn_communities_all.community_type = 'dotlrn_community'
                       THEN 'dotlrn_community'
-                      WHEN dotlrn_communities.community_type = 'dotlrn_club'
+                      WHEN dotlrn_communities_all.community_type = 'dotlrn_club'
                       THEN 'dotlrn_club'
                       ELSE 'dotlrn_class_instance'
                    END) as simple_community_type,
-                   tree_level(dotlrn_communities.tree_sortkey) as tree_level,
+                   tree_level(dotlrn_communities_all.tree_sortkey) as tree_level,
                    coalesce((select tree_level(dotlrn_community_types.tree_sortkey)
                         from dotlrn_community_types
-                        where dotlrn_community_types.community_type = dotlrn_communities.community_type), 0) as community_type_level,
-                   acs_permission__permission_p(dotlrn_communities.community_id, :user_id, 'admin') as admin_p
-            from dotlrn_communities,
+                        where dotlrn_community_types.community_type = dotlrn_communities_all.community_type), 0) as community_type_level,
+                   acs_permission__permission_p(dotlrn_communities_all.community_id, :user_id, 'admin') as admin_p
+            from dotlrn_communities_all,
                  dotlrn_member_rels_approved
-            where dotlrn_communities.community_id = dotlrn_member_rels_approved.community_id
+            where dotlrn_communities_all.community_id = dotlrn_member_rels_approved.community_id
             and dotlrn_member_rels_approved.user_id = :user_id
-            order by dotlrn_communities.tree_sortkey
+            order by dotlrn_communities_all.tree_sortkey
         </querytext>
     </fullquery>