## Motivation
How many of you sometimes want to know how much you have been paid by writing good contents? Especially for those regular writers or even full time steemians, they want to know [how much payout per week](https://helloacm.com/steemit-bot-update-showing-your-payout-in-last-7-days/).

I am adding these to the [steemit discord](https://helloacm.com/the-steemit-discord-bot-upgrade-and-api/) bot and the wechat channel.

## The SteemIt Discord Bot
Adding steemit bot to your discord server:

https://discordapp.com/oauth2/authorize?client_id=418196534660694037&permissions=522304&scope=bot

## Your Payout in Last 7 Days Explained
These information are now included in the profile lookup query such as `?steemit_account`
![image.png](https://gateway.ipfs.io/ipfs/Qmef1gJ1aXf5VaUgrqimC1ewascffwxabQxZb1ofWVVboh)

SBD - The Steem Dollars
SP - The Steem Power via Curation or 100% Power up (These are locked up via 13 week if you power down)
STEEM - These tradeable tokens can be transferred anywhere but they are not usually given per post payout.

## How to Do this?
via SBDS ([MySQL](https://helloacm.com/how-to-connect-to-steem-blockchain-database-service-mysql-using-linqpad/)): 


```
select 
  account, 
  sum(reward_steem) as "STEEM", 
  sum(reward_sbd) as "SBD", 
  sum(reward_vests) as "SP" 
from 
  sbds_tx_claim_reward_balances
where
  account in ('justyy')  and 
  datediff(UTC_Date(), timestamp) between 0 and 7 
group by account
```

or [SteemSQL](https://helloacm.com/steemsql-tutorial-i-have-spent-800-sbd-7000-usd-buying-votes/) ([MSSQL](https://helloacm.com/how-to-check-if-steemsql-is-synchronized-with-steem-blockchain/)):

```
select 
  account, 
  sum(reward_steem) as "STEEM", 
  sum(reward_sbd) as "SBD", 
  sum(reward_vests) as "SP" 
from 
  TxClaimRewardBalances( NOLOCK)
where
  account in ('justyy') and 
  datediff(hour, timestamp, getutcdate()) between 0 and 24*7 
group by 
  account
```

## Wechat Channel `justyyuk`
![image.png](https://gateway.ipfs.io/ipfs/QmVtVJauwYHSdUC7K9UF2L8Bs9VRihEynepciTG8cgpcW4)

------------------------------------------------
Support me and my work as a [witness](https://steemit.com/witness-category/@justyy/justyy-just-another-witness) by
1. voting me [here, or](https://steemconnect.com/sign/account_witness_vote?approve=1&witness=justyy)
2. voting me as a [proxy](https://v2.steemconnect.com/sign/account-witness-proxy?proxy=justyy&approve=1)

Some of my contributions: **[SteemIt Tools, Bots, APIs and Tutorial](https://helloacm.com/tools/steemit/)**


-----------------------------------------------------------
## 动机
有一些时候，我们想了解到我们在STEEM平台上一周得到的奖励。特别是对于一些全职在STEEM上的贡献者来说，他们想了解到是否能通过[STEEM](https://justyy.com/archives/6278)来得到足够养家的收入。

现在，DISCORD的[机器人](https://justyy.com/archives/6091) steemit 还有微信公众号 justyyuk 都将支持查询：过去7天收益。

## SteemIt 机器人
把 steemit 添加到你的 discord 频道上：

https://discordapp.com/oauth2/authorize?client_id=418196534660694037&permissions=522304&scope=bot

## 怎么样查询
只需要和以前一样 输入 `?steemit_account` 即可查询
![image.png](https://gateway.ipfs.io/ipfs/Qmef1gJ1aXf5VaUgrqimC1ewascffwxabQxZb1ofWVVboh)

SBD - 流动性很强
SP - 这些是通过点赞或者你100% POWER UP 得到的奖赏，取出来需要13周（power down）
STEEM - 这可以被转换成SBD或者其它货币，但是文章奖励很少情况下会变成STEEM给你。

## 如何实现查询的？
通过 SBDS 的[MYSQL](https://justyy.com/archives/5918)查询：

```
select 
  account, 
  sum(reward_steem) as "STEEM", 
  sum(reward_sbd) as "SBD", 
  sum(reward_vests) as "SP" 
from 
  sbds_tx_claim_reward_balances
where
  account in ('justyy')  and 
  datediff(UTC_Date(), timestamp) between 0 and 7 
group by account
```

或者[STEEMSQL](https://justyy.com/archives/5908)的 [MSSQL](https://justyy.com/archives/5928)

```
select 
  account, 
  sum(reward_steem) as "STEEM", 
  sum(reward_sbd) as "SBD", 
  sum(reward_vests) as "SP" 
from 
  TxClaimRewardBalances( NOLOCK)
where
  account in ('justyy') and 
  datediff(hour, timestamp, getutcdate()) between 0 and 24*7 
group by 
  account
```

## 微信公众号 `justyyuk`
![image.png](https://gateway.ipfs.io/ipfs/QmVtVJauwYHSdUC7K9UF2L8Bs9VRihEynepciTG8cgpcW4)

------------------------------------------------

## 支持我的工作 支持我成为 [见证人](https://steemit.com/cn/@justyy/5h6gyv-cn) 
1. [请在 这里 投我一票](https://steemconnect.com/sign/account_witness_vote?approve=1&witness=justyy), 或者
2. 设置我 [为代理](https://v2.steemconnect.com/sign/account-witness-proxy?proxy=justyy&approve=1).

我的一些贡献: **[SteemIt 工具、API接口、机器人和教程](https://helloacm.com/tools/steemit-tools/)**