| | |
|---|
| | | "SELECT party.UUID id, party.NAME name, party.USERNAME username, " |
|---|
| | | + " party.LOGINAUTHORITY login_authority, party.WITHDRAW_LIMIT_AMOUNT withdraw_limit_amount, party.WITHDRAW_LIMIT_NOW_AMOUNT withdraw_limit_now_amount, " |
|---|
| | | + " party.LAST_LOGIN_TIME last_loginTime, party.ENABLED enabled, party.ROLENAME rolename, party.CREATE_TIME create_time, " |
|---|
| | | + " party.REMARKS remarks, wallet.MONEY money, party.USERCODE usercode, " |
|---|
| | | + " party.REMARKS remarks, wallet.USDT_MONEY money, party.USERCODE usercode, " |
|---|
| | | + " party_parent.USERNAME username_parent, party.LOGIN_IP login_ip, party.GIFT_USER gift_user, party.USER_LEVEL user_level, " |
|---|
| | | + " party.REGSITER_USERCODE register_usercode,party.OPEN_BLANK open_blank " |
|---|
| | | + " party.REGSITER_USERCODE register_usercode" |
|---|
| | | + " "); |
|---|
| | | |
|---|
| | | queryString.append( |
|---|
| | | " FROM PAT_PARTY party LEFT JOIN PAT_USER_RECOM user ON user.PARTY_ID = party.UUID " |
|---|
| | | + " LEFT JOIN T_WALLET wallet ON wallet.PARTY_ID = party.UUID " |
|---|
| | | + " LEFT JOIN T_WALLET_GATHER wallet ON wallet.PARTY_ID = party.UUID " |
|---|
| | | + " LEFT JOIN PAT_PARTY party_parent ON user.RECO_ID = party_parent.UUID " |
|---|
| | | |
|---|
| | | + " WHERE 1 = 1 "); |
|---|
