Select a subtree:

Query:


SELECT * FROM directory
WHERE
    left >= 4 AND right <= 9