What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 131 Stack Exchange communities.

One thing I love about the stack exchange sites, is that I can quickly and easily sort any of the questions by the number of votes. What would be even better is if I could quickly and easily sort by views. That way I could see some good questions that did not receive as many votes, but are beloved anyway.

I've seen some people pointing out that some query string values will let you see all the questions for a fixed number of views. This is nice and all, but not very fun to use or as useful as it could be.

Also, I've read some other similarly themed proposals, but I don't think any of them state it as frankly as here. Most of those other proposals are mollified when the asker finds that they can pass in a query string value.

Thanks!

share|improve this question
    
Is there anyway I can improve my answer? I know the sql is rough. I might need a hand to clean it up from your friendly StackOverflow data engine legend Sam Saffron. –  Jeremy Thompson Jun 19 '12 at 13:30

1 Answer 1

I agree this would be a nice feature: http://stackoverflow.com/questions?sort=featured&filter=viewcount but realistically it is quite a big ask.

In the mean time, I whipped up this query that will list questions from the start of the month ordered by ViewCount, please give it a go over at: http://data.stackexchange.com/stackoverflow/query/new

SELECT 'http://stackoverflow.com/questions/' +  CONVERT(varchar,P.id),
P.CreationDate,P.Score, P.ViewCount, P.Title,P.Tags,P.Body, P.AnswerCount 
FROM Posts P
WHERE P.CreationDate >= convert(datetime, '01/06/2012', 103)
ORDER BY P.ViewCount DESC

ps It took 38 sec's to run.

share|improve this answer

You must log in to answer this question.

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