DiamondNFLAD Playoff Competition - Rookie Scoring (Super Wild Card Weekend)
    Updated 2024-02-14
    WITH player_data AS (
    SELECT
    CASE
    WHEN PLAYER = 'Patrick Mahomes II' THEN 'Patrick Mahomes'
    ELSE PLAYER
    END AS PLAYER,
    TEAM,
    moment_stats_full:metadata:playerPosition :: string as position,
    NFLALLDAY_ID,
    '0x9b879eee67d839cc' AS WALLET,
    SERIAL_NUMBER,
    MOMENT_TIER
    FROM
    flow.nft.dim_allday_metadata
    WHERE
    nflallday_id IN (
    '8dfc2663-252b-4ba4-8e66-de9c3dedf464', -- Missing Metadata!
    'd9a82207-cfb8-4158-800e-7d5031c10f8c',
    '3cc47464-431a-40af-be17-45f27b333084',
    'f7b7d937-82b5-4e2d-aef6-dd6bf77b3e0a',
    'dbc0085a-ac00-4ca1-8720-70578e13f8df',
    '64966eb1-df0c-4290-bd0b-261ccdaa510e',
    'ec1aa55e-6c7d-405e-a4ef-1193f538b5eb',
    '70432bad-fe46-415f-81e5-ef009427005f',
    'faa38dc1-cba3-49a2-8831-e1db9eecb04a',
    'b1a2ab4a-1709-4dac-90ff-b4fa4664c132'
    )
    AND WALLET = '0x9b879eee67d839cc' -- DONE
    ),
    second_wallet_player_data AS (
    SELECT
    CASE
    WHEN PLAYER = 'Patrick Mahomes II' THEN 'Patrick Mahomes'
    ELSE PLAYER
    END AS PLAYER,
    TEAM,
    Last run: 12 months ago
    Player
    Team
    Position
    ID
    Wallet
    Tier
    PPR Score
    Wallet Score
    1
    Josh AllenBuffalo BillsQB436105c9-a62f-4b42-bbf8-014fffffdb780xf897de380cb49b64UNCOMMON41.9162.425
    2
    Josh AllenBuffalo BillsQB8dfc2663-252b-4ba4-8e66-de9c3dedf4640x9b879eee67d839ccUNCOMMON41.9172.25
    3
    Josh AllenBuffalo BillsQBa5786741-da78-4ea6-babe-36c75f8b1dde0x760e5312752dc4aeUNCOMMON41.9142.9
    4
    Josh AllenBuffalo BillsQB7a79e8c8-a7ed-49ea-b1c8-3f544df1920c0x4f768fbfc061a5b6UNCOMMON41.9211.65
    5
    Josh AllenBuffalo BillsQB2aa71016-310a-45c1-8852-f5f65cace8230x66f4336d1418b0f4UNCOMMON41.9148.125
    6
    Josh AllenBuffalo BillsQBe64ccdb7-73d2-4b58-ac6a-7b6ce2b78b6a0xb0c3cea14d23d224UNCOMMON41.9210.025
    7
    Josh AllenBuffalo BillsQB9bb62484-91c2-4696-a0ec-553ed1fa297b0x67e7b216af9220a1UNCOMMON41.9141.675
    8
    Josh AllenBuffalo BillsQBc11e8b6d-8d9b-4ba5-b4da-48c25e3fac7e0x3376758a5e4ebe6cUNCOMMON41.9174.55
    9
    Josh AllenBuffalo BillsQB4139d1d6-7540-4195-ab64-1d38fd9292730xcfd9bad75352b43bUNCOMMON41.9147.2
    10
    Josh AllenBuffalo BillsQBd5a2e9c4-938b-4c6b-a1c4-ce909bb4e9980xc5f2b68d7bf3fadbUNCOMMON41.9155.525
    11
    Josh AllenBuffalo BillsQB90aa873a-0793-47f9-a9e3-c29448bbfc330x3879c4294f92d6e4UNCOMMON41.9189.775
    12
    Josh AllenBuffalo BillsQB07205827-74c3-4687-9186-265ef4cb010b0x5bd5385a428ef5b2UNCOMMON41.9150.6
    13
    Josh AllenBuffalo BillsQB7e2361ae-996e-4ddc-90a3-dd69c61d23c30x9f74f9896e1df5f1UNCOMMON41.9180.95
    14
    Puka NacuaLos Angeles RamsWR8eebee5b-c678-477d-b11c-55ec0d5c35360xf91acb323cb9df06UNCOMMON41.12582.125
    15
    Puka NacuaLos Angeles RamsWRbaa49878-2bff-400c-a55d-5193533fcbf80x42e1c4c3843ca7d1UNCOMMON41.125156.825
    16
    Puka NacuaLos Angeles RamsWRd816e634-046f-4bdf-b653-12ee1e6691230x813eecae0ea74db8UNCOMMON41.125184.795
    17
    Puka NacuaLos Angeles RamsWRc8509e7a-be5c-414b-8067-49ac0ab7e95f0xb0c3cea14d23d224UNCOMMON41.125210.025
    18
    Puka NacuaLos Angeles RamsWR4a9fabaa-100a-4acf-9e7c-7408e33839260x31aaf244670ceb9dUNCOMMON41.125152.45
    19
    Puka NacuaLos Angeles RamsWRfe439602-2f64-4195-81ed-010a5e76caa00x4f768fbfc061a5b6UNCOMMON41.125211.65
    20
    Puka NacuaLos Angeles RamsWR57b8b519-1d10-4414-ba86-366f07db687d0x3376758a5e4ebe6cUNCOMMON41.125174.55
    ...
    424
    50KB
    198s