ID, BIZ_TYPE, BIZ_ID, ITEM_SOURCE, ITEM_TYPE, ITEM_ID, ITEM_TITLE, SEND_DEPT_ID, SEND_DEPT_NAME, SEND_USER_ID, SEND_LOGIN_NAME, SEND_USER_NAME, SEND_DATE, PLAN_COMPLETE_DATE, URL, PRIORITY, MODE_TYPE, RECEIVE_DEPT_ID, RECEIVE_DEPT_NAME, RECEIVE_USER_ID, RECEIVE_LOGIN_NAME, RECEIVE_USER_NAME, WORKFLOW_ID, WORKFLOW_NAME, WORKFLOW_INSTANCE, WORKFLOW_INSTANCE_NAME, ACTIVITIES_ID, ACTIVITIES_NAME, ACTIVITIES_INSTANCE, ACTIVITIES_INSTANCE_NAME, ADVICE, TRANS_DATE, VERSION, CREATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_TIME_ a.ID_ AS 'siteInspectionVo.id', a.MANAGE_UNIT_ID_ AS 'siteInspectionVo.manageUnitId', a.MANAGE_UNIT_NAME_ AS 'siteInspectionVo.manageUnitName', a.ROAD_SEGMENT_ID_ AS 'siteInspectionVo.roadSegmentId', a.ROAD_SEGMENT_NAME_ AS 'siteInspectionVo.roadSegmentName', a.TYPE_ AS 'siteInspectionVo.type', a.COMPANY_ID_ AS 'siteInspectionVo.companyId', a.COMPANY_NAME_ AS 'siteInspectionVo.companyName', a.PATROL_DATE_ AS 'siteInspectionVo.patrolDate', a.START_TIME_ AS 'siteInspectionVo.startTime', a.END_TIME_ AS 'siteInspectionVo.endTime', a.WEATHER_ AS 'siteInspectionVo.weather', a.WEATHER_VALUE_ AS 'siteInspectionVo.weatherValue', a.RUMMAGER_ID_ AS 'siteInspectionVo.rummagerId', a.RUMMAGER_ACCOUNT_ AS 'siteInspectionVo.rummagerAccount', a.RECORDER_ID_ AS 'siteInspectionVo.recorderId', a.RECORDER_ACCOUNT_ AS 'siteInspectionVo.recorderAccount', a.PROBLEM_ AS 'siteInspectionVo.problem', a.CONTENT_ AS 'siteInspectionVo.content', a.CREATE_BY_ AS 'siteInspectionVo.createBy', a.CREATE_ORG_NAME_ AS 'siteInspectionVo.createOrgName', a.CREATE_COMPANY_ID_ AS 'siteInspectionVo.createCompanyName', a.CREATE_COMPANY_NAME_ AS 'siteInspectionVo.createCompanyName', a.CREATE_NAME_ AS 'siteInspectionVo.createName', a.CREATE_ORG_ID_ AS 'siteInspectionVo.createOrgId', a.CREATE_TIME_ AS 'siteInspectionVo.createTime', a.UPDATE_BY_ AS 'siteInspectionVo.updateBy', a.UPDATE_NAME_ AS 'siteInspectionVo.updateName', a.UPDATE_COMPANY_NAME_ AS 'siteInspectionVo.updateCompanyName', a.UPDATE_COMPANY_ID_ AS 'siteInspectionVo.updateCompanyId', a.UPDATE_ORG_ID_ AS 'siteInspectionVo.updateOrgId', a.UPDATE_ORG_NAME_ AS 'siteInspectionVo.updateOrgName', a.UPDATE_TIME_ AS 'siteInspectionVo.updateTime', a.LAST_TIME_ AS 'siteInspectionVo.lastTime', a.IS_DELE_ AS 'siteInspectionVo.isDele', a.HAND_STATUS_ AS 'siteInspectionVo.handStatus', a.VERSION_ AS 'siteInspectionVo.version', b.ID AS 'taskAlreadyHandleHistory.id', b.BIZ_TYPE AS 'taskAlreadyHandleHistory.bizType', b.BIZ_ID AS 'taskAlreadyHandleHistory.bizId', b.ITEM_SOURCE AS 'taskAlreadyHandleHistory.itemSource', b.ITEM_TYPE AS 'taskAlreadyHandleHistory.itemType', b.ITEM_ID AS 'taskAlreadyHandleHistory.itemId', b.ITEM_TITLE AS 'taskAlreadyHandleHistory.itemTitle', b.SEND_DEPT_ID AS 'taskAlreadyHandleHistory.sendDeptId', b.SEND_DEPT_NAME AS 'taskAlreadyHandleHistory.sendDeptName', b.SEND_USER_ID AS 'taskAlreadyHandleHistory.sendUserId', b.SEND_LOGIN_NAME AS 'taskAlreadyHandleHistory.sendLoginName', b.SEND_USER_NAME AS 'taskAlreadyHandleHistory.sendUserName', b.SEND_DATE AS 'taskAlreadyHandleHistory.sendDate', b.PLAN_COMPLETE_DATE AS 'taskAlreadyHandleHistory.planCompleteDate', b.URL AS 'taskAlreadyHandleHistory.url', b.PRIORITY AS 'taskAlreadyHandleHistory.priority', b.MODE_TYPE AS 'taskAlreadyHandleHistory.modeType', b.RECEIVE_DEPT_ID AS 'taskAlreadyHandleHistory.receiveDeptId', b.RECEIVE_DEPT_NAME AS 'taskAlreadyHandleHistory.receiveDeptName', b.RECEIVE_USER_ID AS 'taskAlreadyHandleHistory.receiveUserId', b.RECEIVE_LOGIN_NAME AS 'taskAlreadyHandleHistory.receiveLoginName', b.RECEIVE_USER_NAME AS 'taskAlreadyHandleHistory.receiveUserName', b.WORKFLOW_ID AS 'taskAlreadyHandleHistory.workflowId', b.WORKFLOW_NAME AS 'taskAlreadyHandleHistory.workflowName', b.WORKFLOW_INSTANCE AS 'taskAlreadyHandleHistory.workflowInstance', b.WORKFLOW_INSTANCE_NAME AS 'taskAlreadyHandleHistory.workflowInstanceName', b.ACTIVITIES_ID AS 'taskAlreadyHandleHistory.activitiesId', b.ACTIVITIES_NAME AS 'taskAlreadyHandleHistory.activitiesName', b.ACTIVITIES_INSTANCE AS 'taskAlreadyHandleHistory.activitiesInstance', b.ACTIVITIES_INSTANCE_NAME AS 'taskAlreadyHandleHistory.activitiesInstanceName', b.TRANS_DATE AS 'taskAlreadyHandleHistory.transDate', b.ADVICE AS 'taskAlreadyHandleHistory.advice' SELECT FROM biz_site_inspection a INNER JOIN biz_task_already_handle_history b ON a.ID_ = b.BIZ_ID ${ew.customSqlSegment} SELECT * FROM biz_task_already_handle_history ${ew.customSqlSegment} ORDER BY TRANS_DATE DESC