select
*
From flow.core.ez_nft_sales
join flow.core.dim_allday_metadata on flow.core.dim_allday_metadata.nft_id = flow.core.ez_nft_sales.nft_id
where flow.core.ez_nft_sales.nft_collection ILIKE 'A.e4cf4bdc1751c65d.AllDay'
and tx_succeeded = 'true'
and play_type= 'Reception'
-- group by
-- order by sales desc
limit 10