WITH address_list AS (

SELECT address

FROM (VALUES

('0xb2b26807f374f5e6')

) AS addresses(address)

TX_ID,

BLOCK_TIMESTAMP,

EVENT_CONTRACT,

EVENT_TYPE,

EVENT_DATA

flow.core.fact_events

EVENT_CONTRACT LIKE '%AFL%'

AND (

EVENT_DATA:to IN (SELECT address FROM address_list)

OR EVENT_DATA:from IN (SELECT address FROM address_list)

OR EVENT_DATA:owner IN (SELECT address FROM address_list)

OR EVENT_DATA:buyer IN (SELECT address FROM address_list)

OR EVENT_DATA:address IN (SELECT address FROM address_list)

OR EVENT_DATA:receiptAddress IN (SELECT address FROM address_list)

)

AND TX_SUCCEEDED = 'TRUE'

ORDER BY

Block_timestamp