SELECT a.id
FROM
    (SELECT O1.lft, O1.id, COUNT(O2.id)
   FROM content_tree AS O1, content_tree AS O2
   WHERE O1.lft BETWEEN O2.lft AND O2.rgt
   GROUP BY O2.id
   ORDER BY O1.lft;
) AS a