Index: openacs-4/packages/dotlrn/www/manage-memberships-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/Attic/manage-memberships-postgresql.xql,v
diff -u -r1.1 -r1.1.10.1
--- openacs-4/packages/dotlrn/www/manage-memberships-postgresql.xql	15 Jul 2002 20:12:46 -0000	1.1
+++ openacs-4/packages/dotlrn/www/manage-memberships-postgresql.xql	22 Jul 2004 16:24:49 -0000	1.1.10.1
@@ -180,4 +180,15 @@
         </querytext>
     </fullquery>
 
+    <fullquery name="select_non_member_club_ids">
+        <querytext>
+                select f.club_id
+                from dotlrn_clubs_full f
+                where f.join_policy <> 'closed'
+                  and f.club_id not in (select dotlrn_member_rels_full.community_id as club_id
+                                          from dotlrn_member_rels_full
+                                         where dotlrn_member_rels_full.user_id = :user_id)
+        </querytext>
+    </fullquery>
+
 </queryset>