SELECT
    d.dataid     dataid,
    dfp.fullpath "Path",
    d.name,
    k.name        "Group",
    acl.PERM_LIST "Permissions"
FROM
    dtree d
join dtreeacl da on d.dataid = da.dataid and da.ancestorid = %1 AND d.subtype=0

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
AND k.name = %2
ORDER BY
    d.dataid,
    k.name