SELECT id, parent_id, name
FROM nodes
WHERE parent_id IN (SELECT descendant FROM closures GROUP BY descendant);

-- wtf:
-- there is only one row in closures
-- it's descendant id is 5
-- none of the rows returned by this query have a parent_id of 5