mapper中mysql复合语句_mapper文件中mysql语句优化

select buildingName, sum(SSSum) as SSSum,

sum(SSOwnerSum) as SSOwnerSum

from(

(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))

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))

)tmp group by buildingName

having buildingName != '无'

and buildingName Like CONCAT('%',#{condition.buildingName},'%')

order by lastModifyTime DESC , buildingName

limit #(start),#(pageSize)