Index: openacs-4/packages/dotlrn/www/communities-chunk-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/communities-chunk-oracle.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/dotlrn/www/communities-chunk-oracle.xql	25 Jan 2002 19:54:20 -0000	1.4
+++ openacs-4/packages/dotlrn/www/communities-chunk-oracle.xql	18 Feb 2002 16:50:43 -0000	1.5
@@ -100,6 +100,7 @@
                         from dotlrn_member_rels_full
                         where dotlrn_member_rels_full.user_id = :user_id
                         and dotlrn_member_rels_full.community_id = dotlrn_communities.community_id)
+      and dotlrn_communities.parent_community_id is null
       order by root_community_type, dotlrn_communities.community_type, dotlrn_communities.pretty_name
     </querytext>
   </fullquery>