This question is inspired by Edit counts toward Strunk & White badge do not always add up to 80, where I remembered that I wrote a Global Edit Summary, which is (on some sites) off by one or more posts.
As an example, consider my Lifehacks Meta profile. The SEDE query says 14 posts edited, but the profile and the badge tracker say 20:
Edits to deleted posts don't count, so in theory everything should be visible on the profile, right? Or am I missing something here?
Most of the times, the query produces the same results as the counter on my profile (not counting edits made after last Sunday morning) but there are a few other sites where the counter and/or the query are off (e.g. Bitcoin where the query reports 54 and the profile 55).
I've found another case where the counter is off by a wide margin. On Board & Card Games, my profile claims I've edited 867 posts, while the appropriate SEDE query says I edited only 781 – 86 less. It wouldn't fully explain the difference, but I've done almost 50 tag-only edits. They are not supposed to count towards the badge, but maybe they do?