flipside

    leaderboard
    PetJokicsHorsesleaderboard
    Updated 22 hours ago
    WITH unique_moments AS (
    SELECT
    NFT_ID AS momentId,
    set_id,
    metadata:FullName AS player,
    serial_number,
    nft_collection,
    play_id
    FROM
    flow.nft.dim_moment_metadata
    WHERE
    metadata:FullName = 'Nikola Jokić'
    OR (momentid = '238283' AND play_id = '376') -- Special case for TSD due to bug in flow.nft.dim_moment_metadata
    ),
    sent_to_pjh AS (
    SELECT
    block_timestamp,
    tx_id,
    COALESCE(
    REGEXP_SUBSTR(script, 'tokenID: ([0-9]+)', 1, 1, 'e', 1),
    '29229965'
    ) AS momentId,
    transaction_result:events[0]:values:value:fields[1]:value:value:value AS sender,
    transaction_result:events[3]:values:value:fields[1]:value:value:value AS recipient,
    CASE
    WHEN block_timestamp >= '2025-01-28 00:30:00.123456789' AND block_timestamp < '2025-01-28 03:30:00.123456789' THEN 2
    WHEN block_timestamp >= '2025-01-30 00:30:00.123456789' AND block_timestamp < '2025-01-30 03:30:00.123456789' THEN 2
    WHEN block_timestamp >= '2025-02-01 00:30:00.123456789' AND block_timestamp < '2025-02-01 03:30:00.123456789' THEN 2
    WHEN block_timestamp >= '2025-02-02 00:00:00.123456789' AND block_timestamp < '2025-02-02 03:00:00.123456789' THEN 2
    WHEN block_timestamp >= '2025-02-04 02:00:00.123456789' AND block_timestamp < '2025-02-04 05:00:00.123456789' THEN 2
    WHEN block_timestamp >= '2025-02-06 02:00:00.123456789' AND block_timestamp < '2025-02-06 05:00:00.123456789' THEN 2
    WHEN block_timestamp >= '2025-02-07 02:00:00.123456789' AND block_timestamp < '2025-02-07 05:00:00.123456789' THEN 2
    WHEN block_timestamp >= '2025-02-09 02:00:00.123456789' AND block_timestamp < '2025-02-09 05:00:00.123456789' THEN 2
    ELSE 1
    END AS multiplier
    FROM
    Last run: about 22 hours agoAuto-refreshes every 12 hours
    DAPPER_WALLET
    TS_NAME
    POINTS
    POSITION_REACHED_TIME
    PRIZE
    1
    0xbf3286046c76cf86
    		wildrick3062025-02-23 21:57:39.88625% prize pool
    2
    0x1537f0c54ebe4aa1
    		mileah092012025-02-23 21:58:39.70620% prize pool
    3
    0x334a20bbaa7f2801
    		bobobobo1112025-02-23 21:54:55.53415% prize pool
    4
    0x1381915616f894fb
    		Jammerz512025-02-23 21:26:04.33911% prize pool
    5
    0x4974f6a62def220c
    		BrendanMcDonnell162025-02-23 21:59:28.0988% prize pool
    6
    0xb5a2d654b28dcf76
    		SingaBas132025-02-23 21:49:43.8896% prize pool
    7
    0x63872cb44c7774ae
    		Nolan11102025-02-23 21:47:10.8075% prize pool
    8
    0x525bbc8ea4a0943e
    		Coach_P062582025-02-23 17:23:53.6454% prize pool
    9
    0x70c0cb528d3bfaed
    		waybeyondthearchive52025-02-23 18:21:56.9793% prize pool
    10
    0x6877b9930f77d002
    		lframpton42025-02-23 18:32:55.4032% prize pool
    11
    0x17d63446b1e38e09
    		EXCITED_MEERKAT22025-02-19 22:59:08.966-
    12
    0x9a620aac275d4ba6
    		massdog2322025-02-19 23:23:37.232-
    13
    0xc246d05ba775362e
    		KnotBean22025-02-19 23:36:41.962-
    14
    0xca87efe2e0da6297
    		Agent0012025-02-17 12:40:23.912-
    15
    0x5e5666f0d35c95c9
    		MagnumKolle12025-02-20 00:13:49.627-
    16
    0xdad344d00b889de2
    		td80848612025-02-20 00:34:23.002-
    17
    0xfab01b00f2fab997
    		JTadashi12025-02-20 00:47:07.216-
    18
    0xf9050403ac603c0f
    		HEART198212025-02-20 02:26:13.164-
    18
    1KB
    126s