select
    <include refid="baseSqlV2">
        <property name="alias" value="p"/>
    </include>
    ,
    u.user_name as user_name,
    (SELECT COUNT(*) FROM t_ds_process_definition AS def WHERE def.project_code = p.code) AS def_count,
    (SELECT COUNT(*) FROM t_ds_process_definition_log def, t_ds_process_instance inst WHERE def.code =
    inst.process_definition_code and def.version = inst.process_definition_version AND def.project_code = p.code
    AND inst.state=1 ) as inst_running_count
    from t_ds_project p
    left join t_ds_user u on u.id=p.user_id
    where 1=1