(select tx_group_id,concat('pool:',tx_message:txn:apas) as pool from algorand.application_call_transaction

where app_id = 552635992)

, mint_count as

(select count(*) as cnt, concat('pool:',tx_message:txn:apas) as pool from algorand.application_call_transaction

where app_id = 552635992 and try_base64_decode_string(tx_message:txn:apaa[0]::string) IN ( 'mint')

group by pool

having cnt>100)

, burn_count as

(select count(*) as cnt, concat('pool:',tx_message:txn:apas) as pool from algorand.application_call_transaction

where app_id = 552635992 and try_base64_decode_string(tx_message:txn:apaa[0]::string) IN ( 'burn')

group by pool

having cnt>100)

, mint_burn_count as

(select count(*) as cnt, concat('pool:',tx_message:txn:apas) as pool, try_base64_decode_string(tx_message:txn:apaa[0]::string) as action

from algorand.application_call_transaction

where app_id = 552635992 and try_base64_decode_string(tx_message:txn:apaa[0]::string) IN ( 'mint','burn')

group by pool,action

having cnt>100 )

, app_call as

(select count(*) as cnt, tx_message:txn:apas as pool from algorand.application_call_transaction

where app_id = 552635992 and tx_message:txn:apas is not null

group by pool

having cnt > 100

order by cnt desc)

, wallet_count as (select count(distinct sender) as cnt , pool

from algorand.asset_transfer_transaction inner join group_id on group_id.tx_group_id=algorand.asset_transfer_transaction.tx_group_id

group by 2

having cnt > 100)

,asset_count as (select count(distinct asset_id) as cnt , pool

from algorand.asset_transfer_transaction inner join group_id on group_id.tx_group_id=algorand.asset_transfer_transaction.tx_group_id

group by 2

)

, mint_group_id_temp as

(select tx_group_id,tx_message:txn:apas as pool from algorand.application_call_transaction

where app_id = 552635992 and try_base64_decode_string(tx_message:txn:apaa[0]::string) IN ( 'mint'))