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.

I am interested in some information about Stack Exchange, like

  1. How can I find the question with the maximum number of answers?
  2. How can I list all moderators of Stack Overflow?
  3. How to list users that have maximum reputation for all Stack Exchange sites? I know for Stack Overflow it's Jon Skeet. I can get this information by going on each site and clicking on users and see the maximum reputation user of all time, but is there any query to list all in one?
  4. The person who got the highest upvote for an answer and the same for a question?
share|improve this question
data.stackexchange.com –  Robert Harvey May 30 '11 at 5:13
add comment

1 Answer

up vote 9 down vote accepted

The question with the maximum number of answers:

Via data.stackexchange.com:

select ParentId
from Posts
group by ParentId
order by count(ParentId) DESC

636 answers for Great programming quotes
528 answers for What is the best comment in source code you have ever encountered?

Stack Overflow moderators:

http://stackoverflow.com/about (scroll down)

All time highest rep users across all sites:

Closest thing right now is "feature users" on this page: http://stackexchange.com/sites (scroll down, right side)

Highest voted question and answer?

via data.stackexchange.com:

select Id
from Posts
where PostTypeId = 1
order by Score DESC

Change the PostTypeId to 2 to get highest scoring answers.

Question: 2330 votes for List of freely available programming books
Answer: 4351 votes for RegEx match open tags except XHTML self-contained tags

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 .