with request_fulfillments as (

select

event_name,

decoded_log:fulfiller as challenge_submitter,

decoded_log:requestId as challenge_id,

decoded_log:submissionId as submission_id,

to_char(block_timestamp,'MM-DD-YYYY HH:MM') as submission_date,

case

when contract_address = lower('0x280b3b748ccc42d5062ce59111fad08594f51d9f') then 'MetricsApp Beta Launch'

when contract_address = lower('0x3eeac7cf0526e4c26f9cd400fbea852715381709') then 'Flash Bounty'

when contract_address = lower('0xacbf13fd19f35c2032d3030619318f5b595cc7d8') then 'Pine Analytics Marketplace'

when contract_address = lower('0x496804c528146315e136570daaac5a1509f739e3') then 'Pine Public Marketplace'

when contract_address = lower('0x3e4f7978447e354e832d38363e927231e518e33a') then 'MetricsDAO Marketplace'

when contract_address = lower('0xd587bfaccaa32c338fc0b1424739d5197ac8521b') then 'Flipside Partner Marketplace'

when contract_address = lower('0x7216ec17c2d4e568c9e9ee0365adb4ba9b1d4d7e') then 'Flipside Solana Marketplace'

when contract_address = lower('0x7c18b5cf6f980002e15304d13c1f9171641484b2') then 'Flipside Marketplace, July 27th'

when contract_address = lower('0x5817361094d09f2279793a1933019b592a832368') then 'Flipside Marketplace, July 20th'

when contract_address = lower('0x769e3a4074f9f321f4b64ab5360954ca2414f611') then 'Flipside Marketplace, July 16th'

when contract_address = lower('0x32445a79e22ac545b45548a5b76122b2142c62b2') then 'Flipside Marketplace'

end as market_name

from

polygon.core.fact_decoded_event_logs

where

market_name ilike '%flipside%'

and

event_name = 'RequestFulfilled'

and

block_timestamp::date > '2023-04-01'::date

),

review_submissions as (

select

event_name,

decoded_log:requestId as challenge_id,