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 n.id' at line 8


querry error:/home/tosia90n/public_html4/include/class.dataaccessobject.php:242
SELECT n.id, n.lft, n.rgt, n.name, MAX(p.lft) AS plft, MIN(p.rgt) AS prgt, COUNT(p.id)-1 AS depth, (n.rgt-n.lft+1) AS width, IF((n.rgt-n.lft)=1,1,0) AS leaf FROM node AS n, node AS p WHERE n.lft > p.lft AND n.rgt < p.rgt AND n.id = GROUP BY n.id