Published via Ecency

Check the official announcement here

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

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

Select 
ID, json, timestamp, tid, required_auth
From
TxCustoms
where
timestamp between '2022-09-14' and '2022-09-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

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

73dd62e2597	e766de425e4	b58863974eb	dd2268b2394
99bbe4399b8	e766de24d5b	596685d76dd	99bbe48b7b9
e766de376b9	84ddeb3bd62	3b556d3e526	e766de33499
22ee63e4982	22ee63458bb	59668eb89b3	22ee6372223
73dd65d3584	b588628b638	3b5564b4b64	59668ee2288
b588628b638	73dd65d922d	84dde5e6b4e	73dd6568de4
e766d8deb95	73dd656b293	b58862672de	3b5564bd6eb

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

▶️ 3Speak

September LPUD Winners - Transparency video | Ecency