labor_markets as (

select

block_timestamp as created_at,

origin_from_address as creator,

concat('0x', right(topics[1]::string, 40)) as marketplace_address

from

polygon.core.fact_event_logs

where

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

and origin_to_address = lower('0x7b8f452916847f1bc04e187ce8a47462da44895c')

and contract_address = lower('0x7b8f452916847f1bc04e187ce8a47462da44895c')

),

-- select

-- distinct address

-- from

-- labor_markets

-- where

-- not address ilike any (

-- '0xaCbf13fD19F35C2032D3030619318f5B595cc7d8',

-- '0x280b3b748Ccc42D5062CE59111fAd08594f51d9F',

-- '0x3eEAC7cf0526e4c26F9Cd400fbeA852715381709',

-- '0xAdFD6e51b1A8a4f6cD5bb2e1C33b08cBaf47B1E8',

-- '0x3e4f7978447e354E832D38363e927231e518e33a'

-- )

claims as (

select

contract_address as marketplace_address,

ethereum.public.udf_hex_to_int (substr(topics[2], 3, 64)) bounty_id,

ethereum.public.udf_hex_to_int (substr(topics[3], 3, 64)) submission_id,

tx_hash

from

polygon.core.fact_event_logs

-- join labor_markets using (contract_address)

where