Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

I've been trying to come up with a query which will tell me how may edits someone has done as per the rules for the Strunk & White and Copy Editor badges.

So far I've come up with this:

I know that it has a number of potential problems with counting edits that it shouldn't do, including:

  • If an edit is made to the title and body of a post at the same time I suspect 2 edits might be counted instead of 1
  • Edits made to CW questions are counted
  • It counts multiple edits to the same question

But it is still reporting a edit count that is too low - for user Id 114029 (who according to the data dump has the Strunk & White badge), this query reports only 71 edits.

What have I missed? Why is the edit count returned too low?

share|improve this question
It's too low because of the data dump cutoff, but the query itself will report too high because of the anomalies you mentioned. (Multiple edits on the same post don't count?) – Jon Seigel Jan 25 '11 at 18:17

Use either of these instead which are more accurate

They don't agree, but both show the user over the threshold

FYI - The data dump is updated only once every month. It is nearly 3 weeks old by now

share|improve this answer
Read the question - it is from the same data dump that the user id was obtained, so the answer here is irrelevant – Yi Jiang Jan 25 '11 at 11:57
Both of those queries use the Posts table and so are pretty much guaranteed to be incorrect - since they were written the PostHistory table has been added which should contain the information needed to accurately work out the number of edits. – Justin Jan 25 '11 at 15:14
While that is true, those are the ready queries you can use with a slight margin of error. Given the dump is X days old, that margin of error is less than the rate of change except for the most avid SO users – RichardTheKiwi Jan 25 '11 at 18:52

You must log in to answer this question.

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