with data as(

SELECT event_data:id as id, parse_json(event_data:metadata) as m, parse_json(event_data:royalties) as r, *

FROM flow.core.fact_events as e

where event_contract like '%Cryptoys%'

and event_type = 'Minted'

and block_timestamp >= '5/23/2023'

order by event_data:id ASC

SELECT id, m[0].value.value, m[6].value.value, m[8].value.value,r[0].value.fields[2].value.value, tx_id

from data

WHERE m[6].value.value like '%Star Wars%' and m[4].value.value = '0001-01-01'