with delegatees AS (

distinct decoded_log:delegatee AS Delegatee,

count(DISTINCT decoded_log:delegator) AS delegated_wallets,

CASE

when delegatee = '0x329c54289ff5d6b7b7dae13592c6b1eda1543ed4' then 'aavechan.eth'

when delegatee = '0x32a9d6a550c3d89284d5700f7d7758dbc6f0fb2c' then 'No ENS 1'

when delegatee = '0x25cc275cfe3cce1700e816e00d4cd1f60872038a' then 'pranjalbora.eth'

when delegatee = '0x070341aa5ed571f0fb2c4a5641409b1a46b4961b' then 'franklindao.eth'

when delegatee = '0x215514118a4e99d4839b660661dc717e3bc959aa' then '20220203.eth'

when delegatee = '0xeeb5a54551f79b546e8babccade66ba3c9440efc' then 'deepernetwork.eth'

when delegatee = '0xc17cb209d5abdb2d00f566a1e48f558debc264e1' then 'aave.standard-crypto.eth'

when delegatee = '0x33f6ee932cea603fafd6854827259be172c91da4' then 'airdropalertdaily.eth'

when delegatee = '0xc3c2e1cf099bc6e1fa94ce358562bcbd5cc59fe5' then 'Aavegotchi: Deployer.eth'

when delegatee = '0xa7499aa6464c078eeb940da2fc95c6acd010c3cc' then 'bneiluj.eth'

when delegatee = '0x8df352ddeaee7abc815674051b75f4734a87b622' then 'hundredtwenty.eth'

when delegatee = '0x190473b3071946df65306989972706a4c006a561' then 'chainlinkgod.eth'

when delegatee = '0x6ada6454cd458e230c26e8cba2ba18b0b41f041f' then 'crype.eth'

when delegatee = '0x23abad8c65a9a93abcc343892aaf3d6e88b5ccc9' then '223238'

when delegatee = '0xafdabfb6227507ff6522b8a242168f6b5f353a6e' then 'No ENS 2'

end AS ENS

FROM ethereum.core.fact_decoded_event_logs l

LEFT JOIN crosschain.core.ez_ens dl on dl.owner = l.decoded_log:delegatee

WHERE contract_address = '0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9'

AND event_name in ('DelegateChanged')

GROUP BY delegatee, ENS

ORDER BY delegated_wallets DESC

LIMIT 15)

SELECT

voter,

ENS,

delegated_wallets,

count(tx_hash) AS vote_count,