Anonymous

SELECT node.GROUPNAME, (COUNT(parent.GROUPNAME) - (sub_tree.depth + 1)) AS depthFROM p_groups2 AS node,	p_groups2 AS parent,	p_groups2 AS sub_parent,	(		SELECT node.GROUPNAME, (COUNT(parent.GROUPNAME)-1) AS depth		FROM p_groups2 AS node,		p_groups2 AS parent,    	(			SELECT 				node.L,				COUNT(node.GROUPNAME) as depth			FROM                p_groups2 as node 			INNER JOIN 				grouplist ON grouplist.GROUPID=node.ID 			WHERE 				grouplist.UID=54320 			GROUP BY node.GROUPNAME			ORDER BY 				node.L ASC 			LIMIT 1    	 ) as m		WHERE node.L BETWEEN parent.L AND parent.R		AND node.L > m.L		GROUP BY node.GROUPNAME		ORDER BY node.L	)AS sub_treeWHERE node.L BETWEEN parent.L AND parent.R	AND node.L BETWEEN sub_parent.L AND sub_parent.R	AND sub_parent.GROUPNAME = sub_tree.GROUPNAMEGROUP BY node.GROUPNAMEORDER BY node.L;