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

Thanks to the new edit system(which I really like, BTW) I recently got Strunk-and-White. Awesome! I'm a curious guy, so I had been periodically seeing how many edits I had with some data explorer queries. I was about 35-40 away last time I checked, so I went back and...

  • Query 1 says I still need 32 edits for S&W
  • Query 2 says I only have 68 edits
  • Query 3 says I only have 69 edits

Are these queries all flawed? Is there a bug in the S&W badge? Is there another explanation?

share|improve this question
    
I've been wondering the same thing. –  Justin Feb 22 '11 at 7:02
    
Check this out - meta.stackexchange.com/questions/79054/… –  jjnguy Feb 23 '11 at 20:09
    
The requirements for the badge changed yesterday. So all of the queries may be wrong. –  jjnguy Feb 23 '11 at 20:10

5 Answers 5

up vote 15 down vote accepted

I believe these are based on monthly data dumps not real time queries. From the FAQ section:-

How frequently is Stack Exchange Data Explorer updated?

Data is updated monthly.
share|improve this answer
1  
-facepalm- That's what I get for posted on little sleep. –  John Feb 22 '11 at 5:30
    
Cant blame you :-) –  CoolBeans Feb 22 '11 at 5:32
4  
Data are updated monthly. Speaking of Strunk & White problems.. –  Scott S Feb 24 '11 at 2:36
3  
@Scott S: "Data is" is perfectly grammatical. I humbly direct you to these questions over at English Language and Usage for details: Data is or data are? and Where are the “data”? I only have one “datum”. –  ЯegDwight Feb 24 '11 at 22:55

There are two problems:

  1. As CoolBeans noted, the data dumps are behind.

  2. In addition, the queries are flawed as they only consider the most recent editor, even though the badges consider all editors. It is now possible to construct a query which considers all editors (which could not be done at the time), but it appears no one has done so yet.

share|improve this answer

Update:

I wrote a final query to determine how many edits you've made and how much more until you earn the badges. This is based on the query waffles had graciously shared with us in the comments below. It should be accurate now though still behind as expected due to to it using the monthly dumps. This will be the final version from me (aside from any performance tweaks).

How many edits have I made and how much more until I earn the badges?


Older queries:

Based on the older way of counting edits.
How many edits have I made and how much more until I earn the badges? (v1)

Based on waffles' description here counting posts that are edited.
How many edits have I made and how much more until I earn the badges? (v2)

Based on v2 but counts revisions instead of posts. It is ultimately the final version so I have deleted it. I'm leaving the link here for historical purposes.
How many edits have I made and how much more until I earn the badges? (v3)

share|improve this answer
    
97. Yep, that sounds a bit more accurate. +1. –  John Feb 24 '11 at 3:02
    
@John: I've added an alternative query based on the new explanation that you linked to. Looks like we're being cut down a bit more now. –  Jeff Mercado Feb 24 '11 at 6:49
    
That one says I need 7 more to S&W, but with the whole monthly update thing it's probably right. –  John Feb 24 '11 at 18:42
    
you need to account for post history type, PostHistoryTypeId in (4,5) .... also be sure to exclude self edits –  waffles Feb 24 '11 at 21:40
    
@waffles: That's taken care of in the second version. ;) –  Jeff Mercado Feb 24 '11 at 21:43
    
@waffles: Are there any other ways I can make these queries more accurate? Right now I only count posts/revisions that are non-self edits that modifies the title or body that isn't deleted. Are tag wiki edits included? Are CW edits excluded? Is it counting the posts or the revisions? Would be really helpful if you could answer these. –  Jeff Mercado Feb 24 '11 at 22:00
1  
@Jeff .. tag wikis and CW are included ... here is our current query ... select max(UserId) as UserId from PostHistory ph where PostHistoryTypeId in (4,5) and PostId not in ( select p.Id from Posts p where p.OwnerUserId = ph.UserId or DeletionDate is not null ) group by UserId having COUNT(distinct RevisionGUID) >= 500 –  waffles Feb 24 '11 at 22:19
    
@waffles: Thanks for that. –  Jeff Mercado Feb 24 '11 at 22:30
    
@John: Final version added. Now ought to be the most accurate. –  Jeff Mercado Feb 24 '11 at 23:17

CoolBeans' and waiwai933's answers still only explain part of it.

I'll add (3): the Strunk & White badge has recently (yesterday?) been changed from needing 100 edits to needing only 80.

share|improve this answer
1  
And Copy Editor needs 500 (instead of 600) –  Jeff Mercado Feb 23 '11 at 10:32
    
Oh, wow, I had no idea...do you have a source for this? –  John Feb 23 '11 at 14:40
    
@John The Badges page on any site. I can't find any other source. But I had been checking my progress too and was surprised to get the badge today. –  mercator Feb 23 '11 at 16:39
1  
@Jeff, @Mercator: Found it :-) –  John Feb 24 '11 at 2:58

And just to throw another query into the mix...

http://data.stackexchange.com/stackoverflow/s/1026/editor-strunk-white-copy-editor

share|improve this answer

You must log in to answer this question.

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