select t1.tsubmiteditmodelid,sum(t1.fisread)as fisread, sum(case when t1.fstatus='Μα½»'then 1 else 0 end) as fissubmit from tsubmitedit t1
where t1.siteid=$siteid$ and t1.tsubmiteditmodelid in $tsubmiteditmodelid$ and t1.tenterprise_userid=$tenterprise_userid$
group by t1.tsubmiteditmodelid