select

distinct el.contract_address as contract,

case

when dl.project_name is not null then dl.project_name

when el.contract_address is null then 'transfer'

end as dapp,

dl.address_name as contract_name

from

polygon.core.fact_decoded_event_logs el

left join

polygon.core.dim_labels dl

on el.contract_address = dl.address

OR (el.contract_address IS NULL AND dl.address IS NULL)

where date(el.block_timestamp) between '{{Start_date}}' and '{{End_date}}'

)

coalesce(c.contract, 'transfer') as contract_address,

c.contract_name as contract_name,

count(distinct ft.tx_hash) as transactions,

count(distinct ft.from_address) as addresses

from

polygon.core.fact_transactions ft

left join

polygon.core.fact_decoded_event_logs el

on ft.tx_hash = el.tx_hash

left join

contracts c

on el.contract_address = c.contract

where ft.tx_hash = '0xa88a34be42c590b5c66a38c84aa7c5344363a666f1db2f34fe420bda306d4b40'

group by 1,2

order by 3 desc