提示缺少关键字，哪点写错了吗？求指点
select loginname,realname,qd,
(case
when substr(qt,0,10)=to_char(to_date(qd,'yyyy-mm-dd')+1,'yyyy-mm-dd') then qt=substr(qd,0,10)||' 00:00:00'
when substr(qt,0,10)>to_char(to_date(qd,'yyyy-mm-dd')+1,'yyyy-mm-dd') then qt=qd
else qt end) as qt from
(
select loginname,realname,qt,qd
from (
select loginname,realname,qt ,max(qd) qd from (
select loginname,realname,qd,min(qt) qt from (
select qdl.loginname,qdl.realname,qdl.qd,qtl.qt from
(select a.loginname,a.realname,b.create_time as qd
from sys_user a
left join call_in_out_count b
on a.loginname = b.loginname
where a.userid in (select USERID from sys_user_role where ROLEID in (146,306))
and b.type = 1
order by b.create_time) qdl
left join (
select a.loginname,a.realname,b.create_time as qt
from sys_user a
left join call_in_out_count b
on a.loginname = b.loginname
where a.userid in (select USERID from sys_user_role where ROLEID in (146,306))
and b.type = 2
order by b.create_time) qtl
on qdl.loginname=qtl.loginname
and qtl.qt>qdl.qd
order by qd asc,qt asc)
group by loginname,realname,qd
order by qd asc)
group by loginname,realname,qt
order by qt)
)
;
