SELECT term.term, term.mptt_left, term.mptt_right, COUNT(*) AS depth,
	(SELECT COUNT(*)+1
	FROM {terms} AS t1
	INNER JOIN {terms} AS t2
		ON t1.mptt_left BETWEEN t2.mptt_left AND t2.mptt_right
	WHERE t1.term = @myterm) AS child_depth
FROM {terms} AS term
INNER JOIN {terms} AS t2
	ON term.mptt_left BETWEEN t2.mptt_left AND t2.mptt_right
GROUP BY term.term
HAVING term.mptt_left BETWEEN @myterm_left+1 AND @myterm_right-1
AND depth = child_depth
ORDER BY NULL;