SELECT
    d.dataid "Folder ID",
    dfp.fullpath "Path",
    d.name "Folder Name",
    k.name        "Group",
    acl.PERM_LIST "Permissions"
FROM
    dtree d
join dtreeancestors da on d.dataid = da.dataid and da.ancestorid = %1 AND d.subtype IN (0,751)
JOIN
    lrer_fullpath dfp
ON
    dfp.dataid = d.dataid
JOIN
    lrer_dtreeacl acl
ON
    d.dataid = acl.DATAID
JOIN
    kuaf k
ON
    acl.RIGHTID = k.id
AND k.type = 1
ORDER BY
    d.dataid,
    k.name