select

message_value:label as name,

attributes:instantiate:_contract_address as contract_address,

message_value:admin as creator,

tx_id as tx,

block_timestamp::date as time

from terra.core.ez_messages where message_type='/cosmwasm.wasm.v1.MsgInstantiateContract' and tx_succeeded='TRUE')

select

* from

terra.core.ez_messages where tx_id='393A4CB8B29051722195CE780CBC4F06EC72FB3424C889A7A83CBD38A70AC8E8'

and message_value:contract='terra1vavu6en35af4wg9k5tzhssg2n0krffvs8tufqc7ddpsyre9d2gxs6ttk55' and message_value:msg:create_table is not null and