"SELECT node.id, node.node_path, (COUNT(parent.node_path)-1) AS depth FROM zd_snapshot_tree AS node, zd_snapshot_tree AS parent WHERE node.cluster_name = 'test' AND parent.cluster_name = 'test' AND node.node_path like '/%%' AND node.left BETWEEN parent.left AND parent.right GROUP BY node.node_path ORDER BY node.left"
这个sql 报错了