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 -N -r1.2.8.2 -r1.2.8.3
--- openacs-4/packages/chat/www/room-postgresql.xql	2 Jul 2016 10:46:45 -0000	1.2.8.2
+++ openacs-4/packages/chat/www/room-postgresql.xql	31 Aug 2016 09:58:39 -0000	1.2.8.3
@@ -4,7 +4,7 @@
 
 <fullquery name="list_user_ban">
   <querytext>
-   select m.party_id, p.last_name || ', ' || p.first_names as name, pa.email
+   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 acs_permission__permission_p(:room_id, pa.party_id, 'chat_ban')