SteemitSQL继续教大家学坏 💻

in #cn • 7 years ago

IMG_2281.JPG
我的苹果

上次我教了大家一点SteemitSQL黑科技，如何查询删除的帖子。很多同学说没卵用，因为查到删除了什么链接也不知道被删除的是什么。我是怕大家学坏没有继续教。

最近我发现有些老外实在是太坏了，咱中国人不学坏点没法生存。所以我把上次没讲完的课讲完。

把上堂课的代码用一下，可以查到被删除的记录，比如：

re-giantbear-re-sauravrungta-struggles-of-being-an-overthinker-20170905t204959660z

怎么把删除的回复找出来呢？有工具：https://phist.steemdata.com/

直接把那一条删除记录放到上面的工具里是不可以的，需要重新构造一下才行。根据作者是谁，你可以构造出下面这个URL，然后放进上面的工具里就查询出来了。

https://steemit.com/@s4s/re-giantbear-re-sauravrungta-struggles-of-being-an-overthinker-20170905t204959660z

数据、观察、分析系列

技术系列

加勒比海系列

更多游记

© Copyright 所有照片与文字皆为 @nationalpark原创。All photos taken by @nationalpark. All rights reserved.

#steemit #cn-steemit #programming #cn-programming
7 years ago in #cn by
$6.96
  • Past Payouts $6.96, 0.00 TRX
  • - Author $5.62, 0.00 TRX
  • - Curators $1.34, 0.00 TRX
28 votes
Reply 5
Sort:  
  • Trending
    • [-]
     7 years ago 

    @reported has voted on behalf of @minnowpond. If you would like to recieve upvotes from minnowponds team on all your posts, simply FOLLOW @minnowpond.

            To receive an upvote send 0.25 SBD to @minnowpond with your posts url as the memo
        To receive an reSteem send 0.75 SBD to @minnowpond with your posts url as the memo
        To receive an upvote and a reSteem send 1.00SBD to @minnowpond with your posts url as the memo
    $0.00
      Reply
      [-]
       7 years ago 

      你的蘋果好慘啊~

      $0.00
        Reply
        [-]
         7 years ago 

        是啊特别惨。还有一个掉到海水里，比这个还惨，照片全丢了

        $0.00
          Reply

          Coin Marketplace

          STEEM 0.18
          TRX 0.13
          JST 0.028
          BTC 64300.62
          ETH 3165.63
          USDT 1.00
          SBD 2.56