ehsanstUntitled Query
99
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
›
⌄
⌄
select in_tx,to_addr,asset_e8,memo from outbound_events where in_tx in(
select in_tx from outbound_events where memo like '%:te:%' limit 100)
SELECT SUBSTRING ('PostgreSQL' FROM 1 FOR 8);
SELECT REGEXP_SUBSTR('=:BNB.TWT-8C2:bnb1wkt7q2daz60jtxsrhslrdyyw7nmt8z24202u5n:1562716722362:te:42', '.*:.*:.*:.*:.*:.*') "FETCH_ONLY_taxo_WORD"
select IN_TX,TO_ADDRESS,ASSET_E8,MEMO
from THORCHAIN.CORE.FACT_OUTBOUND_EVENTS
where IN_TX in(
select IN_TX
from THORCHAIN.CORE.FACT_OUTBOUND_EVENTS
where memo like '%:te:%' limit 100)
-- 642
select *
from THORCHAIN.CORE.FACT_OUTBOUND_EVENTS
where memo like '%:%:%:%:te:%' limit 100
select t1.IN_TX as txId,t1.ASSET as FROM_ASSET,t1.ASSET_E8 as FROM_AMOUNT,t2.ASSET as To_ASSET,t2.ASSET_E8 as TO_AMOUNT
from THORCHAIN.CORE.FACT_OUTBOUND_EVENTS as t1
join THORCHAIN.CORE.FACT_OUTBOUND_EVENTS as t2
on t1.IN_TX=t2.IN_TX
where t1.Memo like '%:te:%' and t2.Memo like 'OUT:%' and t1.memo like CONCAT('%', t2.TO_ADDRESS , '%')
limit 100
where memo not like 'OUT:' limit 100
=:ETH.ETH:0xF36f148D6FdEaCD6c765F8f59D4074109E311f0c:2088628:te:75
%:%:%:%:te:%
select t1.*
from THORCHAIN.CORE.FACT_OUTBOUND_EVENTS as t1
join THORCHAIN.CORE.FACT_OUTBOUND_EVENTS as t2
on t1.IN_TX=t2.IN_TX
where t1.Memo like '%:te:%' and t2.Memo like 'OUT:%' and t1.memo like CONCAT('%', t2.TO_ADDRESS , '%')
Run a query to Download Data