PLAYER | TOTAL_PIXELS_EARNED | |
---|---|---|
1 | 0xc4a08a3ac53ea2194010c92b5a0d6800238d8ec5 | 234553.17349056 |
2 | 0x60deac72497b6fb179f736b8057df0ec19b7f79d | 191818.675762649 |
3 | 0x82939c431b817a9e981939c410f90c42652a0321 | 174784.357195722 |
4 | 0x1cefb289539678bf5fba37966c3154b3277907ab | 174711.659401693 |
5 | 0xf1a693215c2dab87e778f5c9935b98b4a3455e81 | 141037.478675409 |
6 | 0xa1d6c57a97d0f400d7428ea9a398beabb94fa9d1 | 139223.6063976 |
7 | 0xcc03e2dc9c05e302aad4b32c39e0ae58efdae982 | 115423.111988839 |
8 | 0xe451c4961d1dcf5a5c1105626bfe3f7426b9da7e | 115335.023960658 |
9 | 0x9b75d9d201aa06f727ffbd89cf6d764dd95565e5 | 109952.908442383 |
10 | 0x9d5481a54393adfd190d26f016f7cace8056f59d | 98491.646046782 |
11 | 0x56cfd020ed5de02b1a5bde07e4085686fd551a7f | 89665.097074219 |
12 | 0x219beb2c3bdc364e4b207de0052cfcdf2ba70f04 | 57902.40898391 |
13 | 0xd7e51dc7eb6c4b4540a796874dc6a12c7107063c | 55655.721073661 |
14 | 0xb9578f3251843023d98a2afa011573d2afe78a40 | 52564.381223958 |
15 | 0x79fea1a5fe3809c9bbb6f18afe8d729ad5c3da65 | 51237.126700195 |
16 | 0x7ef8dacbc0d4a3d1300cba194f70909bdcdfe0e0 | 50349.04949535 |
17 | 0xe21fdffd6b1f791e9b1484c4380e244a6c1fafad | 49493.875751256 |
18 | 0x7ea9923f519f7b760d2152feae07b9be11b91446 | 47000.931216518 |
19 | 0x348b19d4b8d45724b3779db25d73d93c1671fed8 | 44460.004413132 |
20 | 0x9436c72d276d8dbe759b360dab13e861b3c63a09 | 44074.777867746 |
permaryTotal Pixel recieved as rewards
Updated 2025-03-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH rewards AS (
SELECT
tx_hash AS hash
FROM ronin.core.fact_transactions
WHERE to_address = '0x0e6bce8f215c52b53fad009e3bfacbb3be3774a6'
AND origin_function_signature = '0x9ca96ce0'
),
pixel_rewards AS (
SELECT
to_address AS player,
SUM(amount) AS total_pixels_earned
FROM ronin.core.ez_token_transfers
WHERE contract_address = '0x7eae20d11ef8c779433eb24503def900b9d28ad7'
AND from_address = '0x0e6bce8f215c52b53fad009e3bfacbb3be3774a6'
AND tx_hash IN (SELECT hash FROM rewards)
GROUP BY to_address
)
SELECT player, total_pixels_earned
FROM pixel_rewards
ORDER BY total_pixels_earned DESC;
Last run: 11 days ago
...
100000
5MB
17s