WHERE inner_tx = 'FALSE' AND tx_message :dt :itx [0] :txn :type :: STRING = 'acfg' AND tx_message :dt :itx [0] :txn :apar :an :: STRING

LIKE '%PACT LP Token' AND tx_message :dt :itx [0] :txn :apar :au :: STRING = 'https://pact.fi/' )

select count(sender),concat(tx_message:txn:apas) from algorand.application_call_transaction where app_id IN ( SELECT app_id FROM pact_app_ids )

and TRY_BASE64_DECODE_STRING(tx_message :txn :apaa [0] :: STRING) = 'ADDLIQ'

group by 2

order by 1 desc