Aephiascan using array_contains test2
Updated 2024-03-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
--fact_events.*
count(fe.tx_id) as number_of_scans
FROM solana.core.fact_events fe
inner join solana.core.fact_transactions ft USING(block_timestamp, tx_id, succeeded)
, lateral flatten(input => fe.inner_instruction)
where fe.succeeded
and fe.block_timestamp > current_date - 7 AND fe.block_timestamp < current_date
and fe.program_id = 'SAGEqqFewepDHH6hMDcmWy7yjHPpyKLDnRXKb3Ki8e6'
--and array_contains('Program log: Instruction: ScanForSurveyDataUnits'::variant, log_messages)
limit 100