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.

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

2 Answers 2

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
@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. – lunboks 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 .