Index: openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list-postgresql.xql,v
diff -u -r1.6 -r1.6.30.1
--- openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list-postgresql.xql	4 Dec 2001 00:20:47 -0000	1.6
+++ openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list-postgresql.xql	3 Jul 2016 14:10:41 -0000	1.6.30.1
@@ -1,7 +1,5 @@
 <?xml version="1.0"?>
-
 <queryset>
-   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
 <fullquery name="rel_type_info">      
       <querytext>
@@ -18,6 +16,24 @@
 
       </querytext>
 </fullquery>
+  
+<fullquery name="relations_query">      
+      <querytext>
 
+select r.rel_id, 
+       party_names.party_name as element_name
+from (select DISTINCT rels.rel_id, object_id_two
+      from $extra_tables acs_rels rels
+      where rels.rel_type = :rel_type
+        and rels.object_id_one = :group_id $extra_where_clauses) r, 
+     party_names 
+where r.object_id_two = party_names.party_id
+and   acs_permission__permission_p(rels.rel_id, :user_id, 'read')         
+
+order by element_name
+
+      </querytext>
+</fullquery>
+
  
 </queryset>