# 在Mirror开通我的博客拉

By [0xbill](https://paragraph.com/@aicn) · 2022-03-22

---

拥抱web3时，Mirror 解决了`如何让创作者拥创作内容的所有权`

如果要在这里写文章需要看是否能解决写作问题：

FAQ-支持Markdown?
---------------

![](https://storage.googleapis.com/papyrus_images/c78a63cbefd03fa74c6be74bcf21cede8642310f8d69f8c2206f800c0df801ab.jpg)

### FAQ-能否嵌入B站视频？

[https://player.bilibili.com/player.html?aid=510050642&bvid=BV1Cu411q7k6&cid=556343748&page=1&display=iframe](https://player.bilibili.com/player.html?aid=510050642&bvid=BV1Cu411q7k6&cid=556343748&page=1&display=iframe)

### FAQ-能否嵌入代码

    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

---

*Originally published on [0xbill](https://paragraph.com/@aicn/mirror)*