piperlively-beige
Updated 2025-01-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
COUNT(DISTINCT signers [2]) AS total_saga_owners
FROM
solana.core.fact_transactions
WHERE
block_timestamp :: DATE >= '2023-03-20'
AND signers[0] = '7k5qzD2LLJCchakNG9wu9G3AvyFP7eWXBk4WbqgQypm6'
AND (
signers[1] = 'D4v4527fUNT2CYgL4Wz7KnNLK3rTSd62ijQzYFYSjPTH' OR
signers[1] = '8haaz4YwkmiEirHomPNf6BiDaaLhAWrUSXVegexgYpjZ'
)
AND succeeded = TRUE
AND ACCOUNT_KEYS :: TEXT LIKE '%En54STTsmVrWA3Cd43SQNgiLrihRDG2iMJD6zWPHjYfW%'