0xaimanUntitled Query
Updated 2022-01-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with lp as (select address,address_name
from terra.labels
where label='loop' and LABEL_SUBTYPE='pool' and
ADDRESS='terra123neekasfmvcs4wa70cgw3j3uvwzqacdz2we03'),
sender as (select this:by as pool, this:from as sender, this:share/1000000 as LP_position
from terra.msg_events, table(flatten(input=>event_attributes))ea
where event_type='from_contract' and value='mint')
select pool, lp_position
from lp
where sender='terra10fyrywt75ps3wj0ssdxm8sgm6tgkgtylm9sv26'
inner join sender on lp.address=sender.pool