a special date

9.8,我会铭记在心
SELECT * FROM iems_special_task_info A INNER JOIN iems_special_project_info b ON A.proj_no = b.proj_no INNER JOIN sys_organization mo ON mo.bancsid = A.organization LEFT JOIN sys_organization so ON so.org_code = b.proj_org LEFT JOIN sys_user su ON su.account = A.deal_user LEFT JOIN ( SELECT o.*, ROW NUMBER () OVER ( PARTITION BY O.TASK_ID ORDER BY O.OPERATE_TIME DESC ) AS RN FROM iems_special_task_record o WHERE O.OPERATE_TYPE = 'CONFIRM' ) istr ON istr.TASK_ID = A.ID AND ISTR.RN = '1' LEFT JOIN SYS_USER SUU ON SUU.aCcOUnt = ISTR.OPERATE_USER WHERE A.problem_type = 'SPECIAL' AND ( ( A.deal_user IS NOT NULL AND mo.up_all_code LIKE '000000000' | '%' ) OR ( A.deal_user IS NULL AND b.lowest_proj_level >= '1' AND A.DEAL_ORG IS NULL ) ) AND ( A.TASK_END_DATE IS NULL OR ( SELECT substr( OPERATE_TIME, 0, 10 ) FROM ( SELECT * FROM iems_special_task_record WHERE task_id = A.ID ORDER BY operate_time ) LIMIT = 1 )<= A.TASK_END_DATE ) OR ( SELECT substr( OPERATE_TIME, 0, 10 ) FROM ( SELECT * FROM iems_special_task_record WHERE task_id = A.ID ORDER BY OPERATE_TIME ) LIMIT 1 ) IS NULL AND A.OPERATE_TIME <= A.TASK_END_DATE OR ( A.OPERATE TIME IS NULL AND ( SELECT substr( OPERATE_TIME, 0, 10 ) FROM ( SELECT * FROM iems_special_task_record WHERE task_id = A.ID ORDER BY operate_time ) LIMIT = 1 ) IS NULL AND A.task_status IN ( 'WAIT_CHECK', 'CHECKING', 'AGAIN_CHECKING' ) AND A.TASK_END_DATE >= to_char ( sysdate, 'yyyy-MM-dd' ) ) OR ( A.OPERATE_TIME IS NULL AND ( SELECT substr( OPERATE_TIME, 0, 10 ) FROM ( SELECT * FROM iems_special_task_record WHERE task_id = A.ID ORDER BY OPERATE_TIME ) LIMIT 1 ) IS NULL AND A.task_status IN ( 'CHECKING_END', 'AGAIN_CHECKING_END', 'CONFIRMINGCONFIRM_FINISH', 'AGAIN_CONFIRM', 'AGAIN_CONFIRM_FINISH' ) AND ( A.TASK_END_DATE >= A.FINISH_TIME OR A.FINISH_TIME IS NULL ) ) OR A.task_status = 'END' ) AND EXISTS ( SELECT so.org_code FROM sys_user_data_permission dp INNER JOIN sys_organization so ON dp.org_id = so.ID WHERE dp.del_flag = 1 AND so.bancsid = A.organization AND dp.user_id = '123' ) ORDER BY A.CREATE time DESC LIMIT 50 高斯数据库里优化此sql
最新发布
07-08
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值