A Database Error Occurred
Error Number: 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.nome ORDER BY node.`left` )AS sub_tree WHERE node.`' at line 11
SELECT node.*, (COUNT(parent.nome) - (sub_tree.depth + 1)) AS depth FROM categorie AS node, categorie AS parent, categorie AS sub_parent, ( SELECT node.nome, (COUNT(parent.nome) - 1) AS depth FROM categorie AS node, categorie AS parent WHERE node.`left` BETWEEN parent.`left` AND parent.`right` AND node.id = GROUP BY node.nome ORDER BY node.`left` )AS sub_tree WHERE node.`left` BETWEEN parent.`left` AND parent.`right` AND node.`left` BETWEEN sub_parent.`left` AND sub_parent.`right` AND sub_parent.nome = sub_tree.nome GROUP BY node.nome ORDER BY node.`left`;