count(DISTINCT from_address) as voter_count,

CONCAT('0x', SUBSTR(input_data :: STRING, 291, 40)) AS Pool,

case

when pool = '0xe8537b6ff1039cb9ed0b71713f697ddbadbb717d' then 'VolatileV1 AMM - VELO/USDC'

when pool = '0x47029bc8f5cbe3b464004e87ef9c9419a48018cd' then 'VolatileV1 AMM - OP/USDC'

when pool = '0x79c912fef520be002c2b6e57ec4324e260f38e50' then 'VolatileV1 AMM - WETH/USDC'

when pool = '0xffd74ef185989bff8752c818a53a47fc45388f08' then 'VolatileV1 AMM - VELO/OP'

when pool = '0xd16232ad60188b68076a235c65d692090caba155' then 'StableV1 AMM - USDC/sUSD'

when pool = '0xfd7fddfc0a729ecf45fb6b12fa3b71a575e1966f' then 'StableV1 AMM - WETH/sETH'

when pool = '0x4f7ebc19844259386dbddb7b2eb759eefc6f8353' then 'StableV1 AMM - USDC/DAI'

when pool = '0x207addb05c548f262219f6bfc6e11c02d0f7fdbe' then 'StableV1 AMM - USDC/LUSD'

when pool = '0x9355292f66552ea5717b274d27eefc8254011d83' then 'VolatileV1 AMM - THALES/USDC'

when pool = '0xcdd41009e74bd1ae4f7b2eecf892e4bc718b9302' then 'VolatileV1 AMM - WETH/OP'

end as pool_name

from optimism.core.fact_transactions

where ORIGIN_FUNCTION_SIGNATURE = '0x7ac09bf7'

and to_address = '0x09236cff45047dbee6b921e00704bed6d6b8cf7e'

group by pool, pool_name

order by voter_count desc

limit 10