9

Recently I saw an answer from another user where they had quoted one of my answers within theirs. It felt nice.

So that had me wondering, is there any way to see all my answers that are quoted elsewhere by some other users?

I know I can go through all my answers and see the linked posts which may or may not show me the desired results but that is kind of hectic. What I am looking for is a list. I think SEDE's might be the only way, if any.

6
  • What would you consider a substantial quote? Anything after > that matches anything in any of your answers?
    – JAD
    Jan 8, 2018 at 12:22
  • 1
    @JarkoDubbeldam Anything that provides a link to my answer I suppose. The string matching could be inaccurate, e.g. Me and some other guy quoting the same source. The links however are a better way I reckon. But then again, links can be different depending on whether you came from front page, search, comment or share url feature. Anything that contains "Post Id" of one of my posts which is an answer would be a better bet I suppose
    – Aegon
    Jan 8, 2018 at 13:08
  • 1
    I quess getting a table of all your answers and then searching all post bodies for links containing post IDs from that table might be the best way to go. (And of course, cue standard recommendation that you might reach a broader audience of SEDE-knowledgable people by asking this general SE question on Meta Stack Exchange.)
    – TARS
    Jan 8, 2018 at 13:50
  • SELECT Id AS [Post Link] FROM Posts WHERE PostTypeId = 2 AND OwnerUserId != ##UserId## AND Body LIKE CONCAT('%',(SELECT Id FROM Posts WHERE PostTypeId = 2 AND OwnerUserId = ##UserId##),'%') Something like this of course. This one doesn't work tho because the subquery returns more than one results and I need to evaluate the body against all of my answers.
    – Aegon
    Jan 8, 2018 at 13:53
  • @TARS I guess I could take it to MSE. What should I do with this one? Leave open and then answer with whatever I might find there?
    – Aegon
    Jan 8, 2018 at 13:54
  • I don't know. Depends on personal taste, I guess. I would just have gone to Meta Stack Exchange to begin with. ;-)
    – TARS
    Jan 8, 2018 at 13:55

1 Answer 1

Reset to default
7

For this I used some arguably pretty narrow definitions for what counts as a quote. I assumed that a quote is, at very least, a link back to the original post. This link has to have the following format: scifi.stackexchange.com/a/<postid>. The query then takes all posts that contain such links, checks whether they link back to one of your posts, at reports that.

The results are the original post id, the quoting post id, and whether or not you self-quoted in that specific instance or not.

The tally seems to be:

  • 10 quotes by others
  • 24 quotes by yourself

The Query

2
  • By the way, you know that you can use the as [Post Link] magic column name in order to get a neat link to the post (complete with title text) instead of a bare ID? It might also be a good idea to make the user in question an input parameter. I don't particularly care about Ageon's answers. ;-)
    – TARS
    Jan 8, 2018 at 14:18
  • @TARS I was aware of the feature, but didn't know how to use it. Thanks :)
    – JAD
    Jan 8, 2018 at 14:21

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .