Guest User

Untitled

a guest
Oct 21st, 2019
74
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2. d.dataid "Folder ID",
  3. dfp.fullpath "Path",
  4. d.name "Folder Name",
  5. k.name "Group",
  6. acl.PERM_LIST "Permissions"
  7. FROM
  8. dtree d
  9. join dtreeancestors da on d.dataid = da.dataid and da.ancestorid = 44411414 AND d.subtype IN (0,751)
  10. JOIN
  11. lrer_fullpath dfp
  12. ON
  13. dfp.dataid = d.dataid
  14. JOIN
  15. lrer_dtreeacl acl
  16. ON
  17. d.dataid = acl.DATAID
  18. JOIN
  19. kuaf k
  20. ON
  21. acl.RIGHTID = k.id
  22. AND k.type = 1
  23. ORDER BY
  24. dfp.fullpath,
  25. k.name
RAW Paste Data