SELECT $rows, (COUNT(parent.name) - (sub_tree.depth + 1)) AS depth FROM $hCatsTbl AS node, $hCatsTbl AS parent, $hCatsTbl AS sub_parent, ( SELECT $rows, (COUNT(parent.name) - 1) AS depth FROM $hCatsTbl AS node, $hCatsTbl AS parent WHERE node.lft BETWEEN parent.lft AND parent.rgt AND node.category_id = '$category_id' GROUP BY node.category_id ORDER BY node.lft )AS sub_tree WHERE node.lft BETWEEN parent.lft AND parent.rgt AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt AND sub_parent.name = sub_tree.name GROUP BY node.category_id HAVING depth <= 1 ORDER BY node.lft;