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

A while back I saw something like a SQL query engine for various post related searches but I can't find any FAQ/reference on how to use it. If you could point me to such a page/post I will try to answer this question on my own.

Anyway, I'd like to see a list of the users whose answers I accepted because I they were the most complete and useful. Specifically I'm curious to see if I accepted the same person more than once.

share|improve this question
add comment

2 Answers

up vote 3 down vote accepted

You're talking about the Data Explorer. Using it is dead simple; you just compose an SQL query and run it (you'll notice the database layout on the right-hand side; see this post for some more detailed information). There are a couple special features, such as parameters and "magic" column names on which the documentation leaves something to be desired, though.

Here's a query I just wrote that lists the users you've accepted the most answers from.

share|improve this answer
    
It's not simple for me :( Thank you for helping. I'm not able to get results from your query. I'm only trying my Stack Overflow id, 1238040, which is what makes sense. –  Heitor Chang Apr 27 '12 at 19:37
    
@HeitorChang The Explorer doesn't query the live database; the current data dump is from March 15th. It seems all your questions were asked after that, so regrettably it won't work for you until the next dump. –  lunboks Apr 27 '12 at 19:38
    
That explains it. Looking back I should have also tried the query with other UserIds. Thanks again! –  Heitor Chang Apr 27 '12 at 19:41
1  
@lunboks considering you were the last editor of the answer I'm surprised you didn't mention Database schema documentation for the public data dump and Data Explorer –  Some Helpful Commenter Apr 27 '12 at 19:46
1  
@SomeHelpfulCommenter Right, thanks. That was on account of me forgetting that it even existed. –  lunboks Apr 27 '12 at 19:50
add comment

The Stack Exchange Data Explorer would be the tool you speak of.

I don't believe there is a query like the one you describe, but you can write one.

share|improve this answer
add comment

You must log in to answer this question.

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