SELECT address

FROM (VALUES

('0xdff15c1956e04d6c')

) 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::STRING IN (SELECT address FROM address_list)

OR EVENT_DATA:from::STRING IN (SELECT address FROM address_list)

OR EVENT_DATA:owner::STRING IN (SELECT address FROM address_list)

OR EVENT_DATA:buyer::STRING IN (SELECT address FROM address_list)

OR EVENT_DATA:address::STRING IN (SELECT address FROM address_list)

OR EVENT_DATA:receiptAddress::STRING IN (SELECT address FROM address_list)

)

AND TX_SUCCEEDED = 'TRUE'

ORDER BY

BLOCK_TIMESTAMP;