The unanswered question feed is kind of cool but it feels a tad general to me.

Can anybody think of a different query on data explorer that takes into account the tags I am good at answering and lists those unanswered questions first?

  • 1
    Remember to vote for this: Interesting Tab – Lance Roberts Jun 16 '10 at 21:39
  • @Lance, Which also brings up a good point, I can do this kind of manually by adding interesting tags, but it would be cool to see an automatic query – waffles Jun 16 '10 at 21:59
  • After looking at SEDE, I see there are quite a few fields missing, including anything to tell what a user's interesting tags are. – Lance Roberts Jun 16 '10 at 22:40
  • @Lance, which fields ? – waffles Jun 17 '10 at 0:30
  • @waffles, I haven't looked at the actual database to know what the fields would be, but there isn't one for 'Interesting Tags' or 'Ignored Tags'. There was something else I noticed wasn't there, but can't remember what it is right now. – Lance Roberts Jun 17 '10 at 0:40
  • @Lance true, perhaps we should add that to the data dump. Nonetheless you can get a full list of a users activity and work it out that way. – waffles Jun 17 '10 at 0:52
  • Hold on, there's an unanswered question feed?!?! – Maxim Zaslavsky Aug 16 '10 at 3:46

Here is my take:


It takes into account your 20 most upvoted tags, question score and askers reputation.

You may want to play around with this line: (sum(t.[Count]) / 10.0 + us.Reputation / 200.0 + p.Score * 100) as Weight

Which can be used to determine the score.

I just ran it with my user id and got a very interesting list, which is much better for me (imho) that the current unanswered list.

You must log in to answer this question.

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