with

t0 as (

select

distinct program_id

, tx_id

from solana.core.fact_events

where block_timestamp >= current_date - 8

and block_timestamp < current_date

and succeeded

union

select

distinct c.value:programId::string AS program_id

, t.tx_id

from solana.core.fact_transactions t

, lateral flatten(

input => inner_instructions

) b

, lateral flatten(

input => b.value:instructions

) c

where block_timestamp >= current_date - 8

and block_timestamp < current_date

and t.succeeded

),

t1 as (

select program_id