select * from nodes where parent_id=?

##</code><code>##

select * from nodes,children 
where nodes.node_id=children.node_id
and children.parent_id=?

##</code><code>##

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