ID_, CODE_, NAME_, APP_NAME_, IS_OPEN_API_, ACCESS_KEY_, SECRET_KEY_, TOKEN_INFO_, IS_OPEN_DB_, DATABASE_TYPE_, DATABASE_NAME_, DATABASE_URL_, DATABASE_USER_, DATABASE_PWD_, MEMO_, STATUS_, IS_DELE_, CREATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_ORG_ID_, UPDATE_TIME_, TENANT_ID_ SELECT c1.* FROM ( SELECT c.* FROM biz_share_consumer c WHERE c.IS_DELE_ = '0' AND c.IS_OPEN_DB_ = '1' AND c.ID_ NOT IN ( SELECT a.MEMBER_ID_ AS consumerId FROM biz_share_auth a WHERE a.TABLE_ID_ = #{tableId} AND a.RESOURCE_TYPE_ = '1' ) ) c1 ${ew.customSqlSegment} SELECT c1.* FROM ( SELECT c.* FROM biz_share_consumer c WHERE c.IS_DELE_ = '0' AND c.IS_OPEN_API_ = '1' AND c.ID_ NOT IN ( SELECT a.MEMBER_ID_ AS consumerId FROM biz_share_auth a WHERE a.TABLE_ID_ = #{tableId} AND a.RESOURCE_TYPE_ = '3' AND a.RESOURCE_ID_ = #{resourceId} ) ) c1 ${ew.customSqlSegment} SELECT c1.* FROM ( SELECT c.* FROM biz_share_consumer c WHERE c.IS_DELE_ = '0' AND c.ID_ NOT IN ( SELECT a.MEMBER_ID_ AS consumerId FROM biz_share_auth a WHERE a.TABLE_ID_ = #{tableId} AND a.RESOURCE_TYPE_ = '2' AND a.RESOURCE_ID_ = #{resourceId} ) ) c1 ${ew.customSqlSegment} SELECT a1.* FROM ( SELECT a.* FROM biz_share_auth a JOIN biz_share_consumer c ON a.MEMBER_ID_ = c.ID_ WHERE c.IS_DELE_ = '0' AND a.TABLE_ID_ = #{tableId} AND a.RESOURCE_TYPE_ = '1' ) AS a1 ${ew.customSqlSegment} SELECT a1.* FROM ( SELECT a.* FROM biz_share_auth a JOIN biz_share_consumer c ON a.MEMBER_ID_ = c.ID_ WHERE c.IS_DELE_ = '0' AND a.TABLE_ID_ = #{tableId} AND a.RESOURCE_ID_ = #{resourceId} AND a.RESOURCE_TYPE_ = '3' ) AS a1 ${ew.customSqlSegment} SELECT a1.* FROM ( SELECT a.* FROM biz_share_auth a JOIN biz_share_consumer c ON a.MEMBER_ID_ = c.ID_ WHERE c.IS_DELE_ = '0' AND a.TABLE_ID_ = #{tableId} AND a.RESOURCE_ID_ = #{resourceId} AND a.RESOURCE_TYPE_ = '2' ) AS a1 ${ew.customSqlSegment}