select

proposal_start_time,

proposal_end_time,

proposal_title,

space_id as spaceid

from ethereum.core.ez_snapshot

where proposal_start_time >= '2022-12-13'

order by proposal_start_time asc

),

govdaos as (

select

spaceid,

proposal_title,

proposal_start_time,

proposal_end_time

from ap

where spaceid = 'rss3.eth'

or spaceid = 'sushigov.eth'

or spaceid = 'boringvote.eth'

or spaceid = 'lido-snapshot.eth'

or spaceid = 'epns.eth'

or spaceid = 'vote-perp.eth'

or spaceid = 'saddlefinance.eth'

or spaceid = 'spookyswap.eth'

or spaceid = 'stakewise.eth'

or spaceid = 'apecoin.eth'

or spaceid = 'ilvgov.eth'

or spaceid = 'meritcircle.eth'

or spaceid = 'gmx.eth'

or spaceid = 'gnosis.eth'

or spaceid = 'poolpool.pooltogether.eth'

or spaceid = 'pooltogether.eth'

or spaceid = 'daocity.eth'

or spaceid = 'safegov.eth'