Somewhere in the past few hours, the millionth question was asked on Math.SE. Could someone cleverer than I am please figure out which one it was. Presumably there should be a plaque or statue, or somesuch commemoration. What would be suitable recognition for the questioner and the answer(s), if any? It will be interesting to see if it's a "good" question.
I agree that the person posting this question didn't win a lottery and didn't do anything special. However, math stack exchange has more than 1,000,000 questions now, somebody posted the 1-millionth question, and that is worth celebrating as celebrations always take place at symbolic events. Why celebrate it?: I admire the countless energy, devotion and, at so many instances, brilliance of the work done here by so many, voluntary work.
Here is the screenshot (courtesy of wolfies):
As already mentioned in the comments, the 1000000th question will change over time. For example, depending on deletions/undeletions, migrations here/away etc. It also depends on your definition - do you want to count closed question? Do you want to order the posts by id or by CreationDate? (This can make a difference for migrated question, for example the question Would Relational Calculus be Turing-Complete if it Allowed Unsafe Queries? is older than the question with the id 1: What Does it Really Mean to Have Different Kinds of Infinities?) Do you want to include the locked questions? Do you want include the deleted questions? Do you want to include questions which have been migrated here - and originally asked elsewhere?
There is a somewhat similar question on Meta Stack Overflow: What was the 10 millionth question? One of the answers there provides a solution using API. Here is the link: https://api.stackexchange.com/2.2/questions?page=1000000&pagesize=1&order=asc&sort=creation&site=math The question given there will be changing over time.
It is also possible to try do this using Data Explorer. Again, the 1000000th question will change over time, each time the post shown there will correspond to the state at the most recent update of the data in the database. Here are a few such queries (which definitely can be improved/modified in many ways):
- The nth question (ordered by CreationDate)
- The nth question (excluding closed questions)
- The nth question (including deleted posts)
At the moment, the above queries will come out empty, since at when the database was updated there were less than 1000000 questions. The exception is the query that includes deleted questions. But you can change the numbers and play around with the queries - for example, you can look at 100000 question and compare this with the comment posted at the time: Congrats, Math.StackExchange.com!