select origin_to_address,
case when origin_to_address = '0xa132dab612db5cb9fc9ac426a0cc215a3423f9c9' or origin_to_address = '0x9c12939390052919af3155f41bf4160fd3666a6f' then 'Velodrome Router'
when origin_to_address = '0xc30141b657f4216252dc59af2e7cdb9d8792e1b0' then 'Socket Registry'
when origin_to_address = '0x74a002d13f5f8af7f9a971f006b9a46c9b31dabd' then 'Rabbithole'
when origin_to_address = '0x2e42f214467f647fe687fd9a2bf3baddfa737465' then 'Galxe SpaceStation'
else initcap(ifnull(t2.address_name,t3.address_name)) end as Destination_Label,
count (distinct origin_from_address) as Users_Count,
count (distinct tx_hash) as TX_Count
from optimism.core.fact_event_logs t1 full outer join optimism.core.dim_labels t2 on t1.origin_to_address = t2.address
full outer join flipside_prod_db.crosschain.address_labels t3 on t1.origin_to_address = t3.address
where tx_status = 'SUCCESS'
group by 1,2 having users_count >= 1000
order by 4 DESC
limit 10