2

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

I just went to data.StackExchange and tried top users in Singapore Query, I didn't see my name in the first half of the list, in fact my name appears as 984

enter image description here

and then I modified and ran this query, thinking may be it is not picking up correctly, so provide the username.

SELECT
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], 
    Reputation
FROM
    Users
WHERE
    (LOWER(Location) LIKE '%singapore%'
    OR UPPER(Location) LIKE '%SG') AND DisplayName = 'mprabhat'
ORDER BY
    Reputation DESC;

Result shows I have just 1 reputation, Why ?

enter image description here

marked as duplicate by Josh Darnell, animuson, Tim Stone, Time Traveling Bobby, Pops Jun 7 '12 at 21:26

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
    I can't provide an answer, but I can tell you this: data.stackexchange rarely give accurate responses. – keyser Jun 7 '12 at 18:14
  • Oh I see, I dont remember but some user from Singapore had mentioned this, I looked at his profile and then came to data.stackExchange :), thanks anyway – mprabhat Jun 7 '12 at 18:16
  • 1
    I'm gonna go ahead and blame @BoltClock♦ for this. ;) – Lix Jun 7 '12 at 18:31
  • 4
    Did you happen to be suspended when the last data dump happened (May 7th)? Because it shows lots of upvotes, but the 1 rep makes me think a suspension was active at the time of the export (also you have a gap in posts from May 2nd to May 9th, which also seems like a 1 week suspension). – Josh Darnell Jun 7 '12 at 18:44
  • Yeah I was suspended for 1 week, so this is not real time data rather dump – mprabhat Jun 7 '12 at 18:58
  • 1
    Precisely. If you look in the "duplicate" I linked to, you'll see that it's updated roughly every month / couple of months. – Josh Darnell Jun 7 '12 at 18:59
  • I did a search for data.stackexchange didn't do the data explorer search or else would have gotten that link:) – mprabhat Jun 7 '12 at 19:01
  • Ha, no problem =) It's almost inevitable that one misses something while searching. – Josh Darnell Jun 7 '12 at 19:06

Browse other questions tagged .