<p>These SQL queries are not quite correct.</p>
<p>For 1):</p>
<pre><code>select multi_asset.name, ma_tx_mint.quantity from multi_asset
  inner join ma_tx_mint on multi_asset.id = ma_tx_mint.ident
  where multi_asset.fingerprint =
  'asset1m4u92ke6820pkk07m8qmmguye02ewr8g6tezr0';
      name      |     quantity     
----------------+------------------
 \x53554e444145 | 2000000000000000
(1 row)
</code></pre>
<p>For 3) I had to modify this one to use <code>tx.block_no</code> instead of <code>tx.block_id</code> because my database is currently running a new experimental schema:</p>
<pre><code>select multi_asset.name, ma_tx_mint.quantity, tx.fee, 
    tx.block_no,tx.block_index, tx_out.address, tx_out.value
  from multi_asset inner join ma_tx_mint on multi_asset.id = ma_tx_mint.ident
    inner join tx on ma_tx_mint.tx_id = tx.id
    inner join tx_out on tx.id = tx_out.tx_id
  where multi_asset.fingerprint = 
    'asset1m4u92ke6820pkk07m8qmmguye02ewr8g6tezr0';

      name      |     quantity     |  fee   | block_no | block_index |                          address                           |  value   
----------------+------------------+--------+----------+-------------+------------------------------------------------------------+----------
 \x53554e444145 | 2000000000000000 | 684646 |  6766387 |          39 | addr1w9742z4fewans7ry6cjp95pc4ecv7y54cx298lp5qfw7s9gv8ukrj |  2000000
 \x53554e444145 | 2000000000000000 | 684646 |  6766387 |          39 | addr1w9pgj46r4wh80ujlrdf5h6sxuuvfac2wurfnsn4xgqw584sfa966l |  2000000
 \x53554e444145 | 2000000000000000 | 684646 |  6766387 |          39 | addr1w9pgj46r4wh80ujlrdf5h6sxuuvfac2wurfnsn4xgqw584sfa966l |  2000000
 \x53554e444145 | 2000000000000000 | 684646 |  6766387 |          39 | addr1w9pgj46r4wh80ujlrdf5h6sxuuvfac2wurfnsn4xgqw584sfa966l |  2000000
 \x53554e444145 | 2000000000000000 | 684646 |  6766387 |          39 | addr1w9pgj46r4wh80ujlrdf5h6sxuuvfac2wurfnsn4xgqw584sfa966l |  2000000
 \x53554e444145 | 2000000000000000 | 684646 |  6766387 |          39 | addr1w9pgj46r4wh80ujlrdf5h6sxuuvfac2wurfnsn4xgqw584sfa966l |  2000000
 \x53554e444145 | 2000000000000000 | 684646 |  6766387 |          39 | addr1w9pgj46r4wh80ujlrdf5h6sxuuvfac2wurfnsn4xgqw584sfa966l | 12315354
(7 rows)

</code></pre>
<p>For 2) I am a little unsure. Were all initial tokens held in a single address? If so, are all transactions containing the relevant mutli-asset from that address to other addresses releases to the public?</p>

CC BY-SA 4.0
2022-08-20T22:53:10.457Z
Can I use cardano-cli to check the above information, not to use postgres database. Because my database is not fully synced right now, so maybe the result is not right.
cdt
CC BY-SA 4.0
2022-08-21T05:09:39.380Z
I am not aware of `cardano-cli` being able to provide that information. For `db-sync` you should wait until it is fully synced before querying it.
Erik de Castro Lopo
CC BY-SA 4.0
2022-08-17T06:34:28.823Z
2022-08-17T07:03:56.080Z
2022-08-17T07:03:56.080Z
Erik de Castro Lopo
<p>Given a certain token,for example Sundae, which has</p>
<pre><code>policyID:    9a9693a9a37912a5097918f97918d15240c92ab729a0b7c4aa144d77

fingerprint: asset1m4u92ke6820pkk07m8qmmguye02ewr8g6tezr0
</code></pre>
<p>(<a href="https://cardanoassets.com/asset1m4u92ke6820pkk07m8qmmguye02ewr8g6tezr0" rel="nofollow noreferrer">https://cardanoassets.com/asset1m4u92ke6820pkk07m8qmmguye02ewr8g6tezr0</a>)</p>
<p>I want to get the information of this token, e.g how many Sundae tokens have been staked,how many Sundae remain in the address of the creator.</p>
<p>To do that,I need to know</p>
<p>(1) the total minted amount of Sundae (in this case 2 millions)</p>
<p>(2) the amount has been released to public (which does not belong to the owners)</p>
<p>(3) the amount remains belonging to the owners</p>
<p>I think I can get (1) by</p>
<pre><code>select multi_asset.name, ma_tx_mint.quantity
from public.multi_asset, public.ma_tx_mint, 
where multi_asset.id = ma_tx_mint.ident and 
multi_asset.fingerprint = 'asset1m4u92ke6820pkk07m8qmmguye02ewr8g6tezr0'
</code></pre>
<p>For (3), at least I can get the address of the creator</p>
<pre><code>select multi_asset.name, ma_tx_mint.quantity, tx.fee, tx.block_id,tx.block_index, tx_out.address, tx_out.value
from public.multi_asset, public.ma_tx_mint, public.tx,public.tx_out
where multi_asset.id = ma_tx_mint.ident and ma_tx_mint.tx_id = tx.id and tx.id = tx_out.tx_id and
multi_asset.fingerprint = 'asset1m4u92ke6820pkk07m8qmmguye02ewr8g6tezr0'
</code></pre>
<p>But how to get the remaining amount of Sundae in this address?</p>
<p>For (2),I do not have any idea how to do.</p>
<p>Thanks you very much!</p>

<native-assets><address><mint><asset>
How to get information of a certain native token from Cexplorer database?
# How to get information of a certain native token from Cexplorer database?

(Asked by: username_0 on 2022-08-16)

Given a certain token,for example Sundae, which has
policyID:    9a9693a9a37912a5097918f97918d15240c92ab729a0b7c4aa144d77

fingerprint: asset1m4u92ke6820pkk07m8qmmguye02ewr8g6tezr0

(https://cardanoassets.com/asset1m4u92ke6820pkk07m8qmmguye02ewr8g6tezr0)
I want to get the information of this token, e.g how many Sundae tokens have been staked,how many Sundae remain in the address of the creator.
To do that,I need to know
(1) the total minted amount of Sundae (in this case 2 millions)
(2) the amount has been released to public (which does not belong to the owners)
(3) the amount remains belonging to the owners
I think I can get (1) by
select multi_asset.name, ma_tx_mint.quantity
from public.multi_asset, public.ma_tx_mint, 
where multi_asset.id = ma_tx_mint.ident and 
multi_asset.fingerprint = 'asset1m4u92ke6820pkk07m8qmmguye02ewr8g6tezr0'

For (3), at least I can get the address of the creator
select multi_asset.name, ma_tx_mint.quantity, tx.fee, tx.block_id,tx.block_index, tx_out.address, tx_out.value
from public.multi_asset, public.ma_tx_mint, public.tx,public.tx_out
where multi_asset.id = ma_tx_mint.ident and ma_tx_mint.tx_id = tx.id and tx.id = tx_out.tx_id and
multi_asset.fingerprint = 'asset1m4u92ke6820pkk07m8qmmguye02ewr8g6tezr0'

But how to get the remaining amount of Sundae in this address?
For (2),I do not have any idea how to do.
Thanks you very much!

**Tags:** native-assets, address, mint, asset

---

## 1 answers

### Answer by username_1 on 2022-08-17. Score: 0

These SQL queries are not quite correct.
For 1):
select multi_asset.name, ma_tx_mint.quantity from multi_asset
  inner join ma_tx_mint on multi_asset.id = ma_tx_mint.ident
  where multi_asset.fingerprint =
  'asset1m4u92ke6820pkk07m8qmmguye02ewr8g6tezr0';
      name      |     quantity     
----------------+------------------
 \x53554e444145 | 2000000000000000
(1 row)

For 3) I had to modify this one to use tx.block_no instead of tx.block_id because my database is currently running a new experimental schema:
select multi_asset.name, ma_tx_mint.quantity, tx.fee, 
    tx.block_no,tx.block_index, tx_out.address, tx_out.value
  from multi_asset inner join ma_tx_mint on multi_asset.id = ma_tx_mint.ident
    inner join tx on ma_tx_mint.tx_id = tx.id
    inner join tx_out on tx.id = tx_out.tx_id
  where multi_asset.fingerprint = 
    'asset1m4u92ke6820pkk07m8qmmguye02ewr8g6tezr0';

      name      |     quantity     |  fee   | block_no | block_index |                          address                           |  value   
----------------+------------------+--------+----------+-------------+------------------------------------------------------------+----------
 \x53554e444145 | 2000000000000000 | 684646 |  6766387 |          39 | addr1w9742z4fewans7ry6cjp95pc4ecv7y54cx298lp5qfw7s9gv8ukrj |  2000000
 \x53554e444145 | 2000000000000000 | 684646 |  6766387 |          39 | addr1w9pgj46r4wh80ujlrdf5h6sxuuvfac2wurfnsn4xgqw584sfa966l |  2000000
 \x53554e444145 | 2000000000000000 | 684646 |  6766387 |          39 | addr1w9pgj46r4wh80ujlrdf5h6sxuuvfac2wurfnsn4xgqw584sfa966l |  2000000
 \x53554e444145 | 2000000000000000 | 684646 |  6766387 |          39 | addr1w9pgj46r4wh80ujlrdf5h6sxuuvfac2wurfnsn4xgqw584sfa966l |  2000000
 \x53554e444145 | 2000000000000000 | 684646 |  6766387 |          39 | addr1w9pgj46r4wh80ujlrdf5h6sxuuvfac2wurfnsn4xgqw584sfa966l |  2000000
 \x53554e444145 | 2000000000000000 | 684646 |  6766387 |          39 | addr1w9pgj46r4wh80ujlrdf5h6sxuuvfac2wurfnsn4xgqw584sfa966l |  2000000
 \x53554e444145 | 2000000000000000 | 684646 |  6766387 |          39 | addr1w9pgj46r4wh80ujlrdf5h6sxuuvfac2wurfnsn4xgqw584sfa966l | 12315354
(7 rows)


For 2) I am a little unsure. Were all initial tokens held in a single address? If so, are all transactions containing the relevant mutli-asset from that address to other addresses releases to the public?

> **Comments:**
> **username_0**: Can I use cardano-cli to check the above information, not to use postgres database. Because my database is not fully synced right now, so maybe the result is not right.  
> **username_1**: I am not aware of `cardano-cli` being able to provide that information. For `db-sync` you should wait until it is fully synced before querying it.  

---

