*

--last_transaction() as last_transaction

from solana.core.fact_transactions, lateral flatten(input => inner_instructions) f2

WHERE (instructions[0]:programId::string = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg'

OR instructions[1]:programId::string = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg'

OR instructions[2]:programId::string = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg'

OR instructions[3]:programId::string = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg')

AND succeeded = 'true'

AND f2.value:instructions[2]:parsed:info:source::string IN ('9yWqFjRg9YZMfimZqUmjZXEZAE9kgYxL9yZLQhaqEYye', 'GMjJzHScPShQXy8s6dFoerVKm2tdP2CzV4rgEpRcjV63', 'CNPohnXmRCYZiKa38vMHe8P6GgNG8EQKgK9gS3J1jgZC', 'FAvy64Dp3G1NAnTpyCQKEXoTMEgWy5vtAbHcCVMBmjQg', 'A9TkWYuNWuC6dYNtpgzuSjGDGqXjMmbQaAKUDji5HvxF', '6Po9s7bCor98qVoUURLGQsH2z7zp5w6k9UvNrkn2kqsx', '5espaReJLkX6VfYBMUgZREqn1QMMEs2EnKJYEmZ3xdCe', 'DZDi2hBgBjicyxToyxPSRKiNyCCYi4XLafx8zAib4NHB', '4euRSHhWmsBy8M4hkewBPAfaAowYWMPZPivtMictVqGa')

--AND inner_instructions[0]:instructions[2]:parsed:info:mint::string = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT'

--AND value:owner = '4F8g6pCBAo3KWEBai8EZbrQ8bVcYG3kxRrAGsDCTDWFL'

--AND log_messages::string LIKE '%Harvesting%'

--AND tx_id = '5rRAGsbeTiN3qfQqYA9xQqP76HRPhXWNeStSxCPPYSvM2V3Gs1m9seDnm2W5bGmbhAYXohW8WJE7uoVU5LVoQZg1'

AND f2.value:instructions[1]:parsed:info:mint::string IN ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')

AND block_timestamp > '2022-11-30' --AND block_timestamp <= '2022-10-31'

order by 1 DESC

limit 10