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.

cn steemit cn-steemit programming cn-programming
7 years ago by

Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

  • Disagreement on rewards
  • Fraud or plagiarism
  • Hate speech or trolling
  • Miscategorized content or spam

Submit
$6.96
  • Past Payouts $6.96
  • - Author $5.62
  • - Curators $1.34
29 votes
5
Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  
  • Trending
    • [-]
      ·  7 years ago 

    Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

    • Disagreement on rewards
    • Fraud or plagiarism
    • Hate speech or trolling
    • Miscategorized content or spam

    Submit
    $0.55
    • Past Payouts $0.55
    • - Author $0.55
    • - Curators $0.00
    2 votes
    [-]
      ·  7 years ago 

    赞

    Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

    • Disagreement on rewards
    • Fraud or plagiarism
    • Hate speech or trolling
    • Miscategorized content or spam

    Submit
    $0.00
      [-]
        ·  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

      Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

      • Disagreement on rewards
      • Fraud or plagiarism
      • Hate speech or trolling
      • Miscategorized content or spam

      Submit
      $0.00
        [-]
          ·  7 years ago 

        你的蘋果好慘啊~

        Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

        • Disagreement on rewards
        • Fraud or plagiarism
        • Hate speech or trolling
        • Miscategorized content or spam

        Submit
        $0.00
          [-]
            ·  7 years ago 

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

          Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

          • Disagreement on rewards
          • Fraud or plagiarism
          • Hate speech or trolling
          • Miscategorized content or spam

          Submit
          $0.00