SELECT

TX_FROM as main_acc,

TX_TO as playing_acc,

b.signers[0] as signer

FROM eclipse.core.fact_transfers a

JOIN eclipse.core.fact_transactions b ON a.tx_id = b.tx_id

WHERE a.block_timestamp >= '2024-12-01'

AND a.block_timestamp < '2025-01-13 18:00:00'

-- duplicate timestamps on both tables

AND b.block_timestamp >= '2024-12-01'

AND b.block_timestamp < '2025-01-13 18:00:00'

-- specify exact mints for speed

AND MINT IN ('So11111111111111111111111111111111111111112',

'Eth1111111111111111111111111111111111111111')

AND a.SUCCEEDED = TRUE

AND LOG_MESSAGES[0] LIKE '%turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxN%'

AND LOG_MESSAGES[1] = 'Program log: Instruction: GrantClicker'

),

click_actions AS (

SELECT

ft.tx_id,

ft.block_timestamp,

chrg.main_acc,

chrg.playing_acc

FROM chrg

LEFT JOIN eclipse.core.fact_transactions ft

ON ft.signers[0] = chrg.playing_acc

AND ft.block_timestamp >= '2024-12-01'

AND ft.block_timestamp < '2025-01-13 18:00:00'

AND (

LOG_MESSAGES[0] LIKE '%Instruction: Click%'

OR LOG_MESSAGES[1] LIKE '%Instruction: Click%'

OR LOG_MESSAGES[2] LIKE '%Instruction: Click%'

OR LOG_MESSAGES[3] LIKE '%Instruction: Click%'

OR LOG_MESSAGES[4] LIKE '%Instruction: Click%'