DiamondNFLAD Playoff Competition - Rookie Leaderboard (Super Wild Card Weekend)
    Updated 2024-02-14
    WITH ppr_data AS (
    SELECT
    livequery.live.udf_api (
    'https://flipsidecrypto.xyz/api/v1/queries/16242156-1f04-493d-90d2-84d8f1c76923/data/latest'
    ) :data AS json_data
    ),
    select_data AS (
    SELECT
    DISTINCT f.value:"Wallet" AS "Wallet",
    value:"Wallet Score" :: DOUBLE AS "Score"
    FROM
    ppr_data,
    LATERAL FLATTEN(input => json_data) AS f
    )
    SELECT
    select_data."Score" as "SCORE",
    dim_nflad_playoff_rosters.WALLET AS "WALLET",
    CASE
    WHEN dim_nflad_playoff_rosters.WALLET = '0x9b879eee67d839cc' THEN 'Diamond'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x3376758a5e4ebe6c' THEN 'Draxthedestroyer'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x8b6a462c281aadfb' THEN 'AndrewHallFF'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xc5f2b68d7bf3fadb' THEN 'jaykappa'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x7b70673057616601' THEN 'GRWRIGHT8787'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x31007f0d4dc6f5fc' THEN 'Yolodawg'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xb0c3cea14d23d224' THEN 'BRothrock'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xccad7ebbc155c12e' THEN 'RebelRy09'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xce609693f76f1467' THEN 'Gloade666'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x42e1c4c3843ca7d1' THEN 'hueskie'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x31aaf244670ceb9d' THEN 'Nitsuj_J'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xbee776009d396a51' THEN 'Jaydeegee'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x760e5312752dc4ae' THEN 'ElJefe604'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x2252abfb10fe4ee3' THEN 'ricsquad'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xa4838affeea62764' THEN 'Endless_Winter_2016'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x4e2c842cb5d154ee' THEN 'KGBeast'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xe5d6e4db7b16dd40' THEN 'Hoopahollic'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xf90cc1a4c029c83c' THEN 'Chapstick'
    Last run: 12 months ago
    SCORE
    WALLET
    ACCOUNT
    QB
    RB#1
    RB#2
    RB#3
    WR#1
    WR#2
    WR#3
    TE
    FLEX#1
    FLEX#2
    1
    211.650x4f768fbfc061a5b6chinnypicsJosh Allen - UNCOMMONIsiah Pacheco - UNCOMMONJerome Ford - UNCOMMONJahmyr Gibbs - UNCOMMONCeeDee Lamb - UNCOMMONZay Flowers - UNCOMMONPuka Nacua - UNCOMMONDallas Goedert - UNCOMMONNico Collins - UNCOMMONRachaad White - UNCOMMON
    2
    210.0250xb0c3cea14d23d224BRothrockJosh Allen - UNCOMMONIsiah Pacheco - UNCOMMONJerome Ford - UNCOMMONRachaad White - UNCOMMONTyreek Hill - UNCOMMONCeeDee Lamb - UNCOMMONNico Collins - UNCOMMONSam LaPorta - UNCOMMONA.J. Brown - UNCOMMONPuka Nacua - UNCOMMON
    3
    189.7750x3879c4294f92d6e4MNeyJosh Allen - UNCOMMONRachaad White - UNCOMMONDe'Von Achane - UNCOMMONIsiah Pacheco - COMMONCeeDee Lamb - UNCOMMONPuka Nacua - UNCOMMONDeVonta Smith - COMMONPat Freiermuth - COMMONAmari Cooper - COMMONChristian Watson - COMMON
    4
    184.7950x813eecae0ea74db8MonkimanmonkJosh Allen - COMMONChristian McCaffrey - COMMONIsiah Pacheco - UNCOMMOND'Andre Swift - COMMONPuka Nacua - UNCOMMONCeeDee Lamb - COMMONTyreek Hill - COMMONDavid Njoku - COMMONAmon-Ra St. Brown - COMMONMike Evans - COMMON
    5
    180.950x9f74f9896e1df5f1CaseythewormJosh Allen - UNCOMMONChristian McCaffrey - UNCOMMONDe'Von Achane - UNCOMMONJahmyr Gibbs - UNCOMMONCeeDee Lamb - UNCOMMONNico Collins - UNCOMMONPuka Nacua - UNCOMMONDavid Njoku - COMMONZay Flowers - UNCOMMONA.J. Brown - UNCOMMON
    6
    174.550x3376758a5e4ebe6cDraxthedestroyerJosh Allen - UNCOMMONChristian McCaffrey - COMMONDe'Von Achane - UNCOMMONJerome Ford - UNCOMMONCeeDee Lamb - UNCOMMONNico Collins - UNCOMMONZay Flowers - UNCOMMONTravis Kelce - COMMONPuka Nacua - UNCOMMONMike Evans - COMMON
    7
    172.250x9b879eee67d839ccDiamondJosh Allen - UNCOMMONChristian McCaffrey - UNCOMMONJahmyr Gibbs - UNCOMMONKyren Williams - UNCOMMONCeeDee Lamb - UNCOMMONTyreek Hill - UNCOMMONA.J. Brown - UNCOMMONTravis Kelce - COMMONNico Collins - UNCOMMONRachaad White - UNCOMMON
    8
    163.870xb64f9203a5c5ac68Back2TheJungleJosh Allen - COMMONIsiah Pacheco - UNCOMMONDavid Montgomery - COMMONAaron Jones - COMMONZay Flowers - UNCOMMONA.J. Brown - COMMONTyreek Hill - COMMONDavid Njoku - COMMONDalton Schultz - COMMONCeeDee Lamb - COMMON
    9
    162.4250xf897de380cb49b64AllDayCostanzaJosh Allen - UNCOMMONDe'Von Achane - UNCOMMONRachaad White - UNCOMMONChristian McCaffrey - UNCOMMONZay Flowers - UNCOMMONRashee Rice - UNCOMMONCeeDee Lamb - UNCOMMONDallas Goedert - UNCOMMONAmon-Ra St. Brown - COMMONAmari Cooper - COMMON
    10
    161.1250xbee776009d396a51JaydeegeeBrock Purdy - UNCOMMONJahmyr Gibbs - UNCOMMONRaheem Mostert - UNCOMMONKyren Williams - UNCOMMONRashee Rice - UNCOMMONCeeDee Lamb - UNCOMMONNico Collins - UNCOMMONDalton Kincaid - UNCOMMONJerome Ford - UNCOMMONRachaad White - UNCOMMON
    11
    160.20xddece960930dea52beexLamar Jackson - COMMONChristian McCaffrey - COMMONJahmyr Gibbs - COMMONIsiah Pacheco - COMMONTyreek Hill - UNCOMMONCeeDee Lamb - UNCOMMONStefon Diggs - UNCOMMONDavid Njoku - COMMONMike Evans - COMMONPuka Nacua - UNCOMMON
    12
    156.8250x42e1c4c3843ca7d1hueskieLamar Jackson - COMMONChristian McCaffrey - RAREDe'Von Achane - RAREAaron Jones - COMMONPuka Nacua - UNCOMMONCeeDee Lamb - COMMONStefon Diggs - COMMONDavid Njoku - COMMOND'Andre Swift - COMMONAmon-Ra St. Brown - COMMON
    13
    155.5250xc5f2b68d7bf3fadbjaykappaJosh Allen - UNCOMMONJahmyr Gibbs - UNCOMMONChristian McCaffrey - UNCOMMONIsiah Pacheco - UNCOMMONTyreek Hill - UNCOMMONPuka Nacua - UNCOMMONCeeDee Lamb - UNCOMMONDallas Goedert - UNCOMMONRachaad White - UNCOMMONZay Flowers - UNCOMMON
    14
    152.450x31aaf244670ceb9dNitsuj_JJared Goff - UNCOMMONIsiah Pacheco - UNCOMMONJonathan Taylor - UNCOMMONJerome Ford - UNCOMMONCeeDee Lamb - COMMONPuka Nacua - UNCOMMONTyreek Hill - COMMONLuke Musgrave - COMMONChristian McCaffrey - COMMONStefon Diggs - COMMON
    15
    151.6750x3fbf6fa2d72851eaaznxwolfyLamar Jackson - COMMONChristian McCaffrey - COMMONIsiah Pacheco - COMMOND'Andre Swift - COMMONTyreek Hill - COMMONStefon Diggs - UNCOMMONCeeDee Lamb - UNCOMMONDavid Njoku - COMMONPuka Nacua - COMMONAmon-Ra St. Brown - COMMON
    16
    150.60x5bd5385a428ef5b2BuffaloSpaceJosh Allen - UNCOMMONChristian McCaffrey - COMMONKyren Williams - COMMONJahmyr Gibbs - COMMONCeeDee Lamb - COMMONTyreek Hill - COMMONA.J. Brown - COMMONTravis Kelce - COMMONAaron Jones - COMMONGus Edwards - COMMON
    17
    149.5750xd96bb5897cf0a54eWarOnPugsLamar Jackson - COMMONIsiah Pacheco - UNCOMMONJames Cook - RAREChristian McCaffrey - COMMONPuka Nacua - UNCOMMONTyreek Hill - UNCOMMONCeeDee Lamb - COMMONDavid Njoku - COMMONA.J. Brown - UNCOMMONAmon-Ra St. Brown - COMMON
    18
    148.9750x2252abfb10fe4ee3ricsquadJoe Flacco - UNCOMMONChristian McCaffrey - UNCOMMONRaheem Mostert - UNCOMMONIsiah Pacheco - UNCOMMONPuka Nacua - UNCOMMONA.J. Brown - UNCOMMONZay Flowers - UNCOMMONSam LaPorta - UNCOMMONNico Collins - UNCOMMONCeeDee Lamb - UNCOMMON
    19
    148.1250x66f4336d1418b0f4adriaparcerisasJosh Allen - UNCOMMONRaheem Mostert - UNCOMMONAaron Jones - COMMONNick Chubb - COMMONDeVonta Smith - COMMONZay Flowers - UNCOMMONCooper Kupp - COMMONSam LaPorta - UNCOMMONCeeDee Lamb - UNCOMMONChristian McCaffrey - COMMON
    20
    147.370xccad7ebbc155c12eRebelRy09Josh Allen - COMMONTony Pollard - COMMONDe'Von Achane - UNCOMMONKyren Williams - COMMONZay Flowers - UNCOMMONAmon-Ra St. Brown - COMMONDeVonta Smith - COMMONGeorge Kittle - COMMONIsiah Pacheco - UNCOMMONDavid Njoku - COMMON
    59
    17KB
    46s