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

I think that a feature that sorts all the unanswered questions randomly would be good, as long as it reordered everything every time the page is refreshed. I often browse the newest page, only to find that I am out of questions that I can answer within five minutes. It would help get attention to old questions that would not be looked at otherwise.

share|improve this question
1  
"out of questions that I can answer within five minutes" - That's actually pretty good. For most people (including myself), that would be "zero minutes". –  Mysticial Nov 8 '12 at 19:45
    
The only problem that I can see with this is that there are currently 795,133 unanswered questions, so you're drawing from a pretty large pool of questions, many of which are too old to still be useful. The system already randomly pokes old, unanswered questions to bring them to the front page. –  Robert Harvey Nov 8 '12 at 21:07

1 Answer 1

Here's a SEX-DEX query to do this:

Random Unanswered Posts

It has a few problems, such as SE's overly aggressive caching allowing RAND() not to function properly (make a simple edit every time you run the script & it should work), and the interface isn't the best, but it does pull down what you want.

Here's the query parameters I used:

  • Only Questions
  • Zero total answers
  • Less than 500 views
  • Not closed

And, the most important part

  • Selects 15 in-order rows, from a random part of the SE Question heap.

I could have used ORDER BY newid(), but that would have cause major performance issues, so I decided to use this instead.

Enjoy the script, and let me know if you have any more requests (besides tag filtering, it turned out to be too complex).

share|improve this answer

You must log in to answer this question.

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