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