mysql字符处理

select a.liuzhuan_ID from joinleader_app_run.hj_xiaoshoukaiju_lz8yi257 a

left join (select * from (select bizkey,

ROW_NUMBER() OVER (PARTITION BY bizkey ORDER BY create_time desc) AS n,

a.node_name

from joinleader_base.fixflow_run_taskinstance a

left join joinleader_base.fixflow_run_processinstance b on a.bizkey =b.biz_key

where b.instance_status ='RUNNING' and a.processdefinition_key='process_HJ_sxfapiao_2of0iiaz'

) aa where n=1 and aa.node_name ='制单人填写') b on a.uid=b.bizkey

COLLATE utf8mb4_0900_ai_ci

where a.liuzhuan_id is not null and length(a.liuzhuan_id)>0