I was trying to construct a query in the DataExplorer to find the posts with the most upvotes without any downvotes, but found that (by including the wrong
ORDER BY clause) SO lists a bunch of questions at score -1, yet it doesn't record any downvotes (or votes for that matter) for them.
I can't log into the DataExplorer for some reason, but I'm using the following query (to show all posts of score < 1 without any downvotes):
WITH DownVotes AS ( SELECT v.Id AS Id, v.PostId AS PostId FROM Votes v INNER JOIN VoteTypes vt ON vt.Id = v.VoteTypeId WHERE vt.Name = 'DownMod' ) SELECT p.Id AS [Post Link], p.PostTypeId AS [Post Type], p.Score, (SELECT COUNT(*) FROM Votes v WHERE v.PostId = p.Id) AS [Num Votes] FROM Posts p WHERE p.CommunityOwnedDate IS NULL AND (SELECT COUNT(*) FROM DownVotes v WHERE v.PostId = p.Id) = 0 AND p.Score < 0
I included the
Score column to show that the votes didn't simply happen after the data dump.
Are these votes by deleted users or what may I have found?