SandeshMDAO reviewers per submission 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
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from LittlerData / MDAO reviewers per submission @ https://flipsidecrypto.xyz/LittlerData/q/mdao-graded-submissions-copy-mXp5iz
with submissions as (
select
ethereum.public.udf_hex_to_int(substr(topics[2], 3, 64))::string bounty_id
,ethereum.public.udf_hex_to_int(substr(topics[3], 3, 64))::string submission_id
,contract_address
,concat(contract_address, '-', bounty_id)::string bounty_idd
,origin_from_address analyst
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
),
reviews as (
select
ethereum.public.udf_hex_to_int(substr(topics[2], 3, 64))::string bounty_id
,ethereum.public.udf_hex_to_int(substr(topics[3], 3, 64))::string submission_id
,ethereum.public.udf_hex_to_int(substr(data, 3, 64))::int score
,case
when score = 0 then 0
when score = 1 then 25
when score = 2 then 50
when score = 3 then 75
when score = 4 then 100
end as scaled_score
,contract_address
,concat(contract_address, '-', bounty_id)::string bounty_idd
,origin_from_address reviewer
from polygon.core.fact_event_logs
where contract_address in ('0x280b3b748ccc42d5062ce59111fad08594f51d9f', '0x3e4f7978447e354e832d38363e927231e518e33a'
Run a query to Download Data