sql

 

 

 

 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;