0

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

WHERE
     (Votes.PostId=Posts.Id) AND
     (Votes.VoteTypeId = 5) AND
     (Votes.UserId=@userid)

Select DisplayName, Id
from Users 
where Id = @userid

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

marked as duplicate by Josh Darnell, Tim Stone, jonsca, Pops, kiamlaluno Jul 24 '12 at 9:24

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

4

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>

  • 3 months is sad... – deostroll Jul 18 '12 at 17:20
  • According to the other answer it's every 2 months, but if you want data more current than that, use the API. – Aaron Bertrand Jul 18 '12 at 17:21

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