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