I'm trying to find some good questions on stackoverflow to answer this question. To start my search, I thought it would be good to look at the list of the most popular favorite questions. It is probably obvious but I couldn't find a way to sort the questions by how many each one has been marked as a favorite.

Is there a way get a list of the questions sorted by favorite count?


Why yes there is

id      count   Title
9033    1185    Hidden Features of C#?
234075  918 What is your best programmer joke?
84556   877 What's your favorite "programmer" cartoon?
72394   816 What should a developer know before building a public web site?
1711    706 What is the single most influential book every programmer should read?    
58640   632 Great programming quotes
194812  483 List of freely available programming books
184618  479 What is the best comment in source code you have ever encountered?
662956  397 Most useful free .NET libraries?
38210   388 What non-programming books should programmers read?
164432  376 What real life bad habits has programming given you?
101268  367 Hidden features of Python
182112  364 Funny loading statements to keep users amused
406760  354 What's your most controversial programming opinion?
1644    338 What good technology podcasts are out there?
76364   309 What is the single most effective thing you did to improve your programming skills?    
78756   302 What do you use to keep notes as a developer?
  • Thanks. That does answer the question. Unfortunately it looks like my idea that the most popular favorite questions would also include the best questions that show off the strength of the stackoverflow platform isn't quite true. Nov 20 '09 at 20:20
  • In much the same way as the top-voted questions/answers typically aren't the best, either -- as I read somewhere yesterday, "the crowd isn't always wise".
    – womble
    Nov 20 '09 at 20:57
  • 1
    @David: You should be able to use tags to refine the results. Nov 21 '09 at 0:30
  • @Bill the Lizard, Why i can't arrive the link ? stackql.net/default.aspx?qid=12767 Can SE users use it ? Jul 15 '11 at 13:05
  • 2
    @Soner: It looks like StackQL is down. Here's a SEDE query for Top 100 Most Favorited Questions on SO. Jul 15 '11 at 13:10
  • @Bill Thanks. Is there any query for other StackExchange sites ? (meta.stackoverflow, productivity, superuser etc..) Jul 15 '11 at 13:13
  • 1
    @Soner: Yeah, you can run the same query on any of the sites. Just click one of the site logo icons above the output. Jul 15 '11 at 13:15
  • @Bill Thanks. I couldn't find for productivity btw, Jul 15 '11 at 13:20
  • 1
    @Soner: Oh, yeah. None of the Beta sites are in the data dump, which is where SEDE gets its data. So none of those sites are queryable yet. Jul 15 '11 at 13:24
  • Link no longer works :/
    – Mark Mayo
    Feb 24 '13 at 23:44
  • @BilltheLizard neither does your SEDE query :/
    – Mark Mayo
    Feb 24 '13 at 23:45
  • @MarkMayo Thanks, I updated it. Feb 25 '13 at 2:21

I don't know about this link on Tom Ritter's answer as it asks for login, but I tried to use data.stackexchange.com site, and I build a query that can help you.

You must log in to answer this question.

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