SELECT DISTINCT value AS users

FROM eclipse.core.fact_transactions,

LATERAL FLATTEN(INPUT => SIGNERS) AS value

),

second_list AS (

SELECT DISTINCT signer AS users

FROM solana.core.ez_signers

SELECT first_list.users

FROM first_list

INNER JOIN second_list

ON first_list.users = second_list.users;