ID_, DB_ALIAS_, TABLE_ID_, FILE_SQL_, FILE_NAME_, FILE_CONTENT_, FILE_TYPE_, FILE_SIZE_, FILE_PATH_, IS_CREATE_, CREATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_ORG_ID_, UPDATE_TIME_, TENANT_ID_ SELECT f1.* FROM ( SELECT * FROM biz_share_files f JOIN ( SELECT t1.ID_ AS tableId FROM biz_share_table t1 WHERE t1.CATALOG_ID_ = #{catalogId} AND t1.DEPLOYED_STATUS_ = '1' AND t1.IS_FILE_ = '1' ) AS t2 ON f.TABLE_ID_ = t2.tableId WHERE f.IS_CREATE_ = '1' AND f.ID_ NOT IN ( SELECT au.RESOURCE_ID_ FROM biz_share_auth au WHERE au.MEMBER_ID_ = #{consumerId} AND au.RESOURCE_TYPE_ = '2' )) f1 ${ew.customSqlSegment}