SELECT

DECODED_LOG:name::string as name,

DECODED_LOG:type_id::int as type_id,

BLOCK_TIMESTAMP,

TX_HASH

FROM ethereum.core.ez_decoded_event_logs LOGS

LEFT JOIN ethereum.core.dim_contracts CONTRACT

ON CONTRACT.address = lower(LOGS.DECODED_LOG:gauge_addr::string)

WHERE CONTRACT_ADDRESS = lower('{{curve_voter_address}}')

AND EVENT_NAME = 'AddType'