id, row_number() over (partition by id order by block_timestamp ASC) as nounce,

DATEDIFF(minute, LAG(block_timestamp, 1) over (partition by id order by block_timestamp ASC), block_timestamp) as time_since_last_event,

CASE WHEN player='0xe3ad6030cbaff1c2' THEN minter else player END as player, stake, block_timestamp, tx_id

(SELECT

mq.event_data:to as player, mq.event_data:id::integer as id, mq.event_type,

CASE WHEN mq.block_timestamp<'12/07/2022' THEN 1 ELSE 2 END season,

CASE WHEN mq.event_type='Stake' THEN TRUE ELSE FALSE END stake,

mq.block_timestamp, mq.tx_id, mq.event_data, aq.event_data:to as minter

FROM flow.core.fact_events mq

LEFT JOIN flow.core.fact_events aq on aq.tx_id=mq.tx_id AND aq.event_type='Deposit'

WHERE mq.event_contract = 'A.e3ad6030cbaff1c2.DimensionX' AND mq.tx_succeeded = true

AND (mq.event_type = 'Stake' OR mq.event_type='Unstake'))

ORDER BY block_timestamp DESC