theericstonegovernance__n_projects_staked
    Updated 2021-11-12
    -- supporting ANC, MINE, LOOP, MIR, PSI, VKR, STT
    -- This is a collection of relavant token details for each token that we use below
    WITH token_details as (
    (
    select
    'terra1f32xyep306hhcxxxf7mlyh0ucggc00rm2s9da5' as staking_contract,
    'terra14z56l0fp2lsf86zy3hty2z47ezkhnthtr9yq76' as token_contract,
    'ANC' as token
    )
    union
    (
    select
    'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp' as staking_contract,
    'terra1kcthelkax4j9x8d3ny6sdag0qmxxynl3qtcrpy' as token_contract,
    'MINE' as token
    )
    union
    (
    select
    -- LOOP has no staking contract yet
    'none' as staking_contract,
    'terra1nef5jf6c7js9x6gkntlehgywvjlpytm7pcgkn4' as token_contract,
    'LOOP' as token
    )
    union
    (
    select
    'terra1w6xf64nlmy3fevmmypx6w2fa34ue74hlye3chk' as staking_contract,
    'terra1dy9kmlm4anr92e42mrkjwzyvfqwz66un00rwr5' as token_contract,
    'VKR' as token
    )
    union
    (
    select
    'terra1wh39swv7nq36pnefnupttm2nr96kz7jjddyt2x' as staking_contract,
    'terra15gwkyepfc6xgca5t5zefzwy42uts8l2m4g40k6' as token_contract,
    Run a query to Download Data