ID_, TYPE_, SOURCE_ID_, NAME_, URL_, REMARKS_, SUFFIX_, CREATE_BY_, CREATE_NAME_, CREATE_ORG_NAME_, CREATE_DEPT_ID_, CREATE_DEPT_NAME_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_DEPT_NAME_, UPDATE_DEPT_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, VERSION_, TENANT_ID_, GROUP_, FILE_SIZE_, BID_TYPE_, BID_SIGN_STATUS_, BID_CONTRACT_URL_, BID_CONTRACT_ID_ select * from biz_accessory ${ew.customSqlSegment} SELECT a.*, be.CONTRACT_USER_MOBILE AS contractUserMobile, be.CONTRACT_USER_NAME_ AS contractUserName, u.mobile_ AS mobile FROM biz_accessory a INNER JOIN uc_user u ON a.CREATE_BY_=u.ID_ LEFT JOIN biz_enterprise be ON a.CREATE_ORG_ID_ = be.ORG_ID_ WHERE a.ID_ = #{id} SELECT be.CONTRACT_USER_MOBILE AS contractUserMobile, be.CONTRACT_USER_NAME_ AS contractUserName, u.mobile_ AS mobile FROM uc_user u INNER JOIN uc_org_user ou ON u.ID_=ou.user_id_ AND ou.IS_DELE_='0' AND is_master_=1 LEFT JOIN biz_enterprise be ON ou.ORG_ID_ = be.ORG_ID_ WHERE u.ID_ = #{id}