Hi!
error with Subquery alias...
help...
SELECT *,(SELECT COUNT(id)FROM articles a WHERE a.lft < articles.lft AND a.rgt > articles.rgt) AS depthFROM articleswhere (depth < 3)ORDER BY lft
Max mailto:maxim(dot)bondaruk(at)gmail(dot)com