Bee & Queen Breeds Over Time

HoneylandBee & Queen Breeds Over Time

Updated 11 hours ago

-- WITH GENERATIONS_CIRCULATING_VIALS AS (

-- select

-- MINT

-- from

-- solana.nft.dim_nft_metadata

-- where

-- NFT_NAME LIKE 'Mad Honey Vial%'

-- ),

-- GENERATIONS_BURNED_VIALS AS (

-- SELECT

-- INSTRUCTION:accounts [4] as MINT

-- FROM

-- solana.core.fact_events

-- WHERE

-- BLOCK_TIMESTAMP >= '2022-06-01'

-- AND PROGRAM_ID = 'HLgmgZ4rbzAgP3p8Uj8rTa2PZgnZKaxmUVxprwqqUCyN' -- 'V2hgXrNDQZx': MhvMaxStatsFunctionality

-- -- 'KD55zdLBG4MvBhCh1sQHj5': MhvUniqueBee

-- -- 'KD55zdLBG4MuBVAcAxSe7y': MhvUniqueBee

-- -- 'KD55zdLBG4Mv1zXgD3ugTZ': MhvUniqueBee

-- AND (

-- INSTRUCTION:data = 'V2hgXrNDQZx'

-- OR INSTRUCTION:data LIKE 'KD55zdLBG4M%'

-- )

-- ),

-- GENERATIONS_ALL_VIALS AS (

-- SELECT

-- MINT

-- FROM

-- GENERATIONS_CIRCULATING_VIALS

-- UNION

-- SELECT

-- MINT

-- FROM

-- GENERATIONS_BURNED_VIALS

-- ),

-- HONEYLAND_ALL_ORIGINAL_MINTED AS (

Last run: about 11 hours agoAuto-refreshes every 12 hours

873B

26s

flipside