select

tx_hash,

block_timestamp,

contract_address as collection,

event_inputs:_to as minter,

event_inputs:_id as NFTid

from polygon.core.fact_event_logs

where origin_function_signature in ('0x5a86c41a', '0x669f5a51')

and event_inputs:_from = '0x0000000000000000000000000000000000000000'

and event_name = 'TransferSingle'

and tx_status = 'SUCCESS'),

sales as (

select

tx_hash,

event_inputs:_from as seller,

event_inputs:_to as buyer,

event_inputs:_id

from polygon.core.fact_event_logs

where contract_address in (select collection from source_mints)

and event_inputs:_from != '0x0000000000000000000000000000000000000000'

and event_inputs:_to != '0x0000000000000000000000000000000000000000'

and event_name = 'TransferSingle'

and tx_status = 'SUCCESS'),

other_collections as (

select

tx_hash,

event_inputs:_from,

event_inputs:_to as active_buyers,

event_inputs:_id,

contract_address

from polygon.core.fact_event_logs

where contract_address not in (select collection from source_mints)

and event_inputs:_to in (select buyer from sales)