SELECT
T.uuid,
T.obj_uuid
FROM
AR_APPROVE_HUMAN_ENTRY T
INNER JOIN ar_document T1 ON T.obj_uuid = T1.uuid
INNER JOIN (
SELECT
a.node_code
FROM
ar_document a
INNER JOIN biz_fullset_file_info b ON a.parent_uuid = b.uuid
INNER JOIN biz_pay_comfirm_info c ON b.core_enterprise_id = c.core_enterprise_id
AND b.financial_institutions_id = c.financial_institutions_id
AND b.signing_body_id = c.signing_body_id
AND c.uuid = ‘3cfecd96b7564982a6768fbc0a2b5cab‘
GROUP BY
a.type
) T2 ON INSTR(T1.node_code, T2.node_code)
WHERE
T.UUID LIKE ‘%TS%‘
AND T.`SYS_STATUS` = 0;