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