SajjadiiiLeaderboard
    Updated 2025-02-22
    with market_data AS (
    SELECT
    Block_timestamp
    ,tx_hash
    ,origin_from_address AS user_address
    ,kaia.utils.udf_hex_to_int(topics [3] :: STRING) :: STRING AS points_Spent
    ,kaia.utils.udf_hex_to_int(data :: STRING) :: STRING AS draw_index
    ,CASE
    when draw_index = 1 then 'Spent 1k Point- Unknown'
    when draw_index = 2 then 'Spent 22k Point- Unknown'
    when draw_index = 3 then 'Spent 40k Point- Unknown'
    when draw_index = 4 then 'Spent 60k Point- Unknown'
    when draw_index = 5 then 'Spent 35k Point- Unknown'
    when draw_index = 6 then 'Spent 50k Point- Unknown'
    when draw_index = 7 then 'Draw Jelly (10k $P)'
    when draw_index = 10 then 'Draw JP Amazon Gift Card ¥50'
    when draw_index = 11 then 'Draw GLOBAL Amazon Gift Card $1'
    when draw_index = 12 then 'Draw GLOBAL Amazon Gift Card 100%'
    when draw_index = 13 then 'Draw JP Amazon Gift Card 100%'
    when draw_index = 14 then 'Draw Jelly (1k $P)'
    when draw_index = 15 then '10 Point Lucky Draw'
    when draw_index = 16 then '50 Point Lucky Draw'
    end AS Market_items
    ,CASE
    when draw_index = 1 then 1000
    when draw_index = 2 then 22000
    when draw_index = 3 then 40000
    when draw_index = 4 then 60000
    when draw_index = 5 then 35000
    when draw_index = 6 then 50000
    when draw_index = 7 then 10000
    when draw_index = 10 then 1000
    when draw_index = 11 then 1000
    when draw_index = 12 then 100000
    when draw_index = 13 then 85000
    when draw_index = 14 then 1000
    Last run: 2 months ago
    User Address
    Spent Points Score
    In App Payment Score
    NFT Mint Score
    NFT Trade Score
    Total Score
    Rank
    1
    0x9a3d...2d19cc00011979.412211979.41221
    2
    0x0d12...58db8c429.036219007649.77259599.80252
    3
    0x0bc0...9ae1c45565.58169510007360.583
    4
    0xb77f...7da13735142106300059204
    5
    0xb9b3...19377c5158.26207005365.265
    6
    0xed12...56c6de5058.311985005306.316
    7
    0xa82b...fa947a3932.721194005126.727
    8
    0x1756...fb5c383884.9556425004698.958
    9
    0xea62...2b2a860004249.72734249.72739
    10
    0x0be7...3260fd2416.1196135003862.1110
    11
    0xfa0c...2d67433595.8198003793.811
    12
    0x6bbd...3a1913211703659.17323778.173212
    13
    0xd6b1...1586a53311.812735003634.8113
    14
    0xebac...09e9b43011.4618330003494.4614
    15
    0x5cfd...f22c0f3065.5512615003341.5515
    16
    0xa2f9...5d95790003290.64753290.647516
    17
    0xc146...8a72d32676.6733315003159.6717
    18
    0x64a0...0a19e72780.51025002932.518
    19
    0x4889...01d4242376.8130325002929.8119
    20
    0xce75...15783d2650.9510510002855.9520
    100
    4KB
    292s