*

FROM (

SELECT

e.block_timestamp,

e.tx_id,

NVL(msg_value:init_msg:name, msg_value:init_msg:collection_name) as name,

NVL(msg_value:init_msg:symbol, msg_value:init_msg:collection_symbol) as symbol,

NVL(event_attributes:contract_address, event_attributes:"1_contract_address") as address

FROM terra.msgs m

JOIN terra.msg_events e

ON e.tx_id = m.tx_id

WHERE

m.tx_status = 'SUCCEEDED'

AND m.msg_type = 'wasm/MsgInstantiateContract'

AND (msg_value:init_msg:minter is not null OR msg_value:init_msg:mint_cap is not null)

AND (msg_value:init_msg:symbol is not null OR msg_value:init_msg:collection_name is not null)

AND (msg_value:init_msg:name is not null OR msg_value:init_msg:collection_symbol is not null)

AND event_type = 'instantiate_contract'

AND m.block_timestamp >= '2021-06-01'

WHERE name <> '' AND name is not null AND name <> 'Portfolio'

ORDER BY name