All pastes #158299 Raw Edit

Stuff

public sql v1 · immutable
·published 2006-09-02 02:10 UTC
rendered paste body
SELECT a.idFROM    (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