with GALXE_PASSPORT_CLAIM_EVENT AS (

SELECT

BLOCK_TIMESTAMP,

TX_HASH,

NFT_TO_ADDRESS AS USER_ADDRESS,

TOKENID AS TOKEN_ID

FROM bsc.nft.ez_nft_transfers

WHERE NFT_ADDRESS = '0xe84050261cb0a35982ea0f6f3d9dff4b8ed3c012'

AND NFT_FROM_ADDRESS = '0x0000000000000000000000000000000000000000'

AND PROJECT_NAME = 'Galxe Passport'

AND EVENT_TYPE = 'mint'

),

GALXE_PASSPORT_BURN_EVENT AS (

SELECT

BLOCK_TIMESTAMP,

TX_HASH,

NFT_FROM_ADDRESS AS USER_ADDRESS,

TOKENID AS TOKEN_ID

FROM bsc.nft.ez_nft_transfers

WHERE NFT_ADDRESS = '0xe84050261cb0a35982ea0f6f3d9dff4b8ed3c012'

AND NFT_TO_ADDRESS = '0x0000000000000000000000000000000000000000'

AND PROJECT_NAME = 'Galxe Passport'

AND EVENT_TYPE = 'other'

),

GALXE_PASSPORT_CURRENT_HOLDERS AS (

SELECT

*

FROM GALXE_PASSPORT_CLAIM_EVENT

WHERE TOKEN_ID NOT IN (SELECT TOKEN_ID FROM GALXE_PASSPORT_BURN_EVENT)

select

USER_ADDRESS as address

from GALXE_PASSPORT_CURRENT_HOLDERS

),