Re:Stack Overflow hit 1,000,000 questions last night
by bullseye on Thursday October 14, 2010 @12:37AM
(#1789838)
>> # non-closed questions (broken out by answered/non)
Are the labels flipped? When AcceptedAnswerId is NULL, wouldn't that indicate a non-answered question?
Re:Stack Overflow hit 1,000,000 questions last night
by nopal on Friday October 15, 2010 @10:20PM
(#1797140)
Yes. I played with the order, but forgot to adjust the WHERE clauses.
Here's the right version - http://odata.stackexchange.com/stackoverflow/q/12795/
# non-closed questions (broken out by answered/non) - http://odata.stackexchange.com/stackoverflow/q/12626/
# questions with an accepted answer - http://odata.stackexchange.com/stackoverflow/q/12627/
# questions forced to community-wiki vs those that were not - Don't know enough about their schema to answer this one. This could be the answer - http://odata.stackexchange.com/stackoverflow/q/12635/