when origin_to_address = '0xd8c4cfa978862f4653bfccc1a6e3e9fff1a6dc54' then 'Avalaunch Sale'

when origin_to_address = '0xefac81f709d314604a7daee9ca234da978c2be20' then 'Colony DAO'

when origin_to_address = '0x188bed1968b795d5c9022f6a0bb5931ac4c18f00' then 'Trader Joe'

when origin_to_address = '0x364e232d9880e4a3e8505debbc2f93c6a896233f' then 'CLY Airdrop'

when origin_to_address = '0x486af39519b4dc9a7fccd318217352830e8ad9b4' then 'Benqi'

when origin_to_address = '0x784da19e61cf348a8c54547531795ecfee2affd1' then 'Benqi'

when origin_to_address = '0x35bd6aeda81a7e5fc7a7832490e71f757b0cd9ce' then 'Benqi'

when origin_to_address = '0x77533a0b34cd9aa135ebe795dc40666ca295c16d' then 'Benqi'

when origin_to_address = '0xe54ca86531e17ef3616d22ca28b0d458b6c89106' then 'Pangolin'

when origin_to_address = '0x1f806f7c8ded893fd3cae279191ad7aa3798e928' then 'Pangolin'

when origin_to_address = '0xd49b406a7a29d64e081164f6c3353c599a2eeae9' then 'Pangolin'

when origin_to_address = '0x574d3245e36cf8c9dc86430eadb0fdb2f385f829' then 'Pangolin'

when origin_to_address in ('0xaaa78e8c4241990b4ce159e105da08129345946a','0xaaaf3d9cdd3602d117c67d80eec37a160c8d9869'

,'0xaaae58986b24e422740c8f22b3efb80bcbd68159','0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b') then 'Pharaoh'

when origin_to_address ='0x88de50b233052e4fb783d4f6db78cc34fea3e9fc' then 'Odos'

when origin_to_address = '0x999dc3ce5399b44dcda15869004e9dc31ee8fcde' then 'Ennead'

else coalesce (initcap(project_name),origin_to_address) end as Destination,

count (distinct tx_hash) as Transactions,

count (distinct origin_from_address) as Active_Users

from avalanche.core.ez_decoded_event_logs t1 left outer join avalanche.core.dim_labels t2 on t1.origin_to_address = t2.address

where contract_address = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b'

and origin_to_address not in ('0x60781c2586d68229fde47564546784ab3faca982')

group by 1

order by 2 desc