14

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?

Improve this question
3

5 Answers 5

Reset to default
15

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.
Improve this answer
3
9

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.

Improve this answer
8

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)

Improve this answer
8
  • 97. Yep, that sounds a bit more accurate. +1.
    – John
    Commented Feb 24, 2011 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
    Commented Feb 24, 2011 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
    Commented Feb 24, 2011 at 18:42
  • you need to account for post history type, PostHistoryTypeId in (4,5) .... also be sure to exclude self edits
    – waffles
    Commented Feb 24, 2011 at 21:40
  • @waffles: That's taken care of in the second version. ;)
    – Jeff Mercado
    Commented Feb 24, 2011 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
    Commented Feb 24, 2011 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
    Commented Feb 24, 2011 at 22:19
  • @John: Final version added. Now ought to be the most accurate.
    – Jeff Mercado
    Commented Feb 24, 2011 at 23:17
6

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.

Improve this answer
4
  • 1
    And Copy Editor needs 500 (instead of 600)
    – Jeff Mercado
    Commented Feb 23, 2011 at 10:32
  • Oh, wow, I had no idea...do you have a source for this?
    – John
    Commented Feb 23, 2011 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
    Commented Feb 23, 2011 at 16:39
  • 1
    @Jeff, @Mercator: Found it :-)
    – John
    Commented Feb 24, 2011 at 2:58
1

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

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

Improve this answer

You must log in to answer this question.

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