meidu2021/daju/target/classes/com/xcgl/reports/sql/XcglRptDao_taskStatsOrgUserUnFinishedData.sql

select 
	bu.realname AS name,
	count(*) as noFinishTaskTotal
from p_projecttask task
left join t_s_base_user bu on bu.id = task.owner
where (task.taskstatus ='0' or task.taskstatus ='1')
and task.tasktype<>'weeklyschedule'
group by task.owner
order by noFinishTaskTotal desc
limit :rows