s.msg_value:contract, b.label,

sum(msg_value:execute_msg:provide_liquidity:assets[1]:amount/1e6) as tt

from terra.msgs s

LEFT OUTER JOIN terra.labels b ON s.msg_value:contract = b.address

where msg_value:execute_msg:provide_liquidity:assets[0]:info:token:contract_addr='terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp'

-- and msg_value:contract !='terra1ptjp2vfjrwh0j0faj9r6katm640kgjxnwwq9kn'

and msg_index=1 group by 1,2 order by 3 desc