distinct block_timestamp,

tx_id,

regexp_replace(f_logs.value, '^Program log: Instruction: ') as label_action

from

solana.core.fact_events

inner join solana.core.fact_transactions using(tx_id, block_timestamp, succeeded, block_id)

, lateral flatten (input => fact_transactions.log_messages) f_logs

where

succeeded

and fact_events.program_id = 'RainEraPU5yDoJmTrHdYynK9739GkEfDsE4ffqce2BR'

and fact_transactions.log_messages [f_logs.index -1] = 'Program RainEraPU5yDoJmTrHdYynK9739GkEfDsE4ffqce2BR invoke [1]'

and BLOCK_TIMESTAMP :: date >= '2024-03-06'

and BLOCK_TIMESTAMP :: date < '2024-04-20'

and label_action not in ('UpdateCollection', 'UpdateStats', 'UpdateFloor', 'AdminSyncLiquidity')