select CAST(count(1) AS DECIMAL(16,0)) typestatistics from (select sys_enterpriseid from sa_order t1 where t1.status not in('新建','提交') and t1.siteid =$siteid$ and $where$ GROUP BY t1.sys_enterpriseid) t