<iframe width="560" height="315" src="https://www.youtube.com/embed/zE7JSaeAwA0" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

### <center>[Check the official announcement here](https://leofinance.io/@leogrowth/lpud-keeps-kicking-ass-or-october-winners)</center>

This is a video where I pick the LPUD winners for the month of October, this is not an announcement, it's just a video where anyone can watch the process we used to pick the winners of the 5th Leo Power Up day.

This is the SQL query I ran to get the LPUD October participants:

```
Select 
ID, json, timestamp, tid, required_auth
From
TxCustoms
where
timestamp between '2022-10-14' and '2022-10-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(parseFloat(obj.contractPayload.quantity));
}

```
***

The link to [the spreadsheet is here](https://docs.google.com/spreadsheets/d/1D2LxXCYOaUeA4e99aU-PO9O4pRsCsxCu7MjCOGmzHcI/edit#gid=939179693)

***

Here are the bet IDs of every roll I made to pick the winners and you can crosscheck them with the video:

dd685b7668d | 62547249d62 | 226536bbe73 | 226536b6975
-|-|-|-
5983e8e3324 | b56b2624772 | b56b2633984 | 226536de93b
84e95e93db9 | b56b26b3e47 | 99e25e2e993 | 3b694698e78
b56b266d535 | dd674668e95 | 22653664dd4 | 3b69468239d
73685644b26 | 4462b65e28d | 99e25b8937d | 5983e6db7dd
84e95d72496 | 5983e64bb43 | 4462bebed84 | No more

That's it, if anyone has any questions regarding the transparency of this process, hit me up on discord @anoamdsoul#8455

<sub> Disclaimer: I used shitty youtube because 3speak is glitching at the moment</sub>

Posted Using [LeoFinance <sup>Beta</sup>](https://leofinance.io/@anomadsoul/lpud-october-transparency-video)