Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

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.

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.

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


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 .