ErsvanCopy of Discovery
    Updated 2022-06-17
    /*
    TABLAS A UTILIZAR


    SELECT * FROM flipside_prod_db.algorand.labels LIMIT 1

    SELECT * FROM flipside_prod_db.algorand.transfers LIMIT 1
    SELECT * FROM flipside_prod_db.algorand.transactions LIMIT 1
    SELECT * FROM flipside_prod_db.algorand.asset_configuration_transaction LIMIT 1
    SELECT * FROM flipside_prod_db.algorand.payment_transaction LIMIT 1
    SELECT * FROM flipside_prod_db.algorand.application_call_transaction WHERE APP_ID = 710909840
    SELECT * FROM flipside_prod_db.algorand.app WHERE APP_ID = 710909840





    SELECT * FROM flipside_prod_db.algorand.asset WHERE asset_url like '%#arc3%' and closed_at is null --AND ASSET_ID = 746421524
    SELECT * FROM flipside_prod_db.algorand.asset WHERE asset_url like '%#arc69%' and closed_at is null


    SELECT * FROM flipside_prod_db.algorand.transactions WHERE TX_ID = '6Z5R47GSIMQC4JDCTRAPLPC5BTNCC5K5DJ2QKSACW4KV5RZFZDQQ'
    SELECT * FROM flipside_prod_db.algorand.asset_configuration_transaction WHERE TX_ID = '6Z5R47GSIMQC4JDCTRAPLPC5BTNCC5K5DJ2QKSACW4KV5RZFZDQQ'
    SELECT * FROM flipside_prod_db.algorand.payment_transaction WHERE TX_ID = '6Z5R47GSIMQC4JDCTRAPLPC5BTNCC5K5DJ2QKSACW4KV5RZFZDQQ'
    SELECT * FROM flipside_prod_db.algorand.asset WHERE ASSET_ID = 326189642




    SOBRE EL DECODE 64
    SELECT COUNT(*) FROM flipside_prod_db.algorand.transactions WHERE try_base64_decode_string(TX_MESSAGE:txn:note) like '%arc69%' --LIMIT 2
    CONTAR
    SELECT COUNT(*) FROM flipside_prod_db.algorand.transactions WHERE try_base64_decode_string(TX_MESSAGE:txn:note) LIKE '%arc3%' LIMIT 2
    SELECT COUNT(*) FROM flipside_prod_db.algorand.transactions WHERE try_base64_decode_string(TX_MESSAGE:txn:note) like '%arc69%' LIMIT 2


    Run a query to Download Data