EXPLAIN SELECT
*
FROM
(
SELECT
NULL AS 'queryType',
pf.INSTANCE_ID AS 'flowKey',
payPlanVoucher.*
FROM
pay_plan_voucher payPlanVoucher,
plan_flow pf
WHERE
pf.PLAN_ID = payPlanVoucher.PLAN_ID
AND payPlanVoucher.is_deleted = 0
AND pf.INSTANCE_ID IS NOT NULL
AND payPlanVoucher.mof_dep_code IN (
'101010',
'101072',
'101020',
'101013',
'101018',
'101022',
'101046',
'101014',
'101074',
'101026',
'101080',
'101030',
'101047',
'101019',
'101006',
'101009',
'101012',
'101011',
'101004',
'101027',
'101007',
'101008',
'101073',
'101017',
'101048'
)
AND payPlanVoucher.fiscal_year = '2021'
AND payPlanVoucher.tenant_id = '440000000'
) pay
INNER JOIN (
SELECT
a.PROC_INST_ID_ processInstanceId,
a.END_TIME_ bpmEndTime
FROM
ibpms_engine.ACT_HI_TASKINST a
LEFT JOIN ibpms_engine.ACT_HI_IDENTITYLINK b ON a.ID_ = b.TASK_ID_
WHERE
a.CATEGORY_ = '1211112'
AND a.TENANT_ID_ = '440000_zxy_gd_2021_440000000'
AND a.END_TIME_ IS NOT NULL
AND a.START_TIME_ = (
SELECT
MAX(b.START_TIME_)
FROM
ibpms_engine.ACT_HI_TASKINST b
WHERE
a.PROC_INST_ID_ = b.PROC_INST_ID_
AND a.TASK_DEF_KEY_ = b.TASK_DEF_KEY_
)
AND (
b.USER_ID_ = '737737248748908544'
)
) t ON pay.flowKey = t.processInstanceId
ORDER BY
issue_time DESC LIMIT 50,
50
