What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 150 Stack Exchange communities.

I am looking for a pre-made query for Data Explorer that finds all my answers that have the most votes for questions without accepted answer.

Just want to see how many of those I have, and if possible a link to those questions.

share|improve this question
Looking at your SO profile, I have to expect you know at least a little bit of SQL. Why not just write the query yourself and, if you have trouble doing so, ask for help on SO? –  McCannot Jul 20 '11 at 18:06
Just not so familiar with the Data Explorer database design. –  Yochai Timmer Jul 20 '11 at 18:36

2 Answers 2

up vote 3 down vote accepted

Not the most elegant answer (I'm not a fan of correlated sub queries), but it works and it's what I came up with first:

share|improve this answer

I've just edited Joel's code, got something that works the way I wanted:


share|improve this answer
You might want a LEFT JOIN rather than an INNER JOIN for the last join, otherwise you won't see questions with no other answers (unless that's what you wanted) –  Joel Coehoorn Jul 20 '11 at 22:06
I want only questions that I've answered with the highest score. So there's at least 1 answer to them. questions without answers wouldn't be needed. Thanks –  Yochai Timmer Jul 20 '11 at 22:07

You must log in to answer this question.

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