from polygon.transactions

where to_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d')

select contract_address, case

when contract_address = '0xa5f1ea7df861952863df2e8d1312f7305dabf215' then 'ZED Horse'

when contract_address = '0x8634666ba15ada4bbc83b9dbf285f73d9e46e4c2' then 'Chicken Derby'

when contract_address = '0xfd12ec7ea4b381a79c78fe8b2248b4c559011ffb' then 'CryptoRaiders'

when contract_address = '0x1f5567d9d3efa79c4b03beb42491344111efbdf5' then 'WhelpsNFT'

when contract_address = '0x2ad64e95eff639fbd0273bcd4d0eeb72a60c8586' then 'MobsKeys'

when contract_address = '0x0a0bf65248805efa926c39bf51b6dd94e3d1a7af' then 'Visitor'

when contract_address = '0xbccaa7acb552a2c7eb27c7eb77c2cc99580735b9' then 'Artvatars'

when contract_address = '0x9498274b8c82b4a3127d67839f2127f2ae9753f4' then 'PolygonPunks'

when contract_address = '0xe7e16f2da731265778f87cb8d7850e31b84b7b86' then 'Embersword Land'

when contract_address = '0x82bbf7be0eb9a6024b7a641ba179e00812bdae53' then 'Riot Racers Cars'

when contract_address = '0x58530e43b89234fe08fd20ed06ef536233b6dd69' then 'NFTokins'

when contract_address = '0x4f17c6514b9ca3abccfdefd12df2dfa195a76dc4' then 'TrumpChick'

when contract_address = '0x36a8377e2bb3ec7d6b0f1675e243e542eb6a4764' then 'Non-Fungible Matic V2'

when contract_address = '0x85cbf58c9d20459339a0b1f586a5fac643a29286' then 'CryptoSharks'

when contract_address = '0xcda17cf2ac3cf8e6e818088f21ee9b52bf9e021f' then 'MaticMonkey'

when contract_address = '0xa115dfbb5ab7adffad2f7f25fa7a5c227616c2c3' then 'Flowerpatch.app'

when contract_address = '0xd319eb71f8d630381001dcea9fb50573b9c12343' then 'Alatelecoin Airdrop Eligible Pass'

when contract_address = '0xb2cbdc22d0fc9da42954d9d06bb946e8d77dbf70' then 'SpaceCats'

else concat('unknown-', contract_address) end as Project_name,

count(distinct tx_id) as Total_Traded

from polygon.udm_events

where event_name = 'Approval' and event_type = 'event' and contract_address != '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' and contract_address != '0x8f3cf7ad23cd3cadbd9735aff958023239c6a063'

and tx_id in (select tx_id from raw)

group by 1,2

order by 3 desc

limit 10