I've been clicking various links and interrogating Help. So far no luck.

I'd like to find or make a league table of the most popular questions of all time on the main Worldbuilding SE. I'm interested in upvotes and/or views .

Does such exist? If not, how can I build one?


For questions by votes, you can search for is:q and sort by votes.

For answers by votes, you can search for is:a and sort by votes.

To get a list of questions by views, you can use the Stack Exchange Data Explorer. Here's an example query to get you started:

  'https://worldbuilding.stackexchange.com/q/' + CONVERT(NVARCHAR(MAX), Id) AS Link
FROM Posts

(SEDE isn't using the most recent data -- I think it updates weekly -- but allows you to perform queries that are difficult or impossible to express in the on-site search field syntax.)

  • 1
    $\begingroup$ views:# is also a sort parameter on the site; you don't have to wait for the SEDE update. $\endgroup$ Dec 1 '18 at 23:23
  • $\begingroup$ @MonicaCellio views:# is a search criteria, but then you need to pick a threshold. (You can search for, e.g., is:q views:50000.. which on Worldbuilding gives you a handful of questions.) I didn't see any way to sort by views. If I missed something, could you elaborate? The help center page doesn't even mention the words "sort" or "order". $\endgroup$
    – user
    Dec 2 '18 at 12:49
  • $\begingroup$ Oh, sorting -- no, I don't know of a way to do that, unfortunately. $\endgroup$ Dec 2 '18 at 17:35
  • $\begingroup$ SEDE is fed by the weekly data dump that happens during the Sunday-->Monday overnight, GMT. $\endgroup$
    – nitsua60
    Dec 3 '18 at 2:34

A timely question

Datapalooza is just around the corner! I'm planning a more complete experience this year. Last year's focus was users, but this year's focus is going to be questions.

Basically, if you don't want to do it yourself as MichaelKjorling suggests, comment with what you want, and I will see if I can work that into Datapalooza this year. Now is the time to let me know!


You must log in to answer this question.

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