m.event_attributes:"0_from"::string as sender,

m.event_attributes:collateral_amount[0]:amount as uaust_collateralised,

m.event_attributes:collateral_amount[0]:amount / pow(10, 6) as aust_collateralised

from terra.msg_events m

where m.event_type = 'from_contract'

and m.event_attributes:"0_to"::string = 'terra1wfz7h3aqf4cjmjcvc6s8lxdhh7k30nkczyf0mj'

and m.event_attributes:collateral_amount[0]:denom::string = 'terra1hzh9vpxhsk8253se0vv5jj6etdvxu3nv8z07zu'

and m.event_attributes:"0_from"::string = 'terra1san7x37tn4zs09ufazgtyxf9h0ht9gm4t6qcdd';