Is there a good Data Explorer query to find how "SFF-linky" my answers are in-site?

In more technical terms, for a given user, how many links to SFF.SE are on average in their answers on the site?

  • This question is posted in honor of Ted Nelson Aug 9, 2016 at 13:20
  • I'm willing to bet that I'm very linky indeed.
    – Valorum
    Aug 9, 2016 at 15:15
  • Do you mean how many other questions link to answers you've posted? Or how many links you've included to other answers on the site?
    – Valorum
    Aug 9, 2016 at 15:21
  • @Valorum - the latter (but not only to answers, but to ANY site URLs) Aug 9, 2016 at 15:36
  • Whoops, missed the "to SFF URLs" bit in that; that changes my numbers more than a little Aug 9, 2016 at 18:09
  • Okay, I'm getting a bit mixed up in the language of the question. Are you asking for a way to determine how many links you've put in answers?
    – PiousVenom
    Aug 12, 2016 at 18:19
  • @MyCodeSucks - links in answers, pointing to SFF pages. Aug 12, 2016 at 18:39
  • FWIW Here's the full rankings data.stackexchange.com/scifi/query/edit/524384
    – Hack-R
    Aug 15, 2016 at 3:29
  • @Hack-R Yoink Sep 19, 2016 at 17:30
  • 1
    I feel like I did math, by getting that query to work! I am 0.5121951219512195% linky. :) Sep 19, 2016 at 20:39
  • @DVK Ted Nelson is the High Sparrow of http. :)
    – Möoz
    Sep 19, 2016 at 23:42

1 Answer 1


Ask and ye shall receive

Standard SEDE disclaimers apply:

  • Updated once weekly; currently we're about two days behind reality
  • Doesn't include deleted posts

Plug your SFF UserId into the box and away you go.

  • Mine is 0.453
  • Yours is 0.111
  • Valorum's (since he asked) is 0.047

Note that this hasn't really been tested, since I'm not inclined to manually count all the links in all of my answers. I'm always welcome to corrections.

An earlier version of the query counted all links, but the one above only counts links to SFF.SE (and not meta).

With due credit to Hack-R for doing most of the hard work, you can also check out the Linky Leaderboard, though it isn't very instructive; indeed, the top five are:

  • errantlinguist, with four links in one answer
  • USFBS, with five links in two answers
  • user137369, with two links in one answer
  • The unregistered Vates, also with two links in one answer
  • Tony R, still with two links in one post

To my eternal shame, I am merely the 139th most linky user of the site.

  • Apparently I'm not very linky at all :-( Unless you count 'all links', in which case I'm quite linky indeed.
    – Valorum
    Aug 9, 2016 at 18:09
  • The share link below posts (which is what I usually use for post linking) seems to provide an http link. And indeed, if I remove the whole a href="https business from your query, the people listed here are way more linky.
    – TARS
    Aug 9, 2016 at 20:14
  • 1
    @Cahir Hm, that's annoying. Query updated; thanks Aug 9, 2016 at 20:18
  • Mine's 0.79 is that bad?
    – Möoz
    Aug 9, 2016 at 21:57
  • 2
    @Mooz - Yes. Dreadful. Possibly.
    – Valorum
    Aug 9, 2016 at 22:29
  • Oh gosh, and if I include all links, then I get 7.15! What do I win?
    – Möoz
    Aug 9, 2016 at 23:30
  • Nothing. That doesnt seep like too much
    – bleh
    Aug 11, 2016 at 23:10
  • 1
    @Mooz - It's good if you're into the whole interwebz idea. Aug 12, 2016 at 18:40
  • Made a similar query: Linkyness Leaderboard (including external links)
    – Möoz
    Sep 19, 2016 at 22:20

You must log in to answer this question.

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