select bb.ENFORCEUNIT,count(bb.pid) as num ,sum(bb.totalWeightGoods) as totalWeightGoods ,sum(bb.aftertotalMass) as aftertotalMass

from  bwsn_basicinfo bb

left join s_project sp on bb.pid =sp.id

left join s_unit su on bb.enforceUnitId =su.id

where (sp.status !='撤销' or sp.status is null) and caseType='联合治超'  

and  su.CATALOGROUTE like '%${pid}%'

GROUP BY bb.enforceUnitId,bb.ENFORCEUNIT