SandeshSubmission searcher copy
Updated 2023-06-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from LittlerData / Submission searcher @ https://flipsidecrypto.xyz/LittlerData/q/2023-05-17-12-58-pm-zvGYGy
select
ethereum.public.udf_hex_to_int(substr(topics[2], 3, 64))::int bounty_id
,ethereum.public.udf_hex_to_int(substr(topics[3], 3, 64))::int submission_id
,contract_address
,concat(contract_address, '-', bounty_id) bounty_idd
,origin_from_address analyst
,tx_hash
,concat ('https://metricsdao.xyz/app/market/',contract_address,'/submission/',submission_id) Submission_URL
from polygon.core.fact_event_logs
where origin_function_signature = '0x269dde89'
and contract_address in ('0x280b3b748ccc42d5062ce59111fad08594f51d9f', '0x3e4f7978447e354e832d38363e927231e518e33a'
,'0xadfd6e51b1a8a4f6cd5bb2e1c33b08cbaf47b1e8', '0xacbf13fd19f35c2032d3030619318f5b595cc7d8'
,'0x3eeac7cf0526e4c26f9cd400fbea852715381709') --approved marketplaces, cant get to leave out the test marketplaces
-- and origin_from_address ilike '{{User}}'
Run a query to Download Data