WITH vaults_ethereum AS (

WITH v1_ethereum AS (

SELECT

'Ethereum' AS chain,

'Moloch' as vault_type,

'V1' AS vault_version,

CONCAT('0x', SUBSTR(data, 3 + 24, 40)) AS dao_address,

dao_address as vault_address,

'Main Treasury' as vault_name,

FALSE as is_safe,

block_timestamp::date as summon_date

FROM ethereum.core.fact_event_logs

WHERE

contract_address = '0x2840d12d926cc686217bb42b80b662c7d72ee787' -- V1 Factory

-- utils.keccak256(utils.toUtf8Bytes("Register(address,address,uint256,string,uint256)"))

AND topics[0] = '0xa50d98082663c2b716ab4f8b6b2a51fcaed7eae222cd3d74b19de4691ede728a'

), v1_minion_ethereum AS (

SELECT

'Ethereum' AS chain,

'Minion' as vault_type,

'V1' AS vault_version,

event_inputs:"moloch" AS dao_address,

event_inputs:"minion" as vault_address,

event_inputs:"details" as vault_name,

FALSE as is_safe,

block_timestamp::date as summon_date

FROM ethereum.core.fact_event_logs

WHERE

contract_address = LOWER('0x2A0D29d0a9e5DE91512805c3E2B58c1e95700dDa') -- V1MinionFactory

-- utils.keccak256(utils.toUtf8Bytes("SummonMinion(address,address,string,string)"))

AND topics[0] = '0x82c46fce23f68e421df03972dc4fcfc2add76d8c37a037fbc47e378d132ca626'

), v2_ethereum AS (

SELECT

'Ethereum' AS chain,