https://3speak.tv/watch?v=anomadsoul/dxunvluw
### [Check the official announcement here](https://leofinance.io/@leogrowth)
This is a video where I pick the LPUD winners for the month of April, this is not an announcement, it's just a video where anyone can watch the process we used to pick the winners of the 12th Leo Power Up day.
This is the SQL query I ran to get the LPUD March participants:
```
Select
ID, json, timestamp, tid, required_auth
From
TxCustoms
where
timestamp between '2023-04-14' and '2023-04-16 14:00:00'
and tid like '%ssc_mainnet_hive%'
and json like '%"contractAction":"stake"%'
and json like '%"symbol":"LEO"%'
order by timestamp desc
```
***
This is the Javascript script I ran to clean the SQL database:
```
const leo = [
'{"contractName":"tokens","contractAction":"stake","contractPayload":{"to":"tinyputerboy","symbol":"LEO","quantity":"0.225"}}',
'{"contractName":"tokens","contractAction":"stake","contractPayload":{"to":"kolus290","symbol":"LEO","quantity":"2.115"}}',
];
for (let i = 0; i < leo.length; i++) {
const obj = JSON.parse(leo[i]);
console.log(obj.contractPayload.to, parseFloat(obj.contractPayload.quantity));
}
```
***
The link to [the spreadsheet is here](https://docs.google.com/spreadsheets/d/1bI__xltj1sgWx_z3z47narLbimPENn_HVfD6do3PU44/edit#gid=946090411)
***
Here are the bet IDs of every roll I made to pick the winners and you can crosscheck them with the video and on DuckDice:
896396b4934 | bbe7beee27b | bbe7577564b | bbe7577e387
-|-|-|-
896343236db | 8963432bb44 | d7e9d9be726 | 89634375de2
6436268ed6d | bbe7572eedb | 6436269b22e | 78793923367
64362695453 | e95373eb665 | 787939899d2 | 7879398d863
2579292d535 | 257929243d3 | 25792968367 | 532797885b8
7879396d652 | 787939db68e | |
That's it, if anyone has any questions regarding the transparency of this process, hit me up on discord @anomadsoul#8455