What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 130 Stack Exchange communities.

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.

share|improve this question

marked as duplicate by jadarnel27, 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.

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>

share|improve this answer
    
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 .