SQL:

SELECT  id, laber, coalesce(name, 'Anonymous') AS autor,
	 datum::date AS datum,
	 l,r,
	 (SELECT count(i.*)
	  FROM laber i
	  WHERE i.l < a.l AND i.r>a.r AND coalesce(i.mama,i.id)=a.mama) AS depth,
	 CASE
	 WHEN l=0 THEN 'root'
	 WHEN l+1=r then  'blatt'
	 ELSE 'knoten'
	 END AS typ,
	 CAST((r-l-1)/2 AS int) AS kinder
	 FROM laber a
	 WHERE root = '/blog/blog_in.phtml' AND (speer is null or speer = false)
	 ORDER BY r DESC, l DESC