select all dm_document.r_object_id 
from dm_document_sp dm_document 
where (dm_document.i_has_folder = 1 
and dm_document.i_is_deleted = 0) 
and  (  (   dm_document.owner_name = 'DaveJones' 
         or dm_document.owner_name in ('group3','group4')
        ) 
      or exists (select   * 
           from     dm_acl_sp, 
                    dm_acl_rp 
           where    dm_acl_sp.r_object_id = dm_acl_rp.r_object_id 
           and      dm_document.acl_domain = dm_acl_sp.owner_name 
           and      dm_document.acl_name = dm_acl_sp.object_name 
           and      dm_acl_rp.r_accessor_permit >= 2 
           and      (   dm_acl_rp.r_accessor_name = 'dm_world' 
                     or (    dm_document.owner_name = 'DaveJones' 
                         and dm_acl_rp.r_accessor_name = 'dm_owner'
                        ) 
                     or dm_acl_rp.r_accessor_name = 'DaveJones' 
                     or (    dm_acl_rp.r_is_group = 1 
                         and dm_acl_rp.r_accessor_name in ('group3','group4')
                        )
                     )
                 )
       )