with
penguin
AS
(
SELECT
DISTINCT
tokenid AS token_id
FROM
ethereum.nft.ez_nft_transfers
WHERE
nft_address = lower('0xbd3531da5cf5857e7cfaa92426877b022e612cf8')
ORDER
BY
token_id
DESC
),
lil
AS
(
SELECT
block_timestamp,
decoded_log:id :: string AS lil_token_id,
tx_hash
FROM
ethereum.core.fact_decoded_event_logs
WHERE
contract_address = lower('0x524cab2ec69124574082676e6f654a18df49a048')
AND
event_name = 'MintLilPudgy'
ORDER
BY
block_timestamp
DESC
)
SELECT
token_id