Index: openacs-4/packages/dotlrn/www/my-communities-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/my-communities-oracle.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/dotlrn/www/my-communities-oracle.xql	21 May 2002 07:46:03 -0000	1.7
+++ openacs-4/packages/dotlrn/www/my-communities-oracle.xql	31 May 2002 15:14:45 -0000	1.8
@@ -17,8 +17,9 @@
                    decode(dotlrn_community.admin_p(dotlrn_communities.community_id, dotlrn_member_rels_approved.user_id),'f',0,1) as admin_p
             from dotlrn_communities,
                  dotlrn_member_rels_approved
-            where dotlrn_communities.community_id = dotlrn_member_rels_approved.community_id
-            and dotlrn_member_rels_approved.user_id = :user_id
+            where dotlrn_member_rels_approved.user_id = :user_id
+            and dotlrn_communities.community_id = dotlrn_member_rels_approved.community_id
+            and dotlrn_communities.community_type != 'dotlrn_community'
             order by dotlrn_communities.pretty_name
         </querytext>
     </fullquery>