select buildingName, sum(SSSum) as SSSum,
sum(SSOwnerSum) as SSOwnerSum
from(
<if test="condition.firstDate != null">(SELECT info.dutyNum as dutyNum, info.companyName as companyName, info.orderName as orderName, info.buildingName as buildingName, info.companyType as companyType, info.lastModifyTime as lastModifyTime,
gzzs, gqysds, ggrsds, gcswhjss, dyys, dqysds, dgrsds, dtdzzs, dzzs, dcswhjss, dfcs, dyhs, dcztusys, dccs, dqs, djyffj, ddfjyfj, dzys, DSSum, DSOwner, GSSum, GSOwner, SSSum, SSOwnerSum
FROM companyinfo info LEFT JOIN ${condition.firstDate} ON (info.dutyNum = ${condition.firstDate}.dutyNum))</if>
<if test="condition.qTables != null">
<foreach collection="condition.qTables" index="index" item="item" open="" separator="" close="">
UNION ALL
(SELECT info.dutyNum as dutyNum, info.companyName as companyName, info.orderName as orderName, info.buildingName as buildingName, info.companyType as companyType, info.lastModifyTime as lastModifyTime,
gzzs, gqysds, ggrsds, gcswhjss, dyys, dqysds, dgrsds, dtdzzs, dzzs, dcswhjss, dfcs, dyhs, dcztusys, dccs, dqs, djyffj, ddfjyfj, dzys, DSSum, DSOwner, GSSum, GSOwner, SSSum, SSOwnerSum
FROM companyinfo info LEFT JOIN ${item} ON (info.dutyNum = ${item}.dutyNum))
</foreach>
</if>
)tmp group by buildingName
having buildingName != '无'
<if test="condition.buildingName != null">and buildingName Like CONCAT('%',#{condition.buildingName},'%')</if>
order by lastModifyTime DESC , buildingName
<if test="condition.pageSize > 0">limit #(start),#(pageSize)</if>
</select>