date_trunc('week', block_timestamp) date,

when event_data:metadata like '%Mickey and Friends: Volume I%' then 'Mickey and Friends: Volume I'

when event_data:metadata like '%Star Wars™: Volume I%' then 'Star Wars™: Volume I'

when event_data:metadata like '%Zoo-F-O%' then 'Zoo-F-O'

when event_data:metadata like '%Masters of the Universe™ Special Edition 2022%' then 'Masters of the Universe™ Special Edition 2022'

when event_data:metadata like '%Masters of the Universe™%' then 'Masters of the Universe™'

when event_data:metadata like '%MOTU x Cryptoys Comic%' then 'MOTU x Cryptoys Comic'

when event_data:metadata like '%MOTU Poster%' then 'MOTU Poster'

when event_data:metadata like '%Apprentice Mickey%' then 'Sorcerers Apprentice Mickey'

when event_data:metadata like '%Dagobah%' then 'Star Wars™: Yoda Dagobah'

else event_data:metadata

end as collection_type,

count (distinct event_data:id) NFTs

flow.core.fact_events

event_contract = 'A.ca63ce22f0d6bdba.Cryptoys'

and event_type = 'Minted'

and tx_succeeded = 'true'

group by

1,

2