SELECT DISTINCT(DECODED_LOG['vault']) AS vault_address

FROM ethereum.core.ez_decoded_event_logs

WHERE CONTRACT_ADDRESS = LOWER('0x00000000000076A84feF008CDAbe6409d2FE638B')

AND event_name = 'DelegateForAll'

SELECT

symbol,

sum(current_bal) as balance,

sum(usd_value_now) as balance_usd

FROM ethereum.core.ez_current_balances a

INNER JOIN vaults b ON a.user_address = b.vault_address

WHERE contract_address NOT IN ('0x59d4ccc94a9c4c3d3b4ba2aa343a9bdf95145dd1', '0x84fa8f52e437ac04107ec1768764b2b39287cb3e')

and symbol not in ('AsunaInu','EXPO','KISHIMOTO','ELAN','LUFFY','KICK','PRINTS','Shibtoro')

GROUP BY 1

having balance_usd >1

ORDER BY 3 DESC

LIMIT 25;