when try_parse_json(EVENT_DATA:metadata)[7]:value:value like 'Star Wars™: Volume III%' then 'Star Wars™ Volume III,0'

when try_parse_json(EVENT_DATA:metadata)[7]:value:value like '%Star Wars™: Volume II%' then 'Star Wars™ Volume II,39.99'

when try_parse_json(EVENT_DATA:metadata)[7]:value:value like '%Star Wars™: Volume I%' then 'Star Wars™ Volume I,39.99'

when try_parse_json(EVENT_DATA:metadata)[7]:value:value like '%Star Wars™ Special Editions: Yoda%' then 'Star Wars™ Special Editions Yoda,29.99'

when try_parse_json(EVENT_DATA:metadata)[7]:value:value like '%Star Wars™ Special Editions: Anakin Skywalker%' then 'Star Wars™ Special Editions Anakin Skywalker,29.99'

when try_parse_json(EVENT_DATA:metadata)[7]:value:value like '%Star Wars™ Special Editions: Boba Fett%' then 'Star Wars™ Special Editions Boba Fett,0'

else 'not registered' end as collect,

count (distinct event_data:id) NFTS,

count (distinct TX_ID) MINT_NFTs

from flow.core.fact_events

where event_contract = 'A.ca63ce22f0d6bdba.Cryptoys'

and tx_succeeded = 'true'

--and event_data:metadata not like '%Mickey and Friends: Volume I%'

--and event_data:metadata not like '%Star Wars™: Volume I%'

--and event_data:metadata not like '%Zoo-F-O%'

--and event_data:metadata not like '%Masters of the Universe™ Special Edition 2022%'

--and event_data:metadata not like '%Masters of the Universe™%'

and event_type = 'Minted'

group by 1