left(block_timestamp :: date, 10) as block_date,

case

when tx_id = '3E158B3B788CBFAC0F8AA6A34C894C4CF8643ABBA89C994E7B2EF6121B4EC4CA' then ' 1: Swap UST for MINE on Terraswap'

when tx_id = '982877EA78CC33852E125D99E252257182B7C3807CA334625465BCF1443C4E9D' then ' 2: Provide Liquidity on Terraswap'

when tx_id = '849558EDBDF3803149F9F2D8E42D277A59F5BD3324C6EF4C737285ED1CAC8BFD' then ' 3: Stake MINE LP in Apollo vault'

end as Terra_event,

tx_id

from

terra.msgs

where

tx_status = 'SUCCEEDED'

and msg_index = 0

and tx_id in ('3E158B3B788CBFAC0F8AA6A34C894C4CF8643ABBA89C994E7B2EF6121B4EC4CA',

'982877EA78CC33852E125D99E252257182B7C3807CA334625465BCF1443C4E9D',

'849558EDBDF3803149F9F2D8E42D277A59F5BD3324C6EF4C737285ED1CAC8BFD')

order by

Terra_event