3

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. This was originally posted on Sci fi SE meta but It has been pointed out to me that I would get better responses here.

I am trying something like this:

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##),'%')

But of course this one doesn't work because the subquery is returning more than one values (As it should, given that I want to evaluate the body against all of my own answers) and my knowledge of SQL leaves much to be desired so can't evaluate the body against the Post Ids of all my answers.

Improve this question
3

1 Answer 1

Reset to default
3

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, the quoting post, 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

Improve this answer
3
  • This does not account for multiple quotes in one post. I'm looking for a way to mitigate that
    – JAD
    Commented Jan 8, 2018 at 14:29
  • Hmm, it doesn't seem to be possible to use the string_split function on SEDE, which exhausts my ideas to improve on this.
    – JAD
    Commented Jan 8, 2018 at 14:40
  • Just leave out that distinction by self-quote and it works fine.
    – Helmar
    Commented Jan 8, 2018 at 22:31

You must log in to answer this question.

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