SELECT '0x'|| hex(ac.topic0) as topic_hash, thm.signature, count()
from blockchains.all_chains ac
  LEFT JOIN reports.topic_hash_methods thm 
		ON ac.topic0 = unhex(thm.topic0_hash)
where log_emitter = unhex('7d2768dE32b0b80b7a3454c06BdAc94A69DDc7A9') -- change contract
and signed_at >= '2022-07-01' -- change timeline
AND chain_name = 'eth_mainnet' -- change chain
GROUP BY topic_hash, thm.signature;