0xaimanUntitled Query
    Updated 2022-01-26
    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
    Run a query to Download Data