Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

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
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. – a cat 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
@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
@SomeHelpfulCommenter Right, thanks. That was on account of me forgetting that it even existed. – a cat Apr 27 '12 at 19:50

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

You must log in to answer this question.

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