block_timestamp,

contract_address as "Organization Address",

origin_from_address as "Badge Creator",

max(event_inputs:"_id"::string) as "Token ID"

from

polygon.core.fact_event_logs

where block_timestamp::date > '2022-10-16'::date

and contract_Address in

(select

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

from

polygon.core.fact_event_logs

where block_timestamp::date > '2022-10-16'::date

and contract_Address = lower('0x218b3c623ffb9c5e4dbb9142e6ca6f6559f1c2d6')

and origin_function_signature = '0x7b366213')

and origin_function_signature = '0x78677a8d'

group by 1,2,3

order by 1 desc