SELECT

block_timestamp::date as ddate,

event_inputs:id as prop_id,

event_inputs:proposer as proposer,

event_inputs:startBlock as starttime,

event_inputs:endBlock as endtime,

substr(event_inputs:description, 0, 70) as short_desc

from ethereum.core.fact_event_logs

WHERE 1=1

--Thanks to Delta/M.Zamani in #lilnouns

AND origin_to_address in (

'0x6f3e6272a167e8accb32072d08e0957f9c79223d', -- NounDAOProxy, the rest is just Gnosis Safe Multisig using a delegate_call

'0x2573c60a6d127755aa2dc85e342f7da2378a0cc5',

'0xae7f458667f1b30746354abc3157907d9f6fd15e',

'0x37b8e20646d174b00198b7e183dd1f25520c0f60',

'0xcc2688350d29623e2a0844cc8885f9050f0f6ed5',

'0xf6c625851d48fe26b50d96b821a87efc7e35c222'

)

AND topics[0] = '0x7d84a6263ae0d98d3329bd7b46bb4e8d6f98cd35a7adb45c274c8b7fd5ebd5e0'

),

merge as (

SELECT

ddate, prop_id, proposer,

fb.block_timestamp as start_date,

coalesce(fb2.block_timestamp, DATEADD(day,3,start_date)) as end_date, --Handling shit that ENDS IN FUTURE ie no block data yet!

short_desc

from base_props b

LEFT JOIN ethereum.core.fact_blocks fb ON TO_NUMBER(b.starttime) = fb.block_number

LEFT JOIN ethereum.core.fact_blocks fb2 ON TO_NUMBER(b.endtime) = fb2.block_number

ORDER BY ddate ASC

),

votes as (

SELECT