from ethereum.core.ez_token_transfers

where from_address ilike '0xe50b2ceac4f60e840ae513924033e753e2366487'

and contract_address ilike '0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f'

group by 1 order by 2 DESC limit 20),

tab1 as (select block_timestamp, tx_hash, to_address as claimer, raw_amount/1e18 as amount

from ethereum.core.ez_token_transfers

where from_address ilike '0xe50b2ceac4f60e840ae513924033e753e2366487'

and contract_address ilike '0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f'

and claimer in (select top_claimers from tem)),

tab2 as (

select tab1.block_timestamp, origin_from_address, origin_to_address, tab1.tx_hash, contract_address

from ethereum.core.fact_event_logs

join tab1 on ethereum.core.fact_event_logs.origin_from_address = tab1.claimer

and ethereum.core.fact_event_logs.block_timestamp > tab1.block_timestamp

where contract_address ilike '0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f')

select origin_to_address,

count (distinct tx_hash) as number_of_transactions

from tab2 full outer join ethereum.core.dim_labels on tab2.origin_to_address = ethereum.core.dim_labels.address

group by 1 having origin_to_address <> 'null'

order by 2 desc

limit 20