Index: openacs-4/packages/chat/www/room-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/www/room-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/chat/www/room-postgresql.xql	7 Aug 2017 23:48:07 -0000	1.3
+++ openacs-4/packages/chat/www/room-postgresql.xql	29 May 2018 17:09:02 -0000	1.4
@@ -4,12 +4,11 @@
 
 <fullquery name="list_user_ban">
   <querytext>
-    select pa.party_id, p.last_name || ', ' || p.first_names as name, pa.email
-    from persons p, parties pa
-    where p.person_id = pa.party_id
-    and pa.party_id in
+    select person_id as party_id, first_names, last_name
+    from persons
+    where person_id in 
     (select acs_permission.parties_with_object_privilege(:room_id::integer, 'chat_ban'::varchar))
-    order by p.last_name, p.first_names
+    order by last_name, first_names
   </querytext>
 </fullquery>