Nested Sets headache - Printable Version

Code:
SELECT

            node.id as nid,            

            node.user_id,

            node.name,            

            node.node_type,

            node.leftval,

            node.rightval,

            node.asset_id,            

            (node.rightval - node.leftval) as height,

            (COUNT(parent.name) - (sub_tree.depth + 1)) AS depth 

          FROM            

            directories AS node,

            directories AS parent,            

            directories AS sub_parent,            

            (

              SELECT                

                node.id as nid,                

                node.name,



                (COUNT(parent.name)-1 ) AS depth              



              FROM

                directories,                

                directories AS node,                

                directories AS parent

              WHERE                

                node.leftval

                    BETWEEN parent.leftval AND parent.rightval              

              AND 

                node.leftval= " .$parNode['leftval']  . " 

              GROUP BY node.name              

              ORDER BY node.leftval            

          ) AS sub_tree

          WHERE

            node.user_id=$uid

          AND

            node.leftval BETWEEN parent.leftval AND parent.rightval

          AND 

            node.rightval=(node.leftval+1)

          AND

            sub_parent.name = sub_tree.name

          GROUP BY node.name

          HAVING depth = 1

          ORDER BY node.leftval;