select tokenid as tid,max(block_timestamp) as max_bts

from ethereum.core.ez_nft_sales

where nft_address = lower('0xb47e3cd837dDF8e4c57F05d70Ab865de6e193BBB')

group by tid

select buyer_address,SUM(nft.price) AS eth_spent,count(distinct tx_hash) as nfts

from ethereum.core.ez_nft_sales

left outer join nft on tid = tokenid

and max_bts = block_timestamp

where not tid is null

and not buyer_address like '0x0000000000000000000000000000000000000000'

and ETHPRICE is not null

group by buyer_address

order by nfts desc

limit 10