|
My database has been primed with a bunch of questions, and I'd like to focus the answering on those questions that are getting the most views. I've been poking around the schema a bit but I can't yet determine how I might write a query that says "Show me questions ordered by number of views, from highest to lowest". Can anybody help me out? Thanks! |
|
I think the "hottest" query sorts by number of views - but is limited to those created or modified in the last 24 hours. If that's the case, then you could use that as a starting point, and modify it to remove the time condition. Search for "hottest" in the source code and see what you find |
