SELECT folder.* FROM [sling:Folder] AS folder LEFT OUTER JOIN
[nt:unstructured] AS childnode ON ISCHILDNODE(childnode, folder) WHERE
ISDESCENDANTNODE(folder, "/var/test/links/a@b.com") and
folder.[jcr:path] LIKE '/var/test/links/%/%/%/%' AND
childnode.[jcr:primaryType] IS NULL AND childnode.[sling:resourceType]
IS NULL Check if this works. Assuming:1. your path is constant2. if you
run on the root path, which in this case is /var/test/links/a@b.com ,
you should get all empty folder path until da...