with tab1 as (

SELECT

block_timestamp,

tx_hash as tx,

event_inputs['_to'] as nft_to_address,

event_inputs['_from'] as nft_from_address

FROM polygon.core.fact_event_logs

WHERE

tx_status = 'SUCCESS'

AND event_name = 'TransferSingle'

AND contract_address IN (

'0xb9c042c3275bc49799688eea1a29b1405d02946b'

)

),

tab2 as

(

SELECT

block_timestamp,

tx_hash as tx,

event_inputs['_to'] as nft_to_address

FROM polygon.core.fact_event_logs

WHERE

tx_status = 'SUCCESS'

AND event_name = 'TransferSingle'

AND event_inputs:_from = '0x0000000000000000000000000000000000000000'

AND contract_address IN (

'0xb9c042c3275bc49799688eea1a29b1405d02946b'

)

) ,

tab3 as( select * from tab1 where tx not in(select tx from tab2))