-- try_base64_decode_string(tx_message:txn:apaa[0]::string) as ACTION

-- ,block_timestamp::date as daily

-- ,count(DISTINCT tx_id) as tx_count

sender as LP_Provider

-- ,try_base64_decode_string(tx_message:txn:apaa[0]::string) as ACTION

,count(DISTINCT tx_id) as tx_count

from algorand.application_call_transaction

WHERE year(BLOCK_TIMESTAMP)='2022'

and try_base64_decode_string(tx_message:txn:apaa[0]::string)

IN ('mint')

AND app_id IN (552635992)

group by 1

order by tx_count DESC

limit 10