ID_, MEMBER_ID_, TABLE_ID_, RESOURCE_TYPE_, RESOURCE_ID_ SELECT a.* FROM ( SELECT * FROM biz_share_auth WHERE MEMBER_ID_ = #{consumerId} AND RESOURCE_TYPE_ = #{resourceType}) a ${ew.customSqlSegment} SELECT a.* FROM ( SELECT * FROM biz_share_auth WHERE RESOURCE_ID_ = #{resourceId} AND RESOURCE_TYPE_ = #{resourceType} ) a ${ew.customSqlSegment} SELECT a1.* FROM ( SELECT a.* FROM biz_share_auth a JOIN ( SELECT t.ID_ AS tableId FROM biz_share_table t WHERE t.IS_DELE_ = '0' ) AS t1 ON a.TABLE_ID_ = t1.tableId WHERE a.MEMBER_ID_ = #{consumerId} AND a.RESOURCE_TYPE_ = '1' ) a1 ${ew.customSqlSegment} SELECT a1.* FROM ( SELECT a.* FROM biz_share_auth a JOIN ( SELECT t.ID_ AS tableId FROM biz_share_table t WHERE t.IS_DELE_ = '0' ) AS t1 ON a.TABLE_ID_ = t1.tableId JOIN biz_share_api api on a.RESOURCE_ID_ = api.ID_ WHERE a.MEMBER_ID_ = #{consumerId} AND a.RESOURCE_TYPE_ = '3' AND api.IS_DELE_ = '0' AND api.STATUS_ = '1' ) a1 ${ew.customSqlSegment} SELECT a1.* FROM ( SELECT a.* FROM biz_share_auth a JOIN ( SELECT t.ID_ AS tableId FROM biz_share_table t WHERE t.IS_DELE_ = '0' ) AS t1 ON a.TABLE_ID_ = t1.tableId JOIN biz_share_files f ON f.ID_ = a.RESOURCE_ID_ WHERE a.MEMBER_ID_ = #{consumerId} AND a.RESOURCE_TYPE_ = '2' AND f.IS_CREATE_ = '1' ) a1 ${ew.customSqlSegment}