Possible Duplicate:
Why are my SEDE results inaccurate/obsolete/incorrect/outdated?

There is a mismatch between the favorites count reported on my SO user profile and on the data explorer.

I got the query for getting the favorites from here - I modified it a bit though. Is the query I've typed correct?

SELECT count(*) as [Favorites Count]

FROM Votes, Posts

     (Votes.PostId=Posts.Id) AND
     (Votes.VoteTypeId = 5) AND
Select DisplayName, Id
from Users 
where Id = @userid

Also checked it against other users, and still got the mismatch.


1 Answer 1


You know that Data Explorer is not up-to-the-minute, right? There are only dumps periodically.

From http://www.clearbits.net/feeds/creator/146-stack-overflow-data-dump.rss

released every 3 months
<pubDate>Wed, 30 May 2012 17:38:15 +0000</pubDate>

  • According to the other answer it's every 2 months, but if you want data more current than that, use the API.
    – Aaron Bertrand Staff
    Commented Jul 18, 2012 at 17:21

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