select case when t1.flastreadtime is null then '未浏览'else '已浏览' end as ftype,count(0)fcount from tnotice_users t1
inner join tenterprise_users t2 on t1.siteid=t2.siteid and t1.tenterprise_userid=t2.tenterprise_userid and t2.fusertype='企业'
where t1.siteid=$siteid$ and t1.tnoticeid=$tnoticeid$
group by case when t1.flastreadtime IS null then '未浏览'else '已浏览' end