block_timestamp, tx_id, msg_value, msg_value:execute_msg:liquidate_collateral:borrower as borrower

from terra.msgs

where substring(msg_value:execute_msg::string, 3, 20) = 'liquidate_collateral'

and tx_status = 'SUCCEEDED'

order by block_timestamp desc