select

block_timestamp

, tx_hash

, event_inputs:from as seller

, origin_from_address as purchaser

, event_inputs:tokenId as token_id

, contract_address as nft_address

, case

when contract_address = '0x92618c4c8ef2534242cabed0614ab8b89ef2dc52' then 'Beenz On Acid'

when contract_address = '0x65787a9abc4563316b20ce6c46d0f46f4e357c36' then 'AvaPepes'

when contract_address = '0xdcd0711505f7fb3daa3eb8b358e18020a87d58cc' then 'NavySealGame'

when contract_address = '0x001e68282d52dcaba3749291bac33a9678073d01' then 'Pizza Game Chefs'

when contract_address = '0xacc0cf012b4c28e23e9450c9824a88a4e178a64a' then 'The Person'

when contract_address = '0xa69fee085a4c38656ce9c37a064a330725307482' then 'Avalant'

when contract_address = '0xec675b7c5471c67e9b203c6d1c604df28a89fb7f' then 'Snail Trail'

when contract_address = '0xe2c13aadb000a58f4348313f346b0f01cef95332' then 'DegenFrogs'

when contract_address = '0x6cc4cc814c7154fb67965c8044cc803b3199ec53' then 'Pizza Game Chef Tools'

when contract_address = '0xcf91b99548b1c17dd1095c0680e20de380635e20' then 'Roostr'

when contract_address = '0x0e1ce5cd26d67fd416dc6a22eb97d60131d0901b' then 'Tadpole'

when contract_address = '0x7ff31635e267df29bf47c9eb0880740a798a3bc8' then 'RunBlox'

when contract_address = '0x3025c5c2aa6eb7364555aac0074292195701bbd6' then 'MadSkullz'

when contract_address = '0x11cea873dd8adb5feb97875c317c771d887629fc' then 'Evil Beanz'

when contract_address = '0x071defcaea5e76c035d8af2c56b9fa90e7394c4e' then 'VALIFI NFT'

when contract_address = '0x4245a1bd84eb5f3ebc115c2edf57e50667f98b0b' then 'Hopper'

when contract_address = '0x75c95c8e779b2fe9dd36c9fbdfa98d7eb06bc44b' then 'The Underground'

when contract_address = '0xe8dba81d5b9f605d3c53c67adea91d295606ce74' then 'Cloudheadz'

when contract_address = '0x52b542d613ca3ef2fb7e208dda1b25b723372acd' then 'BootLug'

when contract_address = '0x8927985b358692815e18f2138964679dca5d3b79' then 'Chikn'

when contract_address = '0x5f4320f1eca0c2d65c437bee79609b201a2925a0' then 'Fiscus All-Chain Level 3 NFT'

when contract_address = '0xf675a87397a6239eaf95ad948670a5b19d076c59' then 'Particle_Love_Is_In_The_Air'

when contract_address = '0x1fa5409d159f6b8be52ac89531124761df21d393' then 'Moose V1'

when contract_address = '0x39dafc4c728839f326cb56108a65d71ea8100dcd' then 'Asgardian'

when contract_address = '0x51649692854297bbafc14b7408951f0d42bfd89c' then 'Cities'

when contract_address = '0x149c347860f7cc89726fa4ae21855562f7d2c311' then 'La Chatte Pucie'

when contract_address = '0x6af53a162deb0d3abfd4f47bd6c9615b08d553fd' then 'Doodleverse'