Query editor
withtoken_metadata as (SELECTget_href(get_chain_explorer('solana') || '/tx/' || call_tx_id, '🔗 tx') as tx, call_block_slot, account_mintAuthority, account_masterEdition, account_metadata, account_mint, version, json_value(args, 'strict $.tokenStandard.TokenStandard') as token_standard, json_value(args, 'strict $.print_supply.PrintSupply') as prints, json_value(args, 'strict $.name') as token_name, json_value(args, 'strict $.symbol') as token_symbol, json_value(args, 'strict $.uri') as token_uri, cast(json_value(args, 'strict $.sellerFeeBasisPoints') as double) as seller_fee_basis_points, replace(replace(json_value(args, 'strict $.collection.Collection.collection'), 'PublicKey(', ''), ')','') as collection_mint--likely find a way to get account_collectionMint from edition?, replace(replace(json_value(args, 'strict $.creators[1].Creator.address'), 'PublicKey(', ''), ')','') as verified_creator, json_value(args, 'strict $.creators') as creators_struct, call_tx_id, call_block_time, call_tx_signerFROM (SELECTcall_tx_id, call_block_slot, call_block_time, json_query(createArgs, 'lax $.CreateArgs.V1.asset_data.AssetData') as args, account_authority as account_mintAuthority, account_masterEdition, account_metadata, account_mint, call_tx_signer, 'Token Metadata' as versionFROM mpl_token_metadata_solana.mpl_token_metadata_call_CreateUNION ALLSELECTm.call_tx_id, m.call_block_slot, m.call_block_time, m.args, master.account_mintAuthority, master.account_edition as account_masterEdition, m.account_metadata, m.account_mint, m.call_tx_signer, m.versionFROM (SELECTcall_tx_id, call_outer_instruction_index, call_inner_instruction_index, call_block_slot, call_block_time, json_query(createMetadataAccountArgs, 'lax $.CreateMetadataAccountArgs.data.Data') as args, account_metadata, account_mint, call_tx_signer, 'Token Metadata' as version