How to find questions with

  1. most comments
  2. most votes
  3. most viewed

I have seen following question, but seems like there is no easy way. How do I find all "Famous Questions" on StackOverflow?

Is there way to bookmark a page so that the same URL can be used to update data (which will be very seldom) at each hit?


You can use the Stack Exchange Data Explorer to query most aspects of the site.

Stack Exchange Data Explorer allows you to run arbitrary queries on the Stack Exchange public data dumps.

List of queries for:


You could simply check the list of questions with the most votes:


Once you have access to moderator tools on SO, there is a section where you can see questions and answers with "extreme votes".

Additionally, a lot of these very famous questions were eventually deleted. Users with 10k rep can still read them. You can find a list of "Popular deleted questions" here:


  • I think the second link is borken – Hakan Fıstık Feb 4 '17 at 6:55

The greatest hits page is probably the closest built-in mechanism to what you want, except it doesn't take comments into account. And, of course, closed and deleted questions don't show up, so most of the "famous" SO questions won't show up there.

See also this blog post.

  1. Try the Data Explorer query Posts with lots of comments.

    Note that this includes all post (questions and answers).

  2. That's easy. Just click on the tab votes to sort the questions by votes.

    Direct link: Highest Voted Questions

  3. Two options:

The Data Explorer queries have the disadvantage that the data dump it queries isn't might be up to a month old (according to Jeff).

  • 6 months!!! I thought they updated it every month! ?? – Matt Fenwick May 3 '12 at 15:50
  • @MattFenwick: My mistake. As of 2 days ago, the data dump was still 18 months old (link). – Dennis May 3 '12 at 15:53
  • Isn't the link saying that, as of 18 months ago, the data is updated every month or so? – Matt Fenwick May 3 '12 at 15:59
  • 1
    @MattFenwick: If I had only learned to read... – Dennis May 3 '12 at 16:00
  • Confirmed ... that shows posts from March of this year, so it's no more than 2 months out of date ... – Matt Fenwick May 3 '12 at 16:03

A query to view the top 100 questions by views:

SELECT TOP 100 Title, DisplayName AS 'Author', ViewCount AS 'Viewed', Score 
FROM Posts a 
JOIN Users b ON (a.OwnerUserId = b.Id)
ORDER by ViewCount DESC
  • 1
    Try select top 100 id as [Post Link], owneruserid as [User Link], viewcount, score from posts order by viewcount desc to leverage magic columns. – rene Jul 7 '17 at 12:42
  • Nice about the links! – Kurt Van den Branden Jul 7 '17 at 12:53
  • 1
    Beyond the help you might like the tutorial as it is a bit of an hidden gem.... – rene Jul 7 '17 at 13:03

You must log in to answer this question.

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