select

--fact_events.*

distinct(instruction:accounts[1]) as player_profiles

FROM solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)

WHERE program_Id = 'pprofELXjL5Kck7Jn5hCpwAL82DpTkSYBENzahVtbc9'

AND succeeded = 'true'

AND value:parsed:type = 'createAccount'

--AND signers[0] = 'FjJ1ZQWAz5tYKNu4g1ti7ptCH5YNED5nmA5giMMC8BZg'

--AND (signers = ['{{Wallet1}}'] OR signers = ['{{Wallet2}}'] OR signers = ['{{Wallet3}}'])

--AND (signers[0] IN ('{{Wallet1}}', '{{Wallet2}}', '{{Wallet3}}'))-- OR signers = ['{{Wallet2}}'] OR signers = ['{{Wallet3}}'])

AND ARRAYS_OVERLAP(signers, ['{{Wallet1}}', '{{Wallet2}}', '{{Wallet3}}'])

AND block_timestamp > '2023-09-21'

SELECT * FROM player_profile