What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 133 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
2  
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:
http://data.stackexchange.com/stackoverflow/q/106139/questions-with-no-accepted-answer-where-i-have-the-highest-score?UserID=536086

share|improve this answer

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

http://data.stackexchange.com/stackoverflow/s/1621/answers-with-best-score-but-question-has-no-accepted-answer

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 .