ErsvanCopy of Discovery
Updated 2022-06-17
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
/*
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