Index: openacs-4/packages/acs-subsite/www/admin/rel-segments/one.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/rel-segments/one.xql,v diff -u -r1.1 -r1.1.4.1 --- openacs-4/packages/acs-subsite/www/admin/rel-segments/one.xql 15 May 2001 16:59:00 -0000 1.1 +++ openacs-4/packages/acs-subsite/www/admin/rel-segments/one.xql 17 Feb 2003 03:15:45 -0000 1.1.4.1 @@ -15,12 +15,14 @@ - select count(*) as number_elements - from rel_segment_party_map map, acs_object_party_privilege_map perm - where perm.object_id = map.party_id - and perm.party_id = :user_id - and perm.privilege = 'read' - and map.segment_id = :segment_id + select count(*) as number_elements + from rel_segment_party_map map + where map.segment_id = :segment_id + and exists (select 1 + from acs_object_party_privilege_map perm + where perm.object_id = map.party_id + and perm.party_id = :user_id + and perm.privilege = 'read')