select * from nodes where nodes.root_id=X.root_id
and X.left<= nodes.right and nodes.left<=X.right