# 在Mirror开通我的博客拉

**Published by:** [0xbill](https://paragraph.com/@aicn/)
**Published on:** 2022-03-22
**URL:** https://paragraph.com/@aicn/mirror

## Content

拥抱web3时，Mirror 解决了如何让创作者拥创作内容的所有权 如果要在这里写文章需要看是否能解决写作问题：FAQ-支持Markdown?FAQ-能否嵌入B站视频？https://player.bilibili.com/player.html?aid=510050642&bvid=BV1Cu411q7k6&cid=556343748&page=1&display=iframeFAQ-能否嵌入代码WITH token AS (SELECT DISTINCT call_tx_hash AS tx_hash, CASE WHEN addrs[7] = '\x0000000000000000000000000000000000000000' THEN '\xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' ELSE addrs[7] END AS token_address FROM opensea."WyvernExchange_call_atomicMatch_" WHERE (addrs[4] = '\x5b3256965e7c3cf26e11fcaf296dfc8807c01073' OR addrs[11] = '\x5b3256965e7c3cf26e11fcaf296dfc8807c01073') AND call_success), excluded_txns AS (SELECT call_tx_hash FROM opensea."WyvernExchange_call_atomicMatch_" WHERE (addrs[4] = '\x5b3256965e7c3cf26e11fcaf296dfc8807c01073' OR addrs[11] = '\x5b3256965e7c3cf26e11fcaf296dfc8807c01073') AND call_success AND call_block_time > '2022-01-21' GROUP BY 1 HAVING count(DISTINCT CASE WHEN addrs[7] = '\x0000000000000000000000000000000000000000' THEN '\xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' ELSE addrs[7] END) > 1) SELECT date_trunc('month', evt_block_time) AS MONTH, SUM((om.price / 10^erc.decimals) * p.price) AS usd FROM opensea."WyvernExchange_evt_OrdersMatched" om INNER JOIN token ON token.tx_hash = om.evt_tx_hash INNER JOIN erc20.tokens erc ON token.token_address = erc.contract_address INNER JOIN prices.usd p ON p.minute = date_trunc('minute', evt_block_time) AND maker != taker AND token.token_address = p.contract_address AND date_trunc('month', p.minute) >= '2018-06-01' AND evt_tx_hash not in (SELECT * FROM excluded_txns) GROUP BY 1 ORDER BY 1

## Publication Information

- [0xbill](https://paragraph.com/@aicn/): Publication homepage
- [All Posts](https://paragraph.com/@aicn/): More posts from this publication
- [RSS Feed](https://api.paragraph.com/blogs/rss/@aicn): Subscribe to updates
- [Twitter](https://twitter.com/web3bill): Follow on Twitter