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 CONCAT("%","db5b833fc3f6a90f1a0ac008a03ff713","%") GROUP BY bb.enforceUnitId,bb.ENFORCEUNIT |