SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY node.id ORDER BY node.lft )AS sub_tree WHERE node.lf' at line 11

---

(SELECT node.name,node.id,node.lft, (COUNT(parent.id) - (sub_tree.depth +1)) AS depth FROM tree AS node, tree AS parent, tree AS sub_parent, ( SELECT node.name,node.id, (COUNT(parent.id) - 1) AS depth FROM tree AS node, tree AS parent WHERE node.lft BETWEEN parent.lft AND parent.rgt AND node.id = GROUP BY node.id ORDER BY node.lft )AS sub_tree WHERE node.lft BETWEEN parent.lft AND parent.rgt AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt AND sub_parent.id = sub_tree.id GROUP BY node.id HAVING depth <= 1) UNION DISTINCT (SELECT node.name name ,node.id,node.lft lft, (COUNT(parent.id) - (sub_tree.depth+2)) AS depth FROM tree AS node, tree AS parent, tree AS sub_parent, ( SELECT node.name,node.id, (COUNT(parent.id) - 1) AS depth FROM tree AS node, tree AS parent WHERE node.lft BETWEEN parent.lft AND parent.rgt AND node.id = 0 GROUP BY node.id ORDER BY node.lft )AS sub_tree WHERE node.lft BETWEEN parent.lft AND parent.rgt AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt AND node.id <> AND sub_parent.id = sub_tree.id GROUP BY node.id HAVING depth = 0) ORDER BY lft