flipside

Eman-RazLeaderboard

Updated 17 hours ago

select from_address as "GMer", count(distinct tx_hash) as "Number of Daily Check-ins"

from ink.core.fact_transactions

where to_address='0x9f500d075118272b3564ac6ef2c70a9067fd2d3f'

and tx_succeeded='TRUE' and (origin_function_signature='0xe884624b' -- GM_to_a_Fren

or origin_function_signature='0xc0129d43') -- GM

group by 1

order by 2 desc

limit 1000

Last run: about 17 hours ago

	GMer	Number of Daily Check-ins
1	0x43bac7e1acca4d9af7d518786673175800b9d46d	93
2	0xedb77f0ffd272a2480d0bf2dbf8c6ea7af0d17d3	93
3	0x8f52f5eaffa522ffef4577687041188e34fe8081	93
4	0x86247eaa60c875fede26cf3d5b0385073e0cb826	93
5	0xe4b3cce9c0c744c8f784b67dfb2d84f91928f0db	93
6	0x3e3eabbc5c48eaa3260e055bae2747c5eed958b7	93
7	0x4cb89f0e7bd428a73439c8f2358aef42bce0841d	92
8	0x97b9ed00b38b1ac76480741c8320a2489fab73c1	92
9	0xd4f62ebc6db82af5637ef85ec16da1c6af255186	92
10	0x66a21107f65d610703b2229b0e0d6fec0c5d6c9d	92
11	0x0a95be584c72eca0f18808ff35dd8fc4a2ee4c59	92
12	0x8a13682c44573a3d31ec0401681906f7bc2f5d88	92
13	0xfd6ba91ba7e083d312a9f2377e93e94841cf93bd	92
14	0x6e02a17918d7236d75ee7a620a670ab540ebe032	92
15	0x698f14141ad6380f4cac337b2585a479cc0d2d94	92
16	0x79d03409c179b127b1dc578647aad8f87b75c2cd	92
17	0xa96c86a4c8ee98ff674fd3474e5e9b4bb090b4c6	92
18	0x8d4a827095c1e4531b065d235b768c1a225a8efe	92
19	0xc75af9dab74909c535c96493b51f8b7666e2056b	92
20	0x4cda0323e173e1022420106a8d4b55dc4fee4b70	92

...

1000

49KB

6s