为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】：win10
【CPU】:
【问题描述】：[limit]附近出现错误 语法分析出错
SQL语句：SELECT
*
FROM
(
SELECT
TMP.,
ROWNUM ROW_ID
FROM
(
select
ppi.* ,
IFNULL(su.name, ’ ') managerName ,
IFNULL(ssu.name, ’ ') directorName ,
IFNULL(sssu.name, ’ ') changePersonName,
(
select
status
from
node_term
where
projectid = ppi.id
and is_delete = 0
order by
create_date desc limit 1
)
nodeTermStatus,
(
select
proc_ins_id
from
node_term
where
projectid = ppi.id
and is_delete = 0
order by
create_date desc limit 1
)
nodeProcInsId
from
pm_projectinfo ppi
LEFT JOIN sys_user su
on
ppi.manager = su.id
LEFT JOIN sys_user ssu
on
ppi.director = ssu.id
LEFT JOIN sys_user sssu
on
ppi.change_person = sssu.id
where
ppi.is_delete = 0
and
(
ppi.create_by IN ( ? )
or ppi.id in
(
select
ppt.project_id
FROM
pm_project_team ppt
where
ppt.user_id = ?
and ppt.is_delete = 0
and ppt.type = 1
)
)
order by
ppi.update_date desc
)
TMP
WHERE
ROWNUM <=?
)
WHERE
ROW_ID > ?