flow_program_wallets as (

SELECT

wallet_address

FROM

"BI_ANALYTICS"."BRONZE"."HEVO_SUBMISSIONS"

WHERE

claim_id IN (

SELECT id

FROM "BI_ANALYTICS"."BRONZE"."HEVO_CLAIMS"

WHERE bounty_id = '92de4d04-2365-4970-945b-706acc4c6c72' -- june 6th hunt

)

),

txs as (

select * from flow.core.fact_transactions

where arrays_overlap((select array_agg(wallet_address) from flow_program_wallets), authorizers)

select * from flow.core.fact_events

where tx_id in (select tx_id from txs)

and block_timestamp >= '2022-06-06'

order by block_timestamp asc, tx_id, event_index;